Whse Demo Data Setup

Dynamics 365 BC Table ReferenceTablesCompany TablesWWhse Demo Data Setup

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

Table Type: Company

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

Table Number: 4763

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Whse 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]
   ,[Adjust for Payment Discount]
   ,[Retail Code]
   ,[Domestic Code]
   ,[Resale Code]
   ,[VAT Prod_ Posting Group Code]
   ,[Price Factor]
   ,[Rounding Precision]
   ,[Customer No_]
   ,[Cust_ Posting Group]
   ,[Cust_ Gen_ Bus_ Posting Group]
   ,[Vendor No_]
   ,[Vendor Posting Group]
   ,[Vend_ Gen_ Bus_ Posting Group]
   ,[Item 1 No_]
   ,[Item 2 No_]
   ,[Item 3 No_]
   ,[Customer VAT Bus_ Code]
   ,[Vendor VAT Bus_ Code]
   ,[Location Bin]
   ,[Location Adv Logistics]
   ,[Location Directed Pick]
   ,[Location In-Transit]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Whse 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_$Whse Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Whse Demo Data Setup]
LEFT JOIN
   [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
      ON
         [Whse Demo Data Setup].[Retail Code] = [Gen. Product Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
      ON
         [Whse Demo Data Setup].[Resale Code] = [Inventory Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
      ON
         [Whse Demo Data Setup].[Vendor Posting Group] = [Vendor Posting Group].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Whse Demo Data Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Whse Demo Data Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Whse 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”
24Adjust for Payment Discount SearchAdjust for Payment DiscountNormalBoolean4Adjust for Payment Discounttinyint
31Retail Code SearchRetail – Gen. Prod. Posting GroupNormalCode20Retail Codenvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
       [Whse Demo Data Setup].[Retail Code]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Whse Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Whse Demo Data Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Whse Demo Data Setup].[Retail Code] = [Gen. Product Posting Group].[Code]
34Domestic Code SearchDomestic – Tax Posting GroupNormalCode10Domestic Codenvarchar(20)
35Resale Code SearchResale – Inventory Posting GroupNormalCode20Resale Codenvarchar(40)
Key to join to the Inventory Posting Group table.

Show/hide example query

SELECT
       [Whse Demo Data Setup].[Resale Code]
       ,[Inventory Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Whse Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Whse Demo Data Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
              ON
                     [Whse Demo Data Setup].[Resale Code] = [Inventory Posting Group].[Code]
36VAT Prod. Posting Group Code SearchTax Prod. Posting Group CodeNormalCode20VAT Prod_ Posting Group Codenvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

SELECT
       [Whse Demo Data Setup].[VAT Prod_ Posting Group Code]
       ,[VAT Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Whse Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Whse Demo Data Setup]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
              ON
                     [Whse Demo Data Setup].[VAT Prod_ Posting Group Code] = [VAT Product Posting Group].[Code]
38Price Factor SearchPrice FactorNormalDecimal12Price Factordecimal(38,38)
39Rounding Precision SearchRounding PrecisionNormalDecimal12Rounding Precisiondecimal(38,38)
40Customer No. SearchCustomer No.NormalCode20Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Whse Demo Data Setup].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Whse Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Whse Demo Data Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Whse Demo Data Setup].[Customer No_] = [Customer].[No_]
41Cust. Posting Group SearchCust. Posting GroupNormalCode20Cust_ Posting Groupnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

SELECT
       [Whse Demo Data Setup].[Cust_ Posting Group]
       ,[Customer Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Whse Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Whse Demo Data Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
              ON
                     [Whse Demo Data Setup].[Cust_ Posting Group] = [Customer Posting Group].[Code]
42Cust. Gen. Bus. Posting Group SearchCust. Gen. Bus. Posting GroupNormalCode20Cust_ Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Whse Demo Data Setup].[Cust_ Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Whse Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Whse Demo Data Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Whse Demo Data Setup].[Cust_ Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
50Vendor No. SearchVendor No.NormalCode20Vendor No_nvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Whse Demo Data Setup].[Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Whse Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Whse Demo Data Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Whse Demo Data Setup].[Vendor No_] = [Vendor].[No_]
51Vendor Posting Group SearchVendor Posting GroupNormalCode20Vendor Posting Groupnvarchar(40)
Key to join to the Vendor Posting Group table.

Show/hide example query

SELECT
       [Whse Demo Data Setup].[Vendor Posting Group]
       ,[Vendor Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Whse Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Whse Demo Data Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
              ON
                     [Whse Demo Data Setup].[Vendor Posting Group] = [Vendor Posting Group].[Code]
52Vend. Gen. Bus. Posting Group SearchVend. Gen. Bus. Posting GroupNormalCode20Vend_ Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Whse Demo Data Setup].[Vend_ Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Whse Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Whse Demo Data Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Whse Demo Data Setup].[Vend_ Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
60Item 1 No. SearchItem 1 No.NormalCode20Item 1 No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Whse Demo Data Setup].[Item 1 No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Whse Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Whse Demo Data Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Whse Demo Data Setup].[Item 1 No_] = [Item].[No_]
61Item 2 No. SearchItem 2 No.NormalCode20Item 2 No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Whse Demo Data Setup].[Item 2 No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Whse Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Whse Demo Data Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Whse Demo Data Setup].[Item 2 No_] = [Item].[No_]
62Item 3 No. SearchItem 3 No.NormalCode20Item 3 No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Whse Demo Data Setup].[Item 3 No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Whse Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Whse Demo Data Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Whse Demo Data Setup].[Item 3 No_] = [Item].[No_]
63Customer VAT Bus. Code SearchCustomer – Tax Business Posting GroupNormalCode20Customer VAT Bus_ Codenvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [Whse Demo Data Setup].[Customer VAT Bus_ Code]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Whse Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Whse Demo Data Setup]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Whse Demo Data Setup].[Customer VAT Bus_ Code] = [VAT Business Posting Group].[Code]
64Vendor VAT Bus. Code SearchVendor – Tax Business Posting GroupNormalCode20Vendor VAT Bus_ Codenvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [Whse Demo Data Setup].[Vendor VAT Bus_ Code]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Whse Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Whse Demo Data Setup]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Whse Demo Data Setup].[Vendor VAT Bus_ Code] = [VAT Business Posting Group].[Code]
70Location Bin SearchLocation BinNormalCode10Location Binnvarchar(20)
80Location Adv Logistics SearchLocation AdvancedNormalCode10Location Adv Logisticsnvarchar(20)
90Location Directed Pick SearchLocation Directed Pick and Put-awayNormalCode10Location Directed Picknvarchar(20)
100Location In-Transit SearchLocation In-TransitNormalCode10Location In-Transitnvarchar(20)
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
       [Whse Demo Data Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Whse Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Whse Demo Data Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Whse 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
       [Whse Demo Data Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Whse Demo Data Setup$5a0b41e9-7a42-4123-d521-2265186cfb31] AS [Whse Demo Data Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Whse Demo Data Setup].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Whse Demo Data Setup table

Vendor Posting Group
Dynamics 365 BC Table ReferenceTablesCompany TablesWWhse Demo Data Setup

Leave a Reply

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