Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/9054
Table Type: Company
Table Name: Finance Cue
Database Table Name: CRONUS UK Ltd_$Finance Cue$437dbf0e-84ff-417a-965d-ed2bb9650972
Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Finance Cue can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Finance Cue$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[Primary Key]
,[Cash Accounts Balance]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Finance Cue$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Finance Cue$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Finance Cue]
LEFT JOIN
[User] AS [User]
ON
[Finance Cue].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Finance Cue].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Finance Cue table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Primary Key  | Primary Key | Normal | Code | 10 | Primary Key | nvarchar(20) |
| 2 | Overdue Sales Documents  | Overdue Sales Documents | FlowField | Integer | 4 | ||
| 3 | Purchase Documents Due Today | Purchase Documents Due Today | FlowField | Integer | 4 | ||
| 4 | POs Pending Approval | POs Pending Approval | FlowField | Integer | 4 | ||
| 5 | SOs Pending Approval | SOs Pending Approval | FlowField | Integer | 4 | ||
| 6 | Approved Sales Orders | Approved Sales Orders | FlowField | Integer | 4 | ||
| 7 | Approved Purchase Orders | Approved Purchase Orders | FlowField | Integer | 4 | ||
| 8 | Vendors – Payment on Hold | Vendors – Payment on Hold | FlowField | Integer | 4 | ||
| 9 | Purchase Return Orders | Purchase Return Orders | FlowField | Integer | 4 | ||
| 10 | Sales Return Orders – All | Sales Return Orders – All | FlowField | Integer | 4 | ||
| 11 | Customers – Blocked | Customers – Blocked | FlowField | Integer | 4 | ||
| 16 | Overdue Purchase Documents | Overdue Purchase Documents | FlowField | Integer | 4 | ||
| 17 | Purchase Discounts Next Week | Purchase Discounts Next Week | FlowField | Integer | 4 | ||
| 18 | Purch. Invoices Due Next Week | Purch. Invoices Due Next Week | FlowField | Integer | 4 | ||
| 19 | Due Next Week Filter | Due Next Week Filter | FlowFilter | Date | 4 | ||
| 20 | Due Date Filter | Due Date Filter | FlowFilter | Date | 4 | ||
| 21 | Overdue Date Filter | Overdue Date Filter | FlowFilter | Date | 4 | ||
| 22 | New Incoming Documents | New Incoming Documents | FlowField | Integer | 4 | ||
| 23 | Approved Incoming Documents | Approved Incoming Documents | FlowField | Integer | 4 | ||
| 24 | OCR Pending | OCR Pending | FlowField | Integer | 4 | ||
| 25 | OCR Completed | OCR Completed | FlowField | Integer | 4 | ||
| 29 | Non-Applied Payments | Non-Applied Payments | FlowField | Integer | 4 | ||
| 30 | Cash Accounts Balance | Cash Accounts Balance | Normal | Decimal | 12 | Cash Accounts Balance | decimal(38,38) |
| 31 | Last Depreciated Posted Date | Last Depreciated Posted Date | FlowField | Date | 4 | ||
| 33 | Outstanding Vendor Invoices | Outstanding Vendor Invoices | FlowField | Integer | 4 | ||
| 4000 | Replication Success Rate | Replication Success Rate | Normal | Decimal | 12 | ||
| 10120 | Bank Reconciliations to Post | Bank Reconciliations to Post | FlowField | Integer | 4 | ||
| 10121 | Bank Acc. Reconciliations | Bank Acc. Reconciliations | FlowField | Integer | 4 | ||
| 10140 | Deposits to Post | Deposits to Post | FlowField | Integer | 4 | ||
| 10150 | Bank Deposits to Post | Bank Deposits to Post | FlowField | Integer | 4 | ||
| 2000000000 | $systemId | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
| 2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
| 2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT [Finance Cue].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Finance Cue$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Finance Cue] LEFT JOIN [User] AS [User] ON [Finance Cue].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |