Finance Cue – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables FFinance Cue

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

Table Number: 9054

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 query SELECT [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
	Key to join to the User table. Show/hide example query SELECT [Finance Cue].[$systemModifiedBy] ,[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].[$systemModifiedBy] = [User].[User Security ID]