xpms.v_sheet_gl_accounts
View
The Playbook GL Accounts sheet as the database holds it: one row per source row, computed columns reproduced in SQL.
| Column | Type | Nullable | Description |
|---|---|---|---|
| source_row | integer | Yes | Row number in the source sheet. |
| account_code | text | Yes | ACCOUNT CODE (column A), field. |
| account_name | text | Yes | ACCOUNT NAME (column B), field. |
| account_type | text | Yes | ACCOUNT TYPE (column C), field. |
| tax_type | text | Yes | TAX TYPE (column D), field. |
| normal_balance | text | Yes | NORMAL BALANCE (column E), field. |
| description | text | Yes | DESCRIPTION (column F), field. |
| status | text | Yes | STATUS (column G), field. |
| created_by | text | Yes | CREATED BY (column H), field. |
| created_at | text | Yes | CREATED AT (column I), field. |
| updated_at | text | Yes | UPDATED AT (column J), field. |