BUDGET Table
View exposing budget measures by plan version, cost collector, general ledger account, and fiscal year including annual and monthly budget amounts.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APRIL_BUDGET |
April budget as provided by the source. |
NUMBER |
13,2 |
AUGUST_BUDGET |
August budget as provided by the source. |
NUMBER |
13,2 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
DECEMBER_BUDGET |
December budget as provided by the source. |
NUMBER |
13,2 |
FEBRUARY_BUDGET |
February budget as provided by the source. |
NUMBER |
13,2 |
FISCAL_YEAR |
Fiscal year as provided by the source. |
VARCHAR2 |
4 |
FISCAL_YEAR_BUDGET |
Fiscal year budget as provided by the source. |
NUMBER |
13,2 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
JANUARY_BUDGET |
January budget as provided by the source. |
NUMBER |
13,2 |
JULY_BUDGET |
July budget as provided by the source. |
NUMBER |
13,2 |
JUNE_BUDGET |
June budget as provided by the source. |
NUMBER |
13,2 |
MARCH_BUDGET |
March budget as provided by the source. |
NUMBER |
13,2 |
MAY_BUDGET |
May budget as provided by the source. |
NUMBER |
13,2 |
NOVEMBER_BUDGET |
November budget as provided by the source. |
NUMBER |
13,2 |
OCTOBER_BUDGET |
October budget as provided by the source. |
NUMBER |
13,2 |
PLAN_VERSION |
Plan version as provided by the source. |
VARCHAR2 |
3 |
RECORD_COUNTER |
Record counter as provided by the source. |
NUMBER |
|
SEPTEMBER_BUDGET |
September budget as provided by the source. |
NUMBER |
13,2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |