xpms.element_price_bands
TableRow level security on
Price bands per element and grade. NULL is never stored: an element without a band is unpriced.
Primary key: element_id, grade_code
| Column | Type | Nullable | Description |
|---|---|---|---|
| element_id | xpms.canon_code | No | Element priced.References xpms.elements.element_id |
| grade_code | xpms.canon_code | No | Price grade.References xpms.grade.code |
| amount_minor | bigint | No | Amount in minor units of currency_code. |
| currency_code | xpms.currency_code | No | ISO 4217 currency of the amount. |
| assertion_word | xpms.canon_code | Yes | Economics assertion word; NULL means canon states none and confidence resolves as no answer. |
| valid_from | date | Yes | Date the band was sourced; NULL means canon states none. |
| valid_to | date | Yes | Date the band stops applying, if stated. |