Average Cost Calc. Overview #5847

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

26
Fields
0
Records
1
Primary key
0
FlowFields
7
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Entry No..

All fields (26)

Average Cost Calc. Overview — FIELDS
NO.FIELDTYPECLASSRELATION
1 Entry No. PK Integer Normal
2 Type Option Normal
3 Valuation 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 Cost is Adjusted Boolean Normal
11 Attached to Entry No. Integer Normal → Item Ledger Entry #32
12 Attached to Valuation Date Date Normal
13 Level Integer Normal
21 Item Ledger Entry No. Integer Normal → Item Ledger Entry #32
22 Posting Date Date Normal
23 Entry Type Option Normal
24 Document Type Option Normal
25 Document No. Code Normal
26 Document Line No. Integer Normal
27 Description Text Normal
31 Quantity Decimal Normal
32 Applied Quantity Integer Normal
33 Cost Amount (Expected) Decimal Normal
34 Cost Amount (Actual) Decimal 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 Average Cost 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., Item Ledger Entry No.