CST_INV_INTRANSIT_TXNS_GT
The table is used to create intransit transactions by the PreProcessor.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
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 | |
| CST_INV_TRANSACTION_DTL_ID | NUMBER | 18 | The source inventory transaction detail identifier references the source inventory transaction details 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 | 15 | 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. | ||
| 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. | |
| TRANSACTION_DATE | TIMESTAMP | Yes | The date when this transaction happened. | ||
| HDR_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 | |
| HDR_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 | |
| HDR_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 | ||
| STATUS | VARCHAR2 | 30 | The status of processing of transactions | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | Yes | Business Unit Id of the Inventory Organization | |
| 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. | ||
| 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 | |
| PARENT_CST_INV_TRANSACTION_ID | NUMBER | 18 | Parent cst_inv_transaction_id, identifies the parent transaction which created the intransit transactions. | ||
| FROM_GRADE_CODE | VARCHAR2 | 150 | For a grade change transaction, the column specifies the old grade of the lot. | ||
| TO_GRADE_CODE | VARCHAR2 | 150 | For a grade change transaction, the column specifies the ew grade of the lot. | ||
| ADDN_TXN_CREATED_FLAG | VARCHAR2 | 1 | The flag specifies whether or not the intransit transactions has been created by the parent transaction. Valid values for the flag are (U)nprocessed, (N)ot yet created, Null : Child txn has been created or the flag is not applicable to this txn. | ||
| TRANSFER_LINKED_FLAG | VARCHAR2 | 1 | Specifies whether or not this transfer transaction has been chained to the other leg of transfer. Values are (U)nprocessed, (N)ot yet, Null : linked or column not applicable for this trasnaction. | ||
| ACCRUAL_EXTERNAL_SYSTEM_REF_ID | NUMBER | 18 | For an in-transit receipt, this refers to the associated Accrual Transaction event | ||
| PRIOR_EXTERNAL_SYSTEM_REF_ID | NUMBER | 18 | Prior transaction that is the source of the cost for this transaction. | ||
| LEGAL_ENTITY_ID | NUMBER | 18 | Legal entity of the transaction | ||
| BILL_TO_BU_ID | NUMBER | 18 | Bill to AP BU for the accrual events. | ||
| OWNERSHIP_CHANGE_TXN_ID | NUMBER | 18 | The transaction that triigered the ownership change. e.g. ASN, Customer Clearance, Supplier Aceptance. | ||
| OWNERSHIP_CHANGE_EVENT_TYPE | VARCHAR2 | 30 | The type of the event associated to the ownership change transaction. | ||
| SUCCESSOR_BUSINESS_UNIT_ID | NUMBER | 18 | Successor profit center BU | ||
| SUCCESSOR_INVENTORY_ORG_ID | NUMBER | 18 | Successor Inventory organization | ||
| PRIOR_BUSINESS_UNIT_ID | NUMBER | 18 | Prior profit center BU | ||
| PRIOR_INVENTORY_ORG_ID | NUMBER | 18 | Prior Inventory organization | ||
| OWNERSHIP_CHANGE_SYSTEM_REF | VARCHAR2 | 100 | The system from which the ownership change flow originated. E.g. EBS vs. 3rd party system etc. | ||
| 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. | ||
| CONSIGNED_FLAG | VARCHAR2 | 1 | Indicates whether the transaction is consigned or owned. | ||
| PO_UOM_CODE | VARCHAR2 | 3 | The unit of measure Code for the Purchase Order Source Quantity | ||
| PO_DOC_TXN_QUANTITY | NUMBER | The transaction quantity in Purchase Order unit of measure code. | |||
| OWNER_TYPE | NUMBER | 18 | This is the party that transfers the ownership to the org where the ownership change happens. Values: 1 is SUPPLIER, 2 is INVENTORY_ORG, null is for non-consigned scenario | ||
| OWNING_ENTITY_ID | NUMBER | 18 | This is the party that transfers the ownership to the org where the ownership change happens. Owner Type = SUPPLIER, represents the supplier site ID; Owner type = INVENTORY_ORG, represents the inventory org id | ||
| ORIGINAL_TO_SHIPMENT_TXN_ID | NUMBER | 18 | For return shipment transactions, this references the original forward flow transaction id. | ||
| TRANSFER_ORDER_DIST_ID | NUMBER | 18 | Transfer Order distribution identifier. |