xpms.dim_counterparty_type
TablaSeguridad a nivel de fila activa
The counterparty types (Bible tab 28). A vendor engagement carries a counterparty type; an internal one carries a role code.
Clave primaria: counterparty_type
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| counterparty_type | xpms.canon_text | No | Counterparty type. |
| ordinal | integer | No | Position of the counterparty type in its Bible tab; the canonical display order where the code is not numeric. |
| definition | xpms.canon_text | No | What the counterparty does. |
| classification_code | xpms.canon_code | Sí | CLASSIFICATION CODE from the Playbook Counterparty Types sheet. |
| vendor_class | xpms.canon_text | Sí | VENDOR CLASS from the Playbook Counterparty Types sheet. |
| clearance_tier | xpms.canon_text | Sí | CLEARANCE TIER from the Playbook Counterparty Types sheet. |
| default_account_code | xpms.canon_code | Sí | DEFAULT GL ACCOUNT from the Playbook Counterparty Types sheet: the counterparty GL default ruling D13 allows (owner decision 39), used when the line's class gives no account of the type.Hace referencia a xpms.dim_gl_account.account_code |
| source_row | integer | Sí | Row of the Playbook sheet that mirrors this canon row; NULL when the Playbook has no such row. |
| source_status | xpms.canon_text | Sí | STATUS as recorded on the Playbook row (for example Active). |
| source_created_by | xpms.canon_text | Sí | CREATED BY as recorded on the Playbook row. |
| source_created_at | timestamp without time zone | Sí | CREATED AT as recorded on the Playbook row: a wall-clock time; the Playbook records no time zone. |
| source_updated_at | timestamp without time zone | Sí | UPDATED AT as recorded on the Playbook row: a wall-clock time; the Playbook records no time zone. |