A summary table for trade scheme consumption by account, partner, branch, item or item group. Nothing in xMatix writes it: the scheme engine records consumption only in the Scheme Ledger, and budgets, Val Count limits and the Utilized Amount figure are all read from the ledger. The entity has no menu entry in any app, and sync profiles refuse to include it in either direction. The standard Scheme Consumption dashboard and the Scheme Utilisation analytics dataset are built from this table, so they stay empty unless rows are added to it some other way. Rows entered by hand change no scheme behaviour.
Fields
| Field | Label | Type | Required | What it does |
|---|
AccountId | Account | Lookup → Account | | The customer account the consumption is summarised for. On the create form only. Read by the Scheme Consumption analytics model as its account dimension, and never by the scheme engine. |
BranchId | Branch | Lookup → Branch | | The branch the consumption is summarised for. On the create form only. The analytics model joins on it for its branch dimension. |
ConsumedAmount | Consumed Amount | Currency | | Amount consumed, defaulting to 0. Entered by hand, because no process calculates it. The analytics datasets sum it. Budget headroom is not affected by it. |
ConsumedQuantity | Consumed Quantity | Number | | Quantity consumed, defaulting to 0. Entered by hand, because no process calculates it. The analytics datasets sum it. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
Id | Id | Guid | Yes | |
ItemGroupId | Item Group | Lookup → ItemGroup | | The item group the consumption is summarised for. |
ItemId | Item | Lookup → Item | | The item the consumption is summarised for. The analytics model joins on it for its item dimension. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Name | Text | Yes | Record number. When a row is saved, it is generated from the SCN document name series. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | Partner Account | Lookup → Account | | The partner (distributor or dealer) account the consumption is summarised for. On the create form only. Not read by the scheme engine; partner budgets count Scheme Ledger rows instead. |
RecordTypeId | Record Type | Guid, hidden | | |
SchemeName | Scheme Name | Text | | Shown on the create form, but not stored: a value typed here is discarded on save. A consumption record therefore cannot be tied to a scheme. |
UIProps | UI Props | Text | | |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |
Actions
| Action | Label | Type | What it does |
|---|
Clone | Clone | ServerAction (Clone) | Create a copy of this record |
Delete | Delete | Delete | Delete |
DeleteListHeader | Delete | Delete | DeleteListHeader |
DeleteListRow | Delete | Delete | DeleteListRow |
Edit | Edit | Edit | Edit |
EditInLine | Edit | EditInline | EditInLine |
EditListHeader | Edit | EditInline | EditListHeader |
EditListRow | Edit | Edit | EditListRow |
New | New | New | New |
