SB Owner Cue – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SSB Owner Cue

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/9060

Table Type: Company

Table Name: SB Owner Cue
Database Table Name: CRONUS UK Ltd_$SB Owner Cue$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 9060

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 SB Owner Cue can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$SB Owner Cue$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Primary Key]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$SB Owner 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_$SB Owner Cue$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SB Owner Cue]
LEFT JOIN
   [User] AS [User]
      ON
         [SB Owner Cue].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [SB Owner Cue].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in SB Owner 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	Released Sales Quotes	Released Sales Quotes	FlowField	Integer	4
3	Open Sales Orders	Open Sales Orders	FlowField	Integer	4
4	Released Sales Orders	Released Sales Orders	FlowField	Integer	4
5	Released Purchase Orders	Released Purchase Orders	FlowField	Integer	4
6	Overdue Sales Documents	Overdue Sales Documents	FlowField	Integer	4
7	SOs Shipped Not Invoiced	SOs Shipped Not Invoiced	FlowField	Integer	4
8	Customers – Blocked	Customers – Blocked	FlowField	Integer	4
9	Purchase Documents Due Today	Purchase Documents Due Today	FlowField	Integer	4
10	Vendors – Payment on Hold	Vendors – Payment on Hold	FlowField	Integer	4
11	Sales Invoices	Sales Invoices	FlowField	Integer	4
12	Unpaid Sales Invoices	Unpaid Sales Invoices	FlowField	Integer	4
13	Overdue Sales Invoices	Overdue Sales Invoices	FlowField	Integer	4
14	Sales Quotes	Sales Quotes	FlowField	Integer	4
20	Due Date Filter	Due Date Filter	FlowFilter	Date	4
21	Overdue Date Filter	Overdue Date Filter	FlowFilter	Date	4
30	Purchase Invoices	Purchase Invoices	FlowField	Integer	4
31	Unpaid Purchase Invoices	Unpaid Purchase Invoices	FlowField	Integer	4
32	Overdue Purchase Invoices	Overdue Purchase Invoices	FlowField	Integer	4
33	User ID Filter	User ID Filter	FlowFilter	Code	50
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 [SB Owner Cue].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$SB Owner Cue$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SB Owner Cue] LEFT JOIN [User] AS [User] ON [SB Owner 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 [SB Owner Cue].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$SB Owner Cue$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SB Owner Cue] LEFT JOIN [User] AS [User] ON [SB Owner Cue].[$systemModifiedBy] = [User].[User Security ID]