maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
Budget detail rows. Grain (budget, gl_account, cost_center, period) UNIQUE on the source — the budget side of budget-vs-actuals.
8 of 8
Column
Description
Tests · PII
budget_line_id
Primary key — BIGSERIAL on the source.
2 tests
budget_id
FK to `budgets.budget_id`. NOT NULL.
1 test
gl_account_id
FK to `gl_accounts.gl_account_id`. NOT NULL.
1 test
cost_center_id
FK to `cost_centers.cost_center_id`. NOT NULL.
1 test
period_id
FK to `fiscal_periods.period_id` (not staged in this slice). NOT NULL.
1 test
budget_amount
Budgeted amount. NUMERIC(14,2).
created_at
Row insert timestamp in the source DB.
updated_at
Row update timestamp in the source DB.