Transfer Shipment Line

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

Table Number: 5745

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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
2Line No. Primary Key SearchLine No.NormalInteger4Line No_int
3Item No. Primary Key SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

4Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
5Unit of Measure SearchUnit of MeasureNormalText50Unit of Measurenvarchar(100)
Key to join to the Unit of Measure table.

Show/hide example query

7Description SearchDescriptionNormalText100Descriptionnvarchar(200)
8Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

9Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

10Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

11Inventory Posting Group SearchInventory Posting GroupNormalCode20Inventory Posting Groupnvarchar(40)
Key to join to the Inventory Posting Group table.

Show/hide example query

12Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
14Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
15Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
16Gross Weight SearchGross WeightNormalDecimal12Gross Weightdecimal(38,38)
17Net Weight SearchNet WeightNormalDecimal12Net Weightdecimal(38,38)
18Unit Volume SearchUnit VolumeNormalDecimal12Unit Volumedecimal(38,38)
21Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

22Units per Parcel SearchUnits per ParcelNormalDecimal12Units per Parceldecimal(38,38)
23Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
24Transfer Order No. SearchTransfer Order No.NormalCode20Transfer Order No_nvarchar(40)
Key to join to the Transfer Header table.

Show/hide example query

25Shipment Date SearchShipment DateNormalDate4Shipment Datedatetime
26Shipping Agent Code SearchShipping Agent CodeNormalCode10Shipping Agent Codenvarchar(20)
Key to join to the Shipping Agent table.

Show/hide example query

27Shipping Agent Service Code SearchShipping Agent Service CodeNormalCode10Shipping Agent Service Codenvarchar(20)
28In-Transit Code SearchIn-Transit CodeNormalCode10In-Transit Codenvarchar(20)
29Transfer-from Code SearchTransfer-from CodeNormalCode10Transfer-from Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

30Transfer-to Code SearchTransfer-to CodeNormalCode10Transfer-to Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

31Item Shpt. Entry No. SearchItem Shpt. Entry No.NormalInteger4Item Shpt_ Entry No_int
32Shipping Time SearchShipping TimeNormalDateFormula32Shipping Timevarchar(32)
33Trans. Order Line No. SearchTransfer Order Line No.NormalInteger4Trans_ Order Line No_int
34Derived Trans. Order Line No. SearchDerived Transfer Order Line No.NormalInteger4Derived Trans_ Order Line No_int
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

5704Item Category Code SearchItem Category CodeNormalCode20Item Category Codenvarchar(40)
Key to join to the Item Category table.

Show/hide example query

5707Product Group Code SearchProduct Group CodeNormalCode10Product Group Codenvarchar(20)
5817Correction Line SearchCorrectionNormalBoolean4Correction Linetinyint
7300Transfer-from Bin Code SearchTransfer-from Bin CodeNormalCode20Transfer-from Bin Codenvarchar(40)
10003Custom Transit Number SearchCustom Transit NumberNormalText30
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Transfer Shipment Line table

Leave a Reply

Your email address will not be published. Required fields are marked *