VRM_PERF_OBLIGATION_LINES_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_LINE_ID | NUMBER | 18 | Yes | Performance obligation line unique identifier. | |
| PERF_OBLIGATION_LINE_NUMBER | NUMBER | 18 | Running sequence number within a customer contract. | ||
| CUSTOMER_CONTRACT_HEADER_ID | NUMBER | 18 | Customer contract header unique identifier. | ||
| PERF_OBLIGATION_ID | NUMBER | 18 | Performance obligation line unique identifier. | ||
| DOCUMENT_LINE_ID | NUMBER | 18 | Source document line unique identifier. | ||
| LINE_SATISFACTION_STATUS | VARCHAR2 | 30 | 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. | |||
| PRICING_COMBINATION_ID | NUMBER | 18 | Pricing combination identifier. | ||
| FMV_LINE_ID | NUMBER | 18 | Revenue price line unique identifier. | ||
| LINE_CURRENCY_CODE | VARCHAR2 | 15 | Revenue price line unique identifier | ||
| NET_LINE_AMT | NUMBER | Yes | Net line amount of the source document line. | ||
| ENTERED_CUR_VAR_CONSIDER_AMT | NUMBER | Variable consideration amount in the entered currency. | |||
| 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_REPROCESS_STATUS_CODE | VARCHAR2 | 30 | Revenue recognition reprocessing status. Values are from the lookup ORA_REV_REC_REPROCESS_STATUS. | ||
| 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. | ||
| 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. | |||
| 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. | |||
| BU_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| LEDGER_ID | NUMBER | 18 | Ledger identifier of source document. | ||
| 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 promised detail line. | ||
| 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. | |||
| DISCARD_FLAG | VARCHAR2 | 1 | Used to identify whether the obligation line is discarded or not. | ||
| 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. | ||
| PARENT_PERF_OBLIG_LINE_ID | NUMBER | 18 | Related line identifier for an implied performance obligation line. | ||
| CREATED_FROM | VARCHAR2 | 30 | The process or user interface from which this row is created.. | ||
| REV_REC_PROCESSED_FLAG | VARCHAR2 | 1 | Indicates whether the revenue recognition of this performance obligation line was processed. | ||
| PERF_OBLIG_LINE_STATUS_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| ALLOCATION_REQUIRED_FLAG | VARCHAR2 | 1 | Indicates whether the promised detail line is eligible for allocation after processing the immaterial change. | ||
| IS_OPEN_ON_CM_DATE_FLAG | VARCHAR2 | 1 | Indicates whether the promised detail line is open or closed as of the contract modification date. | ||
| 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. | |||
| TERMINATION_DATE | DATE | The date on which the revenue line was terminated. | |||
| 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. | ||
| 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. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| VRM_PO_LINES_GT_N1 | Non Unique | DOCUMENT_LINE_ID |
| VRM_PO_LINES_GT_N2 | Non Unique | PERF_OBLIG_LINE_STATUS_CODE, REMOVED_FLAG |