Manufacturing Demo Data Setup

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

Table Type: Company

Table Name: Manufacturing Demo Data Setup
Database Table Name: CRONUS UK Ltd_$Manufacturing Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31

Table Number: 4760

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 Manufacturing Demo Data Setup can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Manufacturing Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Primary Key]
   ,[Is DemoData Populated]
   ,[Starting Year]
   ,[Working Date]
   ,[Company Type]
   ,[Base VAT Code]
   ,[Adjust for Payment Discount]
   ,[Finished Code]
   ,[Retail Code]
   ,[Raw Mat Code]
   ,[Manufact Code]
   ,[Domestic Code]
   ,[Manufacturing Location]
   ,[Price Factor]
   ,[Rounding Precision]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Manufacturing Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31]

Show/hide columns in Manufacturing Demo Data Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchint
3Is DemoData Populated Searchtinyint
4Starting Year Searchint
5Working Date Searchdatetime
6Company Type Searchint
7Base VAT Code Searchnvarchar(20)
8Adjust for Payment Discount Searchtinyint
9Finished Code Searchnvarchar(20)
10Retail Code Searchnvarchar(20)
11Raw Mat Code Searchnvarchar(20)
12Manufact Code Searchnvarchar(20)
13Domestic Code Searchnvarchar(20)
14Manufacturing Location Searchnvarchar(20)
15Price Factor Searchdecimal(38,38)
16Rounding Precision Searchdecimal(38,38)
17$systemId Searchuniqueidentifier
18$systemCreatedAt Searchdatetime
19$systemCreatedBy Searchuniqueidentifier
20$systemModifiedAt Searchdatetime
21$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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