Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/911
Table Type: Company
Table Name: Posted Assembly Line
Database Table Name: CRONUS UK Ltd_$Posted Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972
Table Number: 911Due 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 Posted Assembly Line can be queried.
SELECT
*
FROM
[CRONUS UK Ltd_$Posted Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
[Document No_]
,[Line No_]
,[Order No_]
,[Order Line No_]
,[Type]
,[No_]
,[Variant Code]
,[Description]
,[Description 2]
,[Lead-Time Offset]
,[Resource Usage Type]
,[Location Code]
,[Shortcut Dimension 1 Code]
,[Shortcut Dimension 2 Code]
,[Bin Code]
,[Position]
,[Position 2]
,[Position 3]
,[Item Shpt_ Entry No_]
,[Quantity]
,[Quantity (Base)]
,[Due Date]
,[Quantity per]
,[Qty_ per Unit of Measure]
,[Inventory Posting Group]
,[Gen_ Prod_ Posting Group]
,[Unit Cost]
,[Cost Amount]
,[Unit of Measure Code]
,[Dimension Set ID]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Posted Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
*
FROM
[CRONUS UK Ltd_$Posted Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Line]
LEFT JOIN
[CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
ON
[Posted Assembly Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
ON
[Posted Assembly Line].[Location Code] = [Location].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Posted Assembly Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Posted Assembly Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
ON
[Posted Assembly Line].[Bin Code] = [Bin].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
ON
[Posted Assembly 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
[Posted Assembly Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
[User] AS [User]
ON
[Posted Assembly Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Posted Assembly Line].[SystemModifiedBy] = [User].[User Security ID]
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|
| 2 | Document No.  | Document No. | Normal | Code | 20 | Document No_ | nvarchar(40) |
| 3 | Line No.  | Line No. | Normal | Integer | 4 | Line No_ | int |
| 8 | Order No. | Order No. | Normal | Code | 20 | Order No_ | nvarchar(40) |
| 9 | Order Line No. | Order Line No. | Normal | Integer | 4 | Order Line No_ | int |
| 10 | Type | Type | Normal | Option | 4 | Type | int |
| Available options are:
|
| 11 | No. | No. | Normal | Code | 20 | No_ | nvarchar(40) |
| 12 | Variant Code | Variant Code | Normal | Code | 10 | Variant Code | nvarchar(20) |
| Key to join to the Item Variant table.SELECT
[Posted Assembly Line].[Variant Code]
,[Item Variant].[Code]
FROM
[CRONUS UK Ltd_$Posted Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Line]
LEFT JOIN
[CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
ON
[Posted Assembly Line].[Variant Code] = [Item Variant].[Code] |
| 13 | Description | Description | Normal | Text | 100 | Description | nvarchar(200) |
| 14 | Description 2 | Description 2 | Normal | Text | 50 | Description 2 | nvarchar(100) |
| 18 | Lead-Time Offset | Lead-Time Offset | Normal | DateFormula | 32 | Lead-Time Offset | varchar(32) |
| 19 | Resource Usage Type | Resource Usage Type | Normal | Option | 4 | Resource Usage Type | int |
| Available options are:
|
| 20 | Location Code | Location Code | Normal | Code | 10 | Location Code | nvarchar(20) |
| Key to join to the Location table.SELECT
[Posted Assembly Line].[Location Code]
,[Location].[Code]
FROM
[CRONUS UK Ltd_$Posted Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Line]
LEFT JOIN
[CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
ON
[Posted Assembly Line].[Location Code] = [Location].[Code] |
| 21 | Shortcut Dimension 1 Code | Shortcut Dimension 1 Code | Normal | Code | 20 | Shortcut Dimension 1 Code | nvarchar(40) |
| Key to join to the Dimension table.SELECT
[Posted Assembly Line].[Shortcut Dimension 1 Code]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Posted Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Line]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Posted Assembly Line].[Shortcut Dimension 1 Code] = [Dimension].[Code] |
| 22 | Shortcut Dimension 2 Code | Shortcut Dimension 2 Code | Normal | Code | 20 | Shortcut Dimension 2 Code | nvarchar(40) |
| Key to join to the Dimension table.SELECT
[Posted Assembly Line].[Shortcut Dimension 2 Code]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Posted Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Line]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Posted Assembly Line].[Shortcut Dimension 2 Code] = [Dimension].[Code] |
| 23 | Bin Code | Bin Code | Normal | Code | 20 | Bin Code | nvarchar(40) |
| Key to join to the Bin table.SELECT
[Posted Assembly Line].[Bin Code]
,[Bin].[Code]
FROM
[CRONUS UK Ltd_$Posted Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Line]
LEFT JOIN
[CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
ON
[Posted Assembly Line].[Bin Code] = [Bin].[Code] |
| 25 | Position | Position | Normal | Code | 10 | Position | nvarchar(20) |
| 26 | Position 2 | Position 2 | Normal | Code | 10 | Position 2 | nvarchar(20) |
| 27 | Position 3 | Position 3 | Normal | Code | 10 | Position 3 | nvarchar(20) |
| 39 | Item Shpt. Entry No. | Item Shpt. Entry No. | Normal | Integer | 4 | Item Shpt_ Entry No_ | int |
| 40 | Quantity | Quantity | Normal | Decimal | 12 | Quantity | decimal(38,38) |
| 41 | Quantity (Base) | Quantity (Base) | Normal | Decimal | 12 | Quantity (Base) | decimal(38,38) |
| 52 | Due Date | Due Date | Normal | Date | 4 | Due Date | datetime |
| 60 | Quantity per | Quantity per | Normal | Decimal | 12 | Quantity per | decimal(38,38) |
| 61 | Qty. per Unit of Measure | Qty. per Unit of Measure | Normal | Decimal | 12 | Qty_ per Unit of Measure | decimal(38,38) |
| 62 | Inventory Posting Group | Inventory Posting Group | Normal | Code | 20 | Inventory Posting Group | nvarchar(40) |
| Key to join to the Inventory Posting Group table.SELECT
[Posted Assembly Line].[Inventory Posting Group]
,[Inventory Posting Group].[Code]
FROM
[CRONUS UK Ltd_$Posted Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Line]
LEFT JOIN
[CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
ON
[Posted Assembly Line].[Inventory Posting Group] = [Inventory Posting Group].[Code] |
| 63 | 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.SELECT
[Posted Assembly Line].[Gen_ Prod_ Posting Group]
,[Gen. Product Posting Group].[Code]
FROM
[CRONUS UK Ltd_$Posted Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Line]
LEFT JOIN
[CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
ON
[Posted Assembly Line].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code] |
| 65 | Unit Cost | Unit Cost | Normal | Decimal | 12 | Unit Cost | decimal(38,38) |
| 67 | Cost Amount | Cost Amount | Normal | Decimal | 12 | Cost Amount | decimal(38,38) |
| 80 | Unit of Measure Code | Unit of Measure Code | Normal | Code | 10 | Unit of Measure Code | nvarchar(20) |
| 480 | Dimension Set ID | Dimension Set ID | Normal | Integer | 4 | Dimension Set ID | int |
| Key to join to the Dimension Set Entry table.SELECT
[Posted Assembly Line].[Dimension Set ID]
,[Dimension Set Entry].[Dimension Set ID]
FROM
[CRONUS UK Ltd_$Posted Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Line]
LEFT JOIN
[CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
ON
[Posted Assembly Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID] |
| 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.SELECT
[Posted Assembly Line].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Posted Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Line]
LEFT JOIN
[User] AS [User]
ON
[Posted Assembly Line].[$systemCreatedBy] = [User].[User Security ID] |
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
