Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5745
Table Type: Company
Table Name: Transfer Shipment Line
Database Table Name: CRONUS UK Ltd_$Transfer Shipment 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 Transfer Shipment Line can be queried.
Show/hide an example select of all columns
Show/hide an example select of all columns by name
Show/hide an example select of all columns including those from all joined tables
Show/hide columns in Transfer Shipment 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 |
3 | Item No. | Item No. | Normal | Code | 20 | Item No_ | nvarchar(40) |
Key to join to the Item table.Show/hide example query | |||||||
4 | Quantity | Quantity | Normal | Decimal | 12 | Quantity | decimal(38,38) |
5 | 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 | |||||||
7 | Description | Description | Normal | Text | 100 | Description | nvarchar(200) |
8 | 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 | |||||||
9 | 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 | |||||||
10 | 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 | |||||||
11 | 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 | |||||||
12 | Quantity (Base) | Quantity (Base) | Normal | Decimal | 12 | Quantity (Base) | decimal(38,38) |
14 | Qty. per Unit of Measure | Qty. per Unit of Measure | Normal | Decimal | 12 | Qty_ per Unit of Measure | decimal(38,38) |
15 | Unit of Measure Code | Unit of Measure Code | Normal | Code | 10 | Unit of Measure Code | nvarchar(20) |
16 | Gross Weight | Gross Weight | Normal | Decimal | 12 | Gross Weight | decimal(38,38) |
17 | Net Weight | Net Weight | Normal | Decimal | 12 | Net Weight | decimal(38,38) |
18 | Unit Volume | Unit Volume | Normal | Decimal | 12 | Unit Volume | decimal(38,38) |
21 | Variant Code | Variant Code | Normal | Code | 10 | Variant Code | nvarchar(20) |
Key to join to the Item Variant table.Show/hide example query | |||||||
22 | Units per Parcel | Units per Parcel | Normal | Decimal | 12 | Units per Parcel | decimal(38,38) |
23 | Description 2 | Description 2 | Normal | Text | 50 | Description 2 | nvarchar(100) |
24 | Transfer Order No. | Transfer Order No. | Normal | Code | 20 | Transfer Order No_ | nvarchar(40) |
Key to join to the Transfer Header table.Show/hide example query | |||||||
25 | Shipment Date | Shipment Date | Normal | Date | 4 | Shipment Date | datetime |
26 | Shipping Agent Code | Shipping Agent Code | Normal | Code | 10 | Shipping Agent Code | nvarchar(20) |
Key to join to the Shipping Agent table.Show/hide example query | |||||||
27 | Shipping Agent Service Code | Shipping Agent Service Code | Normal | Code | 10 | Shipping Agent Service Code | nvarchar(20) |
28 | In-Transit Code | In-Transit Code | Normal | Code | 10 | In-Transit Code | nvarchar(20) |
29 | Transfer-from Code | Transfer-from Code | Normal | Code | 10 | Transfer-from Code | nvarchar(20) |
Key to join to the Location table.Show/hide example query | |||||||
30 | Transfer-to Code | Transfer-to Code | Normal | Code | 10 | Transfer-to Code | nvarchar(20) |
Key to join to the Location table.Show/hide example query | |||||||
31 | Item Shpt. Entry No. | Item Shpt. Entry No. | Normal | Integer | 4 | Item Shpt_ Entry No_ | int |
32 | Shipping Time | Shipping Time | Normal | DateFormula | 32 | Shipping Time | varchar(32) |
33 | Trans. Order Line No. | Transfer Order Line No. | Normal | Integer | 4 | Trans_ Order Line No_ | int |
34 | Derived Trans. Order Line No. | Derived Transfer Order Line No. | Normal | Integer | 4 | Derived Trans_ Order Line No_ | int |
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 | |||||||
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 | |||||||
5707 | Product Group Code | Product Group Code | Normal | Code | 10 | Product Group Code | nvarchar(20) |
5817 | Correction Line | Correction | Normal | Boolean | 4 | Correction Line | tinyint |
7300 | Transfer-from Bin Code | Transfer-from Bin Code | Normal | Code | 20 | Transfer-from Bin Code | nvarchar(40) |
10003 | Custom Transit Number | Custom Transit Number | Normal | Text | 30 | ||
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 | |||||||
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |