VRM_FMV_TEMPLATES_B
This object stores the processing options for VSOE fair value calculation. The VSOE template is then assigned to items/items groups that inherit the VSOE processing options from the template.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
VRM_FMV_TEMPLATES_B_PK |
TEMPLATE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TEMPLATE_ID | NUMBER | 18 | Yes | Internal identifier of the template. | |
| STRUCTURE_INSTANCE_NUMBER | NUMBER | 18 | Yes | Number of the pricing dimension structure. | |
| FMV_PRICE_TYPE | VARCHAR2 | 30 | Oracle internal use only. | ||
| FMV_REPRESENTATION_TYPE | VARCHAR2 | 30 | FMV price representation type. The value is derived from VRM_FMV_REPRESENTATIONS lookup type. | ||
| DATA_SELECTION_TIME_SPAN | NUMBER | 18 | Yes | Number of coverage periods that a VSOE price calculation process will gather the standalone sales from. | |
| MINIMUM_LINE_COUNT | NUMBER | 18 | Yes | Minimum number of standalone sales required in order to calculate a valid VSOE price. | |
| TOLERANCE_PCT_RANGE_HIGH | NUMBER | Yes | Higher limit of the VSOE fair price tolerance range in percentage. | ||
| TOLERANCE_PCT_RANGE_LOW | NUMBER | Yes | Lower limit of the VSOE fair price tolerance range in percentage. | ||
| TOLERANCE_RANGE_COVERAGE | NUMBER | Yes | The required minimum percentage of standalone sales that its unit selling price falls within tolerance range price of an item. | ||
| USE_TOLERANCE_FOR_COMPLIANCE | VARCHAR2 | 1 | Oracle internal use only. | ||
| DIMENSION_ASSIGNMENT_ID | NUMBER | 18 | Dimension assignment internal identifier. | ||
| INCLUDE_CURRENT_PERIODS | VARCHAR2 | 1 | Indicates whether to include sales in current effective price period. Possible values are Yes or No. | ||
| 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. | |
| 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. | ||
| 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. | |||
| ELEMENT_TYPE | VARCHAR2 | 30 | The element type used to identify the nature of item. | ||
| IN_USE | VARCHAR2 | 1 | Indicates whether the record is in-used and cannot be deleted. Possible values are Yes or No. | ||
| FMV_TOLERANCE_CODE | VARCHAR2 | 10 | Indicates the fair market value tolerance range level used to calculate the carve-out adjustment. | ||
| BELOW_RANGE_SSP_RULE_CODE | VARCHAR2 | 30 | The rule to be used in accordance with the Standalone Selling Price policy of the business when the actual value is below the SSP Low Point. Valid values are from the lookup type ORA_VRM_SSP_RANGE_CODE. | ||
| IN_RANGE_SSP_RULE_CODE | VARCHAR2 | 30 | The rule to be used in accordance with the Standalone Selling Price policy of the business when the actual value is between the SSP Low and SSP High Points. Valid values are from the lookup type ORA_VRM_SSP_RANGE_CODE. | ||
| ABOVE_RANGE_SSP_RULE_CODE | VARCHAR2 | 30 | The rule to be used in accordance with the Standalone Selling Price policy of the business when the actual value is above the SSP High Point. Valid values are from the lookup type ORA_VRM_SSP_RANGE_CODE. | ||
| SSP_RANGE_TOLERANCE_PERCENT | NUMBER | The tolerance percentage in accordance with the Standalone Selling Price policy of the business. The SSP Low Point and SSP High Point are calculated by the application when the SSP tolerance percentage and SSP midpoint are provided for an item or service. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| VRM_FMV_TEMPLATES_B | vrm_price_seg_assign_hdrs_b | DIMENSION_ASSIGNMENT_ID |
| vrm_fmv_line_sets | vrm_fmv_templates_b | TEMPLATE_ID |
| vrm_price_basis_data_sets | vrm_fmv_templates_b | TEMPLATE_ID |
| vrm_fmv_templ_assignments | vrm_fmv_templates_b | TEMPLATE_ID |
| vrm_perf_obligations | vrm_fmv_templates_b | FMV_TEMPLATE_ID |
| vrm_price_seg_assignments | vrm_fmv_templates_b | TEMPLATE_ID |
| vrm_pricing_lines | vrm_fmv_templates_b | TEMPLATE_ID |
| vrm_price_segment_assigns | vrm_fmv_templates_b | TEMPLATE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_FMV_TEMPLATES_B_U1 | Unique | Default | TEMPLATE_ID |