Phys. Invt. Record Line #5878

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

37
Fields
0
Records
3
Primary key
0
FlowFields
13
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.FIELDTYPECLASSRELATION
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

Related tables (9)

Tables referenced by fields on the Phys. Invt. Record Line table through TableRelation properties.

Phys. Invt. Record Header
#5877 · Other · via Order No., Recording No.
Phys. Invt. Order Line
#5876 · Other · via Order Line No.
Item
#27 · Inventory · via Item No.
Item Variant
#5401 · Other · via Variant Code
Location
#14 · General Ledger · via Location Code
Bin
#7354 · Warehouse · via Bin Code
Item Unit of Measure
#5404 · Other · via Unit of Measure Code, Reference Unit of Measure
Employee
#5200 · Human Resources · via Person Recorded