CST_XFER_SOURCE_TXNS_GT
This table is used by the Quantity Preprocessor and stores the source transactions which are used along with the corresponding destination transaction to derive the transfer_uom_conversion_factor.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| QUANTITY | NUMBER | Transaction Quantity in Secondary unit of measure | ||
| UOM_CODE | VARCHAR2 | 3 | The unit of measure code in which transaction quantity is specified | |
| TRANSACTION_QTY | NUMBER | Transaction Quantity | ||
| TRANSACTION_UOM_CODE | VARCHAR2 | 3 | The unit of measure code in which transaction quantity is specified | |
| PRIMARY_QTY | NUMBER | Transaction Quantity in Primary unit of measure | ||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | The unit of measure code in which primary transaction quantity is specified | |
| SECONDARY_TRANSACTION_QTY | NUMBER | Transaction Quantity in Secondary unit of measure | ||
| SECONDARY_TRANSACTION_UOM_CODE | VARCHAR2 | 3 | The unit of measure code in which secondary transaction quantity is specified | |
| CST_INV_TRANSACTION_ID | NUMBER | 18 | This is a database sequence generated number by Cost Preprocessor to identify the inventory transaction within costing system. | |
| CST_INV_TRANSACTION_DTL_ID | NUMBER | 18 | This is a database sequence generated number by Cost Preprocessor to identify the lot/serial detail of inventory transaction within costing system. | |
| MIN_CITD_ID | NUMBER | 18 | If the source has multiple lot/serial details, this column holds the minimum id to uniquely identify one source transaction in case the destination transaction does ot have any detail transactions |