1. Tables and Views for Financials
  2. VRM_DEVOLVED_PERF_OBLIG_DTLS

VRM_DEVOLVED_PERF_OBLIG_DTLS

This table contains summary information about promised detail lines for devolved performance obligations. Each row represents total of all the promised detail line amounts apportioned by accounting period. The calculation of apportioned amount is derived using satisfaction plan on the promised detail line. Initial Performance Event accounting of a devolved performance obligation is driven from the records in this table.

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

VRM_DEVOLVED_PO_DTLS_PK

DEVOLVED_PERF_OBLIG_DTL_ID

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 Yes 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.
CREATED_FROM VARCHAR2 30 Yes The process or user interface from which this row is created.
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.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Foreign Keys

Table Foreign Table Foreign Key Column
VRM_DEVOLVED_PERF_OBLIG_DTLS vrm_perf_obligations PERF_OBLIGATION_ID

Indexes

Index Uniqueness Tablespace Columns
VRM_DEVOLVED_PO_DTLS_N1 Non Unique FUSION_TS_TX_DATA PERF_OBLIGATION_ID
VRM_DEVOLVED_PO_DTLS_U1 Unique FUSION_TS_TX_DATA DEVOLVED_PERF_OBLIG_DTL_ID