gl_accounts
Chart of accounts. One row is one account.
- One row is
- one account
- Columns
- 3
- Rows in Sample
- 32
- Rows in Standard
- 32
- Rows in Full
- 32
This table describes the company, not individual guests, so it is identical in all three sizes.
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| account_idkey | integer | Unique id for the row. | |
| account_name | text | Name. | |
| account_type | text | Asset, liability, equity, revenue, contra revenue or expense. | asset; contra revenue; equity; expense; liability; revenue |
How it connects
Tables that point here
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| account_id | account_name | account_type |
|---|---|---|
| 1000 | Cash | asset |
| 1200 | Inventory | asset |
| 1500 | Accumulated depreciation | asset |
| 2000 | Accounts payable | liability |
| 2100 | Sales tax payable | liability |