Config. Package Table

Dynamics 365 BC Table ReferenceTablesCompany TablesCConfig. Package Table

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

Table Number: 8613

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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Package Code SearchPackage CodeNormalCode20Package Codenvarchar(40)
Key to join to the Config. Package table.

Show/hide example query

SELECT
	       [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]
2Table ID Primary Key SearchTable IDNormalInteger4Table IDint
Key to join to the Data Exch. Mapping table.

Show/hide example query

SELECT
	       [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]
3Table Name Primary Key SearchTable NameFlowFieldText250
4No. of Package Records SearchNo. of Package RecordsFlowFieldInteger4
5No. of Package Errors SearchNo. of Package ErrorsFlowFieldInteger4
7Imported Date and Time SearchImported Date and TimeNormalDateTime8Imported Date and Timedatetime
8Exported Date and Time SearchExported Date and TimeNormalDateTime8Exported Date and Timedatetime
9Comments SearchCommentsNormalText250Commentsnvarchar(500)
10Created Date and Time SearchCreated Date and TimeNormalDateTime8Created Date and Timedatetime
11Company Filter (Source Table) SearchCompany Filter (Source Table)FlowFilterText30
Key to join to the Company table.

Show/hide example query

SELECT
	       [Config. Package Table].[]
	       ,[Company].[Name]
	FROM
	       [CRONUS UK Ltd_$Config_ Package Table$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Package Table]
	LEFT JOIN
	       [Company] AS [Company]
	              ON
	                     [Config. Package Table].[] = [Company].[Name]
12Table Caption SearchTable CaptionFlowFieldText250
13Data Template SearchData TemplateNormalCode10Data Templatenvarchar(20)
Key to join to the Config. Template Header table.

Show/hide example query

SELECT
	       [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]
14Package Processing Order SearchPackage Processing OrderNormalInteger4Package Processing Orderint
15Page ID SearchPage IDNormalInteger4Page IDint
16Processing Order SearchProcessing OrderNormalInteger4Processing Orderint
17No. of Fields Included SearchNo. of Fields IncludedFlowFieldInteger4
18No. of Fields Available SearchNo. of Fields AvailableFlowFieldInteger4
19No. of Fields to Validate SearchNo. of Fields to ValidateFlowFieldInteger4
20Package Caption SearchPackage CaptionFlowFieldText50
21Imported by User ID SearchImported by User IDNormalCode50Imported by User IDnvarchar(100)
Key to join to the User table.

Show/hide example query

SELECT
	       [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]
22Created by User ID SearchCreated by User IDNormalCode50Created by User IDnvarchar(100)
24Dimensions as Columns SearchDimensions as ColumnsNormalBoolean4Dimensions as Columnstinyint
25Filtered SearchFilteredFlowFieldBoolean4
26Skip Table Triggers SearchSkip Table TriggersNormalBoolean4Skip Table Triggerstinyint
27Delete Recs Before Processing SearchDelete Recs Before ProcessingNormalBoolean4Delete Recs Before Processingtinyint
28Processing Report ID SearchProcessing Report IDNormalInteger4Processing Report IDint
29Parent Table ID SearchParent Table IDNormalInteger4Parent Table IDint
30Validated SearchValidatedNormalBoolean4Validatedtinyint
31Delayed Insert SearchDelayed InsertNormalBoolean4Delayed Inserttinyint
32Cross-Column Filter SearchCross-Column FilterNormalBoolean4Cross-Column Filtertinyint
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
	       [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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesCConfig. Package Table

Leave a Reply

Your email address will not be published. Required fields are marked *