Config. 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code Primary Key SearchCodeNormalCode20Codenvarchar(40)
2Package Name SearchPackage NameNormalText50Package Namenvarchar(100)
4Language ID SearchLanguage IDNormalInteger4Language IDint
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]
5No. of Tables SearchNo. of TablesFlowFieldInteger4
6Product Version SearchProduct VersionNormalText248Product Versionnvarchar(496)
11Exclude Config. Tables SearchExclude Config. TablesNormalBoolean4Exclude Config_ Tablestinyint
12Processing Order SearchProcessing OrderNormalInteger4Processing Orderint
13No. of Records SearchNo. of RecordsFlowFieldInteger4
16No. of Errors SearchNo. of ErrorsFlowFieldInteger4
17Import Status SearchImport StatusNormalOption4Import Statusint
Available options are:
  • “No”
  • “Scheduled”
  • “InProgress”
  • “Completed”
  • “Error”
18Apply Status SearchApply StatusNormalOption4Apply Statusint
Available options are:
  • “No”
  • “Scheduled”
  • “InProgress”
  • “Completed”
  • “Error”
19Min. Count For Async Import SearchMin. Count For Async ImportNormalInteger4Min_ Count For Async Importint
20Import Error SearchImport ErrorNormalText2048Import Errornvarchar(4096)
21Apply Error SearchApply ErrorNormalText2048Apply Errornvarchar(4096)
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].[$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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Config. Package].[$systemModifiedBy]
       ,[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].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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