VRM_PO_IMMATERIAL_DETAILS_GT

Oracle internal use only. This global temporary table is used in identify customer contracts job during internal processing of immaterial change.

Details

• Schema: FUSION

• Object owner: VRM

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PO_IMMATERIAL_DETAIL_ID	NUMBER		18	Yes	Performance obligation level immaterial details unique identifier.
PERF_OBLIGATION_ID	NUMBER		18		Performance obligation unique identifier.
FMV_LINE_ID	NUMBER		18		Standalone selling price line unique identifier.
CONTR_CUR_FMV_AMT	NUMBER				Standalone selling price amount in the contract currency.
CONTR_CUR_TOTAL_ALLOCATED_AMT	NUMBER				Allocated transaction price in the contract currency.
LATEST_REC_FLAG	VARCHAR2	1			Latest immaterial change type that occurred on the performance obligation.
CONTRACT_MODIFICATION_DATE	DATE				Date on which the revenue contract was modified.
IMMATERIAL_CHANGE_CODE	VARCHAR2	30			Immaterial change type for this line. Valid values are from the lookup type ORA_IMMATERIAL_CHANGE_TYPE.
REMOVED_FLAG	VARCHAR2	1			Indicates whether the current line is considered when computing the total allocated amount on the performance obligation after processing an immaterial change.
CUSTOMER_CONTRACT_HEADER_ID	NUMBER		18		Customer contract header unique identifier.
CONTR_CUR_MOD_DATE_REV_AMT	NUMBER				Recognized revenue in the contract currency as of the contract revision date.
ENTERED_CUR_FMV_AMT	NUMBER				Standalone selling price amount in the entered currency.
ENTERED_CUR_TOTAL_ALLOC_AMT	NUMBER				Allocated transaction price in the entered currency.
ENTERED_CUR_MOD_DATE_REV_AMT	NUMBER				Recognized revenue in the entered currency as of the contract revision date.
EXCHANGE_RATE	NUMBER				Conversion rate used for converting the amount from the entered currency to the ledger currency.
ENTER_CURR_LIST_PRICE_AMOUNT	NUMBER				List price amount of the performance obligation.