CST_QTY_CONS_ADVICE_LINE_GT

Temporary table used to gather the ownership change quantity and the invoiced quantity at the consumption advice line level.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: TEMP3

Primary Key

Name	Columns
CST_QTY_CONS_ADVICE_LINE_GT_PK	EXTERNAL_SYSTEM_REFERENCE, CONSUMPTION_ADVICE_LINE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
EXTERNAL_SYSTEM_REFERENCE	VARCHAR2	60		Yes	Identifies the external source system. Necessary in joins to consumption advice line.
CONSUMPTION_ADVICE_LINE_ID	NUMBER		18	Yes	Identifies the consumption advice line.
NET_OWNERSHIP_CHANGE_QTY	NUMBER				The net ownership change quantity (including all the ownership change returns) against this consumption advice line. The quantity is in the primary UOM of the item.
TOTAL_INVOICED_QTY	NUMBER				The total invoiced quantity against this consumption advice line. The quantity is in the primary UOM of the item.
TFR_TO_REG_CURRENCY_CONV_RATE	NUMBER				Currency conversion rate specified on the transfer to regular transaction associated with this trade event.
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.
PRICE_CHANGE_EFFECTIVE_DATE	TIMESTAMP				The effective date of the latest price change that is relevant for this consumption advice line. This will be null if there are no price updates.
CMR_ROOT_RCV_TXN_ID	NUMBER		18		Single column FK: Identifies the root receive transaction that is associated with this consumption advice line. This is used to derive tax for the uninvoiced portion.
CMR_PO_DISTRIBUTION_ID	NUMBER		18		Single column FK: Identifies the PO distribution associated with this consumption advice line. This is used to derive tax for the uninvoiced portion.

Indexes

Index	Uniqueness	Columns
CST_QTY_CONS_ADVICE_LINE_GT_PK	Unique	EXTERNAL_SYSTEM_REFERENCE, CONSUMPTION_ADVICE_LINE_ID