FM_APPROVED_BUDGETS
This table stores approved budgets of financial summaries.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KNTA_USERS |
USER_ID |
CREATED_BY |
FM_FINANCIAL_SUMMARY |
FINANCIAL_SUMMARY_ID |
FINANCIAL_SUMMARY_ID |
PPM_FISCAL_PERIODS_NLS |
FISCAL_PERIOD_ID |
FISCAL_PERIOD_ID |
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
APPROVED_BUDGET_ID |
NOT NULL |
NUMBER |
System-generated identifier |
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date record was last updated |
VERSION |
NOT NULL |
NUMBER |
System-generated version, used for hibernate version control. |
NAME |
NOT NULL |
VARCHAR2(200) |
Name of the approved budget |
LABOR_TYPE_CODE |
NULLABLE |
VARCHAR2(40) |
Not used. The labor type for which the budget is approved. Possible values are: LABOR/NON_LABOR |
CATEGORY_CODE |
NULLABLE |
VARCHAR2(40) |
Not used. The category for which the budget is approved. |
EXPENSE_TYPE_CODE |
NOT NULL |
VARCHAR2(40) |
Expense type for which the budget is approved. Possible values are: CAPITAL, OPERATING |
AMOUNT_LCL |
NOT NULL |
NUMBER |
Amount of approved budget in local currency |
AMOUNT_BSE |
NOT NULL |
NUMBER |
Amount of approved budget in base currency |
FISCAL_PERIOD_ID |
NULLABLE |
NUMBER |
Identifier of the fiscal period for which the budget is approved |
APPROVAL_DATE |
NOT NULL |
DATE |
Date at which the budget is approved |
APPROVED_BY |
NOT NULL |
NUMBER |
Identifier of the person who approves the budget |
NOTES |
NULLABLE |
VARCHAR2(1000) |
Notes |
FINANCIAL_SUMMARY_ID |
NULLABLE |
NUMBER |
Identifier of financial summary to which the approved budget belongs |
SYNCH_SOURCE_FLAG |
NULLABLE |
VARCHAR2(10) |
If the approved budget is synchronized, describes the source. If the approved budget is not synchronized, the value is "N". For example, synch_source_flag could be "FSR" for Financial Summary Rollup, and it could be "ALLOC" for budget allocated from programs. |
SOURCE_FS_ID |
NULLABLE |
NUMBER |
For synchronized approved budgets in program's financial summary, this column stores the source financial summary IDs from which the approved budgets are rolled up. |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
FM_APPROVED_BUDGETS_PK |
UNIQUE |
1 |
APPROVED_BUDGET_ID |
Sequences
Sequence Name |
Sequence Type |
---|---|
FM_APPROVED_BUDGETS_S |
APPROVED_BUDGET_ID |