VRM_PERF_OBLIGATION_LINES
This table contains the performance obligation lines of customer contract.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
VRM_PERF_OBLIG_LINES_PK |
PERF_OBLIGATION_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PERF_OBLIGATION_LINE_ID | NUMBER | 18 | Yes | Performance obligation line unique identifier. | |
| PERF_OBLIGATION_LINE_NUMBER | NUMBER | 18 | Yes | Running sequence number within a customer contract. | |
| CUSTOMER_CONTRACT_HEADER_ID | NUMBER | 18 | Yes | Customer contract header unique identifier. | |
| PERF_OBLIGATION_ID | NUMBER | 18 | Yes | Performance obligation line unique identifier. | |
| DOCUMENT_LINE_ID | NUMBER | 18 | Yes | Source document line unique identifier. | |
| LINE_SATISFACTION_STATUS | VARCHAR2 | 30 | Yes | Satisfaction status of the performance obligation line. Values are derived from the lookup type ORA_VRM_LINE_SATISFACTN_STATUS. | |
| LINE_SATISFACTION_DATE | DATE | Date on which a performance obligation line is satisfied. | |||
| FIRST_SATISFACTION_EVENT_DATE | DATE | Date on which the first satisfaction event is created for a promised detail line. | |||
| PRICING_COMBINATION_ID | NUMBER | 18 | Pricing combination identifier. | ||
| FMV_LINE_ID | NUMBER | 18 | Revenue price line unique identifier | ||
| NET_LINE_AMT | NUMBER | Yes | Net line amount. | ||
| ENTERED_CUR_VAR_CONSIDER_AMT | NUMBER | Variable consideration amount. | |||
| ENTERED_CUR_NET_CONSIDER_AMT | NUMBER | The sum of the net line amount and the variable consideration in the entered currency. | |||
| ENTERED_CUR_CARVE_OUT_AMT | NUMBER | Discount amount in the entered currency. | |||
| ENTERED_CUR_ALLOCATED_AMT | NUMBER | The sum of the net consideration amount and the discount amount in the entered currency. | |||
| ENTERED_CUR_RECOG_REV_AMT | NUMBER | Revenue recognized in the entered currency. | |||
| ENTERED_CUR_BILLED_AMT | NUMBER | Billed amount in the entered currency. | |||
| ENTERED_CUR_FMV_AMT | NUMBER | Revenue price amount in the entered currency. | |||
| REV_REC_PROCESSED_FLAG | VARCHAR2 | 1 | Indicates whether the revenue recognition of this performance obligation line was processed. | ||
| MISSING_REV_INFORMATION_FLAG | VARCHAR2 | 1 | Indicates if any revenue related attributes are missing on the performance obligation line for the satisfaction measurement events creation. | ||
| REPROCESS_LINE_EVENTS_FLAG | VARCHAR2 | 1 | No longer used. | ||
| REV_REC_REPROCESS_STATUS_CODE | VARCHAR2 | 30 | Revenue recognition reprocessing status. Values are from the lookup ORA_REV_REC_REPROCESS_STATUS. | ||
| BILLING_LINE_CREATED_FLAG | VARCHAR2 | 1 | Indicates whether zero amount billing line is created for the implied promise detail line upon full satisfaction. | ||
| PAYMENT_AMOUNT | NUMBER | Amount paid by the customer against this performance obligation line. | |||
| SATISFACTION_MEASUREMENT_MODEL | VARCHAR2 | 30 | Specifies how satisfaction will be measured and recorded for a performance obligation line. Values are derived from the lookup type ORA_VRM_SATIS_MEAS_MODEL. | ||
| 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. | |||
| REVENUE_RULE_ID | NUMBER | 18 | Unique identifier of a revenue scheduling rule. | ||
| REVENUE_START_DATE | DATE | Date from which revenue must be recognized. | |||
| REVENUE_RULE_DURATION | NUMBER | Number of periods in which revenue of this performance obligation line is to be recognized. | |||
| REVENUE_END_DATE | DATE | Date until which revenue must be recognized. | |||
| REV_REC_PROCESD_DOC_LINE_ID | NUMBER | 18 | Source document line unique identifier. Used for satisfaction events creation. | ||
| 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. | |||
| CONTR_CUR_NET_LINE_AMT | NUMBER | Total line amount of all the performance obligation lines in the contract currency. | |||
| CONTR_CUR_VAR_CONSIDER_AMT | NUMBER | Variable consideration amount in the contract currency. | |||
| CONTR_CUR_NET_CONSIDER_AMT | NUMBER | Net consideration amount in the contract currency. | |||
| CONTR_CUR_CARVE_OUT_AMT | NUMBER | Discount amount in the contract currency. | |||
| CONTR_CUR_ALLOCATED_AMT | NUMBER | Allocated transaction price in the contract currency. | |||
| CONTR_CUR_RECOG_REV_AMT | NUMBER | Revenue recognized in the contract Currency. | |||
| CONTR_CUR_BILLED_AMT | NUMBER | Billed amount in the contract currency. | |||
| CONTR_CUR_FMV_AMT | NUMBER | Revenue price amount in the contract currency. | |||
| STANDALONE_SALES_FLAG | VARCHAR2 | 1 | Indicates whether this obligation line will be used in selling price calculation. The following are the eligible contracts for selling price calculation: Contracts with a single obligation and a single obligation line. Contracts with a single obligation and multiple obligation lines. | ||
| SATISFACTION_CONFIRM_FLAG | VARCHAR2 | 1 | Indicates whether this obligation line needs a satisfaction confirmation. | ||
| AUTOMATIC_CONFIRMATION_PERIOD | NUMBER | The number of days after the satisfaction measurement date of each satisfaction event on which the satisfaction measurement should be automatically confirmed by the system. | |||
| LINE_SOURCE | VARCHAR2 | 30 | The source through which this line is created. Values are from the lookup type ORA_LINE_SOURCE. | ||
| LINE_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency code of the obligation line. | |
| BU_ID | NUMBER | 18 | No longer used. | ||
| LEDGER_ID | NUMBER | 18 | Ledger identifier of source document line. | ||
| COMMENTS | VARCHAR2 | 1000 | User entered comments. | ||
| EXCHANGE_RATE | NUMBER | Conversion rate for converting amounts from the obligation currency to the ledger currency. | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Conversion rate type. | ||
| EXCHANGE_RATE_DATE | DATE | Conversion date to be used to derive the conversion rate for converting amounts from the obligation currency to the ledger currency. | |||
| REMOVED_DATE | DATE | Obligation line removed date. | |||
| REMOVED_BY | VARCHAR2 | 64 | Obligation line removed by | ||
| REMOVED_FLAG | VARCHAR2 | 1 | Indicates whether a given performance obligation line is removed from performance obligation. | ||
| REMOVED_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that marked this row as removed. | ||
| MOVE_TO_CONTR_NUMBER | NUMBER | 18 | Target customer contract number. | ||
| MOVE_TO_OBLIG_NUMBER | NUMBER | 18 | Target performance obligation number. | ||
| PARENT_PERF_OBLIG_LINE_ID | NUMBER | 18 | Related line identifier for an implied performance obligation line. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| CREATED_FROM | VARCHAR2 | 30 | Yes | The process or user interface from which this row is created.. | |
| 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. | |
| 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_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SE_CREATED_FROM_SUBLINE_FLAG | VARCHAR2 | 1 | No longer used. | ||
| DISCARD_FLAG | VARCHAR2 | 1 | Used to identify whether the obligation line is discarded or not. | ||
| CONTRACT_UPDATE_TEMPLATE_ID | NUMBER | 18 | Revenue contract update template identifier. | ||
| LATEST_REVISION_INTENT_CODE | VARCHAR2 | 30 | Revision intent of the last source document line version of the promised detail. Values are from the lookup type ORA_VRM_REVISION_INTENT_TYPE. | ||
| LATEST_VERSION_DATE | DATE | Date of the most recent version of the promised detail line's supporting source document. | |||
| ALLOCATION_REQUIRED_FLAG | VARCHAR2 | 1 | Indicates whether the promised detail line is eligible for allocation after processing the immaterial change. | ||
| NET_QUANTITY | NUMBER | Net quantity of a promised detail line. | |||
| EFFECTIVITY_PERIOD_ID | NUMBER | 18 | Unique identifier of a standard sales price effectivity period. Derived using the customer contract date. | ||
| RESIDUAL_APPROACH_FLAG | VARCHAR2 | 1 | Indicates the pricing for the goods or services for the promised detail line is variable or missing and the standalone selling price for the performance obligation is estimated using the residual approach. Valid values are from the lookup type VRM_YES/NO. | ||
| PO_TEMPLATE_GROUPING_CODE | VARCHAR2 | 100 | Code value used to group lines with a similar non-amount band pricing dimension combination. | ||
| SERVICE_UOM | VARCHAR2 | 200 | Unit of measure of the service item on the source document line. Valid values are from the Price Periodicity UOM Class defined in Oracle Fusion Pricing. | ||
| SERVICE_DURATION | NUMBER | Duration of the service item in terms of the service unit of measure. | |||
| ABS_SSP_POL | NUMBER | The absolute value of the unit standalone selling price for an item or service. | |||
| POL_SSP_RANGE_RULE_CODE | VARCHAR2 | 30 | The rule that is applied to the promised detail in accordance with the Standalone Selling Price policy. Valid values are from the lookup type ORA_VRM_SSP_RANGE_RULE. | ||
| POL_SSP_RULE_RESULT_CODE | VARCHAR2 | 30 | The result of the rule that is applied to the promised detail in accordance with the Standalone Selling Price policy. Valid values are from the lookup type ORA_VRM_SSP_RANGE_CODE. | ||
| SSP_LOW | NUMBER | The low point of the acceptable standalone selling price ranges. This value is used to determine the unit standalone selling price in accordance with the Standalone Selling Price policy for ranges. | |||
| SSP_HIGH | NUMBER | The high point of the acceptable standalone selling price ranges. This value is used to determine the unit standalone selling price in accordance with the Standalone Selling Price policy for ranges. | |||
| REFERENCE_CURRENCY_CODE | VARCHAR2 | 15 | Currency used as the reference currency for converting entered currency amounts to the reference currency. | ||
| REFERENCE_EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Rate type used to convert entered currency amounts to reference currency. | ||
| REFERENCE_EXCHANGE_RATE_DATE | DATE | Date used for converting amounts from the entered currency to the reference currency. | |||
| REFERENCE_EXCHANGE_RATE | NUMBER | Rate used for converting amounts from the entered currency to the reference currency. | |||
| REFERENCE_CURR_DATE_TYPE_CODE | VARCHAR2 | 30 | Date type used to convert entered currency amounts to the reference currency, Valid values are from the lookup type ORA_REF_CONVERSION_RATE_DATE. | ||
| OBLIGATION_CURRENCY_UNIT_SSP | NUMBER | The unit standalone selling price in obligation currency. | |||
| ADDITIONAL_SE_EXISTENCE_CODE | VARCHAR2 | 30 | Indicates whether the promised detail line has any additional satisfaction events on it. Values are derived from the lookup type ORA_VRM_LINE_ASE_EXISTANCE. | ||
| ASE_FULFILLMENT_PROCESS_CODE | VARCHAR2 | 30 | Indicates whether all the additional sublines indicating the fulfillment of additional satisfaction events for the promised detail line are processed or not. Values are derived from the lookup type ORA_VRM_LINE_ASE_PROCESS | ||
| ADDITIONAL_SE_STATUS_CODE | VARCHAR2 | 30 | The 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. | ||
| 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_RECOGNIZED_REVENUE_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. | |||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| VRM_PERF_OBLIGATION_LINES | vrm_perf_obligations | PERF_OBLIGATION_ID |
| VRM_PERF_OBLIGATION_LINES | vrm_source_doc_lines | REV_REC_PROCESD_DOC_LINE_ID |
| VRM_PERF_OBLIGATION_LINES | vrm_perf_obligation_lines | PARENT_PERF_OBLIG_LINE_ID |
| VRM_PERF_OBLIGATION_LINES | ra_rules | REV_REC_PROCESD_REV_RULE_ID |
| VRM_PERF_OBLIGATION_LINES | gl_daily_conversion_types | REFERENCE_EXCHANGE_RATE_TYPE |
| VRM_PERF_OBLIGATION_LINES | fnd_currencies_b | REFERENCE_CURRENCY_CODE |
| VRM_PERF_OBLIGATION_LINES | vrm_source_doc_lines | DOCUMENT_LINE_ID |
| VRM_PERF_OBLIGATION_LINES | vrm_fmv_lines | FMV_LINE_ID |
| VRM_PERF_OBLIGATION_LINES | vrm_customer_contract_headers | CUSTOMER_CONTRACT_HEADER_ID |
| VRM_PERF_OBLIGATION_LINES | ra_rules | REVENUE_RULE_ID |
| VRM_PERF_OBLIGATION_LINES | gl_ledgers | LEDGER_ID |
| VRM_PERF_OBLIGATION_LINES | gl_daily_conversion_types | EXCHANGE_RATE_TYPE |
| vrm_create_event_dists_interim | vrm_perf_obligation_lines | PERF_OBLIGATION_LINE_ID |
| vrm_pol_billing_events | vrm_perf_obligation_lines | PERF_OBLIGATION_LINE_ID |
| vrm_perf_obligation_lin_splits | vrm_perf_obligation_lines | PERF_OBLIGATION_LINE_ID |
| vrm_contr_carveout_lines | vrm_perf_obligation_lines | PERF_OBLIGATION_LINE_ID |
| vrm_reference_currency_details | vrm_perf_obligation_lines | PERF_OBLIGATION_LINE_ID |
| vrm_perf_obligation_lin_dists | vrm_perf_obligation_lines | PERF_OBLIGATION_LINE_ID |
| vrm_pol_satisfaction_events | vrm_perf_obligation_lines | PERF_OBLIGATION_LINE_ID |
| vrm_perf_obligation_lines | vrm_perf_obligation_lines | PARENT_PERF_OBLIG_LINE_ID |
| vrm_customer_contract_audit | vrm_perf_obligation_lines | PERF_OBLIGATION_LINE_ID |
| vrm_pol_immaterial_details | vrm_perf_obligation_lines | PERF_OBLIGATION_LINE_ID |
| vrm_contract_activities | vrm_perf_obligation_lines | PERF_OBLIGATION_LINE_ID |
| vrm_accounting_events | vrm_perf_obligation_lines | PERF_OBLIGATION_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_PERF_OBLIG_LINES_N1 | Non Unique | Default | REV_REC_PROCESSED_FLAG, LEDGER_ID, CUSTOMER_CONTRACT_HEADER_ID |
| VRM_PERF_OBLIG_LINES_N2 | Non Unique | Default | CUSTOMER_CONTRACT_HEADER_ID |
| VRM_PERF_OBLIG_LINES_N3 | Non Unique | Default | REQUEST_ID |
| VRM_PERF_OBLIG_LINES_N4 | Non Unique | Default | PERF_OBLIGATION_ID, DOCUMENT_LINE_ID, REMOVED_FLAG |
| VRM_PERF_OBLIG_LINES_N5 | Non Unique | Default | DOCUMENT_LINE_ID |
| VRM_PERF_OBLIG_LINES_N6 | Non Unique | VRM_PERF_OBLIG_LINES_N6 | ADDITIONAL_SE_EXISTENCE_CODE, ASE_FULFILLMENT_PROCESS_CODE, LEDGER_ID |
| VRM_PERF_OBLIG_LINES_U1 | Unique | Default | PERF_OBLIGATION_LINE_ID |