CST_XFER_UOM_CONVERSIONS_GT

The table is used by Quantity PreProcessor to find the transfer_uom_conersion_factor which the conversion factor between the primary uoms of the issue transaction and the receiving transaction.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TRANSACTION_ID	NUMBER		18	Yes	Cost transaction identifier
CST_INV_TRANSACTION_ID	NUMBER		18	Yes	Costing inventory transaction identifier
CST_INV_TRANSACTION_DTL_ID	NUMBER		18		Costing inventory transaction lot/serial detail identifier
INVENTORY_ITEM_ID	NUMBER		18	Yes	Inventory item identifier
RCV_UOM_CODE	VARCHAR2	3			Receiving transaction primary uom code
ISS_UOM_CODE	VARCHAR2	3			Issue transaction primary uom code
TRANSFER_UOM_CONVERSION_FACTOR	NUMBER				The conversion factor from primary uom of issue transaction to the primary uom of receiving transaction.
STATUS	VARCHAR2	10			Specify if the conversion between primary uom of issue and receiving transactions was successfull or not.

Indexes

Index	Uniqueness	Columns
CST_XFER_UOM_CONVERSIONS_GT_U1	Unique	TRANSACTION_ID