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: 0

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
   [timestamp]
   ,[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 columns in Config_ Package table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(40)
3Package Name Searchnvarchar(100)
4Language ID Searchint
5Product Version Searchnvarchar(496)
6Exclude Config_ Tables Searchtinyint
7Processing Order Searchint
8Import Status Searchint
9Apply Status Searchint
10Min_ Count For Async Import Searchint
11Import Error Searchnvarchar(4096)
12Apply Error Searchnvarchar(4096)
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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