VRM_FMV_LINES
This object stores the fair market values (FMV).
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
VRM_FMV_LINES_PK |
FMV_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| FMV_LINE_ID | NUMBER | 18 | Yes | Internal identifier for a FMV line. | |
| PRICING_COMBINATION_ID | NUMBER | 18 | Pricing dimension combination identifier. | ||
| TEMPLATE_ID | NUMBER | 18 | Internal Identifier of the FMV template. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency code of the document line. | ||
| UOM_CODE | VARCHAR2 | 200 | Code name of the unit of measure. | ||
| ITEM_TYPE | VARCHAR2 | 10 | Yes | Indicates the type of a source document items. The valid values are ITEM, MEMO_LINE and ITEM_GROUP. | |
| ITEM_TYPE_ID | NUMBER | 18 | Yes | Unique identifier of an item type. | |
| INVENTORY_ORG_ID | NUMBER | 18 | Unique identifier of an item inventory organization. | ||
| FMV_LINE_SET_ID | NUMBER | 18 | Internal identifier for a fair marker value set. | ||
| STATUS | VARCHAR2 | 30 | VSOE price set status. Values are from the lookup: VSOE Price Sets Status. | ||
| FAIR_MARKET_VALUE | NUMBER | A fair market value of an item, item group, or memo line in entered currency. | |||
| CORP_CURRENCY_FM_VALUE | NUMBER | A fair market value of an item, item group, or memo line in corporate currency. | |||
| FMV_TOLERANCE_HIGH_PCT | NUMBER | High price percentage of the FMV tolerance range. | |||
| FMV_TOLERANCE_LOW_PCT | NUMBER | Low price percentage of the FMV tolerance range. | |||
| 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. | |||
| AVERAGE_PRICE | NUMBER | An average price of an item, item group, or memo line. | |||
| HIGHEST_PRICE | NUMBER | High price of the tolerance range. | |||
| LOWEST_PRICE | NUMBER | Lowest selling price of standalone sales of an item within a coverage period. | |||
| LINE_COUNT | NUMBER | 18 | An item pricing count of a VSOE price set. | ||
| TOTAL_AMOUNT | NUMBER | Total line amount of a price basis data set. | |||
| TOTAL_QUANTITY | NUMBER | Total quantity of a price basis data set. | |||
| STANDARD_DEVIATION | NUMBER | Stores the standard deviation of the FMV based on the FMV price basis line set used for calculating the FMV. | |||
| TOLERANCE_COVERAGE | NUMBER | Stores the percentage of standalone sales that its unit selling price falls within tolerance range price of an item. | |||
| TOLERANCE_COVERAGE_COUNT | NUMBER | 18 | Stores the number of standalone sales that its unit selling price falls within tolerance range price of an item. | ||
| EXCEPTION_ACTION | VARCHAR2 | 30 | An action taken on a VSOE price with exception status. An exception VSOE price can be determined if it is a valid or invalid VSOE price by a revenue analyst or manager. Lookup Name: VSOE Price Exception Line Status. | ||
| EXCEPTION_TYPE | VARCHAR2 | 30 | Type of a fair market value exception. Value is either Manual or System. Values are from the lookup VRM_VSOE_PRICE_EXLINE_TYPE. | ||
| EXCEPTION_REASON | VARCHAR2 | 60 | A reason that a revenue analyst or manager needs to provide in order to mark a VSOE price for an item as invalid. Values are from the lookup VRM_VSOE_PRICE_EXLINE_REASON. | ||
| EXCEPTION_COMMENT | VARCHAR2 | 1000 | User entered comments. | ||
| MINIMUM_LINE_COUNT | NUMBER | 18 | Minimum number of standalone sales required in order to calculate a valid VSOE price. | ||
| TOLERANCE_RANGE_COVERAGE | NUMBER | The required minimum percentage of standalone sales that its unit selling price falls within tolerance range price of an item. | |||
| 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. | |
| 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. | ||
| USED_IN_COMPLIANCE | VARCHAR2 | 1 | Indicates whether the FMV line has been used in compliance process. Possible values are Yes or No. | ||
| MANUALLY_ENTERED_FLAG | VARCHAR2 | 1 | Indicates whether the FMV value is the manually added by the user. Possible values are Yes or No. | ||
| COMMENTS | VARCHAR2 | 240 | The comments entered by the user for the FMV line if FMV is rejected. | ||
| PRICE_EFF_PERIOD_ID | NUMBER | 18 | VSOE price effectivity period unique identifier. | ||
| LINE_SOURCE | VARCHAR2 | 30 | Indicates the source of the sets if Manual or System generated, where Manual indicates that the price is manually entered. | ||
| FMV_TYPE | VARCHAR2 | 30 | Fair Market Value price type of the item. Possible values are VSOE, TPE, or ESP. | ||
| 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. | |||
| VSOE_VALUE_STATUS | VARCHAR2 | 30 | Status of VSOE value. Values are from the lookup VRM_VSOE_PRICE_LINE_STATUS. | ||
| REVIEW_STATUS | VARCHAR2 | 30 | Status of VSOE value review. Values are from the lookup VRM_VSOE_VALUE_REVIEW_STATUS. | ||
| EXCHANGE_RATE | NUMBER | Conversion rate of the VSOE value. | |||
| EXCHANGE_DATE | DATE | Conversion rate date of the VSOE value. | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Conversion rate type of the VSOE value. | ||
| COVERAGE_START_DATE | DATE | Start date of the coverage period used to compute VSOE value. | |||
| COVERAGE_END_DATE | DATE | End date of the coverage period used to compute VSOE value. | |||
| VALUE_REASON | VARCHAR2 | 60 | Used to identify value status reason of the VSOE value. Values are from the lookup VRM_VSOE_VALUE_REASON. | ||
| REVIEW_REASON | VARCHAR2 | 60 | Used to identify value review status reason of the VSOE value. Values are from the lookup VRM_VSOE_VALUE_REVIEW_REASON. | ||
| ELEMENT_TYPE | VARCHAR2 | 30 | Element is a deliverable or separate unit of accounting. Used to group element types for FMV sets. Values are from the lookup VRM_ELEMENT_TYPE. | ||
| ESTABLISHED_BY | VARCHAR2 | 64 | User who established the fair market value. | ||
| ESTABLISHED_DATE | TIMESTAMP | Date the fair market value is established. | |||
| PERF_OBLIGATION_TEMPLATE_ID | NUMBER | 18 | The identifier of the performance obligation template that is used to group the source document lines under a single performance obligation. | ||
| 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_MID | NUMBER | The mid 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. | |||
| PUBLISHED_SALES_POINT | NUMBER | The price determined and published by the business as published sales point of an item or service. | |||
| 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_LINES | vrm_fmv_line_sets | FMV_LINE_SET_ID |
| vrm_perf_obligations | vrm_fmv_lines | FMV_LINE_ID |
| vrm_perf_obligation_lines | vrm_fmv_lines | FMV_LINE_ID |
| vrm_fmv_data_set_usages | vrm_fmv_lines | FMV_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_FMV_LINES_N1 | Non Unique | FUSION_TS_TX_DATA | PRICING_COMBINATION_ID, ITEM_TYPE_ID, ITEM_TYPE, UOM_CODE, FMV_LINE_SET_ID |
| VRM_FMV_LINES_N2 | Non Unique | FUSION_TS_TX_DATA | REQUEST_ID |
| VRM_FMV_LINES_U1 | Unique | Default | FMV_LINE_ID |
| VRM_FMV_LINES_U2 | Unique | Default | PRICING_COMBINATION_ID, ITEM_TYPE_ID, ITEM_TYPE, UOM_CODE, FMV_TYPE, PRICE_EFF_PERIOD_ID, CURRENCY_CODE, PERF_OBLIGATION_TEMPLATE_ID |