Configuration Package File

Table Type: System

Table Name: Configuration Package File
Database Table Name: Configuration Package File

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [Configuration Package File]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Code]
   ,[Name]
   ,[Language ID]
   ,[Setup Type]
   ,[Processing Order]
   ,[Package]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [Configuration Package File]

Show/hide columns in Configuration Package File table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Code	nvarchar(40)
3	Name	nvarchar(100)
4	Language ID	int
5	Setup Type	int
6	Processing Order	int
7	Package	image
8	$systemId	uniqueidentifier
9	$systemCreatedAt	datetime
10	$systemCreatedBy	uniqueidentifier
11	$systemModifiedAt	datetime
12	$systemModifiedBy	uniqueidentifier