maiven gateway · online··
manifest · 2d ago
Sign in Back to catalog
Definition
Forecast detail rows per account / cost center / period.
9 of 9
Column
Description
Tests · PII
forecast_line_id
Primary key — UInt64.
2 tests
forecast_id
FK to `stg_postgres__forecasts.forecast_id`. NOT NULL.
2 tests
gl_account_id
FK to `stg_postgres__gl_accounts.gl_account_id`. NOT NULL.
2 tests
cost_center_id
FK to `stg_postgres__cost_centers.cost_center_id`. NOT NULL.
2 tests
period_id
FK to fiscal_periods.period_id (not staged in this slice). NOT NULL.
1 test
forecast_amount
Forecasted amount. Decimal(14,2).
source_created_at
Row insert timestamp from the source DB. DateTime64(6).
source_updated_at
Row update timestamp from the source DB. DateTime64(6).
airbyte_extracted_at
When the loader extracted this row from postgres-source.