Table 5830 "Availability Calc. Overview"

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

Learn documents this table through its pages: Page 5830 “Demand Overview” (1 Learn page).

Properties

Property	Value
Caption	Availability Calc. Overview
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	Entry No.	Integer	—
2	Type Δ BC28	Option	Specifies the type of availability being calculated.	OptionCaption: Item,As of Date,Inventory,Supply,Supply Forecast,Demand
3	Date Δ BC28	Date	Specifies the date of the availability calculation.
4	Item No. Δ BC28	Code[20]	Specifies the identifier number for the item.	TableRelation Table 27 “Item”
5	Location Code Δ BC28	Code[10]	Specifies the location code of the item for which availability is being calculated.	TableRelation Table 14 “Location”
6	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.”)))
7	Unit of Measure Code	Code[10]	—
11	Attached to Entry No.	Integer	—	TableRelation Table 32 “Item Ledger Entry” (Item Ledger Entry)
13	Level	Integer	—
21	Source Type	Integer	—
22	Source Order Status Δ BC28	Integer	Specifies the order status of the item for which availability is being calculated.
23	Source ID Δ BC28	Code[20]	Specifies the identifier code of the source.
24	Source Batch Name	Code[10]	—
25	Source Ref. No.	Integer	—
26	Source Prod. Order Line	Integer	—
27	Description Δ BC28	Text[100]	Specifies the description of the item for which availability is being calculated.
41	Quantity Δ BC28	Decimal	—
42	Reserved Quantity Δ BC28	Decimal	—
45	Inventory Running Total Δ BC28	Decimal	Specifies the count of items in inventory.
46	Supply Running Total Δ BC28	Decimal	Specifies the count of items in supply.
47	Demand Running Total Δ BC28	Decimal	Specifies the count of items in demand.
48	Running Total Δ BC28	Decimal	Specifies the total count of items from inventory, supply, and demand.
50	Matches Criteria Δ BC28	Boolean	Specifies whether the line in the Demand Overview window is related to the lines where the demand overview was calculated.

Keys

Key1: Entry No. (clustered)
Key2: Item No., Date, Attached to Entry No., Type
Key3: Item No., Variant Code, Location Code

Relations

Location Code: TableRelation Table 14 “Location”
Item No.: TableRelation Table 27 “Item”
Attached to Entry No.: TableRelation Table 32 “Item Ledger Entry”
Variant Code: TableRelation Table 5401 “Item Variant”

Pages and codeunits on this table

Page 5830 “Demand Overview” (source table)
Codeunit 5830 “Calc. Availability Overview” (codeunit runs on it)

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: "Availability Calc. Overview"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.