Pstd. Phys. Invt. Record Line #5882

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

30
Fields
0
Records
3
Primary key
0
FlowFields
11
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 (30)

Pstd. Phys. Invt. Record Line — FIELDS
NO.FIELDTYPECLASSRELATION
1 Order No. PK Code Normal → Pstd. Phys. Invt. Order Hdr #5879
2 Recording No. PK Integer Normal → Pstd. Phys. Invt. Record Hdr #5881
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
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
130 Serial No. Code Normal
131 Lot No. Code Normal
132 Package 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 (10)

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

Pstd. Phys. Invt. Order Hdr
#5879 · Other · via Order No.
Pstd. Phys. Invt. Record Hdr
#5881 · Other · via 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
Employee
#5200 · Human Resources · via Person Recorded