XCC_BALANCES

Details

Schema: FUSION
Object owner: XCC
Object type: TABLE
Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
XCC_BALANCES_PK	CONTROL_BUDGET_ID, BUDGET_CCID, PERIOD_NAME

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
CONTROL_BUDGET_ID	NUMBER		18	Yes	Identifies the impacted control budget.
BUDGET_CCID	NUMBER		18	Yes	Identifier of the budget account for which this balance is being tracked.
PERIOD_NAME	VARCHAR2	15		Yes	Corresponds to the budget period of this balance.
BUDGET_AMOUNT	NUMBER				Initial budget amount. Add to budget adjustment amount to get current budget.
BUDGET_ADJUSTMENT_AMOUNT	NUMBER				Amount by which the budget has been adjusted.
COMMITMENT_AMOUNT	NUMBER				Budget consumption classified as commitments, typically requisitions
OBLIGATION_AMOUNT	NUMBER				Budget consumption classified as obligations, typically purchase orders
OTHER_AMOUNT	NUMBER				Other types of budget consumption, e.g. project expenditures
ACTUAL_AMOUNT	NUMBER				Budget consumption classified as actual expenditures, typically receipts or invoices
FUNDS_AVAILABLE_AMOUNT	NUMBER				Amount available for this budget.
APPROVED_COMMITMENT_AMOUNT	NUMBER				Amount in approved commitments, a lower level bucket.
APPROVED_AUTHORIZATION_AMOUNT	NUMBER				Approved spending authorization commitment amount.
APPROVED_OBLIGATION_AMOUNT	NUMBER				Amount in approved obligations a lower level bucket.
VALIDATED_PAYABLES_AMOUNT	NUMBER				Amount in validated payables, a lower level bucket.
APPROVED_PROJECT_AMOUNT	NUMBER				Amount in approved project, a lower level bucket.
DETAIL_OTHER_AMOUNT	NUMBER				Amount in other encumbrances, a lower level bucket.
UNRELEASED_BUDGET_AMOUNT	NUMBER				Amount that has been budgeted to this period but has not yet been released for expenditure.
ACCOUNTED_PAYABLES_AMOUNT	NUMBER				Amount in accounted payables, a lower level bucket.
ACCOUNTED_RECEIPTS_AMOUNT	NUMBER				Amount in accounted receipts, a lower level bucket.
ACCOUNTED_PROJECT_AMOUNT	NUMBER				Amount in accounted projects, a lower level bucket.
MISC_EXPENDITURES_AMOUNT	NUMBER				Amount in miscellaneous expenditures, a lower level bucket.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active

Indexes

Index	Uniqueness	Tablespace	Columns	Status
XCC_BALANCES_U1	Unique	FUSION_TS_TX_DATA	CONTROL_BUDGET_ID, BUDGET_CCID, PERIOD_NAME	Active