Inventory Adjmt. Entry (Order) – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IInventory 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Order Type	Order Type	Normal	Option	4	Order Type	int
	Available options are: ” “ “Production” “Transfer” “Service” “Assembly”
2	Order No.	Order No.	Normal	Code	20	Order No_	nvarchar(40)
3	Order Line No.	Order Line No.	Normal	Integer	4	Order Line No_	int
4	Item No.	Item No.	Normal	Code	20	Item 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_]
7	Routing No.	Routing No.	Normal	Code	20	Routing 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_]
8	Routing Reference No.	Routing Reference No.	Normal	Integer	4	Routing Reference No_	int
21	Indirect Cost %	Indirect Cost %	Normal	Decimal	12	Indirect Cost _	decimal(38,38)
22	Overhead Rate	Overhead Rate	Normal	Decimal	12	Overhead Rate	decimal(38,38)
29	Cost is Adjusted	Cost is Adjusted	Normal	Boolean	4	Cost is Adjusted	tinyint
30	Allow Online Adjustment	Allow Online Adjustment	Normal	Boolean	4	Allow Online Adjustment	tinyint
41	Unit Cost	Unit Cost	Normal	Decimal	12	Unit Cost	decimal(38,38)
42	Direct Cost	Direct Cost	Normal	Decimal	12	Direct Cost	decimal(38,38)
43	Indirect Cost	Indirect Cost	Normal	Decimal	12	Indirect Cost	decimal(38,38)
44	Single-Level Material Cost	Single-Level Material Cost	Normal	Decimal	12	Single-Level Material Cost	decimal(38,38)
45	Single-Level Capacity Cost	Single-Level Capacity Cost	Normal	Decimal	12	Single-Level Capacity Cost	decimal(38,38)
46	Single-Level Subcontrd. Cost	Single-Level Subcontrd. Cost	Normal	Decimal	12	Single-Level Subcontrd_ Cost	decimal(38,38)
47	Single-Level Cap. Ovhd Cost	Single-Level Cap. Ovhd Cost	Normal	Decimal	12	Single-Level Cap_ Ovhd Cost	decimal(38,38)
48	Single-Level Mfg. Ovhd Cost	Single-Level Mfg. Ovhd Cost	Normal	Decimal	12	Single-Level Mfg_ Ovhd Cost	decimal(38,38)
52	Direct Cost (ACY)	Direct Cost (ACY)	Normal	Decimal	12	Direct Cost (ACY)	decimal(38,38)
53	Indirect Cost (ACY)	Indirect Cost (ACY)	Normal	Decimal	12	Indirect Cost (ACY)	decimal(38,38)
54	Single-Lvl Material Cost (ACY)	Single-Lvl Material Cost (ACY)	Normal	Decimal	12	Single-Lvl Material Cost (ACY)	decimal(38,38)
55	Single-Lvl Capacity Cost (ACY)	Single-Lvl Capacity Cost (ACY)	Normal	Decimal	12	Single-Lvl Capacity Cost (ACY)	decimal(38,38)
56	Single-Lvl Subcontrd Cost(ACY)	Single-Lvl Subcontrd Cost(ACY)	Normal	Decimal	12	Single-Lvl Subcontrd Cost(ACY)	decimal(38,38)
57	Single-Lvl Cap. Ovhd Cost(ACY)	Single-Lvl Cap. Ovhd Cost(ACY)	Normal	Decimal	12	Single-Lvl Cap_ Ovhd Cost(ACY)	decimal(38,38)
58	Single-Lvl Mfg. Ovhd Cost(ACY)	Single-Lvl Mfg. Ovhd Cost(ACY)	Normal	Decimal	12	Single-Lvl Mfg_ Ovhd Cost(ACY)	decimal(38,38)
61	Completely Invoiced	Completely Invoiced	Normal	Boolean	4	Completely Invoiced	tinyint
62	Is Finished	Is Finished	Normal	Boolean	4	Is Finished	tinyint
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier