CST_TXFR_DEL_ACQ_COSTS_GT

This global temporary table is used to hold the transfer delivery acquisition cost records during cost processing.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: DEFAULT

Columns

Name	Datatype	Length	Precision	Comments
TXFR_DEL_ACQ_COST_ID	NUMBER		18	Surrogate ID that identifies a record in this table.
CST_INV_TRANSACTION_ID	NUMBER		18	Foreign key reference to a transaction in cst_inv_transactions.
EFFECTIVE_DATE	TIMESTAMP			System timestamp when this acquisition cost is calculated. Used to maintain order and history of acquisition costs.
CMR_ROOT_RECEIVE_TXN_ID	NUMBER		18	Foreign key reference to the receive transaction in Receipt Accounting. This is the root parent transaction of the delivery.
INVENTORY_ORG_ID	NUMBER		18	Identifies the inventory organization where the delivery happened.
INVENTORY_ITEM_ID	NUMBER		18	Identifies the item that is delivered.
SOURCE_DOC_QTY	NUMBER			Indicates the delivery quantity in source document UOM. This value comes from the linked delivery transaction in Receipt Accounting.
CIT_PRIMARY_QTY	NUMBER			Indicates the delivery quantity in primary UOM as received on the inventory transaction.
CIT_SECONDARY_QTY	NUMBER			Indicates the delivery quantity in secondary UOM as received on the inventory transaction.
COST_COMPONENT_ID	NUMBER		18	Identifies the cost component of the acquisition cost.
UNIT_COST	NUMBER			Per unit acquisition cost in source document UOM and material requisition BU currency.
CURRENCY_CODE	VARCHAR2	15		Functional currency of the material requisition BU.
CURRENCY_CONVERSION_DATE	DATE			Indicates the date to be used when performing currency conversion.
CHARGE_UNIT_COST	NUMBER			Per unit acquisition cost in the source document UOM and charge BU currency.
CHARGE_CURRENCY_CODE	VARCHAR2	15		Functional currency of the charge BU.
PRIOR_COST_FLAG	VARCHAR2	1		Indicates if this record represents the new cost or prior cost. Valid values are N - new cost, Y- prior cost.