XCC_REV_FUND_REQUEST_RULES

This table contains a record for each control budget and revenue funding rule processed by the create expense budget entry from revenue enterprise service scheduler process request. The create expense budget entry from revenue report displays the results of this process request using this data.

Details

• Schema: FUSION

• Object owner: XCC

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
XCC_REV_FUND_REQUEST_RULES_PK	REV_FUNDING_REQUEST_RULE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
REV_FUNDING_REQUEST_RULE_ID	NUMBER		18	Yes	Unique identifier for the process request, control budget and revenue funding rule.
REV_FUNDING_REQUEST_ID	NUMBER		18	Yes	Enterprise Service Scheduler: indicates the request ID of the create expense budget entry from revenue process job that created or last updated the row.
CONTROL_BUDGET_ID	NUMBER		18	Yes	Control budget identifier of the revenue funding rule.
REV_FUNDING_RULE_ID	NUMBER		18	Yes	Revenue funding rule identifier.
REV_FUNDING_SOURCE_LEDGER_ID	NUMBER		18	Yes	Primary or secondary ledger identifier with the earned or collected revenue source amounts.
BUDGET_PERIOD_NAME	VARCHAR2	15		Yes	Budget period of the control budget derived from the accounting period of the process request.
BUDGET_CURRENCY_CODE	VARCHAR2	15		Yes	Currency assigned to the control budget.
MIN_REV_THRESHOLD_TYPE_CODE	VARCHAR2	30			Indicates the method used to determine the minimum revenue threshold amount.
MIN_REV_BUDGET_SCENARIO	VARCHAR2	80			GL budget scenario with the revenue estimate amounts used to determine the minimum revenue threshold amount.
MIN_REV_AMOUNT	NUMBER				Minimum revenue amount at the time of the process request. Either the amount specified by the user as the minimum funding threshold or the sum of all the revenue budget amounts in the GL budget scenario for the revenue source accounting combinations of the revenue funding rule.
MAX_FUNDING_LIMIT_TYPE_CODE	VARCHAR2	30			Indicates the method used to determine the maximum funding threshold amount.
MAX_FUNDING_BUDGET_SCENARIO	VARCHAR2	80			GL budget scenario with the revenue estimate amounts used to determine the maximum funding threshold amount.
MAX_FUNDING_AMOUNT	NUMBER				Maximum funding amount at the time of the process request. Either the amount specified by the user as the maximum funding threshold or the sum of all the revenue budget amounts in the GL budget scenario for the revenue source accounting combinations of the revenue funding rule.
REVENUE_SOURCE_AMOUNT	NUMBER				Sum of the source ledger GL balances for the accounting period of the process and all the revenue source account combinations of the revenue funding rule at the time of the process request.
REVENUE_FUNDING_AMOUNT	NUMBER				Calculated budget entry amount for the revenue funding rule and process request.
RESULT_CODE	VARCHAR2	30			Processing result for the rule.
ERROR_MESSAGE_CODE	VARCHAR2	30			Error code when the processing of the rule has an error.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
BUDGET_PERIOD_YEAR	NUMBER		18	Yes	Indicates the budget year of the accumulated funding amount for the control budget and revenue funding rule used in the process request.
ACCUMULATED_FUNDING_AMOUNT	NUMBER				Amount of funding from revenue added to the budget for the control budget, revenue funding rule and budget year at the time of the process request.

Indexes

Index	Uniqueness	Tablespace	Columns
XCC_REV_FUND_REQUEST_RULES_N1	Non Unique	FUSION_TS_TX_DATA	REV_FUNDING_REQUEST_ID, RESULT_CODE
XCC_REV_FUND_REQUEST_RULES_U1	Unique	FUSION_TS_TX_DATA	REV_FUNDING_REQUEST_RULE_ID
XCC_REV_FUND_REQUEST_RULES_U2	Unique	FUSION_TS_TX_DATA	REV_FUNDING_REQUEST_ID, CONTROL_BUDGET_ID, REV_FUNDING_RULE_ID