Table 5884 "Pstd. Phys. Invt. Tracking"

Base Application · Microsoft.Inventory.Counting.Tracking · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Pstd. Phys. Invt. Tracking
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Item Tracking No. Δ BC28	Integer	Specifies the value from the same field on the physical inventory tracking line.
2	Line No.	Integer	—
3	Document No. Δ BC28	Code[20]	Specifies the appropriate field of the physical inventory tracking line.
11	Item No. Δ BC28	Code[20]	Specifies the value from the same field on the physical inventory tracking line.	TableRelation Table 27 “Item”; not editable
12	Description	Text[100]	—
13	Location Code Δ BC28	Code[10]	Specifies the value from the same field on the physical inventory tracking line.	TableRelation Table 14 “Location”; not editable
14	Quantity Δ BC28	Decimal	Specifies the value from the same field on the physical inventory tracking line.
15	Serial No. Δ BC28	Code[50]	Specifies the serial number of the item that is being handled on the document line.	TableRelation Table 6504 “Serial No. Information” (“Serial No. Information”.“Serial No.” where(“Item No.” = field(“Item No.”), “Variant Code” = field(“Variant Code”)))
18	Positive	Boolean	—	not editable
19	Warranty Date	Date	—
20	Expiration Date	Date	—
5400	Lot No. Δ BC28	Code[50]	Specifies the value from the same field on the physical inventory tracking line.	TableRelation Table 6505 “Lot No. Information” (“Lot No. Information”.“Lot No.” where(“Item No.” = field(“Item No.”), “Variant Code” = field(“Variant Code”)))
5401	Variant Code Δ BC28	Code[10]	Specifies the variant of the item on the line.	not editable
5402	Bin Code Δ BC28	Code[20]	Specifies the value from the same field on the physical inventory tracking line.	TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Code”))); not editable
5403	Entry Type Δ BC28	Option	Specifies the value from the same field on the physical inventory tracking line.	OptionCaption: ,Positive Adjmt.,Negative Adjmt.

Keys

Key1: Document No., Item Tracking No., Line No. (clustered)

Relations

drill-down page Page 5894 “Posted Phys. Invt. Tracking”
lookup page Page 5894 “Posted Phys. Invt. Tracking”
Location Code: TableRelation Table 14 “Location”
Item No.: TableRelation Table 27 “Item”
Serial No.: TableRelation Table 6504 “Serial No. Information”
Lot No.: TableRelation Table 6505 “Lot No. Information”
Bin Code: TableRelation Table 7354 “Bin”

Pages and codeunits on this table

Page 5894 “Posted Phys. Invt. Tracking” (source table)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Pstd. Phys. Invt. Tracking"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.