Item Analysis View Entry #7154

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

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: Analysis Area, Analysis View Code, Item No., Source Type, Source No., Location Code, Dimension 1 Value Code, Dimension 2 Value Code, Dimension 3 Value Code, Posting Date, Entry No., Item Ledger Entry Type, Entry Type.

All fields (25)

Item Analysis View Entry — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Analysis Area PK	Option	Normal
2	Analysis View Code PK	Code	Normal	→ Item Analysis View #7152
3	Item No. PK	Code	Normal	→ Item #27
4	Source Type PK	Option	Normal
5	Source No. PK	Code	Normal
8	Location Code PK	Code	Normal	→ Location #14
9	Dimension 1 Value Code PK	Code	Normal
10	Dimension 2 Value Code PK	Code	Normal
11	Dimension 3 Value Code PK	Code	Normal
12	Posting Date PK	Date	Normal
13	Entry No. PK	Integer	Normal
14	Item Ledger Entry Type PK	Option	Normal
15	Entry Type PK	Option	Normal
21	Invoiced Quantity	Decimal	Normal
22	Sales Amount (Actual)	Decimal	Normal
23	Cost Amount (Actual)	Decimal	Normal
24	Cost Amount (Non-Invtbl.)	Decimal	Normal
31	Quantity	Decimal	Normal
32	Sales Amount (Expected)	Decimal	Normal
33	Cost Amount (Expected)	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 (4)

Tables referenced by fields on the Item Analysis View Entry table through TableRelation properties.

Item Analysis View

#7152 · Other · via Analysis View Code

Item

#27 · Inventory · via Item No.

Location

#14 · General Ledger · via Location Code