VRM_PERF_OBLIGATIONS
This table contains the performance obligations of customer contract.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
VRM_PERF_OBLIGATIONS_PK |
PERF_OBLIGATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PERF_OBLIGATION_ID | NUMBER | 18 | Yes | Performance obligation unique identifier. | |
| CUSTOMER_CONTRACT_HEADER_ID | NUMBER | 18 | Yes | Customer contract header unique identifier. | |
| PERF_OBLIGATION_NUMBER | NUMBER | 18 | Yes | Performance obligation number. | |
| PERF_OBLIGATION_TYPE | VARCHAR2 | 30 | Obligation type of a performance obligation. Values are from the lookup type ORA_VRM_PERF_OBLIGATION_TYPE. | ||
| PERF_OBLIG_CLASSIFICATION_CODE | VARCHAR2 | 30 | Classification code of a performance obligation. Values are from the lookup type ORA_VRM_OBLIG_CLASSIF_CODE. | ||
| PERF_OBLIGATION_TEMPLATE_ID | NUMBER | 18 | The identifier of the performance obligation template that is used to group the source document lines under a single performance obligation. | ||
| PERF_OBLIGATION_GROUP_RULE_ID | NUMBER | 18 | The identifier of the performance obligation identification rule that is used to group the source document lines under a single performance obligation. | ||
| PRICING_COMBINATION_ID | NUMBER | 18 | Pricing combination identifier. | ||
| FMV_LINE_ID | NUMBER | 18 | Revenue price line unique identifier. | ||
| SATISFACTION_METHOD | VARCHAR2 | 30 | Yes | Specifies whether the obligation is satisfied at a point in time or over time. Values are derived from the ORA_VRM_SATISFACTION_METHOD lookup type. | |
| SATISFACTION_STATUS | VARCHAR2 | 30 | Yes | Satisfaction status of the performance obligation. Values are derived from the lookup type ORA_VRM_LINE_SATISFACTN_STATUS. | |
| SATISFACTION_DATE | DATE | Date on which the performance obligation is satisfied. | |||
| OBLIG_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency code of the obligation. | |
| OBLIG_CUR_NET_LINE_AMT | NUMBER | Yes | Total line amount of all the performance obligation lines in the obligation currency. | ||
| OBLIG_CUR_NET_SALES_PRICE | NUMBER | Total net unit selling price in all the performance obligation lines in the obligation currency. | |||
| OBLIG_CUR_TOT_VAR_CONSIDER_AMT | NUMBER | Yes | Variable consideration amount of all performance obligation lines in the obligation currency. | ||
| OBLIG_CUR_TOT_NET_CONSIDER_AMT | NUMBER | Yes | Total net consideration amount in all the performance obligation lines in the obligation currency. | ||
| OBLIG_CUR_TOT_CARVE_OUT_AMT | NUMBER | Total discount amount of all performance obligation lines in the obligation currency. | |||
| OBLIG_CUR_TOT_ALLOC_AMT | NUMBER | Total allocated transaction price in the obligation currency. | |||
| OBLIG_CUR_TOTAL_RECOG_REV_AMT | NUMBER | Total revenue recognized for all the performance obligation lines in the obligation currency. | |||
| OBLIG_CUR_TOTAL_BILLED_AMT | NUMBER | Total billed amount of all the performance obligation lines in the obligation currency. | |||
| OBLIG_CUR_FMV_AMT | NUMBER | Revenue price amount of the obligation in the obligation currency. | |||
| OBLIG_PAYMENT_AMOUNT | NUMBER | Total payment amount for all the performance obligation lines in the contract currency. | |||
| CONTR_CUR_NET_LINE_AMT | NUMBER | Total line amount of all the performance obligation lines in the contract currency. | |||
| CONTR_CUR_TOT_VAR_CONSIDER_AMT | NUMBER | Variable consideration amount of all the performance obligation lines in the contract currency. | |||
| CONTR_CUR_TOT_NET_CONSIDER_AMT | NUMBER | Total net consideration amount of all the performance obligation lines in the contract currency. | |||
| CONTR_CUR_TOT_CARVE_OUT_AMT | NUMBER | Total discount amount of all the performance obligation lines in the contract currency. | |||
| CONTR_CUR_TOT_ALLOC_AMT | NUMBER | Total allocated transaction price in the contract currency. | |||
| CONTR_CUR_TOTAL_RECOG_REV_AMT | NUMBER | Total revenue recognized for all the performance obligation lines in the contract currency. | |||
| CONTR_CUR_TOTAL_BILLED_AMT | NUMBER | Total billed amount of all the performance obligation lines in the contract currency. | |||
| CONTR_CUR_FMV_AMT | NUMBER | Revenue price amount of the obligation in the contract currency. | |||
| LIST_PRICE_AMOUNT | NUMBER | List price amount of an item. | |||
| DISCOUNT_PERCENTAGE | NUMBER | Discount percentage. | |||
| COST_AMOUNT | NUMBER | Cost amount. | |||
| GROSS_MARGIN_PERCENTAGE | NUMBER | Gross margin percentage. | |||
| BASE_PRICE | NUMBER | Base price. | |||
| BASE_PRICE_PERCENTAGE | NUMBER | Base price percentage. | |||
| EXEMPT_FROM_ALLOCATION_FLAG | VARCHAR2 | 1 | Indicates whether this performance obligation is exempted from allocation. | ||
| PERF_OBLIG_FREEZE_FLAG | VARCHAR2 | 1 | Indicates if the performance obligation is frozen. | ||
| 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. | |||
| DEVOLVE_PO_FLAG | VARCHAR2 | 1 | Indicates whether this performance obligation 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_EXPECTED_DATE | DATE | Date on which the initial performance event is expected to be created. | |||
| INITIAL_PERF_EVT_CREATED_FLAG | VARCHAR2 | 1 | Indicates if the initial performance accounting event was created. | ||
| INITIAL_PERF_EVT_RECORDED_FLAG | VARCHAR2 | 1 | Indicates if the initial performance accounting event was recorded. | ||
| 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. | |
| REMOVED_FLAG | VARCHAR2 | 1 | Indicates whether a given performance obligation is removed from customer contract. | ||
| 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. | |||
| LEGAL_ENTITY_ID | NUMBER | 18 | Legal entity of the performance obligation. | ||
| FMV_TEMPLATE_ID | NUMBER | 18 | Revenue price profile. | ||
| OBLIG_HASH_CODE | VARCHAR2 | 100 | Obligation processing code. | ||
| CONTR_CUR_DR_ASSET_AMT | NUMBER | Total debit contract asset amount on the performance obligation. | |||
| CONTR_CUR_CR_LIABILITY_AMT | NUMBER | Total credit contract liability amount on the performance obligation. | |||
| CONTR_CUR_DR_DISCOUNT_AMT | NUMBER | Total debit discount amount on the performance obligation. | |||
| SUBSTANTIAL_DIST_CREATED_FLAG | VARCHAR2 | 1 | No longer used. | ||
| DISCOUNT_AMOUNT | NUMBER | Total discount amount in all the performance obligation lines in the obligation currency. | |||
| UNIT_SELLING_PRICE | NUMBER | Selling price per unit of measure of the inventory item or memo line. | |||
| IMPL_PERF_OBLIG_TEMPLATE_ID | NUMBER | 18 | Internal identifier of the implied performance obligation template. | ||
| DISCARD_FLAG | VARCHAR2 | 1 | Used to identify whether the obligation is discarded or not | ||
| OBLIGATION_REFERENCE | VARCHAR2 | 1000 | User entered performance obligation reference or grouping attribute values used to identify the performance obligation as derived by enabling the Copy to Reference option in the Performance Obligation Identification rule. | ||
| FIRST_SATISFACTION_EVENT_DATE | DATE | Date on which the first satisfaction event is created for a promised detail line under an obligation. | |||
| LATEST_REVISION_INTENT_CODE | VARCHAR2 | 30 | Revision intent of the last promised detail revision of the performance obligation. Values are from the lookup type ORA_VRM_REVISION_INTENT_TYPE. | ||
| LATEST_VERSION_DATE | DATE | Date of the most recent version of the performance obligation's underlying promised detail. | |||
| RESIDUAL_APPROACH_FLAG | VARCHAR2 | 1 | Indicates the pricing for the goods or services 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. | ||
| CONTR_CUR_RESIDUAL_PRICE_AMT | NUMBER | Calculated residual estimated extended standalone selling price of the performance obligation in the contract currency. | |||
| OBLIG_CUR_RESIDUAL_PRICE_AMT | NUMBER | Calculated residual estimated extended standalone selling price of the performance obligation in the entered currency. | |||
| ALLOCATION_BASIS_CODE | VARCHAR2 | 30 | The basis used to calculate the ratio of the allocated revenue for performance obligation distributions to their underlying promise detail lines. Valid values are from the lookup type ORA_VRM_ALLOC_BASIS. | ||
| ABS_SSP_PO | NUMBER | The absolute value of the unit standalone selling price for an item or service. | |||
| PO_SSP_RANGE_RULE_CODE | VARCHAR2 | 30 | The rule that is applied to the performance obligation template in accordance with the Standalone Selling Price policy. Valid values are from the lookup type ORA_VRM_SSP_RANGE_RULE. | ||
| PO_SSP_RULE_RESULT_CODE | VARCHAR2 | 30 | The result of the rule that is applied to the performance obligation template 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 to convert entered currency amounts to reference currency. | |||
| REFERENCE_EXCHANGE_RATE | NUMBER | Rate used for converting amounts from the entered currency to the reference currency. | |||
| OBLIGATION_CURRENCY_UNIT_SSP | NUMBER | The unit standalone selling price in obligation currency. | |||
| ADDITIONAL_SE_EXISTENCE_CODE | VARCHAR2 | 30 | Indicates if one or more promised details of the performance obligation has any additional satisfaction events associated with it. Values are derived from the lookup type ORA_VRM_LINE_ASE_EXISTANCE. | ||
| ADDITIONAL_SE_STATUS_CODE | VARCHAR2 | 30 | The overall fulfillment status of all the additional satisfaction events of all the promised detail lines related to the performance obligation. Values are derived from the lookup type ORA_VRM_LINE_SATISFACTION_STATUS. | ||
| FOREIGN_CURR_TREATMENT_CODE | VARCHAR2 | 30 | The currency conversion treatment used for contract liability accounting distributions when processing foreign currency performance obligations for the ledger. Valid values are from the lookup type ORA_VRM_FX_CURR_TREATMENT. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| VRM_PERF_OBLIGATIONS | vrm_customer_contract_headers | CUSTOMER_CONTRACT_HEADER_ID |
| VRM_PERF_OBLIGATIONS | fnd_currencies_b | REFERENCE_CURRENCY_CODE |
| VRM_PERF_OBLIGATIONS | vrm_perf_oblig_templates_b | PERF_OBLIGATION_TEMPLATE_ID |
| VRM_PERF_OBLIGATIONS | vrm_perf_oblig_grp_rules_b | PERF_OBLIGATION_GROUP_RULE_ID |
| VRM_PERF_OBLIGATIONS | vrm_pricing_combinations | PRICING_COMBINATION_ID |
| VRM_PERF_OBLIGATIONS | vrm_fmv_lines | FMV_LINE_ID |
| VRM_PERF_OBLIGATIONS | gl_daily_conversion_types | EXCHANGE_RATE_TYPE |
| VRM_PERF_OBLIGATIONS | xle_entity_profiles | LEGAL_ENTITY_ID |
| VRM_PERF_OBLIGATIONS | vrm_fmv_templates_b | FMV_TEMPLATE_ID |
| VRM_PERF_OBLIGATIONS | gl_daily_conversion_types | REFERENCE_EXCHANGE_RATE_TYPE |
| vrm_create_event_dists_interim | vrm_perf_obligations | PERF_OBLIGATION_ID |
| vrm_reference_currency_details | vrm_perf_obligations | PERF_OBLIGATION_ID |
| vrm_perf_obligation_lin_dists | vrm_perf_obligations | PERF_OBLIGATION_ID |
| vrm_po_immaterial_details | vrm_perf_obligations | PERF_OBLIGATION_ID |
| vrm_perf_obligation_lines | vrm_perf_obligations | PERF_OBLIGATION_ID |
| vrm_devolved_perf_oblig_dtls | vrm_perf_obligations | PERF_OBLIGATION_ID |
| vrm_contr_carveout_hdrs | vrm_perf_obligations | PERF_OBLIGATION_ID |
| vrm_customer_contract_audit | vrm_perf_obligations | PERF_OBLIGATION_ID |
| vrm_pol_immaterial_details | vrm_perf_obligations | PERF_OBLIGATION_ID |
| vrm_contract_activities | vrm_perf_obligations | PERF_OBLIGATION_ID |
| vrm_accounting_events | vrm_perf_obligations | PERF_OBLIGATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_PERF_OBLIGATIONS_N1 | Non Unique | Default | CUSTOMER_CONTRACT_HEADER_ID, REMOVED_FLAG |
| VRM_PERF_OBLIGATIONS_N2 | Non Unique | Default | REQUEST_ID |
| VRM_PERF_OBLIGATIONS_U1 | Unique | Default | PERF_OBLIGATION_ID |