CST_QTY_RCPT_PO_DIST_GT

Global temporary table used in the cost preprocessor. It holds the quantity information (net delivered quantity, invoiced quantity) for PO distribution receipt combinations that have match to receipt invoices.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CMR_PO_DISTRIBUTION_ID	NUMBER		18	Yes	Single column FK: Identifies the PO distribution whose acquisition cost is being computed.
CMR_RCV_TRANSACTION_ID	NUMBER		18		Identifies the root receipt transaction whose acquisition cost is being computed
NET_DELIVERED_QTY	NUMBER				The net delivered quantity (including all the quantity adjustments and returns) against this PO distribution. The quantity is in the primary UOM of the item.
TOTAL_INVOICED_QTY	NUMBER				The total invoiced quantity against this PO distribution and receipt combination. The quantity is in the primary UOM of the item.
PRIMARY_UOM_CODE	VARCHAR2	3			Primary unit of measure of the item.
ROOT_RCPT_CURR_CONV_RATE	NUMBER				Currency conversion rate specified on the root receive transaction associated with this delivery. This rate is used for currency conversion for deliveries against POs whose invoices are matched to receipts.
PO_NET_DEL_QTY	NUMBER				The net delivered quantity (including all the quantity adjustments and returns) against this PO distribution and receipt. The quantity is in the Purchase Order unit of measure.
NET_INVOICED_QTY	NUMBER				The total invoiced quantity against this PO distribution and receipt combination in the Purchase Order UOM.
SECONDARY_NET_DEL_QTY	NUMBER				The net delivered quantity (including all the quantity adjustments and returns) against this PO distribution and receipt. The quantity is in the item secondary unit of measure.
PO_UOM_CODE	VARCHAR2	3			Purchase order pricing unit of measure.
SECONDARY_UOM_CODE	VARCHAR2	3			Secondary unit of measure of the item.