Phys. Invt. Record Line #5878

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

The Phys. Invt. Record Line table (ID 5878) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 37 fields, with a primary key of Order No., Recording No., Line No.. Use the reference below to explore every field, data type, and table relation.

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: Order No., Recording No., Line No..

All fields (37)

Phys. Invt. Record Line — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Order No. PK	Code	Normal	→ Phys. Invt. Record Header #5877
2	Recording No. PK	Integer	Normal	→ Phys. Invt. Record Header #5877
3	Line No. PK	Integer	Normal
16	Order Line No.	Integer	Normal	→ Phys. Invt. Order Line #5876
17	Recorded Without Order	Boolean	Normal
20	Item No.	Code	Normal	→ Item #27
21	Variant Code	Code	Normal	→ Item Variant #5401
22	Location Code	Code	Normal	→ Location #14
23	Bin Code	Code	Normal	→ Bin #7354
30	Description	Text	Normal
31	Description 2	Text	Normal
32	Unit of Measure	Text	Normal
33	Qty. Rounding Precision	Decimal	Normal
34	Qty. Rounding Precision (Base)	Decimal	Normal
40	Unit of Measure Code	Code	Normal	→ Item Unit of Measure #5404
41	Quantity	Decimal	Normal
42	Quantity (Base)	Decimal	Normal
43	Qty. per Unit of Measure	Decimal	Normal
45	Recorded	Boolean	Normal
53	Use Item Tracking	Boolean	Normal
99	Shelf No.	Code	Normal
100	Date Recorded	Date	Normal
101	Time Recorded	Time	Normal
102	Person Recorded	Code	Normal	→ Employee #5200
103	Created by User	Code	Normal
130	Serial No.	Code	Normal
131	Lot No.	Code	Normal
132	Package No.	Code	Normal
5725	Item Reference No.	Code	Normal
5726	Reference Unit of Measure	Code	Normal	→ Item Unit of Measure #5404
5727	Item Reference Type	Option	Normal
5728	Item Reference Type No.	Code	Normal
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