Availability Calc. Overview #5830

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

28
Fields
0
Records
1
Primary key
0
FlowFields
6
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.FIELDTYPECLASSRELATION
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.