VRM_PERF_OBLIGATIONS_GT
Oracle internal use only. This global temporary table is used in identify customer contracts job during internal processing.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PERF_OBLIGATION_ID | NUMBER | 18 | Yes | Performance obligation unique identifier. | |
| CUSTOMER_CONTRACT_HEADER_ID | NUMBER | 18 | Customer contract header unique identifier. | ||
| PERF_OBLIGATION_NUMBER | NUMBER | 18 | Performance obligation number. This is a running sequence number. | ||
| PERF_OBLIGATION_TYPE | VARCHAR2 | 30 | Obligation type of a performance obligation. Values are from the lookup type ORA_VRM_PERF_OBLIGATION_TYPE. | ||
| EXEMPT_FROM_ALLOCATION_FLAG | VARCHAR2 | 1 | Indicates whether this performance obligation is exempted from allocation. | ||
| 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. | ||
| IMPL_PERF_OBLIG_TEMPLATE_ID | NUMBER | 18 | Internal identifier of the implied performance obligation template. | ||
| PRICING_COMBINATION_ID | NUMBER | 18 | Pricing combination identifier. | ||
| FMV_LINE_ID | NUMBER | 18 | Revenue price line unique identifier. | ||
| SATISFACTION_METHOD | VARCHAR2 | 30 | 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 | 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 | Currency code of the obligation. | ||
| OBLIG_CUR_NET_LINE_AMT | NUMBER | 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 | Variable consideration amount of all performance obligation lines in the obligation currency. | |||
| OBLIG_CUR_TOT_NET_CONSIDER_AMT | NUMBER | 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. | |||
| 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. | |||
| FMV_TEMPLATE_ID | NUMBER | 18 | Revenue price profile internal identifier | ||
| LIST_PRICE_AMOUNT | NUMBER | Sum of unit list price of all the promised detail lines of the performance obligation. | |||
| UNIT_SELLING_PRICE | NUMBER | Selling price per unit of measure of the inventory item or memo line. | |||
| DISCOUNT_AMOUNT | NUMBER | Total discount amount in all the performance obligation lines in the obligation currency. | |||
| DISCOUNT_PERCENTAGE | NUMBER | Discount percentage of the performance obligation. | |||
| COST_AMOUNT | NUMBER | Cost amount of the performance obligation. | |||
| GROSS_MARGIN_PERCENTAGE | NUMBER | Gross margin percentage of the performance obligation. | |||
| BASE_PRICE | NUMBER | Base price of the performance obligation. | |||
| BASE_PRICE_PERCENTAGE | NUMBER | Base price percentage of the performance obligation. | |||
| PERF_OBLIG_FREEZE_FLAG | VARCHAR2 | 1 | Indicates if the performance obligation is frozen. | ||
| EXCHANGE_RATE | NUMBER | Conversion rate for converting amounts from the obligation currency to the ledger currency. | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Conversion rate type of the performance obligation. | ||
| 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. | |||
| LEGAL_ENTITY_ID | NUMBER | 18 | Legal entity of the performance obligation. | ||
| REMOVED_FLAG | VARCHAR2 | 1 | Indicates whether a given performance obligation is removed from customer contract. | ||
| DISCARD_FLAG | VARCHAR2 | 1 | Used to identify whether the obligation is discarded or not | ||
| DEVOLVE_PO_FLAG | VARCHAR2 | 1 | Oracle internal use only. 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. | ||
| CREATED_FROM | VARCHAR2 | 30 | The process or user interface from which this row is created.. | ||
| OBLIG_HASH_CODE | VARCHAR2 | 100 | Oracle internal use only. Obligation processing code. | ||
| 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. | ||
| PERF_OBLIGATION_STATUS_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| INITIAL_PERF_EVT_CREATED_FLAG | VARCHAR2 | 1 | Indicates if the initial performance accounting event was created. | ||
| 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 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 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. | |||
| 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. | ||
| 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. | ||
| 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. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| VRM_PERF_OBLIGS_GT_N1 | Non Unique | PERF_OBLIGATION_STATUS_CODE, REMOVED_FLAG |