CST_INV_TXNS_ICP1_GT
The first intermediate table used while creation of cost transaction which holds the transaction with item cost profile information.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Yes | Costing inventory transaction identifier. | |
| COST_ORG_ID | NUMBER | 18 | Yes | Identifies the Cost Organization associated with the inventory organization. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Identifies the Cost Book assigned to the Cost Organization. | |
| ITEM_COST_PROFILE_ID | NUMBER | 18 | Item Cost Profile Identifier for the transaction. | ||
| COST_PROFILE_ID | NUMBER | 18 | Identifies Cost Profile associated with the transaction. | ||
| STATUS | VARCHAR2 | 30 | The status of whether cost profile was identified for the transaction. | ||
| ERROR_CODE | VARCHAR2 | 30 | Error code associated with the transaction. | ||
| LOGICAL_FLAG | VARCHAR2 | 1 | Whether a transaction is logical (not physical) or not. | ||
| UOM_CODE | VARCHAR2 | 3 | Costing unit of measure as specified on the item cost profile. | ||
| CHECK_QTY_SIGN_FLAG | VARCHAR2 | 1 | Whether or not to check the sign of the quantity to determine whether it is a ISSUE or a RECEIPT transaction. | ||
| COST_TRANSACTION_TYPE | VARCHAR2 | 10 | Costing transaction type which is either RECIPT or ISSUE. | ||
| TRANSACTION_FLOW_TYPE | NUMBER | 18 | Transaction Flow Identifier, 1 - Internal Drop Shipment, 2 - Global Procurement, 3 - Customer Drop Shipment, 4 - Intransit Interorg Transfer, 5 - Direct Interorg Transfer, 6 - Intraorg Transfer, 7 - Transfer Order Intransit Interorg Transfer, 8 - Transfer Order Direct Interorg Transfer, 9 - Transfer Order Intraorg Transfer, 10 - TIR/TIRR at ownership change in procuring org for consigned PO, 11 - TIRR of TO Return with Scrap or null for others. | ||
| ADDITIONAL_PROCESSING_CODE | VARCHAR2 | 240 | Specifies the transactions that are further classified with the cost transaction type. It can either be null or TRANSFER. | ||
| USE_ITEM_COST_FLAG | VARCHAR2 | 1 | Specifies whether to use the current item cost or the incoming cost. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_INV_TXNS_ICP1_GT_N1 | Non Unique | CST_INV_TRANSACTION_ID, COST_ORG_ID, COST_BOOK_ID |
| CST_INV_TXNS_ICP1_GT_N2 | Non Unique | STATUS, ERROR_CODE |