VRM_CREATE_SATIS_EVENT_INTERIM
This table contains create satisfaction event processing-related information.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
VRM_CRE_SATIS_EVENT_INT_PK |
PERF_OBLIGATION_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PERF_OBLIGATION_LINE_ID | NUMBER | 18 | Yes | Performance obligation line. | |
| PERF_OBLIGATION_ID | NUMBER | 18 | Performance obligation. | ||
| CUSTOMER_CONTRACT_HEADER_ID | NUMBER | 18 | Customer contract header. | ||
| PERF_OBLIGATION_LINE_NUMBER | NUMBER | 18 | Running sequence number within a customer contract. | ||
| PERF_OBLIGATION_NUMBER | NUMBER | 18 | Performance obligation number. This is a running sequence number. | ||
| CUSTOMER_CONTRACT_NUMBER | NUMBER | 18 | Customer contract number. This is a running sequence number. | ||
| DOCUMENT_LINE_ID | NUMBER | 18 | Source document line. | ||
| SATISFACTION_METHOD | VARCHAR2 | 30 | Specifies whether the obligation is satisfied at a point in time or over time. Values are derived from ORA_VRM_SATISFACTION_METHOD lookup type. | ||
| POB_SATISFACTION_STATUS | VARCHAR2 | 30 | Satisfaction status of the performance obligation. Values are from the lookup type ORA_VRM_SATISFACTION_STATUS. | ||
| POB_SATISFACTION_DATE | DATE | Date on which the performance obligation is satisfied. | |||
| SATISFACTION_MEASUREMENT_MODEL | VARCHAR2 | 30 | Specifies how satisfaction will be measured and recorded for a performance obligation line. Values are from the lookup type ORA_VRM_SATIS_MEAS_MODEL. | ||
| POL_SATISFACTION_STATUS | VARCHAR2 | 30 | Satisfaction status of the performance obligation line. Values are from the lookup type ORA_VRM_SATISFACTION_STATUS. | ||
| POL_SATISFACTION_DATE | DATE | Date on which the performance obligation line is satisfied. | |||
| NET_QUANTITY | NUMBER | Net quantity of the performance obligation line. | |||
| NET_UNIT_SALES_PRICE | NUMBER | Unit selling price after adjusting the return amount. | |||
| ORIGINAL_QUANTITY | NUMBER | Original quantity of the performance obligation line. | |||
| ORIGINAL_LINE_AMT | NUMBER | Original line amount of the performance obligation line. | |||
| REVENUE_RULE_ID | NUMBER | 18 | Unique identifier of a revenue scheduling rule. | ||
| REVENUE_RULE_TYPE | VARCHAR2 | 30 | Type of revenue scheduling rule. | ||
| REVENUE_START_DATE | DATE | Date from which the revenue must be recognized. | |||
| REVENUE_RULE_DURATION | NUMBER | 18 | Number of periods in which the revenue of this performance obligation line is to be recognized. | ||
| REVENUE_END_DATE | DATE | Date until which revenue must be recognized. | |||
| SATISFACTION_BASE_PROPORTION | NUMBER | Base number for the satisfaction schedule proportions. The default value is 100. The base number is updated when the schedule rows are updated and it will be sum of the numerator of the ratio of all schedules. | |||
| REV_REC_PROCESD_DOC_LINE_ID | NUMBER | 18 | Source document line unique identifier. Used for satisfaction events creation. | ||
| LEDGER_ID | NUMBER | 18 | The ledger associated to the obligation line. | ||
| BU_ID | NUMBER | 18 | The business unit associated to the obligation line. | ||
| SINGLE_POB_CONTRACT_FLAG | VARCHAR2 | 1 | Indicates if the contract has single obligations. | ||
| ZERO_AMOUNT_FLAG | VARCHAR2 | 1 | Indicates whether the allocation amount is zero. | ||
| INITIAL_PERF_EVT_CREATED_FLAG | VARCHAR2 | 1 | Indicates if the initial performance accounting event is created. | ||
| INITIAL_PERF_EVT_EXPECTED_DATE | DATE | Date on which the initial performance event is expected to be 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. | ||
| OBLIG_SATISFACTION_STATUS | VARCHAR2 | 30 | No longer used. | ||
| ACCOUNTING_EFFECT_FLAG | VARCHAR2 | 1 | No longer used. | ||
| DELIVERY_STATUS | VARCHAR2 | 30 | No longer used. | ||
| DELIVERY_DATE | DATE | No longer used. | |||
| SATISFACTION_CONFIRM_FLAG | VARCHAR2 | 1 | No longer used. | ||
| REV_REC_PROCESSED_FLAG | VARCHAR2 | 1 | No longer used. | ||
| SE_CREATED_FROM_SUBLINE_FLAG | VARCHAR2 | 1 | No longer used. | ||
| BATCH_NUMBER | NUMBER | 18 | Batch number to be processed. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| POL_AE_CREATION_STATUS | VARCHAR2 | 40 | Performance obligation line accounting event creation status. | ||
| LINE_STATUS | VARCHAR2 | 30 | Performance obligation line status while processing for satisfaction events creation. Used during internal processing. | ||
| CONTRACT_UPDATE_TEMPLATE_ID | NUMBER | 18 | Revenue contract update template identifier. | ||
| DOCUMENT_LINE_TYPE_CODE | VARCHAR2 | 30 | Specifies the type of line sent from the source system. Values are derived from the lookup type ORA_VRM_DOCUMENT_LINE_TYPE. Blank is equivalent to ORA_NEW_LINE. | ||
| POB_FIRST_SE_DATE | DATE | Date on which the first satisfaction event is created for a promised detail under an obligation. | |||
| POL_FIRST_SE_DATE | DATE | Date on which the first satisfaction event is created for a promised detail line. | |||
| PERF_OBLIGATION_TYPE_CODE | VARCHAR2 | 30 | Obligation type of a performance obligation. Values are from the lookup type ORA_VRM_PERF_OBLIGATION_TYPE_CODE. | ||
| BILLING_LINE_CREATED_FLAG | VARCHAR2 | 1 | Indicates whether zero amount billing line is created for the implied promise detail line upon full satisfaction. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_CRE_SATIS_EVENT_INT_N1 | Non Unique | Default | REQUEST_ID, BATCH_NUMBER |
| VRM_CRE_SATIS_EVENT_INT_N2 | Non Unique | Default | REQUEST_ID, LINE_STATUS, CUSTOMER_CONTRACT_HEADER_ID |
| VRM_CRE_SATIS_EVENT_INT_U1 | Unique | Default | PERF_OBLIGATION_LINE_ID |