CST_ORG_BOOK_INV_TXNS_GT
Inventory tansactions exploded for each Cost Org Book
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_ORG_BOOK_INV_TXNS_GT_PK |
TRANSACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 18 | Yes | Single column FK: Identifies the costing transaction. | ||
| COST_ORG_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Organization associated with the inventory organization. | ||
| COST_BOOK_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Book assigned to the Cost Organization. | ||
| VAL_STRUCTURE_ID | NUMBER | 18 | Single column FK: Identifies the Valuation Structure. | |||
| STRUCTURE_INSTANCE_NUMBER | NUMBER | 18 | Structure instance number | |||
| VAL_UNIT_ID | NUMBER | 18 | Valuation unit identifier | |||
| VAL_UNIT_COMBINATION_ID | NUMBER | 18 | Valuation Units Code Combination Identifier | |||
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Inventory Item Identifier | ||
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | Indicates The Inventory Org To Which The Item Belongs | ||
| SUBINVENTORY_CODE | VARCHAR2 | 10 | The subinventory code where the item is stored | |||
| LOCATOR_ID | NUMBER | 18 | Inventory locator identifier | |||
| LOT_NUMBER | VARCHAR2 | 80 | The lot number of the item | |||
| SERIAL_NUMBER | VARCHAR2 | 80 | The serial number of the item | |||
| GRADE_CODE | VARCHAR2 | 150 | Grade of the Lot for a grade controlled Item | |||
| COST_TRANSACTION_TYPE | VARCHAR2 | 10 | Yes | Costing transactin type, ISSUE, RECEIPT or LOGICAL | ||
| BASE_TXN_TYPE_ID | NUMBER | 18 | Yes | Inventory transaction type identifier. For origin as INV the value comes from INV_TRANSACTION_TYPES_TL table. | ||
| BASE_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Yes | Inventory transaction source type identifier. For origin as INV the value comes from INV_TXN_SOURCE_TYPES_TL table, and for CST it comes from Lookup_type CST_BASE_TXN_SOURCE_TYPES | ||
| BASE_TXN_ACTION_ID | NUMBER | 18 | Yes | Inventory transaction action identifier. For Origin as INV, the value comes from lookup INV_TRANSACTION_ACTIONS and for Origin as CST the value is from lookup_type CST_BASE_TXN_ACTIONS. | ||
| LOGICAL_FLAG | VARCHAR2 | 1 | Yes | Denotes whether the transaction is logical or not. This is derived from CST_TXN_SOURCE_ACTIONS. | ||
| INTRANSIT_FLAG | VARCHAR2 | 1 | Yes | Identifies whether a transaction is an issue into or receipt out of Intransit inventory. | ||
| ADDITIONAL_PROCESSING_CODE | VARCHAR2 | 240 | Code specifying what kind of processing needs to be done. The value is defined in CST_INTERNAL_TXN_TYPE for the transaction type and is used during Cost PreProcessor for additional processing. | |||
| TRANSACTION_DATE | TIMESTAMP | The date when this transaction happened. | ||||
| COST_DATE | TIMESTAMP | Cost date used by cost method processors | ||||
| ITEM_COST_PROFILE_ID | NUMBER | 18 | Single column FK: Identifies the Item Cost Profile. | |||
| COST_PROFILE_ID | NUMBER | 18 | Single column FK: Identifies Cost Profile associated with the transaction. | |||
| EXPENSE_TRANSACTION_FLAG | VARCHAR2 | 1 | Identifies whether a transaction is an asset or expense transaction | |||
| COST_METHOD_CODE | VARCHAR2 | 30 | The cost method code like PERPETUAL AVERAGE, FIFO etc. Value comes from lookup_type CST_COST_METHODS | |||
| NEGATIVE_QTY_CODE | VARCHAR2 | 30 | The negative quantity code | |||
| QUANTITY_FLOW_CODE | VARCHAR2 | 30 | Quantity flow code, FIFO or LIFO | |||
| HDR_PRIMARY_QTY | NUMBER | The primary transaction quantity of the inventory transaction header | Active | |||
| DTL_PRIMARY_QTY | NUMBER | The primary transaction quantity of the inventory transaction detail | Active | |||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Yes | The unit of measure code in which primary transaction quantity is specified | ||
| HDR_SECONDARY_TXN_QTY | NUMBER | The secondary transaction quantity of the inventory transaction header | Active | |||
| DTL_SECONDARY_TXN_QTY | NUMBER | The secondary transaction quantity of the inventory transaction detail | Active | |||
| SECONDARY_TRANSACTION_UOM_CODE | VARCHAR2 | 3 | The unit of measure code in which secondary transaction quantity is specified | |||
| COST_BY_UOM_TYPE | VARCHAR2 | 30 | Cost by this unit of measure type | |||
| QUANTITY | NUMBER | Transaction Quantity in costing unit of measure | ||||
| UOM_CODE | VARCHAR2 | 3 | Costing unit of measure code | |||
| UOM_CONVERSION_FACTOR | NUMBER | UOM Conversion factor from primary UOM to costing UOM | ||||
| PREPROCESSING_STATUS | VARCHAR2 | 30 | Cost PreProcessing status | |||
| ERROR_CODE | VARCHAR2 | 30 | Error code | |||
| POSTED_FLAG | VARCHAR2 | 5 | Whether or not the transaction has been posted to quantity layers. Updated by Cost Method processors. | |||
| ACCOUNTED_FLAG | VARCHAR2 | 1 | Whether or not the transaction has been accounted for. Updated by the distributions processor. | |||
| RUN_MODE | VARCHAR2 | 5 | Yes | The mode in which this transaction is created, t specify whether it can be reprocessed. It is FINAL in v1. | ||
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Yes | The inventory transaction identifier references costing's inventory transaction table | ||
| CST_INV_TRANSACTION_DTL_ID | NUMBER | 18 | The inventory transaction detail identifier references costing's inventory transaction details table | |||
| TRANSFER_COST_ORG_ID | NUMBER | 18 | Cost Organization identifier associated with Inventory organization of the other leg of transfer transaction | |||
| TRANSFER_VAL_UNIT_ID | NUMBER | 18 | Valuation unit associated with the other leg of transfer transaction | |||
| TRANSFER_BOOK_ID | NUMBER | 18 | Cost Book to be used for processing transfer transaction | |||
| OWNING_COST_ORG_ID | NUMBER | 18 | The cost organization that owns the transaction. It is different from cost rg for consignment transactions. | |||
| TRANSFER_CST_INV_TXN_ID | NUMBER | 18 | Source inventory transaction identifying the other leg of transfer transaction | |||
| FOB_POINT | NUMBER | 1 | Indicates the 'Free on board' point and determines the point of transfer of liability/ownership. It is 1 for 'SHIPMENT' and 2 for 'RECEIPT | |||
| RCV_TRANSACTION_ID | NUMBER | 18 | Receiving transaction identifier | |||
| PO_DISTRIBUTION_ID | NUMBER | 18 | Purchasing distribution identifier | |||
| WSH_DELIVERY_DETAIL_ID | NUMBER | 18 | Shipping delivery detail identifier | |||
| DOO_FULLFILL_LINE_ID | NUMBER | 18 | Distributed Order Orchestration (Sales Order) fulfillment line identifier | |||
| CODE_COMBINATION_ID | NUMBER | 18 | Code Combination identifier for the referenced account | |||
| TXN_SOURCE_DOC_TYPE | VARCHAR2 | 50 | Transactions Source Document Type | |||
| TXN_SOURCE_DOC_NUMBER | VARCHAR2 | 240 | Transactions Source Document Number | |||
| TXN_SOURCE_REF_DOC_TYPE | VARCHAR2 | 50 | Transactions Source Documents Reference Document Type | |||
| TXN_SOURCE_REF_DOC_NUMBER | VARCHAR2 | 240 | Transactions Source Documents Reference Document Number | |||
| PRICING_OPTION | NUMBER | 18 | Pricing Option identifier. It signifies whether the option is to use the PO price (1), transfer prce (2) or the cost+markup (3) as the transfer cost. | |||
| BUSINESS_UNIT_ID | NUMBER | 18 | Yes | Business Unit Id of the Inventory Organization | ||
| 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. | |||
| TRANSFER_PERCENTAGE | NUMBER | Percentage of value to attribute to transfer costs in an Inter-Orgtransfer | ||||
| INTERNAL_PROFIT_TRACKING | VARCHAR2 | 1 | This column is used by Costing and the values it can hold are 'Y' and 'N'. It indicates whether or not to track profit in inventory. | |||
| USE_ITEM_COST_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate whether to use the current item cost or use txn cost from CST_TRANSACTION_COSTS | ||
| VAL_UNIT_DETAIL_ID | NUMBER | 18 | Single column FK: Identifies the valuation unit detail line. | |||
| TRANSACTION_QTY | NUMBER | Yes | The transaction quantity of the inventory transaction | |||
| TRANSACTION_UOM_CODE | VARCHAR2 | 3 | Yes | The unit of measure code in which transaction quantity is specified | ||
| PRIMARY_QTY | NUMBER | Yes | The primary transaction quantity of the inventory transaction header | |||
| SECONDARY_TRANSACTION_QTY | NUMBER | The secondary transaction quantity of the inventory transaction | ||||
| PROPAGATE_COST_ADJ_FLAG | VARCHAR2 | 1 | Y or N | |||
| RECEIPT_WITHOUT_COST_CODE | VARCHAR2 | 30 | Values can be either FIRST, LAST or CURRENT | |||
| REFERENCED_RMA_COST_CODE | VARCHAR2 | 30 | SO_COST |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_ORG_BOOK_INV_TXNS_GT_N1 | Non Unique | COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID |
| CST_ORG_BOOK_INV_TXNS_GT_U1 | Unique | TRANSACTION_ID |
| CST_ORG_BOOK_INV_TXNS_GT_U2 | Unique | COST_ORG_ID, COST_BOOK_ID, CST_INV_TRANSACTION_ID, NVL("CST_INV_TRANSACTION_DTL_ID", 0) |