Pstd. Phys. Invt. Tracking #5884

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

20
Fields
0
Records
3
Primary key
0
FlowFields
7
Relations
Open in Data Explorer →

Primary key

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

All fields (20)

Pstd. Phys. Invt. Tracking — FIELDS
NO.FIELDTYPECLASSRELATION
1 Item Tracking No. PK Integer Normal
2 Line No. PK Integer Normal
3 Document No. PK Code Normal
11 Item No. Code Normal → Item #27
12 Description Text Normal
13 Location Code Code Normal → Location #14
14 Quantity Decimal Normal
15 Serial No. Code Normal → Serial No. Information #6504
18 Positive Boolean Normal
19 Warranty Date Date Normal
20 Expiration Date Date Normal
5400 Lot No. Code Normal → Lot No. Information #6505
5401 Variant Code Code Normal
5402 Bin Code Code Normal → Bin #7354
5403 Entry Type Option 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 (6)

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

Item
#27 · Inventory · via Item No.
Location
#14 · General Ledger · via Location Code
Serial No. Information
#6504 · Other · via Serial No.
Lot No. Information
#6505 · Other · via Lot No.
Bin
#7354 · Warehouse · via Bin Code