CST_INV_TXNS_FOR_INTRANSIT_GT
The table is used to identify the parent transactions that will create intransit transactions. This table is used by the PreProcessor.
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 | The source inventory transaction identifier references the source inventory transaction table | |
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Identifies the external source system. | |
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | Stores a value that uniquely identifies a certain instance of an object within the external system | |
| COST_ORG_ID | NUMBER | 18 | Yes | Cost Organization identifier associated with the inventory organization | |
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | Indicates The Inventory Org To Which The Item Belongs | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Inventory Item Identifier | |
| COST_TRANSACTION_TYPE | VARCHAR2 | 10 | Costing transactin type, ISSUE or RECEIPT | ||
| 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 or not this is an intransit logical transaction created by Cost PreProcessor. If created by PreProcessor then its value is Y else it is null. | |
| 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 | Yes | The date when this transaction happened. | ||
| TRANSACTION_QTY | NUMBER | Yes | The transaction quantity of the source 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 source inventory transaction | ||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Yes | The unit of measure code in which primary transaction quantity is specified | |
| SECONDARY_TXN_QTY | NUMBER | The secondary transaction quantity of the source inventory transaction | |||
| SECONDARY_TRANSACTION_UOM_CODE | VARCHAR2 | 3 | The unit of measure code in which secondary transaction quantity is specified | ||
| EXPENSE_TRANSACTION_FLAG | VARCHAR2 | 1 | Identifies whether a transaction is an asset or expense transaction | ||
| SUBINVENTORY_CODE | VARCHAR2 | 10 | The subinventory code where the item is stored | ||
| LOCATOR_ID | NUMBER | 18 | Inventory locator identifier | ||
| PARENT_TRANSACTION_ID | NUMBER | 18 | The parent transaction identifier if this is a logical transaction | ||
| OWNING_COST_ORG_ID | NUMBER | 18 | The cost organization that owns the transaction. It is different from cost rg for consignment transactions. | ||
| TRANSFER_TRANSACTION_ID | NUMBER | 18 | Transaction identifying the other leg of transfer transaction | ||
| TRANSFER_CST_INV_TXN_ID | NUMBER | 18 | Source inventory transaction identifying the other leg of transfer transaction | ||
| TRANSFER_COST_ORG_ID | NUMBER | 18 | Cost Organization identifier associated with Inventory organization of the other leg of transfer transaction | ||
| TRANSFER_INVENTORY_ORG_ID | NUMBER | 18 | Inventory Organization identifier associated with the other leg of transfer transaction | ||
| TRANSFER_SUBINVENTORY_CODE | VARCHAR2 | 50 | Subinventory name for the other leg of transfer transaction | ||
| TRANSFER_LOCATOR_ID | NUMBER | 18 | Inventory location identifier for 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 | ||
| TXN_GROUP_ID | NUMBER | 18 | Stamped to identify the set of transactions that are being processed | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | Yes | Business Unit Id of the Inventory Organization | |
| BILL_TO_BU_ID | NUMBER | 18 | Bill to AP BU for the accrual events. | ||
| 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. | ||
| 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. | ||
| FROM_GRADE_CODE | VARCHAR2 | 150 | FROM_GRADE_CODE | ||
| TO_GRADE_CODE | VARCHAR2 | 150 | TO_GRADE_CODE | ||
| CONSIGNED_FLAG | VARCHAR2 | 1 | Indicates whether the goods are consigned or oned | ||
| ORIGINAL_RECEIPT_INV_ORG_ID | NUMBER | 18 | The delivery inventory organization as specified in the original consigned PO receipt | ||
| PO_LINE_LOCATION_ID | NUMBER | 18 | The purchase order line location identifier | ||
| TRANSFER_TO_REGULAR_TXN_ID | NUMBER | 18 | Identifies the transfer to regular transaction that is being returned. This is only populated for transfer to consigned transactions. | ||
| PO_UOM_CODE | VARCHAR2 | 3 | The unit of measure Code for the Source Document. For PO flows, it is Purchase Order UOM and for Transfer Order flows, it is TO UOM code. | ||
| PO_DOC_TXN_QUANTITY | NUMBER | The transaction quantity in Source Document unit of measure code. | |||
| ORIGINAL_TO_SHIPMENT_TXN_ID | NUMBER | 18 | For return shipment transactions, this references the original forward flow transaction id. | ||
| ORIGINAL_RECEIPT_TXN_ID | NUMBER | 18 | Reference of the original receipt txn ID (Deliver txn ID) on the inter org receipt transactions. This is required to find the purchase order delivery to which the inter org receipt is linked to. | ||
| INV_TRANSFER_ORDER_LINE_ID | NUMBER | 18 | Transfer order line identifier and every transfer order related transaction must have this. |