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
   [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 an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Manufacturing Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Manufacturing Demo Data Setup]
LEFT JOIN
   [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
      ON
         [Manufacturing Demo Data Setup].[Base VAT Code] = [VAT Product Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
      ON
         [Manufacturing Demo Data Setup].[Finished Code] = [Inventory Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
      ON
         [Manufacturing Demo Data Setup].[Retail Code] = [Gen. Product Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
      ON
         [Manufacturing Demo Data Setup].[Raw Mat Code] = [Gen. Product Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
      ON
         [Manufacturing Demo Data Setup].[Manufact Code] = [Gen. Product Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Manufacturing Demo Data Setup].[Manufacturing Location] = [Location].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Manufacturing Demo Data Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Manufacturing Demo Data Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Manufacturing Demo Data Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key Primary Key SearchPrimary KeyNormalInteger4Primary Keyint
2Is DemoData Populated SearchIs DemoData PopulatedNormalBoolean4Is DemoData Populatedtinyint
8Starting Year SearchStarting YearNormalInteger4Starting Yearint
9Working Date SearchWorking DateNormalDate4Working Datedatetime
17Company Type SearchCompany TypeNormalOption4Company Typeint
Available options are:
  • “VAT”
  • “Sales Tax”
18Base VAT Code SearchBase Tax CodeNormalCode20Base VAT Codenvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

SELECT
       [Manufacturing Demo Data Setup].[Base VAT Code]
       ,[VAT Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Manufacturing Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Manufacturing Demo Data Setup]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
              ON
                     [Manufacturing Demo Data Setup].[Base VAT Code] = [VAT Product Posting Group].[Code]
24Adjust for Payment Discount SearchAdjust for Payment DiscountNormalBoolean4Adjust for Payment Discounttinyint
30Finished Code SearchFinished CodeNormalCode20Finished Codenvarchar(40)
Key to join to the Inventory Posting Group table.

Show/hide example query

SELECT
       [Manufacturing Demo Data Setup].[Finished Code]
       ,[Inventory Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Manufacturing Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Manufacturing Demo Data Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
              ON
                     [Manufacturing Demo Data Setup].[Finished Code] = [Inventory Posting Group].[Code]
31Retail Code SearchRetail – Gen. Prod. Posting GroupNormalCode20Retail Codenvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
       [Manufacturing Demo Data Setup].[Retail Code]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Manufacturing Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Manufacturing Demo Data Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Manufacturing Demo Data Setup].[Retail Code] = [Gen. Product Posting Group].[Code]
32Raw Mat Code SearchRaw Mat – Gen. Prod. Posting GroupNormalCode20Raw Mat Codenvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
       [Manufacturing Demo Data Setup].[Raw Mat Code]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Manufacturing Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Manufacturing Demo Data Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Manufacturing Demo Data Setup].[Raw Mat Code] = [Gen. Product Posting Group].[Code]
33Manufact Code SearchCapacity – Gen. Prod. Posting GroupNormalCode20Manufact Codenvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
       [Manufacturing Demo Data Setup].[Manufact Code]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Manufacturing Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Manufacturing Demo Data Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Manufacturing Demo Data Setup].[Manufact Code] = [Gen. Product Posting Group].[Code]
34Domestic Code SearchDomestic – Gen. Bus. Posting GroupNormalCode20Domestic Codenvarchar(40)
37Manufacturing Location SearchManufacturing LocationNormalCode10Manufacturing Locationnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Manufacturing Demo Data Setup].[Manufacturing Location]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Manufacturing Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Manufacturing Demo Data Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Manufacturing Demo Data Setup].[Manufacturing Location] = [Location].[Code]
38Price Factor SearchPrice FactorNormalDecimal12Price Factordecimal(38,38)
39Rounding Precision SearchRounding PrecisionNormalDecimal12Rounding Precisiondecimal(38,38)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Manufacturing Demo Data Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Manufacturing Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Manufacturing Demo Data Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Manufacturing Demo Data Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Manufacturing Demo Data Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Manufacturing Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Manufacturing Demo Data Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Manufacturing Demo Data Setup].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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