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
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 ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Primary Key  | int |
| 3 | Is DemoData Populated | tinyint |
| 4 | Starting Year | int |
| 5 | Working Date | datetime |
| 6 | Company Type | int |
| 7 | Base VAT Code | nvarchar(20) |
| 8 | Adjust for Payment Discount | tinyint |
| 9 | Finished Code | nvarchar(20) |
| 10 | Retail Code | nvarchar(20) |
| 11 | Raw Mat Code | nvarchar(20) |
| 12 | Manufact Code | nvarchar(20) |
| 13 | Domestic Code | nvarchar(20) |
| 14 | Manufacturing Location | nvarchar(20) |
| 15 | Price Factor | decimal(38,38) |
| 16 | Rounding Precision | decimal(38,38) |
| 17 | $systemId | uniqueidentifier |
| 18 | $systemCreatedAt | datetime |
| 19 | $systemCreatedBy | uniqueidentifier |
| 20 | $systemModifiedAt | datetime |
| 21 | $systemModifiedBy | uniqueidentifier |