Item Analysis View #7152

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

22
Fields
0
Records
2
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: Analysis Area, Code.

All fields (22)

Item Analysis View — FIELDS
NO.FIELDTYPECLASSRELATION
1 Analysis Area PK Option Normal
2 Code PK Code Normal
3 Name Text Normal
4 Last Entry No. Integer Normal
5 Last Budget Entry No. Integer Normal
6 Last Date Updated Date Normal
7 Update on Posting Boolean Normal
8 Blocked Boolean Normal
9 Item Filter Code Normal → Item #27
10 Location Filter Code Normal → Location #14
11 Starting Date Date Normal
12 Date Compression Option Normal
13 Dimension 1 Code Code Normal → Dimension #348
14 Dimension 2 Code Code Normal → Dimension #348
15 Dimension 3 Code Code Normal → Dimension #348
17 Include Budgets Boolean Normal
18 Refresh When Unblocked 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 (4)

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

Item
#27 · Inventory · via Item Filter
Location
#14 · General Ledger · via Location Filter
Dimension
#348 · Dimensions · via Dimension 1 Code, Dimension 2 Code, Dimension 3 Code