XCC_REV_FUND_REQ_RULE_SOURCES
This table contains a record of each revenue funding rule and revenue source account combination amounts derived 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_REQ_RULE_SRCS_PK |
REV_FUNDING_REQUEST_RULE_ID, REVENUE_SOURCE_CCID |
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. | |
REVENUE_SOURCE_CCID | NUMBER | 18 | Yes | Revenue source account combination code for the revenue source amount and revenue estimate amount. | |
REVENUE_ESTIMATE_AMOUNT | NUMBER | Revenue budget amount in the GL budget scenario for the revenue source account combination at the time of the process request. | |||
REVENUE_SOURCE_AMOUNT | NUMBER | Source ledger GL balance for the accounting period of the process and the revenue source account combination at the time of the process request. | |||
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. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
XCC_REV_FUND_REQ_RULE_SRCS_U1 | Unique | FUSION_TS_TX_DATA | REV_FUNDING_REQUEST_RULE_ID, REVENUE_SOURCE_CCID |