Tracking Specification #336

Item Tracking table in Microsoft Dynamics 365 Business Central. 51 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: Entry No..

All fields (51)

Tracking Specification — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Entry No. PK	Integer	Normal
2	Item No.	Code	Normal	→ Item #27
3	Location Code	Code	Normal	→ Location #14
4	Quantity (Base)	Decimal	Normal
7	Description	Text	Normal
8	Creation Date	Date	Normal
10	Source Type	Integer	Normal
11	Source Subtype	Option	Normal
12	Source ID	Code	Normal
13	Source Batch Name	Code	Normal
14	Source Prod. Order Line	Integer	Normal
15	Source Ref. No.	Integer	Normal
16	Item Ledger Entry No.	Integer	Normal	→ Item Ledger Entry #32
17	Transfer Item Entry No.	Integer	Normal	→ Item Ledger Entry #32
24	Serial No.	Code	Normal
28	Positive	Boolean	Normal
29	Qty. per Unit of Measure	Decimal	Normal
31	Qty. Rounding Precision (Base)	Decimal	Normal
38	Appl.-to Item Entry	Integer	Normal
40	Warranty Date	Date	Normal
41	Expiration Date	Date	Normal
50	Qty. to Handle (Base)	Decimal	Normal
51	Qty. to Invoice (Base)	Decimal	Normal
52	Quantity Handled (Base)	Decimal	Normal
53	Quantity Invoiced (Base)	Decimal	Normal
60	Qty. to Handle	Decimal	Normal
61	Qty. to Invoice	Decimal	Normal
70	Buffer Status	Option	Normal
71	Buffer Status2	Option	Normal
72	Buffer Value1	Decimal	Normal
73	Buffer Value2	Decimal	Normal
74	Buffer Value3	Decimal	Normal
75	Buffer Value4	Decimal	Normal
76	Buffer Value5	Decimal	Normal
80	New Serial No.	Code	Normal
81	New Lot No.	Code	Normal
900	Prohibit Cancellation	Boolean	Normal
5400	Lot No.	Code	Normal
5401	Variant Code	Code	Normal	→ Item Variant #5401
5402	Bin Code	Code	Normal	→ Bin #7354
5811	Appl.-from Item Entry	Integer	Normal
5817	Correction	Boolean	Normal
6505	New Expiration Date	Date	Normal
6515	Package No.	Code	Normal
6516	New Package No.	Code	Normal
7300	Quantity actual Handled (Base)	Decimal	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 Tracking Specification table through TableRelation properties.

Item

#27 · Inventory · via Item No.

Location

#14 · General Ledger · via Location Code

Item Ledger Entry

#32 · Inventory · via Item Ledger Entry No., Transfer Item Entry No.

Item Variant

#5401 · Other · via Variant Code

Bin

#7354 · Warehouse · via Bin Code