CST_ACQ_COST_RCPT_PO_DIST_GT

Global temporary table used in the cost preprocessor. It holds the acquisition costs 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 entity in Receipt accounting PO Distributions. This value will exist for match to PO as well as match to Receipt cases.
CMR_RCV_TRANSACTION_ID	NUMBER		18		Identifies the root receipt transaction whose acquisition cost is being computed.
ACQUISITION_COST	NUMBER				Indicates the unit acquisition cost.
ACQUISITION_AMOUNT	NUMBER				Indicates the acquisition amount in functional currency.
INVOICE_AMOUNT	NUMBER				Indicates the invoice amount in functional currency.
UNINVOICED_AMOUNT	NUMBER				Indicates the amount in functional currency that is not yet invoiced.
ENTERED_AMOUNT	NUMBER				Acquisition amount in purchase order currency.
INVOICE_ENTERED_AMOUNT	NUMBER				Invoice amount in purchase order currency.
COST_COMPONENT_CODE	VARCHAR2	30			Identifies the component of the acquisition cost. Values are based on the seeded cost components in the lookup type CST_COMPONENT_CODES. This column is not used currently.
COST_COMPONENT_ID	NUMBER		18		Indentifies the cost component of the acquisition cost.
SOURCE_DOC_CURR_CODE	VARCHAR2	15			Indicates the transaction source document currency code.
SOURCE_DOC_CURR_CONV_TYPE	VARCHAR2	30			Indicates the transaction source document currency conversion type.
SOURCE_DOC_CURR_CONV_DATE	TIMESTAMP				Indicates the transaction source document currency conversion date.
SOURCE_DOC_CURR_CONV_RATE	NUMBER				Indicates the transaction source document currency conversion rate.

Indexes

Index	Uniqueness	Columns
CST_ACQ_RCPT_PO_DIST_GT_N1	Non Unique	CMR_RCV_TRANSACTION_ID