Average Cost Calc. Overview #5847

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

The Average Cost Calc. Overview table (ID 5847) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 26 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 (26)

Average Cost Calc. Overview — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
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.