Inventory Adjmt. Entry (Order)

Dynamics 365 BC Table ReferenceTablesCompany TablesIInventory Adjmt. Entry (Order)

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

Table Type: Company

Table Name: Inventory Adjmt. Entry (Order)
Database Table Name: CRONUS UK Ltd_$Inventory Adjmt_ Entry (Order)$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5896

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 Inventory Adjmt. Entry (Order) can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Inventory Adjmt_ Entry (Order)$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Order Type]
   ,[Order No_]
   ,[Order Line No_]
   ,[Item No_]
   ,[Routing No_]
   ,[Routing Reference No_]
   ,[Indirect Cost _]
   ,[Overhead Rate]
   ,[Cost is Adjusted]
   ,[Allow Online Adjustment]
   ,[Unit Cost]
   ,[Direct Cost]
   ,[Indirect Cost]
   ,[Single-Level Material Cost]
   ,[Single-Level Capacity Cost]
   ,[Single-Level Subcontrd_ Cost]
   ,[Single-Level Cap_ Ovhd Cost]
   ,[Single-Level Mfg_ Ovhd Cost]
   ,[Direct Cost (ACY)]
   ,[Indirect Cost (ACY)]
   ,[Single-Lvl Material Cost (ACY)]
   ,[Single-Lvl Capacity Cost (ACY)]
   ,[Single-Lvl Subcontrd Cost(ACY)]
   ,[Single-Lvl Cap_ Ovhd Cost(ACY)]
   ,[Single-Lvl Mfg_ Ovhd Cost(ACY)]
   ,[Completely Invoiced]
   ,[Is Finished]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Inventory Adjmt_ Entry (Order)$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Inventory Adjmt_ Entry (Order)$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Adjmt. Entry (Order)]
LEFT JOIN
   [User] AS [User]
      ON
         [Inventory Adjmt. Entry (Order)].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Inventory Adjmt. Entry (Order)].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Inventory Adjmt. Entry (Order) table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Order Type Primary Key SearchOrder TypeNormalOption4Order Typeint
Available options are:
  • ” “
  • “Production”
  • “Transfer”
  • “Service”
  • “Assembly”
2Order No. Primary Key SearchOrder No.NormalCode20Order No_nvarchar(40)
3Order Line No. Primary Key SearchOrder Line No.NormalInteger4Order Line No_int
4Item No. SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Inventory Adjmt. Entry (Order)].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Inventory Adjmt_ Entry (Order)$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Adjmt. Entry (Order)]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Inventory Adjmt. Entry (Order)].[Item No_] = [Item].[No_]
7Routing No. SearchRouting No.NormalCode20Routing No_nvarchar(40)
Key to join to the Routing Header table.

Show/hide example query

SELECT
       [Inventory Adjmt. Entry (Order)].[Routing No_]
       ,[Routing Header].[No_]
FROM
       [CRONUS UK Ltd_$Inventory Adjmt_ Entry (Order)$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Adjmt. Entry (Order)]
LEFT JOIN
       [CRONUS UK Ltd_$Routing Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Header]
              ON
                     [Inventory Adjmt. Entry (Order)].[Routing No_] = [Routing Header].[No_]
8Routing Reference No. SearchRouting Reference No.NormalInteger4Routing Reference No_int
21Indirect Cost % SearchIndirect Cost %NormalDecimal12Indirect Cost _decimal(38,38)
22Overhead Rate SearchOverhead RateNormalDecimal12Overhead Ratedecimal(38,38)
29Cost is Adjusted SearchCost is AdjustedNormalBoolean4Cost is Adjustedtinyint
30Allow Online Adjustment SearchAllow Online AdjustmentNormalBoolean4Allow Online Adjustmenttinyint
41Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
42Direct Cost SearchDirect CostNormalDecimal12Direct Costdecimal(38,38)
43Indirect Cost SearchIndirect CostNormalDecimal12Indirect Costdecimal(38,38)
44Single-Level Material Cost SearchSingle-Level Material CostNormalDecimal12Single-Level Material Costdecimal(38,38)
45Single-Level Capacity Cost SearchSingle-Level Capacity CostNormalDecimal12Single-Level Capacity Costdecimal(38,38)
46Single-Level Subcontrd. Cost SearchSingle-Level Subcontrd. CostNormalDecimal12Single-Level Subcontrd_ Costdecimal(38,38)
47Single-Level Cap. Ovhd Cost SearchSingle-Level Cap. Ovhd CostNormalDecimal12Single-Level Cap_ Ovhd Costdecimal(38,38)
48Single-Level Mfg. Ovhd Cost SearchSingle-Level Mfg. Ovhd CostNormalDecimal12Single-Level Mfg_ Ovhd Costdecimal(38,38)
52Direct Cost (ACY) SearchDirect Cost (ACY)NormalDecimal12Direct Cost (ACY)decimal(38,38)
53Indirect Cost (ACY) SearchIndirect Cost (ACY)NormalDecimal12Indirect Cost (ACY)decimal(38,38)
54Single-Lvl Material Cost (ACY) SearchSingle-Lvl Material Cost (ACY)NormalDecimal12Single-Lvl Material Cost (ACY)decimal(38,38)
55Single-Lvl Capacity Cost (ACY) SearchSingle-Lvl Capacity Cost (ACY)NormalDecimal12Single-Lvl Capacity Cost (ACY)decimal(38,38)
56Single-Lvl Subcontrd Cost(ACY) SearchSingle-Lvl Subcontrd Cost(ACY)NormalDecimal12Single-Lvl Subcontrd Cost(ACY)decimal(38,38)
57Single-Lvl Cap. Ovhd Cost(ACY) SearchSingle-Lvl Cap. Ovhd Cost(ACY)NormalDecimal12Single-Lvl Cap_ Ovhd Cost(ACY)decimal(38,38)
58Single-Lvl Mfg. Ovhd Cost(ACY) SearchSingle-Lvl Mfg. Ovhd Cost(ACY)NormalDecimal12Single-Lvl Mfg_ Ovhd Cost(ACY)decimal(38,38)
61Completely Invoiced SearchCompletely InvoicedNormalBoolean4Completely Invoicedtinyint
62Is Finished SearchIs FinishedNormalBoolean4Is Finishedtinyint
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
       [Inventory Adjmt. Entry (Order)].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Inventory Adjmt_ Entry (Order)$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Adjmt. Entry (Order)]
LEFT JOIN
       [User] AS [User]
              ON
                     [Inventory Adjmt. Entry (Order)].[$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
       [Inventory Adjmt. Entry (Order)].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Inventory Adjmt_ Entry (Order)$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Adjmt. Entry (Order)]
LEFT JOIN
       [User] AS [User]
              ON
                     [Inventory Adjmt. Entry (Order)].[$systemModifiedBy] = [User].[User Security ID]
Dynamics 365 BC Table ReferenceTablesCompany TablesIInventory Adjmt. Entry (Order)

Leave a Reply

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