CST_ACQ_COST_PO_DIST_GT

Global temporary table used in the cost preprocessor. It holds the acquisition costs for PO distributions that have match to PO invoices

Details

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.
ACQUISITION_COST	NUMBER				Indicates the unit acquisition cost.
PO_PRICE	NUMBER				Indicates the unit purchase price for accrual and tax components.
ACQUISITION_COST_IN_PO_UOM	NUMBER				Purchase Order tax exclusive price or non-recoverable tax.
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		Identifies 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.

Index	Uniqueness	Columns
CST_ACQ_COST_PO_DIST_GT_N1	Non Unique	CMR_PO_DISTRIBUTION_ID