gl_entries
The general ledger, summarized to one journal per day per source. One row is one line of one journal.
- One row is
- one line of one journal
- Columns
- 9
- Rows in Sample
- 97,712
- Rows in Standard
- 97,712
- Rows in Full
- 97,712
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 |
|---|---|---|---|
| entry_idkey | integer | Unique id for the row. | |
| journal_id | integer | Lines sharing a journal_id balance: debits equal credits. | |
| entry_date | date | Posting date. | 2018-01-01 to 2025-12-31 |
| account_id | integer | Links to gl_accounts. | |
| department_id | integer | Cost center, on expense lines that have one. Can be empty. | |
| debit | decimal | Debit amount in dollars. | 0 to 38,034,054.34 |
| credit | decimal | Credit amount in dollars. | 0 to 38,034,054.34 |
| source_system | text | System that produced the journal. | accounts payable; lodging; maintenance; manual journal; pass system; payroll; pos: LegacyPOS; pos: VelaluzPOS; purchasing; refund system; ticketing |
| description | text | What the journal is. |
How it connects
This table points to
- account_id matches gl_accounts.account_id
- department_id matches departments.department_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| entry_id | journal_id | entry_date | account_id | department_id | debit | credit | source_system | description |
|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 2018-01-01 | 2310 | 539724.91 | 0 | lodging | Lodging revenue recognized | |
| 2 | 1 | 2018-01-01 | 4100 | 0 | 539724.91 | lodging | Lodging revenue recognized | |
| 3 | 2 | 2018-01-01 | 2310 | 0 | 38034054.34 | lodging | Opening balance: stays booked before 2018 | |
| 4 | 2 | 2018-01-01 | 3000 | 38034054.34 | 0 | lodging | Opening balance: stays booked before 2018 | |
| 5 | 3 | 2018-01-01 | 1000 | 396979.51 | 0 | lodging | Room bookings |