Config. Package – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CConfig. Package

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

Table Type: Company

Table Name: Config. Package
Database Table Name: CRONUS UK Ltd_$Config_ Package$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 8623

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Config_ Package$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Code]
   ,[Package Name]
   ,[Language ID]
   ,[Product Version]
   ,[Exclude Config_ Tables]
   ,[Processing Order]
   ,[Import Status]
   ,[Apply Status]
   ,[Min_ Count For Async Import]
   ,[Import Error]
   ,[Apply Error]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Config_ Package$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$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Package]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Config. Package].[Language ID] = [Language].[Windows Language ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Config. Package].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Config. Package].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Config. Package table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Code	Code	Normal	Code	20	Code	nvarchar(40)
2	Package Name	Package Name	Normal	Text	50	Package Name	nvarchar(100)
4	Language ID	Language ID	Normal	Integer	4	Language ID	int
	Key to join to the Language table. Show/hide example query SELECT [Config. Package].[Language ID] ,[Language].[Windows Language ID] FROM [CRONUS UK Ltd_$Config_ Package$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Package] LEFT JOIN [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language] ON [Config. Package].[Language ID] = [Language].[Windows Language ID]
5	No. of Tables	No. of Tables	FlowField	Integer	4
6	Product Version	Product Version	Normal	Text	248	Product Version	nvarchar(496)
11	Exclude Config. Tables	Exclude Config. Tables	Normal	Boolean	4	Exclude Config_ Tables	tinyint
12	Processing Order	Processing Order	Normal	Integer	4	Processing Order	int
13	No. of Records	No. of Records	FlowField	Integer	4
16	No. of Errors	No. of Errors	FlowField	Integer	4
17	Import Status	Import Status	Normal	Option	4	Import Status	int
	Available options are: “No” “Scheduled” “InProgress” “Completed” “Error”
18	Apply Status	Apply Status	Normal	Option	4	Apply Status	int
	Available options are: “No” “Scheduled” “InProgress” “Completed” “Error”
19	Min. Count For Async Import	Min. Count For Async Import	Normal	Integer	4	Min_ Count For Async Import	int
20	Import Error	Import Error	Normal	Text	2048	Import Error	nvarchar(4096)
21	Apply Error	Apply Error	Normal	Text	2048	Apply Error	nvarchar(4096)
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 [Config. Package].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Config_ Package$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Package] LEFT JOIN [User] AS [User] ON [Config. Package].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier