Table 5531 "Inventory Page Data"

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

Learn documents this table through its pages: Page 5530 “Item Availability by Event” (1 Learn page).

Properties

Property	Value
Caption	Inventory Page Data
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	Code Δ BC28	Code[20]	Specifies the first date in the selected period where a supply or demand event occurs that changes the item’s availability figures.	not editable
2	Line No.	Integer	—	not editable
3	Period Type	Option	—	OptionCaption: Day,Week,Month,Quarter,Year; not editable
4	Period Start Δ BC28	Date	Specifies on which date the period starts, such as the first day of March, if the period is Month.	not editable
5	Period End	Date	—	not editable
6	Period No.	Integer	—	not editable
7	Level	Integer	—	not editable
9	Source Line ID	RecordID	—	not editable
10	Item No.	Code[20]	—	TableRelation Table 27 “Item”; not editable
11	Variant Code Δ BC28	Code[10]	Specifies the variant of the item on the line.	TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Item No.”))); not editable
12	Location Code Δ BC28	Code[10]	Specifies the location of the demand document, from which the Item Availability by Event window was opened.	TableRelation Table 14 “Location”; not editable
13	Description Δ BC28	Text[100]	Specifies the description of the availability line.	not editable
14	Availability Date	Date	—	not editable
15	Type Δ BC28	Enum “Inventory Page Data Type”	Specifies the type of the source document or source line.	enum Enum 5531 “Inventory Page Data Type”; not editable
16	Document No. Δ BC28	Code[20]	Specifies the number of the document that the availability figure is based on.	not editable
19	Source Δ BC28	Text[100]	Specifies which type of document or line the availability figure is based on.	not editable
20	Remaining Quantity (Base) Δ BC28	Decimal	Specifies the difference between the finished quantity and the planned quantity on the production order. via Page 5530 “Item Availability by Event”	not editable
21	Positive	Boolean	—	not editable
22	Gross Requirement Δ BC28	Decimal	Specifies the item’s total demand.	not editable
23	Scheduled Receipt Δ BC28	Decimal	Specifies the sum of items on existing supply orders.	not editable
24	Forecast Δ BC28	Decimal	Specifies the quantity that is demanded on the demand forecast that the availability figure is based on.	not editable
25	Remaining Forecast Δ BC28	Decimal	Specifies the quantity that remains on the demand forecast, after the forecast quantity on the availability line has been consumed.	not editable
26	Action Message Qty. Δ BC28	Decimal	Specifies the quantity that is suggested in the planning or requisition line that this availability figure is based on.	not editable
29	Action Message Δ BC28	Enum “Action Message Type”	Specifies the action message of the planning or requisition line that this availability figure is based on.	enum Enum 99000849 “Action Message Type”; not editable
30	Source Document ID	RecordID	—	not editable
31	Attached to Line No.	Integer	—	not editable
34	Ref. Order No.	Code[20]	—	not editable
36	Projected Inventory Δ BC28	Decimal	Specifies the item’s availability. This quantity includes all known supply and demand but does not include anticipated demand from demand forecasts or blanket sales orders or suggested supplies from planning or requisition worksheets.	not editable
37	Forecasted Projected Inventory Δ BC28	Decimal	Specifies the item’s inventory, including anticipated demand from demand forecasts or blanket sales orders.	not editable
38	Suggested Projected Inventory Δ BC28	Decimal	Specifies the item’s inventory, including the suggested supplies that occur in planning or requisition worksheet lines.	not editable
39	Reserved Requirement Δ BC28	Decimal	Specifies the quantity of the item that is reserved from requirement.	not editable
40	Reserved Receipt Δ BC28	Decimal	Specifies the quantity of the item that is reserved from receipt.	not editable

Keys

Key1: Line No.
Key2: Code, Line No. (clustered)
Key3: Period Start, Line No.

Events published

OnUpdateInventorysOnAfterCalculatingInventorys(var InventoryPageData: Record "Inventory Page Data") (integration)

Procedures

UpdateInventorys(var RunningInventory: Decimal; var RunningInventoryForecast: Decimal; var RunningInventorySuggestion: Decimal)

Relations

Location Code: TableRelation Table 14 “Location”
Item No.: TableRelation Table 27 “Item”
Variant Code: TableRelation Table 5401 “Item Variant”

Pages and codeunits on this table

Page 5530 “Item Availability by Event” (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: "Inventory Page Data"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.