xpms.dim_gl_account
TableRow level security on
The fixed 23-account chart (Bible tab 29 and the GL chart CSV). Tenants cannot add accounts.
Primary key: account_code
| Column | Type | Nullable | Description |
|---|---|---|---|
| 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.References 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 | Yes | 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).References xpms.dim_department.dept_code |
| source_row | integer | Yes | Row of the Playbook sheet that mirrors this canon row; NULL when the Playbook has no such row. |
| source_status | xpms.canon_text | Yes | STATUS as recorded on the Playbook row (for example Active). |
| source_created_by | xpms.canon_text | Yes | CREATED BY as recorded on the Playbook row. |
| source_created_at | timestamp without time zone | Yes | 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 | Yes | UPDATED AT as recorded on the Playbook row: a wall-clock time; the Playbook records no time zone. |