Production BOM Header

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

Table Type: Company

Table Name: Production BOM Header
Database Table Name: CRONUS UK Ltd_$Production BOM Header$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 0

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 Production BOM Header can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Production BOM Header$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Description]
   ,[Description 2]
   ,[Search Name]
   ,[Unit of Measure Code]
   ,[Low-Level Code]
   ,[Creation Date]
   ,[Last Date Modified]
   ,[Status]
   ,[Version Nos_]
   ,[No_ Series]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Production BOM Header$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Production BOM Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Header]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Production BOM Header].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Production BOM Header table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Description Searchnvarchar(200)
4Description 2 Searchnvarchar(100)
5Search Name Searchnvarchar(200)
6Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Production BOM Header].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Production BOM Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Header]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Production BOM Header].[Unit of Measure Code] = [Unit of Measure].[Code]
7Low-Level Code Searchint
8Creation Date Searchdatetime
9Last Date Modified Searchdatetime
10Status Searchint
11Version Nos_ Searchnvarchar(40)
12No_ Series Searchnvarchar(40)
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Production BOM Header table

Show/hide tables related to Production BOM Header table

Leave a Reply

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