VRM_DEVOLVED_PERF_OBLIG_DTL_GT
Oracle internal use only. This global temporary table is used in recognize revenue of customer contracts job during internal processing of devolved performance obligations.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DEVOLVED_PERF_OBLIG_DTL_ID | NUMBER | 18 | Yes | Detailed devolved performance obligation unique record identifier. | |
| PERF_OBLIGATION_ID | NUMBER | 18 | Performance obligation unique identifier of the devolved performance obligation. | ||
| CUSTOMER_CONTRACT_HEADER_ID | NUMBER | 18 | Customer contract header unique identifier of the devolved performance obligation. | ||
| CONTR_CUR_DEVOLVED_PO_AMT | NUMBER | Devolved performance obligation amount in the contract currency. This amount is the sum of the apportioned promised detail line net consideration amounts in the contract currency for the accounting period. The accounting period is determined based on the satisfaction date. | |||
| CONTR_CUR_ALLOCATED_AMT | NUMBER | Devolved performance obligation allocated amount in the contract currency. This amount is the sum of the apportioned promised detail line allocated amounts in the contract currency for the accounting period. The accounting period is determined based on the satisfaction date. | |||
| CONTR_CUR_RECOG_REV_AMT | NUMBER | Devolved performance obligation recognized revenue amount in the contract currency. This amount is the sum of the processed satisfaction event type accounting events amount of the promised detail lines for the accounting period. The accounting period is determined based on the satisfaction date. | |||
| CONTR_CUR_INITIAL_PERF_EVT_AMT | NUMBER | Devolved performance obligation initial performance event amount in the contract currency. This amount is the sum of apportioned promised detail line allocated amounts in the contract currency for the accounting period. The accounting period is determined based on the satisfaction date. This amount is used to create initial performance event type accounting events for the devolved performance obligation. | |||
| INITIAL_PERF_EVT_EXPECTED_DATE | DATE | Date of the expected creation of the initial performance accounting event. For the first accounting period record, this date is computed as the earliest of the bill dates and the satisfaction start dates for the promised detail lines. For the other accounting period records, this date is computed as the earliest of the satisfaction start dates for the promised detail lines. | |||
| INITIAL_PERF_EVT_CREATED_FLAG | VARCHAR2 | 1 | Indicates whether the initial performance accounting event was created. N indicates not created. Y indicates created. | ||
| SATISFACTION_DATE | DATE | The date on which the satisfaction is measured for promised detail lines where the satisfaction measurement model for the line is based on the period satisfied. The default satisfaction date will be the last date of the accounting period for which the satisfaction is measured. | |||
| REVERSED_FLAG | VARCHAR2 | 1 | Indicates whether this devolved performance obligation record is reversed. N indicates not reversed. Y indicates reversed. Not reversed records are the latest records. | ||
| FIRST_RECORD_FLAG | VARCHAR2 | 1 | Indicates whether the current record is the first devolved performance obligation record, after sorting based on the satisfaction date under the performance obligation. | ||
| LEDGER_ID | NUMBER | 18 | Ledger identifier of the customer contract. | ||
| DEVOLVED_PO_DETAIL_STATUS_CODE | VARCHAR2 | 30 | Oracle internal use only. This column is used to maintain the status of each record in this table at each level of processing in the Recognize Revenue of Customer Contracts process. |