Availability Calc. Overview #5830

Other table in Microsoft Dynamics 365 Business Central. 28 fields, 0 records in Cronus demo.

The Availability Calc. Overview table (ID 5830) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 28 fields, with a primary key of Entry No.. Use the reference below to explore every field, data type, and table relation.

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 (28)

Availability Calc. Overview — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Entry No. PK	Integer	Normal
2	Type	Option	Normal
3	Date	Date	Normal
4	Item No.	Code	Normal	→ Item #27
5	Location Code	Code	Normal	→ Location #14
6	Variant Code	Code	Normal	→ Item Variant #5401
7	Unit of Measure Code	Code	Normal
11	Attached to Entry No.	Integer	Normal	→ Item Ledger Entry #32
13	Level	Integer	Normal
21	Source Type	Integer	Normal
22	Source Order Status	Integer	Normal
23	Source ID	Code	Normal
24	Source Batch Name	Code	Normal
25	Source Ref. No.	Integer	Normal
26	Source Prod. Order Line	Integer	Normal
27	Description	Text	Normal
41	Quantity	Decimal	Normal
42	Reserved Quantity	Decimal	Normal
45	Inventory Running Total	Decimal	Normal
46	Supply Running Total	Decimal	Normal
47	Demand Running Total	Decimal	Normal
48	Running Total	Decimal	Normal
50	Matches Criteria	Boolean	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 (5)

Tables referenced by fields on the Availability Calc. Overview table through TableRelation properties.

Item

#27 · Inventory · via Item No.

Location

#14 · General Ledger · via Location Code

Item Variant

#5401 · Other · via Variant Code

Item Ledger Entry

#32 · Inventory · via Attached to Entry No.