Other table in Microsoft Dynamics 365 Business Central. 20 fields, 0 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: Analysis Area, Analysis View Code, Budget Name, Item No., Source Type, Source No., Location Code, Dimension 1 Value Code, Dimension 2 Value Code, Dimension 3 Value Code, Posting Date, Entry No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Analysis Area PK | Option | Normal | |
| 2 | Analysis View Code PK | Code | Normal | → Item Analysis View #7152 |
| 3 | Budget Name PK | Code | Normal | → Item Budget Name #7132 |
| 4 | Item No. PK | Code | Normal | → Item #27 |
| 5 | Source Type PK | Option | Normal | |
| 6 | 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 | |
| 21 | Quantity | Decimal | Normal | |
| 22 | Sales Amount | Decimal | Normal | |
| 23 | Cost Amount | 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 Budg. Entry table through TableRelation properties.