Other table in Microsoft Dynamics 365 Business Central. 25 fields, 0 records in Cronus demo.
The Item Analysis View Entry table (ID 7154) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 25 fields, with a primary key 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. 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, 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.
| 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 |
Tables referenced by fields on the Item Analysis View Entry table through TableRelation properties.