Config_ Package Data

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

Table Type: Company

Table Name: Config_ Package Data
Database Table Name: CRONUS UK Ltd_$Config_ Package Data$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 Data can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Package Code]
   ,[Table ID]
   ,[No_]
   ,[Field ID]
   ,[Value]
   ,[Invalid]
   ,[BLOB Value]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Config_ Package Data$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Config_ Package Data table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Package Code Primary Key Searchnvarchar(40)
3Table ID Primary Key Searchint
4No_ Primary Key Searchint
5Field ID Primary Key Searchint
6Value Searchnvarchar(4096)
7Invalid Searchtinyint
8BLOB Value Searchimage
9$systemId Searchuniqueidentifier
10$systemCreatedAt Searchdatetime
11$systemCreatedBy Searchuniqueidentifier
12$systemModifiedAt Searchdatetime
13$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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