CST_XFER_DESTINATION_TXNS_GT
This table is used by Quantity Preprocessor to store the destination transactions which do not yet have transfer_uom_conversion_factor defined
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 18 | Cost transaction identifier | |
| 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. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory Item Identifier | |
| TRANSFER_CST_INV_TXN_DTL_ID | NUMBER | 18 | Identifies the linked transfer transaction | |
| TRANSFER_CST_INV_TXN_ID | NUMBER | 18 | Identifies the lot/serial detail of the inventory transaction | |
| 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 |