Other table in Microsoft Dynamics 365 Business Central. 19 fields, 0 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: Item No., Source Type, Source No., Location Code, Global Dimension 1 Code, Global Dimension 2 Code, Budget Dimension 1 Code, Budget Dimension 2 Code, Budget Dimension 3 Code, Date.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Item No. PK | Code | Normal | → Item #27 |
| 2 | Source Type PK | Option | Normal | |
| 3 | Source No. PK | Code | Normal | |
| 4 | Location Code PK | Code | Normal | → Location #14 |
| 5 | Global Dimension 1 Code PK | Code | Normal | → Dimension Value #349 |
| 6 | Global Dimension 2 Code PK | Code | Normal | → Dimension Value #349 |
| 7 | Budget Dimension 1 Code PK | Code | Normal | |
| 8 | Budget Dimension 2 Code PK | Code | Normal | |
| 9 | Budget Dimension 3 Code PK | Code | Normal | |
| 10 | Date PK | Date | Normal | |
| 11 | Quantity | Decimal | Normal | |
| 12 | Sales Amount | Decimal | Normal | |
| 13 | Cost Amount | Decimal | Normal | |
| 480 | Dimension Set ID | Integer | Normal | → Dimension Set Entry #480 |
| 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 Budget Buffer table through TableRelation properties.