VRM_POL_IMMATERIAL_DETAILS_GT
Oracle internal use only. This global temporary table is used in identify customer contracts job during internal processing of immaterial change.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| POL_IMMATERIAL_DETAIL_ID | NUMBER | 18 | Yes | Promised detail line level immaterial details unique identifier. | |
| FMV_LINE_ID | NUMBER | 18 | Standalone selling price line unique identifier. | ||
| CONTR_CUR_FMV_AMT | NUMBER | Standalone selling price amount in the contract currency for the promised detail line. | |||
| CONTR_CUR_ALLOCATED_AMT | NUMBER | Allocated transaction price in the contract currency for the promised detail line. | |||
| REVENUE_RULE_ID | NUMBER | 18 | Satisfaction plan unique identifier. | ||
| REVENUE_START_DATE | DATE | The date the satisfaction plan begins. | |||
| REVENUE_RULE_DURATION | NUMBER | Number of periods in which the revenue of this performance obligation line is to be recognized. | |||
| REVENUE_END_DATE | DATE | The date the satisfaction plan ends. | |||
| NET_QUANTITY | NUMBER | Net quantity of a promised detail line. | |||
| LATEST_REC_FLAG | VARCHAR2 | 1 | Latest immaterial change type that occurred on the promised detail line. | ||
| CONTRACT_MODIFICATION_DATE | DATE | Date on which the revenue contract was modified. | |||
| IMMATERIAL_CHANGE_CODE | VARCHAR2 | 30 | Immaterial change type for this line. Valid values are from the lookup type ORA_IMMATERIAL_CHANGE_TYPE. | ||
| EFFECTIVITY_PERIOD_ID | NUMBER | 18 | Effective period unique identifier. Derived using the customer contract date. | ||
| REMOVED_FLAG | VARCHAR2 | 1 | Indicates whether the current line is considered when computing the allocated amount on the promised detail line after processing an immaterial change. | ||
| CONTR_CUR_MOD_DATE_REV_AMT | NUMBER | Recognized revenue in the contract currency as of the contract revision 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. The base number is the sum of the numerator of the ratio of all schedules. | |||
| CONTR_CUR_PART_PERIOD_REV_AMT | NUMBER | Recognized revenue in the contract currency as of the contract revision date in a partial accounting period. | |||
| PERF_OBLIGATION_LINE_ID | NUMBER | 18 | 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. | ||
| PREVIOUS_SERVICE_DURATION | NUMBER | Previous duration of the service item in terms of the service unit of measure. | |||
| SERVICE_DURATION | NUMBER | Duration of the service item in terms of the service unit of measure. | |||
| ENTERED_CUR_FMV_AMT | NUMBER | Standalone selling price amount in the entered currency for the promised detail line. | |||
| ENTERED_CUR_ALLOCATED_AMT | NUMBER | Allocated transaction price in the entered currency for the promised detail line. | |||
| ENTERED_CUR_MOD_DATE_REV_AMT | NUMBER | Recognized revenue in the entered currency as of the contract revision date. | |||
| ENTERED_CUR_PART_PER_REV_AMT | NUMBER | Recognized revenue in the entered currency as of the contract revision date in a partial accounting period. | |||
| EXCHANGE_RATE | NUMBER | Conversion rate used for converting the amount from the entered currency to the ledger currency. | |||
| ENTER_CURR_UNIT_SELLING_PRICE | NUMBER | Unit selling price of the item or memo line in the transaction currency. | |||
| ENTER_CURR_LINE_AMOUNT | NUMBER | Line amount of the promised detail line in the transaction currency. | |||
| CONTR_CURR_UNIT_SELLING_PRICE | NUMBER | Unit selling price of the item or memo line in the accounted currency. | |||
| CONTR_CURR_LINE_AMOUNT | NUMBER | Line amount of the promised detail line in the accounted currency. | |||
| ENTER_CURR_UNIT_LIST_PRICE_AMT | NUMBER | Unit list price amount of the promised detail line. |