XCC_REV_FUND_REQ_RULE_TARGETS
This table contains a record of each revenue funding rule and funding target 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_TGTS_PK |
REV_FUNDING_REQUEST_RULE_ID, REV_FUNDING_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. | |
| REV_FUNDING_CCID | NUMBER | 18 | Yes | Budget account combination code used for the budget entry. | |
| REV_FUNDING_PERCENTAGE | NUMBER | 6 | Percentage of the revenue source funding amount for the revenue funding rule allocated to the target budget account. | ||
| REVENUE_FUNDING_AMOUNT | NUMBER | Budget entry amount for the revenue funding rule and target budget account. | |||
| 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_TGTS_U1 | Unique | FUSION_TS_TX_DATA | REV_FUNDING_REQUEST_RULE_ID, REV_FUNDING_CCID |