VRM_PERF_OBLIG_LINES_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
VRM_PERF_OBLIG_LINES_GT_PK |
PERF_OBLIGATION_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| PERF_OBLIGATION_LINE_ID | NUMBER | 18 | Yes | Performance obligation line unique identifier. | ||
| PERF_OBLIGATION_ID | NUMBER | 18 | Performance obligation unique identifier. | |||
| CUSTOMER_CONTRACT_HEADER_ID | NUMBER | 18 | Customer contract header unique identifier. | |||
| PERF_OBLIGATION_LINE_NUMBER | NUMBER | 18 | Performance obligation line number. This is a 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_ID | NUMBER | 18 | No longer used. | |||
| DOCUMENT_LINE_ID | NUMBER | 18 | Source document line unique identifier. | |||
| DOCUMENT_ADDITIONAL_SLINE_ID | NUMBER | 18 | Source document additional subline unique identifier. | |||
| ACCOUNTING_EFFECT_FLAG | VARCHAR2 | 1 | Indicates that the source product accounting is complete. | |||
| SATISFACTION_METHOD | VARCHAR2 | 30 | Specifies whether the obligation is satisfied at a point in time or over time. Values are derived from the lookup type ORA_VRM_SATISFACTION_METHOD. | |||
| OBLIG_SATISFACTION_STATUS | VARCHAR2 | 30 | No longer used. | |||
| 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. | |||
| LINE_SATISFACTION_STATUS | VARCHAR2 | 30 | No longer used. | |||
| LINE_SATISFACTION_DATE | DATE | No longer used. | ||||
| NET_QUANTITY | NUMBER | Net quantity of the performance obligation line. | ||||
| NET_UNIT_SALES_PRICE | NUMBER | Unit selling price after adjusting the return amount. | ||||
| NET_LINE_AMT | NUMBER | No longer used. | ||||
| ORIGINAL_QUANTITY | NUMBER | Original quantity of the performance obligation line. | ||||
| ORIGINAL_LINE_AMT | NUMBER | Original line amount of the performance obligation line. | ||||
| ENTERED_CUR_NET_CONSIDER_AMT | NUMBER | No longer used. | ||||
| ENTERED_CUR_ALLOCATED_AMT | NUMBER | No longer used. | ||||
| CONTR_CUR_NET_CONSIDER_AMT | NUMBER | No longer used. | ||||
| ENTERED_CURRENCY | VARCHAR2 | 30 | No longer used. | |||
| 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 | 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. | ||||
| DELIVERY_STATUS | VARCHAR2 | 30 | Delivery status of a source document line. Values are from the lookup VRM_MEA_LINE_DELIVERY_STATUS. | |||
| DELIVERY_DATE | DATE | Fulfillment date of a source document line. | ||||
| SATISFACTION_CONFIRM_FLAG | VARCHAR2 | 1 | Indicates whether this obligation line will need satisfaction confirmation. | |||
| REV_REC_PROCESSED_FLAG | VARCHAR2 | 1 | No longer used. | Obsolete | ||
| REV_REC_PROCESD_REV_RULE_ID | NUMBER | 18 | Revenue scheduling rule unique identifier. Used for satisfaction events creation. | |||
| REV_REC_PROCESD_REV_START_DATE | DATE | Revenue recognition start date that was most recently used for accounting events creation. | ||||
| REV_REC_PROCESD_REV_RULE_DUR | NUMBER | Revenue recognition rule duration that was most recently used for accounting events creation. | ||||
| REV_REC_PROCESD_REV_END_DATE | DATE | Revenue recognition end date that was most recently used for accounting events creation. | ||||
| REV_REC_PROCESD_DOC_LINE_ID | NUMBER | 18 | Source document line unique identifier. Used for satisfaction events creation. | |||
| LEDGER_ID | NUMBER | 18 | Unique identifier of a ledger. | |||
| BU_ID | NUMBER | 18 | The identifier of the business unit associated to the obligation line. | |||
| ZERO_AMOUNT_FLAG | VARCHAR2 | 1 | Indicates whether allocation amount is zero or not. | |||
| 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 the sum of the numerator of the ratio of all schedules. | ||||
| SE_CREATED_FROM_SUBLINE_FLAG | VARCHAR2 | 1 | No longer used. | |||
| MAX_SATISFACTION_EVENT_NUM | NUMBER | 18 | Highest satisfaction measurement number under the performance obligation line. | |||
| FIRST_AE_REVERSAL_DATE | DATE | Starting date from which accounting events must be reversed. | ||||
| SINGLE_POB_CONTRACT_FLAG | VARCHAR2 | 1 | Indicates if contract has a single obligation. | |||
| DEVOLVE_PO_FLAG | VARCHAR2 | 1 | Oracle internal use only. Indicates whether the performance obligation that this promised detail line belongs to is devolved. A performance obligation is devolved if the Devolve performance obligation option is set to Yes in either the performance obligation identification rule or the implied obligation template that was used during identification of the performance obligations. | |||
| INITIAL_PERF_EVT_CREATED_FLAG | VARCHAR2 | 1 | Indicates if initial performance accounting event was created. | |||
| INITIAL_PERF_EVT_EXPECTED_DATE | DATE | Date on which initial performance event is expected to be created. | ||||
| 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. | ||||
| 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. | ||||
| POL_FIRST_SE_DATE | DATE | Date on which the first satisfaction event for a performance obligation line is created. | ||||
| POL_SATISFIED_QUANTITY | NUMBER | Quantity satisfied on the performance obligation line. Used only when the model is 'Measure Quantity Satisfied'. | ||||
| POL_SATISFIED_PERCENT | NUMBER | The percentage satisfied on the performance obligation line. Used only when the model is Measure Percentage Satisfied. | ||||
| POL_AE_CREATION_STATUS | VARCHAR2 | 40 | Performance obligation line accounting event creation status. | |||
| LINE_STATUS | VARCHAR2 | 60 | Performance obligation line status | |||
| 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 line under a performance obligation. | ||||
| SATISFACTION_DERIVATION_STATUS | VARCHAR2 | 30 | Specifies whether the satisfaction status and satisfaction date on the performance obligation and promised detail line should be derived again. | |||
| UNPROCESSED_RET_LINE_QUANTITY | NUMBER | Quantity of the return lines related to promised detail which are not processed for accounting. | ||||
| 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. | |||
| LATEST_PERIOD_ACTION_CODE | VARCHAR2 | 30 | Latest satisfaction period action that was processed on this document line. Valid values are from the lookup type ORA_VRM_PERIOD_SUBLINE_ACTION. | |||
| TOTAL_REVERSAL_DAYS | NUMBER | 8 | Total number of days the service was suspended. This value is calculated based on the number of days between the effective dates of all reversals and their corresponding reinstatements. | |||
| LATEST_REVERSAL_DAYS | NUMBER | 8 | Number of days since the latest suspension of service. This value is calculated based on the the number of days between the effective plan end date of the promised detail and the recently processed reversal subline. | |||
| REVISED_RULE_END_DATE | DATE | Revised revenue recoginition end date for the satisfaction plan after the service is reinstated. | ||||
| RECUR_LINE_PROCESSED_FLAG | VARCHAR2 | 1 | Indicates that the line was processed by the Create Contract Renewal Source Data process. Valid values are from the lookup type VRM_YES/NO. | |||
| ADDITIONAL_SE_EXISTENCE_CODE | VARCHAR2 | 30 | Indicates whether the promised detail line has any additional satisfaction events associated with it. Values are derived from the lookup type ORA_VRM_LINE_ASE_EXISTENCE. | |||
| ASE_FULFILLMENT_PROCESS_CODE | VARCHAR2 | 30 | Indicates whether all the additional sublines that indicate the fulfillment of the additional satisfaction events for the promised detail line are processed. Valid values are Yes, No, and Invalid. | |||
| ADDITIONAL_SE_STATUS_CODE | VARCHAR2 | 30 | Overall fulfillment status of all the additional satisfaction events on the promised detail line. Values are derived from the lookup type ORA_VRM_LINE_SATISFACTN_STATUS. | |||
| CUSTOMER_CONTRACT_DATE | DATE | Date the parties entered into an agreement. | ||||
| ASE_ELIGIBLE_REVENUE_AMOUNT | NUMBER | Amount that is equivalent to the fulfillment of all of the additional satisfaction events. | ||||
| PSE_ELIGIBLE_REVENUE_AMOUNT | NUMBER | Amount that is equivalent to the fulfillment of all the primary satisfaction events. | ||||
| ASE_PENDING_REVENUE_AMOUNT | NUMBER | Amount that is pending to be recognized as revenue, even though the additional satisfaction event is fulfilled. | ||||
| PSE_PENDING_REVENUE_AMOUNT | NUMBER | Amount that is pending to be recognized as revenue, even though the primary satisfaction event is fulfilled. | ||||
| SE_REVENUE_RECOGNIZED_AMOUNT | NUMBER | Amount of revenue recognized upon fulfillment of both the primary and additional satisfaction events. | ||||
| LAST_PSE_DATE | DATE | Last fulfillment date of the primary satisfaction event. | ||||
| ELIGIBLE_ASE_VALUE | NUMBER | Value of the fulfillment of the additional satisfaction event according to the satisfaction measurement model. The value indicates the satisfied quantity, satisfied percent, or period equivalent amount. | ||||
| ELIGIBLE_PSE_VALUE | NUMBER | Value of the fulfillment of the primary satisfaction event according to the satisfaction measurement model. The value indicates the satisfied quantity, satisfied percent, or period equivalent amount. | ||||
| RECOGNIZED_SE_VALUE | NUMBER | Value of the fulfillment of both the primary and additional satisfaction events according to the satisfaction measurement model. The value indicates the satisfied quantity, satisfied percent, or period equivalent amount. | ||||
| CONTRACT_CURRENCY_CODE | VARCHAR2 | 15 | Revenue contract currency code. | |||
| EXCHANGE_RATE | NUMBER | Conversion rate of promised line. | ||||
| CONTR_CUR_ALLOCATED_AMOUNT | NUMBER | Allocated transaction price in contract currency | ||||
| ASE_ELIGIBLE_DATE | DATE | Eligible fulfillment date of the additional satisfaction event. | ||||
| ALLOCATION_METHOD_CODE | VARCHAR2 | 30 | The allocation currency basis used to allocate and recognize revenue for a contract. Valid values are from the lookup type ORA_VRM_ALLOCATION_METHOD. | |||
| PENDING_ASE_VALUE | NUMBER | Value of the fulfillment of the additional satisfaction event that is pending revenue recognition according to the satisfaction measurement model. The value is either the satisfied quantity, satisfied percent, or period equivalent amount. | ||||
| PENDING_PSE_VALUE | NUMBER | Value of the fulfillment of the primary satisfaction event that is pending revenue recognition according to the satisfaction measurement model. The value is either the satisfied quantity, satisfied percent, or period equivalent amount. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| VRM_PERF_OBLIG_LINES_GT_N1 | Non Unique | LINE_STATUS |
| VRM_PERF_OBLIG_LINES_GT_N2 | Non Unique | PERF_OBLIGATION_ID |
| VRM_PERF_OBLIG_LINES_GT_N3 | Non Unique | SATISFACTION_MEASUREMENT_MODEL, REVENUE_RULE_TYPE |
| VRM_PERF_OBLIG_LINES_GT_N4 | Non Unique | DOCUMENT_LINE_ID |
| VRM_PERF_OBLIG_LINES_GT_U1 | Unique | PERF_OBLIGATION_LINE_ID |