Other table in Microsoft Dynamics 365 Business Central. 22 fields, 0 records in Cronus demo.
The Item Analysis View table (ID 7152) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 22 fields, with a primary key of Analysis Area, Code. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: Analysis Area, Code.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 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 |
Tables referenced by fields on the Item Analysis View table through TableRelation properties.