xpms.element_price_bands
TablaSeguridad a nivel de fila activa
Price bands per element and grade. NULL is never stored: an element without a band is unpriced.
Clave primaria: element_id, grade_code
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| element_id | xpms.canon_code | No | Element priced.Hace referencia a xpms.elements.element_id |
| grade_code | xpms.canon_code | No | Price grade.Hace referencia a 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 | Sí | Economics assertion word; NULL means canon states none and confidence resolves as no answer. |
| valid_from | date | Sí | Date the band was sourced; NULL means canon states none. |
| valid_to | date | Sí | Date the band stops applying, if stated. |