CST_CONSIGNED_INV_TXNS_GT

Temporary table used to snapshot the consigned transactions and ownership change trade events that need to be processed for acquisition cost calculation.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: TEMP3

Columns

Name	Datatype	Length	Precision	Comments
CST_INV_TRANSACTION_ID	NUMBER		18	Single column FK: Identifies the trade event transaction whose incoming cost needs to be computed.
CMR_PO_DISTRIBUTION_ID	NUMBER		18	Single column FK: Identifies the PO distribution associated with the transaction.
CMR_ROOT_RCV_TXN_ID	NUMBER		18	Single column FK: Identifies the root receipt transaction associated with the transaction.
OWNERSHIP_CHANGE_DATE	TIMESTAMP			Indicates the date of ownership change. Given the date effective pricing for consigned purchase orders, this date helps identify the applicable price.
CURRENCY_CONV_RATE	NUMBER			Currency conversion rate applicable to this transaction.
CURRENCY_CODE	VARCHAR2	15		Currency code of the acquisition cost computed for the transaction.
PRICE_CHANGE_EFFECTIVE_DATE	TIMESTAMP			The effective date of the latest price change that is relevant for this transaction.
PARENT_TIR_CIT_ID	NUMBER		18	Identifies the trade event associated with the 'Transfer to regular' transaction that is being returned. This is only populated for Trade Intransit Return events.
EXTERNAL_SYSTEM_REFERENCE	VARCHAR2	60		Identifies the external source system of the consumption advice line.
OWNED_CONS_ADVICE_LINE_ID	NUMBER		18	Identifies the consumption advice line whose acquisition cost is relevant for the transaction.
TRANSFER_TO_OWNED_TXN_ID	NUMBER		18	Inventory transfer to owned transaction identifier with positive quantity to indicate quantity is moved to inventory from consigned.