VRM_FMV_DATA_SET

Details

Schema: FUSION
Object owner: VRM
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
VRM_FMV_DATA_SET_USAGES_PK	FMV_DATA_SET_USAGE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
FMV_DATA_SET_USAGE_ID	NUMBER		18	Yes	Internal identifier of a data set usage. It will be used to derive the price basis data sets used in price calculation.
FMV_LINE_SET_ID	NUMBER		18		Fair marker value set unique identifier.
PRICE_BASIS_DATA_SET_ID	NUMBER		18		Oracle internal use only.
DATA_SET_TYPE	VARCHAR2	30			Identifier of data set type used to derive the FMV value . Valid values are VSOE and ESP.
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.
FMV_LINE_ID	NUMBER		18		Fair Market Value line unique identifier.
DOCUMENT_LINE_ID	NUMBER		18		Document line unique identifier.
NET_LINE_AMOUNT	NUMBER				Net line amount used to calculate the VSOE value.
NET_UNIT_SALES_PRICE	NUMBER				Net unit sales price used to calculate the VSOE value.
NET_UNIT_SALES_PCT_BASE_PRICE	NUMBER				Net unit sales price used to calculate the VSOE value.
NET_DISCOUNT_PERCENT	NUMBER				Net discount percent used to calculate the VSOE value.
REVISED_COST	NUMBER				Revised cost used to calculate the VSOE value.
REVISED_GROSS_MARGIN_PERCENT	NUMBER				Revised gross margin percent used to calculate the VSOE value.
EXCLUSION_STATUS	VARCHAR2	30			Exclusion status to indicate line used to calculate VSOE value calculation. Possible values are Yes or No.
NET_DISCOUNT_AMOUNT	NUMBER				Net discount amount used to calculate the VSOE value.
REVISED_UOM	VARCHAR2	30			Unit of Measure used to calculate the VSOE value.
NET_QUANTITY	NUMBER				Net quantity used to calculate the VSOE value.
BASE_PRICE	NUMBER				Base price used to calculate the VSOE value.
EXCLUSION_REASON_CODE	VARCHAR2	30			Exclusion reason to exclude a line from VSOE value calculation. Values are from the lookup VSOE_PBL_EXCLUDING_REASON.
COMMENTS	VARCHAR2	1000			Comments entered to exclude a line.
EXCLUDED_BY	VARCHAR2	64			User who excluded the standalone sale.
PERF_OBLIGATION_ID	NUMBER		18		Performance obligation unique identifier.
PERF_OBLIGATION_LINE_ID	NUMBER		18		Performance obligation line unique identifier.
CUSTOMER_CONTRACT_NUMBER	NUMBER		18		Customer contract number.

Foreign Keys

Table	Foreign Table	Foreign Key Column
VRM_FMV_DATA_SET_USAGES	vrm_fmv_line_sets	FMV_LINE_SET_ID
VRM_FMV_DATA_SET_USAGES	vrm_price_basis_data_sets	PRICE_BASIS_DATA_SET_ID
VRM_FMV_DATA_SET_USAGES	vrm_fmv_lines	FMV_LINE_ID
VRM_FMV_DATA_SET_USAGES	vrm_pricing_lines	DOCUMENT_LINE_ID
vrm_fmv_set_usage_ref_lines	vrm_fmv_data_set_usages	FMV_DATA_SET_USAGE_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
VRM_FMV_DATA_SET_USAGES_N1	Non Unique	Default	FMV_LINE_SET_ID
VRM_FMV_DATA_SET_USAGES_N2	Non Unique	Default	FMV_LINE_ID
VRM_FMV_DATA_SET_USAGES_N3	Non Unique	Default	REQUEST_ID
VRM_FMV_DATA_SET_USAGES_U1	Unique	Default	FMV_DATA_SET_USAGE_ID
VRM_FMV_DATA_SET_USAGES_U2	Unique	FUSION_TS_TX_DATA	FMV_LINE_ID, DOCUMENT_LINE_ID	Obsolete