Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/910
Table Type: Company
Table Name: Posted Assembly Header
Database Table Name: CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972
Table Number: 910Due 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 Header can be queried.
SELECT
*
FROM
[CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
[No_]
,[Description]
,[Search Description]
,[Description 2]
,[Order No_]
,[Item No_]
,[Variant Code]
,[Inventory Posting Group]
,[Gen_ Prod_ Posting Group]
,[Location Code]
,[Shortcut Dimension 1 Code]
,[Shortcut Dimension 2 Code]
,[Posting Date]
,[Due Date]
,[Starting Date]
,[Ending Date]
,[Bin Code]
,[Item Rcpt_ Entry No_]
,[Quantity]
,[Quantity (Base)]
,[Unit Cost]
,[Cost Amount]
,[Indirect Cost _]
,[Overhead Rate]
,[Unit of Measure Code]
,[Qty_ per Unit of Measure]
,[Reversed]
,[No_ Series]
,[Posting No_ Series]
,[Order No_ Series]
,[Dimension Set ID]
,[User ID]
,[Source Code]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
*
FROM
[CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
[CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
ON
[Posted Assembly Header].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
ON
[Posted Assembly Header].[Inventory Posting Group] = [Inventory Posting Group].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
ON
[Posted Assembly Header].[Location Code] = [Location].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Posted Assembly Header].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Posted Assembly Header].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
ON
[Posted Assembly Header].[Ending Date] = [Inventory Period].[Ending Date]
LEFT JOIN
[CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
ON
[Posted Assembly Header].[Bin Code] = [Bin].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
ON
[Posted Assembly Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
[CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
ON
[Posted Assembly Header].[Source Code] = [Source Code].[Code]
LEFT JOIN
[User] AS [User]
ON
[Posted Assembly Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Posted Assembly Header].[SystemModifiedBy] = [User].[User Security ID]
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|
| 2 | No.  | No. | Normal | Code | 20 | No_ | nvarchar(40) |
| 3 | Description  | Description | Normal | Text | 100 | Description | nvarchar(200) |
| 4 | Search Description | Search Description | Normal | Code | 100 | Search Description | nvarchar(200) |
| 5 | Description 2 | Description 2 | Normal | Text | 50 | Description 2 | nvarchar(100) |
| 9 | Order No. | Order No. | Normal | Code | 20 | Order No_ | nvarchar(40) |
| 10 | Item No. | Item No. | Normal | Code | 20 | Item No_ | nvarchar(40) |
| Key to join to the Item table.SELECT
[Posted Assembly Header].[Item No_]
,[Item].[No_]
FROM
[CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
[CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
ON
[Posted Assembly Header].[Item No_] = [Item].[No_] |
| 12 | Variant Code | Variant Code | Normal | Code | 10 | Variant Code | nvarchar(20) |
| Key to join to the Item Variant table.SELECT
[Posted Assembly Header].[Variant Code]
,[Item Variant].[Code]
FROM
[CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
[CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
ON
[Posted Assembly Header].[Variant Code] = [Item Variant].[Code] |
| 15 | 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 Header].[Inventory Posting Group]
,[Inventory Posting Group].[Code]
FROM
[CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
[CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
ON
[Posted Assembly Header].[Inventory Posting Group] = [Inventory Posting Group].[Code] |
| 16 | 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 Header].[Gen_ Prod_ Posting Group]
,[Gen. Product Posting Group].[Code]
FROM
[CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
[CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
ON
[Posted Assembly Header].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code] |
| 19 | Comment | Comment | FlowField | Boolean | 4 | | |
| 20 | Location Code | Location Code | Normal | Code | 10 | Location Code | nvarchar(20) |
| Key to join to the Location table.SELECT
[Posted Assembly Header].[Location Code]
,[Location].[Code]
FROM
[CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
[CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
ON
[Posted Assembly Header].[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 Header].[Shortcut Dimension 1 Code]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Posted Assembly Header].[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 Header].[Shortcut Dimension 2 Code]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Posted Assembly Header].[Shortcut Dimension 2 Code] = [Dimension].[Code] |
| 23 | Posting Date | Posting Date | Normal | Date | 4 | Posting Date | datetime |
| 24 | Due Date | Due Date | Normal | Date | 4 | Due Date | datetime |
| 25 | Starting Date | Starting Date | Normal | Date | 4 | Starting Date | datetime |
| 27 | Ending Date | Ending Date | Normal | Date | 4 | Ending Date | datetime |
| Key to join to the Inventory Period table.SELECT
[Posted Assembly Header].[Ending Date]
,[Inventory Period].[Ending Date]
FROM
[CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
[CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
ON
[Posted Assembly Header].[Ending Date] = [Inventory Period].[Ending Date] |
| 33 | Bin Code | Bin Code | Normal | Code | 20 | Bin Code | nvarchar(40) |
| Key to join to the Bin table.SELECT
[Posted Assembly Header].[Bin Code]
,[Bin].[Code]
FROM
[CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
[CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
ON
[Posted Assembly Header].[Bin Code] = [Bin].[Code] |
| 39 | Item Rcpt. Entry No. | Item Rcpt. Entry No. | Normal | Integer | 4 | Item Rcpt_ 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) |
| 54 | Assemble to Order | Assemble to Order | FlowField | Boolean | 4 | | |
| 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) |
| 75 | Indirect Cost % | Indirect Cost % | Normal | Decimal | 12 | Indirect Cost _ | decimal(38,38) |
| 76 | Overhead Rate | Overhead Rate | Normal | Decimal | 12 | Overhead Rate | decimal(38,38) |
| 80 | Unit of Measure Code | Unit of Measure Code | Normal | Code | 10 | Unit of Measure Code | nvarchar(20) |
| 81 | Qty. per Unit of Measure | Qty. per Unit of Measure | Normal | Decimal | 12 | Qty_ per Unit of Measure | decimal(38,38) |
| 100 | Reversed | Reversed | Normal | Boolean | 4 | Reversed | tinyint |
| 107 | No. Series | No. Series | Normal | Code | 20 | No_ Series | nvarchar(40) |
| Key to join to the No. Series table.SELECT
[Posted Assembly Header].[No_ Series]
,[No. Series].[Code]
FROM
[CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
[CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
ON
[Posted Assembly Header].[No_ Series] = [No. Series].[Code] |
| 108 | Posting No. Series | Posting No. Series | Normal | Code | 20 | Posting No_ Series | nvarchar(40) |
| Key to join to the No. Series table.SELECT
[Posted Assembly Header].[Posting No_ Series]
,[No. Series].[Code]
FROM
[CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
[CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
ON
[Posted Assembly Header].[Posting No_ Series] = [No. Series].[Code] |
| 109 | Order No. Series | Order No. Series | Normal | Code | 20 | Order No_ Series | nvarchar(40) |
| Key to join to the No. Series table.SELECT
[Posted Assembly Header].[Order No_ Series]
,[No. Series].[Code]
FROM
[CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
[CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
ON
[Posted Assembly Header].[Order No_ Series] = [No. Series].[Code] |
| 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 Header].[Dimension Set ID]
,[Dimension Set Entry].[Dimension Set ID]
FROM
[CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
[CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
ON
[Posted Assembly Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID] |
| 9010 | User ID | User ID | Normal | Code | 50 | User ID | nvarchar(100) |
| 9020 | Source Code | Source Code | Normal | Code | 10 | Source Code | nvarchar(20) |
| Key to join to the Source Code table.SELECT
[Posted Assembly Header].[Source Code]
,[Source Code].[Code]
FROM
[CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
[CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
ON
[Posted Assembly Header].[Source Code] = [Source Code].[Code] |
| 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 Header].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
[User] AS [User]
ON
[Posted Assembly Header].[$systemCreatedBy] = [User].[User Security ID] |
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
