Activities Cue – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables AActivities Cue

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

Table Number: 1313

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