Invt. Document Line #5851

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

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

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

All fields (62)

Invt. Document Line — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Document Type PK	Option	Normal
2	Line No. PK	Integer	Normal
3	Item No.	Code	Normal	→ Item #27
4	Posting Date	Date	Normal
5	Document Date	Date	Normal
7	Document No. PK	Code	Normal
8	Description	Text	Normal
9	Location Code	Code	Normal	→ Location #14
10	Inventory Posting Group	Code	Normal	→ Inventory Posting Group #94
13	Quantity	Decimal	Normal
16	Unit Amount	Decimal	Normal
17	Unit Cost	Decimal	Normal
18	Amount	Decimal	Normal
23	Salespers./Purch. Code	Code	Normal	→ Salesperson/Purchaser #13
26	Source Code	Code	Normal	→ Source Code #230
29	Applies-to Entry	Integer	Normal
32	Item Shpt. Entry No.	Integer	Normal
34	Shortcut Dimension 1 Code	Code	Normal	→ Dimension Value #349
35	Shortcut Dimension 2 Code	Code	Normal	→ Dimension Value #349
37	Indirect Cost %	Decimal	Normal
38	Gross Weight	Decimal	Normal
39	Net Weight	Decimal	Normal
40	Units per Parcel	Decimal	Normal
41	Unit Volume	Decimal	Normal
42	Reason Code	Code	Normal	→ Reason Code #231
55	Last Item Ledger Entry No.	Integer	Normal	→ Item Ledger Entry #32
57	Gen. Bus. Posting Group	Code	Normal	→ Gen. Business Posting Group #250
58	Gen. Prod. Posting Group	Code	Normal	→ Gen. Product Posting Group #251
65	Posting No. Series	Code	Normal	→ No. Series #308
72	Unit Cost (ACY)	Decimal	Normal
480	Dimension Set ID	Integer	Normal	→ Dimension Set Entry #480
5402	Variant Code	Code	Normal	→ Item Variant #5401
5403	Bin Code	Code	Normal
5404	Qty. per Unit of Measure	Decimal	Normal
5405	Qty. Rounding Precision	Decimal	Normal
5406	Qty. Rounding Precision (Base)	Decimal	Normal
5407	Unit of Measure Code	Code	Normal	→ Item Unit of Measure #5404
5413	Quantity (Base)	Decimal	Normal
5470	Reserved Quantity Inbnd. ⚡ FLOW	Decimal	FlowField
5471	Reserved Quantity Outbnd. ⚡ FLOW	Decimal	FlowField
5472	Reserved Qty. Inbnd. (Base) ⚡ FLOW	Decimal	FlowField
5473	Reserved Qty. Outbnd. (Base) ⚡ FLOW	Decimal	FlowField
5704	Item Category Code	Code	Normal	→ Item Category #5722
5706	Purchasing Code	Code	Normal	→ Purchasing #5721
5725	Item Reference No.	Code	Normal
5726	Item Reference Unit of Measure	Code	Normal	→ Item Unit of Measure #5404
5727	Item Reference Type	Option	Normal
5728	Item Reference Type No.	Code	Normal
5801	Item Charge No.	Code	Normal	→ Item Charge #5800
5807	Applies-from Entry	Integer	Normal
5811	Applied Amount	Decimal	Normal
5812	Update Standard Cost	Boolean	Normal
5813	Amount (ACY)	Decimal	Normal
5819	Applies-to Value Entry	Integer	Normal
12450	FA No.	Code	Normal	→ Fixed Asset #5600
12451	FA Entry No.	Integer	Normal	→ FA Ledger Entry #5601
12452	Depreciation Book Code	Code	Normal	→ FA Depreciation Book #5612
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