Table 5005351 "Phys. Inventory Order Line" (AT)

AT country layer · Microsoft.Inventory.Counting · BC29-30 · source at ea08af5e · facts from BC29

An object of the AT localization, not part of W1.

Properties

Property	Value
Caption	Phys. Inventory Order Line
DataClassification	CustomerContent
ObsoleteState	Removed
ObsoleteTag	27.0
ObsoleteReason	Merged to W1

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	Document No.	Code[20]	—
2	Line No.	Integer	—
12	In Recording Lines	Boolean	—	not editable
20	Item No.	Code[20]	—	TableRelation Item
21	Variant Code	Code[10]	—	TableRelation “Item Variant”.Code where(“Item No.” = field(“Item No.”))
22	Location Code	Code[10]	—	TableRelation Location
23	Bin Code	Code[20]	—	TableRelation Bin.Code where(“Location Code” = field(“Location Code”))
30	Description	Text[50]	—
31	Description 2	Text[50]	—
32	Unit of Measure	Text[50]	—
40	Base Unit of Measure Code	Code[10]	—	TableRelation Unit of Measure; not editable
50	Qty. Expected (Base)	Decimal	—	not editable
51	Qty. Exp. Calculated	Boolean	—	not editable
52	Qty. Exp. Track. Lines (Base)	Decimal	—	obsolete Removed 27.0; #if not CLEANSCHEMA27; FlowField: sum(“Expect. Phys. Inv. Track. Line”.“Quantity (Base)” where(“Order No” = field(“Document No.”), “Order Line No.” = field(“Line No.”))); not editable
53	Use Tracking Lines	Boolean	—
55	Last Item Ledger Entry No.	Integer	—	TableRelation Item Ledger Entry; not editable
60	Unit Amount	Decimal	—
62	Unit Cost	Decimal	—
70	No. Finished Rec.-Lines	Integer	—	not editable
71	Qty. Recorded (Base)	Decimal	—	not editable
72	Quantity (Base)	Decimal	—	not editable
73	Entry Type	Option	—	OptionCaption: ,Positive Adjmt.,Negative Adjmt.; not editable
74	Pos. Qty. (Base)	Decimal	—	not editable
75	Neg. Qty. (Base)	Decimal	—	not editable
76	Without difference	Boolean	—	not editable
80	Recorded without Order	Boolean	—	not editable
90	Shortcut Dimension 1 Code	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1))
91	Shortcut Dimension 2 Code	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2))
100	Shelf/Bin No.	Code[10]	—
110	Gen. Bus. Posting Group	Code[20]	—	TableRelation Gen. Business Posting Group
111	Gen. Prod. Posting Group	Code[20]	—	TableRelation Gen. Product Posting Group
112	Inventory Posting Group	Code[20]	—	TableRelation Inventory Posting Group
480	Dimension Set ID	Integer	—	TableRelation Dimension Set Entry; not editable
5704	Item Category Code	Code[20]	—	TableRelation Item Category
5707	Product Group Code	Code[10]	—	obsolete Removed 25.0; #if not CLEANSCHEMA25
7380	Phys Invt Counting Period Code	Code[10]	—	TableRelation Phys. Invt. Counting Period; not editable
7381	Phys Invt Counting Period Type	Option	—	OptionCaption: ,Item,SKU; not editable

Keys

Key1: Document No., Line No. (clustered)
Key2: Document No., Item No., Variant Code, Location Code, Bin Code
Key3: Document No., Entry Type, Without difference

Deprecations

field Product Group Code: Removed 25.0 (#if not CLEANSCHEMA25), “Product Groups became first level children of Item Categories.”
object: Removed 27.0 (#if not CLEANSCHEMA27), “Merged to W1”
field Qty. Exp. Track. Lines (Base): Removed 27.0 (#if not CLEANSCHEMA27), “Merged to W1”

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

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: "Phys. Inventory Order Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

A AT country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.