CST_INV_TRANSACTIONS
This is Costing's Inventory Transactions table and is the source of all inventory transactions within costing. It contains all transactions that are imported into Costing through the interface and also transactions that are created by costing's engines during processing.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_INV_TRANSACTIONS_PK |
CST_INV_TRANSACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Yes | This is a database sequence generated number by Cost Preprocessor to identify the inventory transaction within costing system. | |
| DOO_SPLIT_FULFILL_LINE_ID | NUMBER | 18 | Reference to the distributed order orchestration (DOO) fulfillment line identifier. | ||
| DS_SOURCE_LINE_ID | NUMBER | 18 | Based on Flow Type (ASN OR INVOICE) either Shipment Line Id or Transaction Event Id will be stored | ||
| REFERENCE_DELIVERY_ID | NUMBER | 18 | Referenced delivery id identifier for RMA. | ||
| FISCAL_DOC_HEADER_ID | NUMBER | 18 | This column stores the unique identifier for the fiscal document header. | ||
| FISCAL_DOC_ACCESS_KNUM | VARCHAR2 | 64 | This column stores the access key number corresponding to the fiscal document. | ||
| FISCAL_DOC_LINE_ID | NUMBER | 18 | This column stores the unique identifier for the fiscal document line. | ||
| REF_FISCAL_DOC_HEADER_ID | NUMBER | 18 | This column stores the unique identifier for the reference fiscal document header. | ||
| REF_FISCAL_DOC_LINE_ID | NUMBER | 18 | This column stores the unique identifier for the reference fiscal document line. | ||
| REF_FISCAL_DOC_ACCESS_KNUM | VARCHAR2 | 64 | This column stores the access key number corresponding to the reference fiscal document. | ||
| FISCAL_DOC_SCHEDULE_ID | NUMBER | 18 | This column stores the unique identifier for the fiscal document schedule. | ||
| REF_FISCAL_DOC_SCHEDULE_ID | NUMBER | 18 | This column stores the unique identifier for the reference fiscal document schedule. | ||
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Identifies the external source system. In case of inventory transfers it is CST with parent transaction identifier relating to original row. | |
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | Stores a value that uniquely identifies a certain instance of an object within the external system | |
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | Indicates the inventory organization to which the item belongs. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | This identifies the inventory item. | |
| 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, but a custom source type is treated as INVENTORY (value>100 is brought in as 13), and for CST it comes from Lookup_type CST_BASE_TXN_SOURCE_TYPES | |
| INV_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Yes | Transaction source type identifier including custom 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. | |
| TRANSACTION_DATE | TIMESTAMP | Yes | The date when this transaction happened. | ||
| TRANSACTION_CREATION_DATE | TIMESTAMP | Yes | Date on which the trade event transaction was created. | ||
| TRANSACTION_TIMEZONE_CODE | VARCHAR2 | 50 | Timezone of transaction date. | ||
| TRANSACTION_QTY | NUMBER | Yes | Transaction quantity of trade event. | ||
| TRANSACTION_UOM_CODE | VARCHAR2 | 3 | Yes | The unit of measure code in which transaction quantity is specified | |
| PRIMARY_QTY | NUMBER | Yes | Transaction Quantity in Primary unit of measure | ||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Yes | The unit of measure code in which primary transaction quantity is specified | |
| SECONDARY_TRANSACTION_QTY | NUMBER | Transaction Quantity in Secondary unit of measure | |||
| SECONDARY_TRANSACTION_UOM_CODE | VARCHAR2 | 3 | The unit of measure code in which secondary transaction quantity is specified | ||
| SUBINVENTORY_CODE | VARCHAR2 | 10 | The subinventory code where the item is stored. | ||
| LOCATOR_ID | NUMBER | 18 | This identifies the item locator. | ||
| INTRANSIT_FLAG | VARCHAR2 | 1 | Identifies whether this is an in-transit logical transaction created by cost preprocessor. | ||
| TXN_GROUP_ID | NUMBER | 18 | Stamped to identify the set of transactions that are being processed | ||
| TRANSACTION_REASON_ID | NUMBER | 18 | Transaction Reason Identifier. | ||
| TRANSFER_TRANSACTION_ID | NUMBER | 18 | Transaction id of the opposing transfer transaction | ||
| ORIGINAL_TRANSACTION_TEMP_ID | VARCHAR2 | 40 | Transaction Temp Id that was generated when the Inventory transaction was saved. | ||
| TRANSFER_INVENTORY_ORG_ID | NUMBER | 18 | Transfer opposing inventory organization id | ||
| TRANSFER_SUBINVENTORY_CODE | VARCHAR2 | 10 | Subinventory name for the other leg of transfer transaction. | ||
| TRANSFER_LOCATOR_ID | NUMBER | 18 | Inventory location identifier for the other leg of transfer transaction | ||
| ORIG_TRANSFER_INVENTORY_ORG_ID | NUMBER | 18 | The transfer transaction identifier as stamped on the transaction. | ||
| EXPENSE_TRANSACTION_FLAG | VARCHAR2 | 1 | Yes | Identifies whether a transaction is an asset or expense transaction | |
| TRANSACTION_TEMP_ID | NUMBER | 18 | Transaction Temp Id generated before Transaction Manager processes this record | ||
| 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. | ||
| 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. | ||
| INTERNAL_PROFIT_TRACKING | VARCHAR2 | 1 | This column is used by Costing and the values it can hold are 'Y' and 'N'. It indicates whether to track profit in inventory. | ||
| INTERCOMPANY_INVOICING_FLAG | VARCHAR2 | 1 | Indicates whether the transaction is eligible for intercompany invoicing or not | ||
| INTERFACE_BATCH_NUMBER | VARCHAR2 | 50 | Batch Number of External Systems interface run. Added to facilitate source system to identify which transactions were sent in which run on the source system. | ||
| INTERFACE_BATCH_NAME | VARCHAR2 | 250 | Batch Name of External Systems interface run. | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | Yes | Business Unit Id of the Inventory Organization | |
| TRANSFER_CST_INV_TXN_ID | NUMBER | 18 | Source inventory transaction identifying the other leg of transfer transaction | ||
| ADDN_TXN_CREATED_FLAG | VARCHAR2 | 1 | The flag specifies whether the intransit transactions has been created by the parent transaction. Valid values for the flag are U:Unprocessed, N:Not yet created, Null: Child transaction has been created or the flag is not applicable to this transaction. | ||
| TRANSFER_LINKED_FLAG | VARCHAR2 | 1 | Specifies whether this transfer transaction has been chained to the other leg of transfer. Values are U:Unprocessed, N:Not yet, Null: linked or column not applicable for this transaction. | ||
| RCV_TRANSACTION_ID | NUMBER | 18 | Receiving transaction identifier | ||
| PO_DISTRIBUTION_ID | NUMBER | 18 | Purchasing distribution identifier | ||
| PO_ITEM_DESCRIPTION | VARCHAR2 | 240 | Item Description for purchase orders where purchase is made for non-inventory items. | ||
| TRANSACTION_AMOUNT | NUMBER | Transaction amount in purchase order currency. Applicable for fixed price lines. | |||
| TRANSACTION_CURRENCY_CODE | VARCHAR2 | 15 | Purchase order currency for the amount column. Applicable for fixed price lines. | ||
| PO_ITEM_DESCRIPTION_TYPE | VARCHAR2 | 30 | Indicates the type of purchase in case purchase is made for non-inventory item based on a description. Valid values are GOODS or SERVICE. | ||
| WSH_DELIVERY_DETAIL_ID | NUMBER | 18 | Shipping delivery detail identifier | ||
| DOO_FULLFILL_LINE_ID | NUMBER | 18 | Reference to the unique identifier of the source fulfillment line in distributed order orchestration (DOO). | ||
| CODE_COMBINATION_ID | NUMBER | 18 | Code Combination identifier for the referenced account | ||
| CST_WORK_ORDER_ID | NUMBER | 18 | Surrogate ID identifying a work order in costing. | ||
| CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | Surrogate ID identifying a work order operation in costing. | ||
| CST_WO_OPERATION_TXN_ID | NUMBER | 18 | Surrogate ID identifying the manufacturing operation transaction creating the material transaction. | ||
| WORK_ORDER_ID | NUMBER | 18 | Surrogate ID identifying a work order in manufacturing. | ||
| SUPPLY_TYPE | VARCHAR2 | 30 | The various supply types are Assembly Pull, Operation Pull, Push, and Phantom. This list will have to be seeded as lookups with the type of EGP_WIP_SUP_TYPE. | ||
| WORK_ORDER_OPERATION_ID | NUMBER | 18 | Surrogate ID identifying an operation within a work order. | ||
| WORK_CENTER_ID | NUMBER | 18 | Surrogate ID identifying Work Center where the operation is executed. | ||
| WO_OPERATION_TRANSACTION_ID | NUMBER | 18 | Surrogate ID identifying a work order operation transaction that generated this material transaction. | ||
| 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 | ||
| PREPROCESSING_STATUS | VARCHAR2 | 30 | The status of quantity processing of transactions | ||
| COST_PREPROCESSING_STATUS | VARCHAR2 | 30 | The status of cost processing of transactions | ||
| FROM_GRADE_CODE | VARCHAR2 | 150 | This code indicates the original lot grade. | ||
| TO_GRADE_CODE | VARCHAR2 | 150 | This code indicates the destination lot grade. | ||
| TRADE_AGREEMENT_PTR_ID | NUMBER | 18 | Identifies the primary trade relationship of the SFO agreement. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE21 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE22 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE23 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE24 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE25 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE26 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE27 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE28 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE29 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE30 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| PJC_CONTEXT_CATEGORY | VARCHAR2 | 40 | DFF Context Column used by Standardized Project Cost Collection Widget | ||
| PJC_PROJECT_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_TASK_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_EXPENDITURE_TYPE_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_EXPENDITURE_ITEM_DATE | DATE | DFF Column used by Standardized Project Cost Collection Widget | |||
| PJC_ORGANIZATION_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_BILLABLE_FLAG | VARCHAR2 | 1 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_CAPITALIZABLE_FLAG | VARCHAR2 | 1 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_WORK_TYPE_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_CONTRACT_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_CONTRACT_LINE_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_FUNDING_ALLOCATION_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
| PJC_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | DFF Column used by Standardized Project Cost Collection Widget | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| TRADE_AGREEMENT_FTR_ID | NUMBER | 18 | Identifies the financial trade relationship of the trade event linked to this transaction. | ||
| TRADE_AGREEMENT_TYPE | VARCHAR2 | 20 | To be used by the accounting template instead of transaction_flow_type. Populate this for all SFO related physical transactions (even when we do not explicitly call SFO) | ||
| TRADE_AGREEMENT_NUMBER | VARCHAR2 | 100 | Required for interorganization shipment, SO Issue, RMA receipt to identify that it is SFO related. All these cases call SFO to figure it out. | ||
| SUCCESSOR_INVENTORY_ORG_ID | NUMBER | 18 | Required for SO issue, interorganization shipment, TO shipment to provide as a source in SLA because accounting of this hits trade in-transit. | ||
| SUCCESSOR_BUSINESS_UNIT_ID | NUMBER | 18 | Required for SO Issue, interorganization shipment, TO shipment to provide as a source in SLA because accounting of this hits trade in-transit. | ||
| PRIOR_INVENTORY_ORG_ID | NUMBER | 18 | Required for direct interorganization receipt to provide as a source in SLA because accounting of this hits trade intransit (as there is no receiving involved here). | ||
| PRIOR_BUSINESS_UNIT_ID | NUMBER | 18 | Required for direct interorganization receipt to provide as a source in SLA because accounting of this hits trade intransit (as there is no receiving involved here). | ||
| TRANSFER_ORDER_LINE_ID | NUMBER | 18 | Required for all transfer order transactions. | ||
| TRANSFER_ORDER_DISTRIBUTION_ID | NUMBER | 18 | Required for transfer order related receipts. Where it does not come from the interface, qty preprocessor will derive it based on ascending order of distribution identifier (to keep it in sync with how Inventory derives it). | ||
| TRANSACTION_GROUP_ID | NUMBER | 18 | Used to group related transactions together. | ||
| TRANSFER_TRANSACTION_GROUP_ID | NUMBER | 18 | The transaction group whose average cost is required to process this transaction. | ||
| PRICING_OPTION | NUMBER | 18 | Pricing Option identifier. It signifies whether the option is to use the PO price (1), transfer price (2) or the cost + markup (3) as the transfer cost. | ||
| PARENT_TRANSACTION_ID | NUMBER | 18 | The parent transaction identifier if this is a logical transaction | ||
| TRANSFER_PERCENTAGE | NUMBER | Percentage of value to attribute to transfer costs in an interorganization transfer. | |||
| CONSIGNED_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the transaction is consigned or owned. | |
| ORIGINAL_RECEIPT_TXN_ID | NUMBER | 18 | Reference of the original receipt transaction ID (Deliver transaction 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. | ||
| ORIGINAL_RECEIPT_NUMBER | VARCHAR2 | 50 | This column is used for valuation unit generation and is the combination of receipt number and the inventory org code. | ||
| ORIGINAL_RECEIPT_INV_ORG_ID | NUMBER | 18 | The Inventory organization where the original receipt of consigned goods was received. | ||
| CUSTODY_INVENTORY_ORG_ID | NUMBER | 18 | Inventory org where the goods are physically present. This attribute would have a value for scenarios when purchased goods are transferred without ownership change and ownership change happens in transferee org. Stamped on Inter org issue transactions. | ||
| CONTINGENT_OWNER_TYPE | VARCHAR2 | 20 | Represents the party type who bears the risk for the goods in custody. This is the party type who will be the owner on ownership change. Values: SUPPLIER, INVENTORY_ORG | ||
| CONTINGENT_OWNER_ID | NUMBER | 18 | Represents the party who bears the risk for the goods in custody. This is the party who will be the owner on ownership change. Party Type = SUPPLIER, represents the supplier site ID; Party Type = INVENTORY_ORG, represents the inventory org ID | ||
| 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 | ||
| OWNER_NAME | VARCHAR2 | 30 | The owner code that is used in the valuation unit generation. | ||
| 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. | ||
| CURRENCY_CONVERSION_RATE | NUMBER | The conversion rate from the entered currency on the purchase order to the functional currency of the Bill to business unit on the purchase order. | |||
| CALLBACK_FLAG | VARCHAR2 | 1 | Indicates if SFO api needs to be called to send the cost to SFO so that next node cost be sent back to costing. Values are N - call back not done yet, Y - call back done, NULL - not applicable. | ||
| TRANSACTION_INTERFACE_LINE_NUM | VARCHAR2 | 30 | Identifies the inventory transaction when entered via the interface. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Used by Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. | ||
| TRANSACTION_INTERFACE_ID | NUMBER | 18 | Transaction Identifier from INV_TRANSACTIONS_INTERFACE | ||
| SOURCE_SALES_ORDER_NUMBER | VARCHAR2 | 150 | Sales order number from shipping | ||
| SOURCE_SALES_ORDER_LINE_NUMBER | VARCHAR2 | 150 | Sales order line number from shipping | ||
| SOURCE_SO_SHIPMENT_NUMBER | VARCHAR2 | 20 | Sales order shipment number from shipping | ||
| SALES_ORDER_SOURCE_SYSTEM | VARCHAR2 | 90 | This column stores source of the sales order document. | ||
| RECEIPT_ADVICE_NUMBER | VARCHAR2 | 80 | This is used has identifier for Sales order RMA transaction | ||
| RECEIPT_ADVICE_LINE_NUMBER | VARCHAR2 | 80 | This is used has line identifier for Sales order RMA transaction | ||
| REFERENCED_SO_NUMBER | VARCHAR2 | 80 | This column stores the Referenced sales order number for Sales order RMA transaction | ||
| REFERENCED_SO_LINE_NUMBER | VARCHAR2 | 80 | Referenced sales order line number | ||
| CST_TRANSFER_ORDER_LINE_ID | NUMBER | 18 | Transfer order line identifier (FK to CST_TRANSFER_ORDER_LINES). | ||
| CST_TRANSFER_ORDER_DIST_ID | NUMBER | 18 | Transfer Order distribution identifier (FK to CST_TRANSFER_ORDER_DISTS). | ||
| INV_TRANSFER_ORDER_HEADER_ID | NUMBER | 18 | Transfer order header unique identifier. | ||
| INV_TRANSFER_ORDER_LINE_ID | NUMBER | 18 | Transfer order line identifier and every transfer order related transaction must have this. | ||
| INV_TRANSFER_ORDER_DIST_ID | NUMBER | 18 | Transfer Order distribution identifier. | ||
| ORIGINAL_TO_SHIPMENT_TXN_ID | NUMBER | 18 | For return shipment transactions, this references the original forward flow transaction id. | ||
| MANUAL_RECEIPT_REQD_FLAG | VARCHAR2 | 1 | Flag to denote Manual receipt is created or not for transfer to expense destination | ||
| REFERENCE_DOO_FULLFILL_LINE_ID | NUMBER | 18 | Referenced fulfillment line identifier | ||
| SHIPPING_INV_ORG_ID | NUMBER | 18 | Original Shipping Inventory Org. Only populated for forward and return IDS and CDS flows. | ||
| SHIPPING_BU_ID | NUMBER | 18 | Profit Center Business Unit of Original Shipping Inventory Org. Only populated for forward and return IDS and CDS flows. | ||
| RETURN_INV_ORG_ID | NUMBER | 18 | Inventory org of return receipt. | ||
| RETURN_BU_ID | NUMBER | 18 | Profit Center Business Unit of Inventory Org where the return receipt. | ||
| REFERENCED_RETURN_FLAG | VARCHAR2 | 5 | Possible values Y/N/NULL. Mainly used in R13 for referenced RMA. May be used for more flows later. Y means return is a referenced return. N means it is unreferenced. NULL means that it is a pre-R13 return flow or this column is not applicable for the flow. | ||
| TXN_CHAINED_FLAG | VARCHAR2 | 5 | Possible values Y/N/NULL. Y/NULL means that chaining is completed. N means chaining not yet done. | ||
| QPP_TXN_GROUPS_UPDATED_FLAG | VARCHAR2 | 1 | Processing flag to support the update of the TRANSACTION_GROUP_ID and TRANSFER_TRANSACTION_GROUP_ID columns. Values are Y - Yes, N - No | ||
| SIMPLE_PROC_FLAG | VARCHAR2 | 5 | Whether the Dropship Delivery is for Simple Procurement (Y) or for Global Procurement flow (N). | ||
| CONSUMPTION_UNIT_PRICE | NUMBER | Transfer to owned transaction unit price | |||
| WO_OUTPUT_TYPE | VARCHAR2 | 30 | Type of output produced on a process manufacturing work order. Valid values exist in the lookup ORA_WIS_WD_OUTPUT_MATERIAL. | ||
| PRIMARY_PRODUCT_FLAG | VARCHAR2 | 1 | Indicates whether this is the primary output for the work order. Valid values are Y or N. | ||
| WO_COST_ALLOCATION_BASIS | VARCHAR2 | 30 | The basis for cost allocation for output items in a process manufacturing work order. It can be either percentage or fixed value. Valid values exist in lookup ORA_WIS_COST_ALLOC_BASIS. | ||
| INV_STRIPING_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for Inventory striping attributes | ||
| PROJECT_ID | NUMBER | 18 | Identifier of the project used to stripe Inventory transactions | ||
| TASK_ID | NUMBER | 18 | Identifier of the task used to stripe Inventory transactions | ||
| COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | Code for the country of manufacture used to stripe Inventory transactions | ||
| WMS_FLAG | VARCHAR2 | 1 | Indicates whether the transaction is WMS reconciliation. | ||
| TRANSFER_PROJECT_ID | NUMBER | 18 | Transfer Project identifier used in project transfer transactions | ||
| TRANSFER_TASK_ID | NUMBER | 18 | Transfer Task identifier used in project transfer transactions | ||
| SUPPLIER_RETURN_HEADER_ID | NUMBER | 18 | Unique identifier for supplier return header. | ||
| SUPPLIER_RETURN_LINE_ID | NUMBER | 18 | Unique identifier for supplier return line. | ||
| RECALL_HEADER_ID | NUMBER | 18 | Unique identifier for recall header. | ||
| RECALL_LINE_ID | NUMBER | 18 | Unique identifier for recall line. | ||
| PARENT_ID | NUMBER | 18 | This column identifies source and resultant transaction group for lot merge, translate and split flows. | ||
| SOURCE_LOT_FLAG | VARCHAR2 | 3 | To identify source transactions for lot merge, translate and split flows. Values: (Y) for Source transaction, (N) for resultant transaction and null in case of other flows. | ||
| REF_RCV_TRANSACTION_ID | NUMBER | 18 | This column identifies the receiving transaction identifier for Shipment and Receipt transactions in the Internal Material Transfers forward and return flows. | ||
| ASSEMBLY_ASSET_ID | NUMBER | 18 | The work order asset for which the material transactions are performed. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CST_INV_TRANSACTIONS | cst_ext_src_systems_info | EXTERNAL_SYSTEM_REFERENCE |
| CST_INV_TRANSACTIONS | cst_internal_txn_types_b | CST_INV_TRANSACTION_ID, BASE_TXN_SOURCE_TYPE_ID |
| cst_incoming_txn_cost_sources | cst_inv_transactions | CST_INV_TRANSACTION_ID |
| cst_transactions | cst_inv_transactions | CST_INV_TRANSACTION_ID |
| cst_transactions | cst_inv_transactions | TRANSFER_CST_INV_TXN_ID |
| cst_inv_transaction_dtls | cst_inv_transactions | CST_INV_TRANSACTION_ID |
| cst_incoming_txn_costs | cst_inv_transactions | CST_INV_TRANSACTION_ID |
| cst_acq_adj_txn_costs | cst_inv_transactions | CST_INV_TRANSACTION_ID |
| cst_transaction_costs | cst_inv_transactions | CST_INV_TRANSACTION_ID |
| cst_upg_interco_txns | cst_inv_transactions | CST_INV_TRANSACTION_ID |
| cst_delivery_acq_cost | cst_inv_transactions | CST_INV_TRANSACTION_ID |
| cst_org_book_inv_txns_tmp | cst_inv_transactions | CST_INV_TRANSACTION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| CST_INV_TRANSACTIONS_N1 | Non Unique | FUSION_TS_TX_DATA | PREPROCESSING_STATUS, CST_INV_TRANSACTION_ID | Obsolete |
| CST_INV_TRANSACTIONS_N10 | Non Unique | Default | TRANSFER_LINKED_FLAG | |
| CST_INV_TRANSACTIONS_N11 | Non Unique | Default | TRANSFER_TRANSACTION_GROUP_ID, TRANSACTION_GROUP_ID | |
| CST_INV_TRANSACTIONS_N12 | Non Unique | FUSION_TS_TX_DATA | EXTERNAL_SYSTEM_REFERENCE, TRANSACTION_INTERFACE_LINE_NUM, LOAD_REQUEST_ID | |
| CST_INV_TRANSACTIONS_N13 | Non Unique | FUSION_TS_TX_DATA | EXTERNAL_SYSTEM_REFERENCE, TRANSACTION_INTERFACE_ID | Obsolete |
| CST_INV_TRANSACTIONS_N14 | Non Unique | Default | CST_WORK_ORDER_ID, CST_WORK_ORDER_OPERATION_ID, TRANSACTION_DATE | |
| CST_INV_TRANSACTIONS_N15 | Non Unique | FUSION_TS_TX_DATA | INVENTORY_ORG_ID, TRANSACTION_DATE | |
| CST_INV_TRANSACTIONS_N16 | Non Unique | Default | TRANSACTION_GROUP_ID | |
| CST_INV_TRANSACTIONS_N17 | Non Unique | Default | ADDN_TXN_CREATED_FLAG | |
| CST_INV_TRANSACTIONS_N18 | Non Unique | Default | QPP_TXN_GROUPS_UPDATED_FLAG | |
| CST_INV_TRANSACTIONS_N19 | Non Unique | Default | PO_DISTRIBUTION_ID | |
| CST_INV_TRANSACTIONS_N2 | Non Unique | FUSION_TS_TX_DATA | TXN_GROUP_ID | |
| CST_INV_TRANSACTIONS_N20 | Non Unique | Default | EXTERNAL_SYSTEM_REFERENCE, TO_CHAR("TRANSACTION_INTERFACE_ID") | |
| CST_INV_TRANSACTIONS_N21 | Non Unique | Default | DOO_FULLFILL_LINE_ID | |
| CST_INV_TRANSACTIONS_N22 | Non Unique | Default | CALLBACK_FLAG | |
| CST_INV_TRANSACTIONS_N23 | Non Unique | Default | PREPROCESSING_STATUS, INVENTORY_ORG_ID | |
| CST_INV_TRANSACTIONS_N3 | Non Unique | FUSION_TS_TX_DATA | COST_PREPROCESSING_STATUS, INVENTORY_ORG_ID | |
| CST_INV_TRANSACTIONS_N4 | Non Unique | FUSION_TS_TX_DATA | ORIGINAL_TRANSACTION_TEMP_ID | |
| CST_INV_TRANSACTIONS_N5 | Non Unique | FUSION_TS_TX_DATA | BASE_TXN_SOURCE_TYPE_ID, BASE_TXN_ACTION_ID, PARENT_TRANSACTION_ID | |
| CST_INV_TRANSACTIONS_N6 | Non Unique | FUSION_TS_TX_DATA | REQUEST_ID, CST_INV_TRANSACTION_ID | |
| CST_INV_TRANSACTIONS_N7 | Non Unique | Default | TRANSFER_TRANSACTION_ID, TRANSFER_CST_INV_TXN_ID | |
| CST_INV_TRANSACTIONS_N8 | Non Unique | FUSION_TS_TX_DATA | RCV_TRANSACTION_ID | |
| CST_INV_TRANSACTIONS_N9 | Non Unique | Default | TRANSACTION_FLOW_TYPE | |
| CST_INV_TRANSACTIONS_U1 | Unique | FUSION_TS_TX_DATA | CST_INV_TRANSACTION_ID | |
| CST_INV_TRANSACTIONS_U2 | Unique | FUSION_TS_TX_DATA | EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID |