CST_XFER_UOM_CONVERSIONS_GT
The table is used by the quantity preprocessor to find the transfer_uom_conversion_factor, which is the conversion factor between the primary unit of measure 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 | Transaction identifier which uniquely identifies a transaction in costing. | |
| 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 | Value that identifies the inventory item associated with the transaction. | |
| RCV_UOM_CODE | VARCHAR2 | 3 | Receiving transaction primary unit of measure. | ||
| ISS_UOM_CODE | VARCHAR2 | 3 | Issue transaction primary unit of measure. | ||
| TRANSFER_UOM_CONVERSION_FACTOR | NUMBER | The conversion factor from the primary unit of measure of the issue transaction to the primary unit of measure of the receiving transaction. | |||
| STATUS | VARCHAR2 | 10 | Specify if the conversion between the primary unit of measure of the issue and receiving transactions was successfull or not. | ||
| LOT_NUMBER | VARCHAR2 | 80 | Lot number information of the inventory item. | ||
| INVENTORY_ORG_ID | NUMBER | 18 | Indicates the inventory organization to which the item belongs. | ||
| TRANSACTION_DATE | TIMESTAMP | The date when this transaction happened. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_XFER_UOM_CONVERSIONS_GT_U1 | Unique | TRANSACTION_ID |