Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5880
Table Type: Company
Table Name: Pstd_ Phys_ Invt_ Order Line
Database Table Name: CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972
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 Pstd_ Phys_ Invt_ Order Line can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[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]
,[Intern Item Track_ Pos_ Qut_]
,[Intern Item Track_ Neg_ Qut_]
,[Dimension Set ID]
,[Item Category Code]
,[Phys Invt Counting Period Code]
,[Phys Invt Counting Period Type]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Pstd_ 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_$Pstd_ Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd_ Phys_ Invt_ Order Line]
LEFT JOIN
[CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
ON
[Pstd_ Phys_ Invt_ Order Line].[Item No_] = [Item].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
ON
[Pstd_ Phys_ Invt_ Order Line].[Location Code] = [Location].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
ON
[Pstd_ Phys_ Invt_ Order Line].[Item Category Code] = [Item Category].[Code]Show/hide columns in Pstd_ Phys_ Invt_ Order Line table
| Column ID | Column Name | Data Type | ||||
|---|---|---|---|---|---|---|
| 1 | timestamp  | timestamp | ||||
| 2 | Document No_  | nvarchar(40) | ||||
| 3 | Line No_ | int | ||||
| 4 | On Recording Lines | tinyint | ||||
| 5 | Item No_ | nvarchar(40) | ||||
Key to join to the Item table.Show/hide example querySELECT
[Pstd_ Phys_ Invt_ Order Line].[Item No_]
,[Item].[No_]
FROM
[CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd_ Phys_ Invt_ Order Line]
LEFT JOIN
[CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
ON
[Pstd_ Phys_ Invt_ Order Line].[Item No_] = [Item].[No_] | ||||||
| 6 | Variant Code | nvarchar(20) | ||||
| 7 | Location Code | nvarchar(20) | ||||
Key to join to the Location table.Show/hide example querySELECT
[Pstd_ Phys_ Invt_ Order Line].[Location Code]
,[Location].[Code]
FROM
[CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd_ Phys_ Invt_ Order Line]
LEFT JOIN
[CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
ON
[Pstd_ Phys_ Invt_ Order Line].[Location Code] = [Location].[Code] | ||||||
| 8 | Bin Code | nvarchar(40) | ||||
| 9 | Description | nvarchar(200) | ||||
| 10 | Description 2 | nvarchar(100) | ||||
| 11 | Unit of Measure | nvarchar(100) | ||||
| 12 | Base Unit of Measure Code | nvarchar(20) | ||||
| 13 | Qty_ Expected (Base) | decimal(38,38) | ||||
| 14 | Qty_ Exp_ Calculated | tinyint | ||||
| 15 | Use Item Tracking | tinyint | ||||
| 16 | Last Item Ledger Entry No_ | int | ||||
| 17 | Unit Amount | decimal(38,38) | ||||
| 18 | Unit Cost | decimal(38,38) | ||||
| 19 | No_ Finished Rec_-Lines | int | ||||
| 20 | Qty_ Recorded (Base) | decimal(38,38) | ||||
| 21 | Quantity (Base) | decimal(38,38) | ||||
| 22 | Entry Type | int | ||||
| 23 | Pos_ Qty_ (Base) | decimal(38,38) | ||||
| 24 | Neg_ Qty_ (Base) | decimal(38,38) | ||||
| 25 | Without Difference | tinyint | ||||
| 26 | Recorded Without Order | tinyint | ||||
| 27 | Shortcut Dimension 1 Code | nvarchar(40) | ||||
| 28 | Shortcut Dimension 2 Code | nvarchar(40) | ||||
| 29 | Shelf No_ | nvarchar(20) | ||||
| 30 | Gen_ Bus_ Posting Group | nvarchar(40) | ||||
| 31 | Gen_ Prod_ Posting Group | nvarchar(40) | ||||
| 32 | Inventory Posting Group | nvarchar(40) | ||||
| 33 | Intern Item Track_ Pos_ Qut_ | int | ||||
| 34 | Intern Item Track_ Neg_ Qut_ | int | ||||
| 35 | Dimension Set ID | int | ||||
| 36 | Item Category Code | nvarchar(40) | ||||
Key to join to the Item Category table.Show/hide example querySELECT
[Pstd_ Phys_ Invt_ Order Line].[Item Category Code]
,[Item Category].[Code]
FROM
[CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd_ Phys_ Invt_ Order Line]
LEFT JOIN
[CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
ON
[Pstd_ Phys_ Invt_ Order Line].[Item Category Code] = [Item Category].[Code] | ||||||
| 37 | Phys Invt Counting Period Code | nvarchar(20) | ||||
| 38 | Phys Invt Counting Period Type | int | ||||
| 39 | $systemId | uniqueidentifier | ||||
| 40 | $systemCreatedAt | datetime | ||||
| 41 | $systemCreatedBy | uniqueidentifier | ||||
| 42 | $systemModifiedAt | datetime | ||||
| 43 | $systemModifiedBy | uniqueidentifier | ||||