VRM_PERF_OBLIG_REF_LINES

Details

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

Primary Key

Name	Columns
VRM_PO_REF_LINES_GT_PK	DOCUMENT_LINE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PERF_OBLIGATION_LINE_ID	NUMBER		18	Yes	Performance obligation line.
DOCUMENT_LINE_ID	NUMBER		18	Yes	Source document line.
PREV_DOCUMENT_LINE_ID	NUMBER		18	Yes	Reference document line. E.g. For return lines, the original line identifier is referred. For version lines, the first version line is referred.
CHILD_LINE_SEQ_NUMBER	NUMBER		18		Order in which return or version lines should be processed for a given document line in the current batch.
SATISFACTION_MEASUREMENT_MODEL	VARCHAR2	30			Specifies how satisfaction will be measured and recorded for a performance obligation line. Values are from lookup type ORA_VRM_SATIS_MEAS_MODEL.
QUANTITY	NUMBER				Quantity of the return or version line.
UNIT_SELLING_PRICE	NUMBER				Selling price per unit of measure of the inventory item or memo line.
LINE_AMOUNT	NUMBER				Line amount of the return or version line.
REVENUE_RULE_ID	NUMBER		18		Revenue scheduling rule.
REVENUE_RULE_TYPE	VARCHAR2	30			Type of revenue scheduling rule.
REVENUE_START_DATE	DATE				Date from which the revenue must be recognized.
REVENUE_RULE_DURATION	NUMBER		18		Number of periods in which the revenue of this performance obligation line is to be recognized.
REVENUE_END_DATE	DATE				Date until which revenue must be recognized.
REVENUE_REVERSAL_METHOD	VARCHAR2	30			Revenue reversal method used to reverse the revenue.
DELIVERY_DATE	DATE				Fulfillment date of a source document line.
VERSION_FLAG	VARCHAR2	1			Indicates whether the current source product line is a version line. Possible values are Y and N.
VERSION_NUMBER	NUMBER		18		The version of the source product line.
MAX_SATISFACTION_EVENT_NUM	NUMBER		18		Highest satisfaction measurement number under the performance obligation line.
POL_FIRST_DISCARDED_SE_DATE	DATE				Date from which satisfaction events of a performance obligation line are to be discarded.
SATISFACTION_BASE_PROPORTION	NUMBER				Base number for the satisfaction schedule proportions. The default value is 100. The base number is updated when the schedule rows are updated. It is the sum of the numerator of the ratio of all schedules.
PROCESSING_TYPE	VARCHAR2	30			Oracle internal use only. Used to identify how the processing of return or version lines should be done for creating satisfaction events.
LINE_STATUS	VARCHAR2	30			Return or version source document line status while processing for satisfaction events creation. Used during internal processing.
COST_AMOUNT	NUMBER				Cost of the inventory item or memo line in the transaction currency. This column is used to calculate the gross margin percentage.
BASE_PRICE	NUMBER				Base price of the inventory item or memo line.
UNIT_LIST_PRICE	NUMBER				Unit list price of the inventory item or memo line.
GROSS_MARGIN_PERCENT	NUMBER				Gross margin percentage of the inventory item or memo line.
SERVICE_DURATION	NUMBER				Duration of service item in terms of the service unit of measure.
UOM_CODE	VARCHAR2	200			Unit of measure of the inventory item or memo line.
ALLOCATION_METHOD_CODE	VARCHAR2	30			The allocation currency basis used to allocate and recognize revenue for a contract. Valid values are from the lookup type ORA_VRM_ALLOCATION_METHOD.

Indexes

Index	Uniqueness	Columns
VRM_PO_REF_LINES_GT_N1	Non Unique	LINE_STATUS, VERSION_NUMBER
VRM_PO_REF_LINES_GT_N2	Non Unique	CHILD_LINE_SEQ_NUMBER
VRM_PO_REF_LINES_GT_U1	Unique	DOCUMENT_LINE_ID