VRM_POL_IMMATERIAL_DETAILS
This table contains the actions performed on the promised detail lines of customer contract because of processing of immaterial change.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
VRM_POL_IMMATERIAL_DETAILS_PK |
POL_IMMATERIAL_DETAIL_ID |
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. | ||
| 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. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| 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. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| 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. | |
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| VRM_POL_IMMATERIAL_DETAILS | vrm_perf_obligations | PERF_OBLIGATION_ID |
| VRM_POL_IMMATERIAL_DETAILS | vrm_customer_contract_headers | CUSTOMER_CONTRACT_HEADER_ID |
| VRM_POL_IMMATERIAL_DETAILS | vrm_perf_obligation_lines | PERF_OBLIGATION_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_POL_IMMATERIAL_DTLS_N1 | Non Unique | FUSION_TS_TX_DATA | PERF_OBLIGATION_ID |
| VRM_POL_IMMATERIAL_DTLS_N2 | Non Unique | FUSION_TS_TX_DATA | CUSTOMER_CONTRACT_HEADER_ID |
| VRM_POL_IMMATERIAL_DTLS_N3 | Non Unique | FUSION_TS_TX_DATA | PERF_OBLIGATION_LINE_ID |
| VRM_POL_IMMATERIAL_DTLS_U1 | Unique | FUSION_TS_TX_DATA | POL_IMMATERIAL_DETAIL_ID |