Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/8613
Table Type: Company
Table Name: Config. Package Table
Database Table Name: CRONUS UK Ltd_$Config_ Package Table$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 Config. Package Table can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Config_ Package Table$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[Package Code]
,[Table ID]
,[Imported Date and Time]
,[Exported Date and Time]
,[Comments]
,[Created Date and Time]
,[Data Template]
,[Package Processing Order]
,[Page ID]
,[Processing Order]
,[Imported by User ID]
,[Created by User ID]
,[Dimensions as Columns]
,[Skip Table Triggers]
,[Delete Recs Before Processing]
,[Processing Report ID]
,[Parent Table ID]
,[Validated]
,[Delayed Insert]
,[Cross-Column Filter]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Config_ Package Table$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Config_ Package Table$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Package Table]
LEFT JOIN
[CRONUS UK Ltd_$Config_ Package$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Package]
ON
[Config. Package Table].[Package Code] = [Config. Package].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping]
ON
[Config. Package Table].[Table ID] = [Data Exch. Mapping].[Table ID]
LEFT JOIN
[Company] AS [Company]
ON
[Config. Package Table].[Company Filter (Source Table)] = [Company].[Name]
LEFT JOIN
[CRONUS UK Ltd_$Config_ Template Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Template Header]
ON
[Config. Package Table].[Data Template] = [Config. Template Header].[Code]
LEFT JOIN
[User] AS [User]
ON
[Config. Package Table].[Imported by User ID] = [User].[User Name]
LEFT JOIN
[User] AS [User]
ON
[Config. Package Table].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Config. Package Table].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Config. Package Table table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Package Code   | Package Code | Normal | Code | 20 | Package Code | nvarchar(40) |
Key to join to the Config. Package table.Show/hide example querySELECT
[Config. Package Table].[Package Code]
,[Config. Package].[Code]
FROM
[CRONUS UK Ltd_$Config_ Package Table$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Package Table]
LEFT JOIN
[CRONUS UK Ltd_$Config_ Package$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Package]
ON
[Config. Package Table].[Package Code] = [Config. Package].[Code] | |||||||
| 2 | Table ID | Table ID | Normal | Integer | 4 | Table ID | int |
Key to join to the Data Exch. Mapping table.Show/hide example querySELECT
[Config. Package Table].[Table ID]
,[Data Exch. Mapping].[Table ID]
FROM
[CRONUS UK Ltd_$Config_ Package Table$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Package Table]
LEFT JOIN
[CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping]
ON
[Config. Package Table].[Table ID] = [Data Exch. Mapping].[Table ID] | |||||||
| 3 | Table Name | Table Name | FlowField | Text | 250 | ||
| 4 | No. of Package Records | No. of Package Records | FlowField | Integer | 4 | ||
| 5 | No. of Package Errors | No. of Package Errors | FlowField | Integer | 4 | ||
| 7 | Imported Date and Time | Imported Date and Time | Normal | DateTime | 8 | Imported Date and Time | datetime |
| 8 | Exported Date and Time | Exported Date and Time | Normal | DateTime | 8 | Exported Date and Time | datetime |
| 9 | Comments | Comments | Normal | Text | 250 | Comments | nvarchar(500) |
| 10 | Created Date and Time | Created Date and Time | Normal | DateTime | 8 | Created Date and Time | datetime |
| 11 | Company Filter (Source Table) | Company Filter (Source Table) | FlowFilter | Text | 30 | ||
| 12 | Table Caption | Table Caption | FlowField | Text | 250 | ||
| 13 | Data Template | Data Template | Normal | Code | 10 | Data Template | nvarchar(20) |
Key to join to the Config. Template Header table.Show/hide example querySELECT
[Config. Package Table].[Data Template]
,[Config. Template Header].[Code]
FROM
[CRONUS UK Ltd_$Config_ Package Table$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Package Table]
LEFT JOIN
[CRONUS UK Ltd_$Config_ Template Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Template Header]
ON
[Config. Package Table].[Data Template] = [Config. Template Header].[Code] | |||||||
| 14 | Package Processing Order | Package Processing Order | Normal | Integer | 4 | Package Processing Order | int |
| 15 | Page ID | Page ID | Normal | Integer | 4 | Page ID | int |
| 16 | Processing Order | Processing Order | Normal | Integer | 4 | Processing Order | int |
| 17 | No. of Fields Included | No. of Fields Included | FlowField | Integer | 4 | ||
| 18 | No. of Fields Available | No. of Fields Available | FlowField | Integer | 4 | ||
| 19 | No. of Fields to Validate | No. of Fields to Validate | FlowField | Integer | 4 | ||
| 20 | Package Caption | Package Caption | FlowField | Text | 50 | ||
| 21 | Imported by User ID | Imported by User ID | Normal | Code | 50 | Imported by User ID | nvarchar(100) |
Key to join to the User table.Show/hide example querySELECT
[Config. Package Table].[Imported by User ID]
,[User].[User Name]
FROM
[CRONUS UK Ltd_$Config_ Package Table$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Package Table]
LEFT JOIN
[User] AS [User]
ON
[Config. Package Table].[Imported by User ID] = [User].[User Name] | |||||||
| 22 | Created by User ID | Created by User ID | Normal | Code | 50 | Created by User ID | nvarchar(100) |
| 24 | Dimensions as Columns | Dimensions as Columns | Normal | Boolean | 4 | Dimensions as Columns | tinyint |
| 25 | Filtered | Filtered | FlowField | Boolean | 4 | ||
| 26 | Skip Table Triggers | Skip Table Triggers | Normal | Boolean | 4 | Skip Table Triggers | tinyint |
| 27 | Delete Recs Before Processing | Delete Recs Before Processing | Normal | Boolean | 4 | Delete Recs Before Processing | tinyint |
| 28 | Processing Report ID | Processing Report ID | Normal | Integer | 4 | Processing Report ID | int |
| 29 | Parent Table ID | Parent Table ID | Normal | Integer | 4 | Parent Table ID | int |
| 30 | Validated | Validated | Normal | Boolean | 4 | Validated | tinyint |
| 31 | Delayed Insert | Delayed Insert | Normal | Boolean | 4 | Delayed Insert | tinyint |
| 32 | Cross-Column Filter | Cross-Column Filter | Normal | Boolean | 4 | Cross-Column Filter | tinyint |
| 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
[Config. Package Table].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Config_ Package Table$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Package Table]
LEFT JOIN
[User] AS [User]
ON
[Config. Package Table].[$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 querySELECT
[Config. Package Table].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Config_ Package Table$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Package Table]
LEFT JOIN
[User] AS [User]
ON
[Config. Package Table].[$systemModifiedBy] = [User].[User Security ID] | |||||||