xpms.dim_gl_account
TablaSeguridad a nivel de fila activa
The fixed 23-account chart (Bible tab 29 and the GL chart CSV). Tenants cannot add accounts.
Clave primaria: account_code
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| account_code | xpms.canon_code | No | Four-digit account: ledger type digit, class digit, 00. |
| account_name | xpms.canon_text | No | Account name. |
| account_type | xpms.canon_text | No | Account type.Hace referencia a xpms.dim_gl_account_type.account_type |
| tax_type | xpms.canon_text | No | Default tax type: Tax on Purchases, Tax on Sales, Tax Exempt or None. |
| description | xpms.canon_text | No | What posts to the account. |
| class_code | xpms.canon_code | Sí | Department class of a revenue or expense account, derived from the class digit; NULL for balance sheet accounts (decision D13: postings resolve by class, after an explicit item GL default and before a counterparty type's, as owner decision 39 reads D13).Hace referencia a xpms.dim_department.dept_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. |