CST_TRANSACTIONS_MAP_GT
This temporary table stores the data to create mappings between source and destination transactions for transfers.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 18 | Yes | Transaction identifier to find a transaction in costing. | |
| INVENTORY_ORG_ID | NUMBER | 18 | Indicates the inventory organization to which the item belongs. | ||
| TRANSFER_UOM_CONVERSION_FACTOR | NUMBER | Conversion factor between the issue transaction primary unit of measure and receipt transaction primary unit of measure. | |||
| UOM_CODE | VARCHAR2 | 3 | Costing unit of measure code for the costing quantity. | ||
| BASE_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Yes | Inventory transaction source type identifier. | |
| BASE_TXN_ACTION_ID | NUMBER | 18 | Yes | Inventory transaction action identifier. | |
| UOM_CONVERSION_FACTOR | NUMBER | Unit of measure conversion factor from primary to costing unit of measure. | |||
| INTRANSIT_FLAG | VARCHAR2 | 5 | Yes | Indicates the transaction is an issue or receipt into in transit. | |
| TRANSACTION_FLOW_TYPE | NUMBER | 18 | This is to identify the transaction flow type of the transaction. | ||
| TRANSFER_CST_INV_TXN_ID | NUMBER | 18 | Indicates the source costing inventory transaction identifier. | ||
| COST_ORG_ID | NUMBER | 18 | Yes | Cost organization identifier associated with the inventory organization. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Cost book Identifier assigned to the cost organization. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Inventory item associated with the transaction. | |
| TRANSFER_TRANSACTION_GROUP_ID | NUMBER | 18 | Indicates the source transaction group identifier. | ||
| SERIAL_NUMBER | VARCHAR2 | 80 | Serial number associated with the transaction. | ||
| GRADE_CODE | VARCHAR2 | 150 | Grade code associated with the transaction. | ||
| LOT_NUMBER | VARCHAR2 | 80 | Lot number associated with the transaction. | ||
| CST_INV_TRANSACTION_DTL_ID | NUMBER | 18 | Costing inventory transaction detail identifier. | ||
| SRC_DEST_IND | VARCHAR2 | 1 | Indicator to determine the transaction is source or destination. Valid values are S/D. | ||
| COST_STATUS | VARCHAR2 | 1 | This is to display the current costing status of the transaction. | ||
| POSTED_FLAG | VARCHAR2 | 5 | This indicates the transaction has been posted to quantity layers for further costing. | ||
| PROPAGATE_COST_ADJ_FLAG | VARCHAR2 | 1 | Indicates the cost adjustments needs to be propagated. | ||
| COST_METHOD_CODE | VARCHAR2 | 30 | The cost method code used for costing the transaction. | ||
| CST_INV_TRANSACTION_ID | NUMBER | 18 | The costing inventory transaction identifier. | ||
| TRANSACTION_GROUP_ID | NUMBER | 18 | This is the transaction group identifier used to group all the related transfer transactions. | ||
| COST_DATE | TIMESTAMP | This indicates the transaction costed date. | |||
| QUANTITY | NUMBER | Transaction quantity in costing unit of measure. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_TRANSACTIONS_MAP_GT_N1 | Non Unique | SRC_DEST_IND, CST_INV_TRANSACTION_DTL_ID |
| CST_TRANSACTIONS_MAP_GT_N2 | Non Unique | TRANSACTION_GROUP_ID, COST_ORG_ID, COST_BOOK_ID |
| CST_TRANSACTIONS_MAP_GT_N3 | Non Unique | TRANSFER_TRANSACTION_GROUP_ID |