CST_CONS_ADVICE_MAPPING_GT

Temporary table to snapshot the mapping data between consumption advice lines and ownership change txns to be processed by the acquisition cost processor.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: TEMP3

Columns

Name	Datatype	Length	Precision	Comments
EXTERNAL_SYSTEM_REFERENCE	VARCHAR2	60		Identifies the external source system. Necessary in joins to consumption advice line.
CONSUMPTION_ADVICE_LINE_ID	NUMBER		18	Identifies the consumption advice line.
OWNERSHIP_CHANGE_CIT_ID	NUMBER		18	Costing internal identifier of the transaction that changed ownership between Supplier and the owner organization.
OWNERSHIP_CHANGE_TIR_CIT_ID	NUMBER		18	Costing internal identifier of the trade event transaction that corresponds to the ownership change transaction.
OWNED_CONS_ADVICE_LINE_ID	NUMBER		18	This is populated only for consumption advice lines with a negative quantity. It points to the consumption advice line that is being returned.