xpms.dim_cost_center_template
TablaSeguridad a nivel de fila activa
Cost center templates (Bible tab 30), dimension 1: standing operations, corporate overhead and one per event scope.
Clave primaria: cost_center_id
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| cost_center_id | xpms.canon_code | No | Cost center code. |
| ordinal | integer | No | Position of the cost center in its Bible tab; the canonical display order where the code is not numeric. |
| cost_center | xpms.canon_text | No | Cost center name. |
| kind | xpms.canon_text | No | Standing, Overhead or Event. |
| scope_code | xpms.canon_code | Sí | Event scope code, for event cost centers. |
| note | xpms.canon_text | Sí | Canon note. |
| 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. |