budgets
Monthly budget for each revenue and expense account, by department where the account has cost centers. One row is one account and department in one month.
- One row is
- one account and department in one month
- Columns
- 5
- Rows in Sample
- 4,608
- Rows in Standard
- 4,608
- Rows in Full
- 4,608
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 |
|---|---|---|---|
| fiscal_year | integer | Calendar year. | 2018 to 2025 |
| month_startkey | date | First day of the month. | |
| account_idkey | integer | Links to gl_accounts. | |
| department_idkey | integer | Cost center, where the account has them. Can be empty. | |
| budget_amount | decimal | Budget in dollars. Revenue is negative, like a credit, so it can be compared with debit minus credit. | 0 to 24,524,000 |
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.
| fiscal_year | month_start | account_id | department_id | budget_amount |
|---|---|---|---|---|
| 2018 | 2018-01-01 | 4000 | 9057100 | |
| 2018 | 2018-02-01 | 4000 | 9334300 | |
| 2018 | 2018-03-01 | 4000 | 12334800 | |
| 2018 | 2018-04-01 | 4000 | 11829400 | |
| 2018 | 2018-05-01 | 4000 | 11157100 |