Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1313
Table Type: Company
Table Name: Activities Cue
Database Table Name: CRONUS UK Ltd_$Activities 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 Activities Cue can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Activities Cue$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[Primary Key]
,[Sales This Month]
,[Top 10 Customer Sales YTD]
,[Overdue Purch_ Invoice Amount]
,[Overdue Sales Invoice Amount]
,[Average Collection Days]
,[Uninvoiced Bookings]
,[Last Date_Time Modified]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Activities 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_$Activities Cue$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Activities Cue]
LEFT JOIN
[User] AS [User]
ON
[Activities Cue].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Activities Cue].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Activities 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 | Due Date Filter  | Due Date Filter | FlowFilter | Date | 4 | ||
| 3 | Overdue Date Filter | Overdue Date Filter | FlowFilter | Date | 4 | ||
| 4 | Ongoing Sales Invoices | Ongoing Sales Invoices | FlowField | Integer | 4 | ||
| 5 | Ongoing Purchase Invoices | Ongoing Purchase Invoices | FlowField | Integer | 4 | ||
| 6 | Sales This Month | Sales This Month | Normal | Decimal | 12 | Sales This Month | decimal(38,38) |
| 7 | Top 10 Customer Sales YTD | Top 10 Customer Sales YTD | Normal | Decimal | 12 | Top 10 Customer Sales YTD | decimal(38,38) |
| 8 | Overdue Purch. Invoice Amount | Overdue Purch. Invoice Amount | Normal | Decimal | 12 | Overdue Purch_ Invoice Amount | decimal(38,38) |
| 9 | Overdue Sales Invoice Amount | Overdue Sales Invoice Amount | Normal | Decimal | 12 | Overdue Sales Invoice Amount | decimal(38,38) |
| 10 | Average Collection Days | Average Collection Days | Normal | Decimal | 12 | Average Collection Days | decimal(38,38) |
| 11 | Ongoing Sales Quotes | Ongoing Sales Quotes | FlowField | Integer | 4 | ||
| 13 | Sales Inv. – Pending Doc.Exch. | Sales Invoices – Pending Document Exchange | FlowField | Integer | 4 | ||
| 14 | Sales CrM. – Pending Doc.Exch. | Sales Credit Memos – Pending Document Exchange | FlowField | Integer | 4 | ||
| 17 | Due Next Week Filter | Due Next Week Filter | FlowFilter | Date | 4 | ||
| 20 | My Incoming Documents | My Incoming Documents | FlowField | Integer | 4 | ||
| 21 | Non-Applied Payments | Non-Applied Payments | FlowField | Integer | 4 | ||
| 22 | Purch. Invoices Due Next Week | Purch. Invoices Due Next Week | FlowField | Integer | 4 | ||
| 23 | Sales Invoices Due Next Week | Sales Invoices Due Next Week | FlowField | Integer | 4 | ||
| 24 | Ongoing Sales Orders | Ongoing Sales Orders | FlowField | Integer | 4 | ||
| 25 | Inc. Doc. Awaiting Verfication | Inc. Doc. Awaiting Verfication | FlowField | Integer | 4 | ||
| 26 | Purchase Orders | Purchase Orders | FlowField | Integer | 4 | ||
| 27 | Uninvoiced Bookings | Uninvoiced Bookings | Normal | Integer | 4 | Uninvoiced Bookings | int |
| 28 | IC Inbox Transactions | IC Inbox Transactions | FlowField | Integer | 4 | ||
| 29 | IC Outbox Transactions | IC Outbox Transactions | FlowField | Integer | 4 | ||
| 31 | Outstanding Vendor Invoices | Outstanding Vendor Invoices | FlowField | Integer | 4 | ||
| 32 | Coupled Data Synch Errors | Coupled Data Synch Errors | FlowField | Integer | 4 | ||
| 33 | CDS Integration Errors | Dataverse Integration Errors | FlowField | Integer | 4 | ||
| 110 | Last Date/Time Modified | Last Date/Time Modified | Normal | DateTime | 8 | Last Date_Time Modified | datetime |
| 4000 | Replication Success Rate | Replication Success Rate | Normal | Decimal | 12 | ||
| 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 [Activities Cue].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Activities Cue$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Activities Cue] LEFT JOIN [User] AS [User] ON [Activities Cue].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |