VRM_FP_TEMPLATES_INTERIM
VRM_FP_TEMPLATES_INTERIM contains the templates which are in the process of FMV calculation.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
VRM_FP_TEMPLATES_INTERIM_PK |
TEMPLATE_ASSIGNMENT_ID, REQUEST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TEMPLATE_ID | NUMBER | 18 | Template internal identifier. | ||
| FMV_PRICE_TYPE | VARCHAR2 | 30 | Fair market value price type. Price type can be either VSOE, TPE, or ESP. Values are from the lookup VRM_FMV_TYPES. This column is obsoleted for usage. | ||
| DATA_SELECTION_TIME_SPAN | NUMBER | Number of coverage periods that a VSOE price calculation process will gather the standalone sales from. | |||
| MINIMUM_LINE_COUNT | NUMBER | Minimum number of standalone sales required in order to calculate a valid VSOE price. | |||
| TOLERANCE_PCT_RANGE_LOW | NUMBER | Lower limit of the VSOE fair price tolerance range in percentage. | |||
| TOLERANCE_PCT_RANGE_HIGH | NUMBER | Higher limit of the VSOE fair price tolerance range in percentage. | |||
| TOLERANCE_RANGE_COVERAGE | NUMBER | The required minimum percentage of standalone sales that its unit selling price falls within tolerance range price of an item. | |||
| COVERAGE_RANGE_START_DATE | DATE | Start date of a coverage period. | |||
| COVERAGE_RANGE_END_DATE | DATE | End date of a coverage period. | |||
| USE_TOLERANCE_FOR_COMPLIANCE | VARCHAR2 | 1 | A flag that indicates if a tolerance range should be used during compliance validation process of a MEA line or not. This column is obsoleted for usage. | ||
| FMV_REPRESENTATION_TYPE | VARCHAR2 | 30 | FMV price representation type. The value is derived from VRM_FMV_REPRESENTATIONS lookup type. | ||
| REQUEST_ID | NUMBER | 18 | Yes | Enterprise Service Scheduler: indicates the request ID of the job that created or 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. | ||
| 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. | ||
| TEMPLATE_ASSIGNMENT_ID | NUMBER | 18 | Yes | Template assignment identifier. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_FP_TEMPLATES_INTERIM_N1 | Non Unique | Default | REQUEST_ID |
| VRM_FP_TEMPLATES_INTERIM_U1 | Unique | Default | TEMPLATE_ASSIGNMENT_ID, REQUEST_ID |