Phys. Invt. Order Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables PPhys. Invt. Order Line

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

Table Type: Company

Table Name: Phys. Invt. Order Line
Database Table Name: CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5876

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 Phys. Invt. Order Line can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Document No_]
   ,[Line No_]
   ,[On Recording Lines]
   ,[Item No_]
   ,[Variant Code]
   ,[Location Code]
   ,[Bin Code]
   ,[Description]
   ,[Description 2]
   ,[Unit of Measure]
   ,[Base Unit of Measure Code]
   ,[Qty_ Expected (Base)]
   ,[Qty_ Exp_ Calculated]
   ,[Use Item Tracking]
   ,[Last Item Ledger Entry No_]
   ,[Unit Amount]
   ,[Unit Cost]
   ,[No_ Finished Rec_-Lines]
   ,[Qty_ Recorded (Base)]
   ,[Quantity (Base)]
   ,[Entry Type]
   ,[Pos_ Qty_ (Base)]
   ,[Neg_ Qty_ (Base)]
   ,[Without Difference]
   ,[Recorded Without Order]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Shelf No_]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Inventory Posting Group]
   ,[Dimension Set ID]
   ,[Item Category Code]
   ,[Item Reference No_]
   ,[Item Reference Unit of Measure]
   ,[Item Reference Type]
   ,[Item Reference Type No_]
   ,[Phys Invt Counting Period Code]
   ,[Phys Invt Counting Period Type]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Phys. Invt. Order Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Phys. Invt. Order Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Phys. Invt. Order Line].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Phys. Invt. Order Line].[Unit of Measure] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Phys. Invt. Order Line].[Base Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Phys. Invt. Order Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Phys. Invt. Order Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
      ON
         [Phys. Invt. Order Line].[Inventory Posting Group] = [Inventory Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Phys. Invt. Order Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Phys. Invt. Order Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Phys_ Invt_ Counting Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Counting Period]
      ON
         [Phys. Invt. Order Line].[Phys Invt Counting Period Code] = [Phys. Invt. Counting Period].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Phys. Invt. Order Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Phys. Invt. Order Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Phys. Invt. Order Line table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Document No.	Document No.	Normal	Code	20	Document No_	nvarchar(40)
2	Line No.	Line No.	Normal	Integer	4	Line No_	int
12	On Recording Lines	On Recording Lines	Normal	Boolean	4	On Recording Lines	tinyint
20	Item No.	Item No.	Normal	Code	20	Item No_	nvarchar(40)
	Key to join to the Item table. Show/hide example query SELECT [Phys. Invt. Order Line].[Item No_] ,[Item].[No_] FROM [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line] LEFT JOIN [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] ON [Phys. Invt. Order Line].[Item No_] = [Item].[No_]
21	Variant Code	Variant Code	Normal	Code	10	Variant Code	nvarchar(20)
	Key to join to the Item Variant table. Show/hide example query SELECT [Phys. Invt. Order Line].[Variant Code] ,[Item Variant].[Code] FROM [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line] LEFT JOIN [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant] ON [Phys. Invt. Order Line].[Variant Code] = [Item Variant].[Code]
22	Location Code	Location Code	Normal	Code	10	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Phys. Invt. Order Line].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Phys. Invt. Order Line].[Location Code] = [Location].[Code]
23	Bin Code	Bin Code	Normal	Code	20	Bin Code	nvarchar(40)
	Key to join to the Bin table. Show/hide example query SELECT [Phys. Invt. Order Line].[Bin Code] ,[Bin].[Code] FROM [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line] LEFT JOIN [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin] ON [Phys. Invt. Order Line].[Bin Code] = [Bin].[Code]
30	Description	Description	Normal	Text	100	Description	nvarchar(200)
31	Description 2	Description 2	Normal	Text	50	Description 2	nvarchar(100)
32	Unit of Measure	Unit of Measure	Normal	Text	50	Unit of Measure	nvarchar(100)
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Phys. Invt. Order Line].[Unit of Measure] ,[Unit of Measure].[Code] FROM [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [Phys. Invt. Order Line].[Unit of Measure] = [Unit of Measure].[Code]
40	Base Unit of Measure Code	Base Unit of Measure Code	Normal	Code	10	Base Unit of Measure Code	nvarchar(20)
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Phys. Invt. Order Line].[Base Unit of Measure Code] ,[Unit of Measure].[Code] FROM [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [Phys. Invt. Order Line].[Base Unit of Measure Code] = [Unit of Measure].[Code]
50	Qty. Expected (Base)	Qty. Expected (Base)	Normal	Decimal	12	Qty_ Expected (Base)	decimal(38,38)
51	Qty. Exp. Calculated	Qty. Exp. Calculated	Normal	Boolean	4	Qty_ Exp_ Calculated	tinyint
52	Qty. Exp. Item Tracking (Base)	Qty. Exp. Item Tracking (Base)	FlowField	Decimal	12
53	Use Item Tracking	Use Item Tracking	Normal	Boolean	4	Use Item Tracking	tinyint
55	Last Item Ledger Entry No.	Last Item Ledger Entry No.	Normal	Integer	4	Last Item Ledger Entry No_	int
	Key to join to the Item Ledger Entry table. Show/hide example query SELECT [Phys. Invt. Order Line].[Last Item Ledger Entry No_] ,[Item Ledger Entry].[Entry No_] FROM [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line] LEFT JOIN [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry] ON [Phys. Invt. Order Line].[Last Item Ledger Entry No_] = [Item Ledger Entry].[Entry No_]
60	Unit Amount	Unit Amount	Normal	Decimal	12	Unit Amount	decimal(38,38)
62	Unit Cost	Unit Cost	Normal	Decimal	12	Unit Cost	decimal(38,38)
70	No. Finished Rec.-Lines	No. Finished Rec.-Lines	Normal	Integer	4	No_ Finished Rec_-Lines	int
71	Qty. Recorded (Base)	Qty. Recorded (Base)	Normal	Decimal	12	Qty_ Recorded (Base)	decimal(38,38)
72	Quantity (Base)	Quantity (Base)	Normal	Decimal	12	Quantity (Base)	decimal(38,38)
73	Entry Type	Entry Type	Normal	Option	4	Entry Type	int
	Available options are: ” “ “Positive Adjmt.” “Negative Adjmt.”
74	Pos. Qty. (Base)	Pos. Qty. (Base)	Normal	Decimal	12	Pos_ Qty_ (Base)	decimal(38,38)
75	Neg. Qty. (Base)	Neg. Qty. (Base)	Normal	Decimal	12	Neg_ Qty_ (Base)	decimal(38,38)
76	Without Difference	Without Difference	Normal	Boolean	4	Without Difference	tinyint
80	Recorded Without Order	Recorded Without Order	Normal	Boolean	4	Recorded Without Order	tinyint
90	Shortcut Dimension 1 Code	Shortcut Dimension 1 Code	Normal	Code	20	Shortcut Dimension 1 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Phys. Invt. Order Line].[Shortcut Dimension 1 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Phys. Invt. Order Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
91	Shortcut Dimension 2 Code	Shortcut Dimension 2 Code	Normal	Code	20	Shortcut Dimension 2 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Phys. Invt. Order Line].[Shortcut Dimension 2 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Phys. Invt. Order Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
100	Shelf No.	Shelf No.	Normal	Code	10	Shelf No_	nvarchar(20)
110	Gen. Bus. Posting Group	Gen. Bus. Posting Group	Normal	Code	20	Gen_ Bus_ Posting Group	nvarchar(40)
	Key to join to the Gen. Business Posting Group table. Show/hide example query SELECT [Phys. Invt. Order Line].[Gen_ Bus_ Posting Group] ,[Gen. Business Posting Group].[Code] FROM [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line] LEFT JOIN [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group] ON [Phys. Invt. Order Line].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
111	Gen. Prod. Posting Group	Gen. Prod. Posting Group	Normal	Code	20	Gen_ Prod_ Posting Group	nvarchar(40)
	Key to join to the Gen. Product Posting Group table. Show/hide example query SELECT [Phys. Invt. Order Line].[Gen_ Prod_ Posting Group] ,[Gen. Product Posting Group].[Code] FROM [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line] LEFT JOIN [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group] ON [Phys. Invt. Order Line].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
112	Inventory Posting Group	Inventory Posting Group	Normal	Code	20	Inventory Posting Group	nvarchar(40)
	Key to join to the Inventory Posting Group table. Show/hide example query SELECT [Phys. Invt. Order Line].[Inventory Posting Group] ,[Inventory Posting Group].[Code] FROM [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line] LEFT JOIN [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group] ON [Phys. Invt. Order Line].[Inventory Posting Group] = [Inventory Posting Group].[Code]
480	Dimension Set ID	Dimension Set ID	Normal	Integer	4	Dimension Set ID	int
	Key to join to the Dimension Set Entry table. Show/hide example query SELECT [Phys. Invt. Order Line].[Dimension Set ID] ,[Dimension Set Entry].[Dimension Set ID] FROM [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line] LEFT JOIN [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry] ON [Phys. Invt. Order Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
5704	Item Category Code	Item Category Code	Normal	Code	20	Item Category Code	nvarchar(40)
	Key to join to the Item Category table. Show/hide example query SELECT [Phys. Invt. Order Line].[Item Category Code] ,[Item Category].[Code] FROM [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line] LEFT JOIN [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category] ON [Phys. Invt. Order Line].[Item Category Code] = [Item Category].[Code]
5725	Item Reference No.	Item Reference No.	Normal	Code	50	Item Reference No_	nvarchar(100)
5726	Item Reference Unit of Measure	Item Reference Unit of Measure	Normal	Code	10	Item Reference Unit of Measure	nvarchar(20)
5727	Item Reference Type	Item Reference Type	Normal	Option	4	Item Reference Type	int
	Available options are: ” “ “Customer” “Vendor” “Bar Code”
5728	Item Reference Type No.	Item Reference Type No.	Normal	Code	30	Item Reference Type No_	nvarchar(60)
7380	Phys Invt Counting Period Code	Phys Invt Counting Period Code	Normal	Code	10	Phys Invt Counting Period Code	nvarchar(20)
	Key to join to the Phys. Invt. Counting Period table. Show/hide example query SELECT [Phys. Invt. Order Line].[Phys Invt Counting Period Code] ,[Phys. Invt. Counting Period].[Code] FROM [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line] LEFT JOIN [CRONUS UK Ltd_$Phys_ Invt_ Counting Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Counting Period] ON [Phys. Invt. Order Line].[Phys Invt Counting Period Code] = [Phys. Invt. Counting Period].[Code]
7381	Phys Invt Counting Period Type	Phys Invt Counting Period Type	Normal	Option	4	Phys Invt Counting Period Type	int
	Available options are: ” “ “Item” “SKU”
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 [Phys. Invt. Order Line].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line] LEFT JOIN [User] AS [User] ON [Phys. Invt. Order Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Phys. Invt. Order Line table

Dynamics 365 BC Table Reference Tables Company Tables PPhys. Invt. Order Line

Leave a Reply Cancel reply