Direct Trans. Line #5857

Other table in Microsoft Dynamics 365 Business Central. 34 fields, 0 records in Cronus demo.

34
Fields
0
Records
2
Primary key
0
FlowFields
16
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Document No., Line No..

All fields (34)

Direct Trans. Line — FIELDS
NO.FIELDTYPECLASSRELATION
1 Document No. PK Code Normal
2 Line No. PK Integer Normal
3 Item No. Code Normal → Item #27
4 Quantity Decimal Normal
5 Unit of Measure Text Normal
7 Description Text Normal
8 Shortcut Dimension 1 Code Code Normal → Dimension Value #349
9 Shortcut Dimension 2 Code Code Normal → Dimension Value #349
10 Gen. Prod. Posting Group Code Normal → Gen. Product Posting Group #251
11 Inventory Posting Group Code Normal → Inventory Posting Group #94
12 Quantity (Base) Decimal Normal
14 Qty. per Unit of Measure Decimal Normal
15 Unit of Measure Code Code Normal → Item Unit of Measure #5404
16 Gross Weight Decimal Normal
17 Net Weight Decimal Normal
18 Unit Volume Decimal Normal
21 Variant Code Code Normal → Item Variant #5401
22 Units per Parcel Decimal Normal
23 Description 2 Text Normal
24 Transfer Order No. Code Normal → Transfer Header #5740
25 Posting Date Date Normal
29 Transfer-from Code Code Normal → Location #14
30 Transfer-to Code Code Normal → Location #14
31 Item Shpt. Entry No. Integer Normal
33 Item Rcpt. Entry No. Integer Normal
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
5704 Item Category Code Code Normal → Item Category #5722
7300 Transfer-from Bin Code Code Normal → Bin #7354
7301 Transfer-To Bin Code Code Normal → Bin #7354
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

Related tables (12)

Tables referenced by fields on the Direct Trans. Line table through TableRelation properties.

Item
#27 · Inventory · via Item No.
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Gen. Product Posting Group
#251 · Other · via Gen. Prod. Posting Group
Inventory Posting Group
#94 · Other · via Inventory Posting Group
Item Unit of Measure
#5404 · Other · via Unit of Measure Code
Item Variant
#5401 · Other · via Variant Code
Transfer Header
#5740 · Other · via Transfer Order No.
Location
#14 · General Ledger · via Transfer-from Code, Transfer-to Code
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
Item Category
#5722 · Other · via Item Category Code
Bin
#7354 · Warehouse · via Transfer-from Bin Code, Transfer-To Bin Code