VRM_FMV_TEMPL_ASSIGNMENTS
VRM_FMV_TEMPL_ASSIGNMENTS contains assignments of VSOE templates to items.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
VRM_FMV_TEMPL_ASSIGNMENTS_PK |
TEMPLATE_ASSIGNMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TEMPLATE_ASSIGNMENT_ID | NUMBER | 18 | Yes | Unique identifier of a template assignment. | |
| TEMPLATE_ID | NUMBER | 18 | Yes | Internal identifier of the template. | |
| 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. | ||
| FROM_PERIOD_ID | NUMBER | 18 | Yes | Extraction period during which an item is assigned to a template. | |
| TO_PERIOD_ID | NUMBER | 18 | Effective ending period name for the item assigned to the FMV profile. | ||
| 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. | ||
| ELEMENT_TYPE | VARCHAR2 | 30 | The element type used to identify the nature of item. | ||
| DATA_SELECTION_TIME_SPAN | NUMBER | 18 | Number of coverage periods that a VSOE price calculation process will gather the standalone sales from. | ||
| MINIMUM_LINE_COUNT | NUMBER | 18 | Minimum number of standalone sales required in order to calculate a valid VSOE price. | ||
| TOLERANCE_PCT_RANGE_HIGH | NUMBER | The higher limit of the VSOE fair price tolerance range in percentage. | |||
| TOLERANCE_PCT_RANGE_LOW | NUMBER | The lower 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. | |||
| 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. | |||
| 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_TEMPL_ASSIGNMENTS | vrm_fmv_templates_b | TEMPLATE_ID |
| VRM_FMV_TEMPL_ASSIGNMENTS | vrm_item_groups_b | ITEM_TYPE_ID |
| VRM_FMV_TEMPL_ASSIGNMENTS | ar_memo_lines_all_b | FROM_PERIOD_ID |
| VRM_FMV_TEMPL_ASSIGNMENTS | vrm_price_eff_periods_b | TO_PERIOD_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| VRM_FMV_TEMPL_ASSIGNMENTS_N1 | Non Unique | Default | TEMPLATE_ID, ITEM_TYPE_ID | |
| VRM_FMV_TEMPL_ASSIGNMENTS_U1 | Unique | FUSION_TS_TX_DATA | TEMPLATE_ASSIGNMENT_ID | |
| VRM_FMV_TEMPL_ASSIGNMENTS_U2 | Unique | FUSION_TS_TX_DATA | TEMPLATE_ID, ITEM_TYPE, ITEM_TYPE_ID | Obsolete |