CST_TRANSACTIONS_S_GT
This table is used to temporarily store a subset of the data from cst_transactions table for internal processing within the cost processor.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_TRANSACTIONS_S_GT_PK |
TRANSACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 18 | Yes | Transaction identifier which uniquely identifies a transaction in costing. | |
| UNREFERENCED_RMA_COST_CODE | VARCHAR2 | 30 | Cost option to value sales returns without any reference to the original sales order, which can be the existing item cost or the price on RMA order. | ||
| DS_SOURCE_LINE_ID | NUMBER | 18 | Based on Flow Type(ASN OR INVOICE) either Shipment Line Id or Transaction Event Id will be stored. | ||
| LE_TIMEZONE_CODE | VARCHAR2 | 50 | LE time zone associated to the transaction. The Cost Date is assumed to be stored in this time zone. | ||
| 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 associated to the valuation unit structure flexfield. | ||
| VAL_UNIT_ID | NUMBER | 18 | Value that uniquely identifies the valuation unit associated with the transaction. | ||
| VAL_UNIT_COMBINATION_ID | NUMBER | 18 | Valuation Units Code Combination Identifier. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Value that identifies the inventory item associated with the transaction. | |
| INVENTORY_ORG_ID | NUMBER | 18 | Indicates The Inventory Org To Which The Item Belongs. | ||
| COST_TRANSACTION_TYPE | VARCHAR2 | 10 | Yes | Costing transaction type ISSUE or RECEIPT. | |
| 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 by Cost Processors for additional processing. | ||
| LOGICAL_FLAG | VARCHAR2 | 1 | Yes | This indicates whether this transaction type is logical. Such transactions have no on-hand quantity impact and do not trigger re-averaging. These transaction show the financial flow. | |
| INTRANSIT_FLAG | VARCHAR2 | 5 | Yes | To identify whether the transaction is a issue or receipt into intransit. | |
| 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 | The date when this transaction happened. | |||
| COST_DATE | TIMESTAMP | Date to be used for transaction sequencing. | |||
| USE_ITEM_COST_FLAG | VARCHAR2 | 1 | Yes | Identifies receipt transactions that did not come with its own cost and are to use an existing item cost in the system (current perpetual average, a specific layer cost, or the current standard cost). Valid values are Y/N. Does not apply to transfer transactions. | |
| MATCHED_TO_COST_FLAG | VARCHAR2 | 5 | Yes | Identifies transactions that have an associated cost in the CST_TRANSACTION_COSTS child table. Valid values are N/Y/X. Transactions for which this does not apply are marked with X. N means waiting for the incoming acquisition cost, transfer cost, or current item cost to be stamped in CTC. | |
| MATCHED_TO_ADDL_TAX_FLAG | VARCHAR2 | 4 | Yes | The values in this column indicates if additional taxes are required and available for the transaction. X - Not expected, N - Expected but missing, Y - Expected and present. | |
| 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 defines the action of cost method processors when the inventory quantity becomes negative. Value comes from lookup_type CST_NEGATIVE_QUANTITY_CODES. | ||
| QUANTITY_FLOW_CODE | VARCHAR2 | 30 | Quantity flow code, FIFO or LIFO. Value comes from lookup_type CST_QUANTITY_FLOW_CODES. | ||
| ENFORCE_TXN_DATE_ORDER_FLAG | VARCHAR2 | 5 | Profile option to have cost dates in the same order as the transaction date. Possible values are (Y)es and (N)o. | ||
| QUANTITY | NUMBER | Value that identifies the transaction quantity. | |||
| UOM_CODE | VARCHAR2 | 3 | Unit of measure code of the transaction quantity. | ||
| UOM_CONVERSION_FACTOR | NUMBER | UOM Conversion factor from primary UOM to costing UOM (because the incoming cost is always in the primary UOM). | |||
| PREPROCESSING_STATUS | VARCHAR2 | 30 | Yes | Value that identifies the cost preprocessing status for transaction. | |
| ERROR_CODE | VARCHAR2 | 100 | Error code for the transaction. | ||
| POSTED_FLAG | VARCHAR2 | 5 | Whether or not the transaction has been posted to quantity layers. Updated by Cost Method processors. | ||
| REC_ONHAND_AVAIL_FLAG | VARCHAR2 | 1 | If the transaction is an Inventory Receipt, this column indicates if the onhand is available for FIFO depletion. | ||
| WO_LAYER_POSTED_FLAG | VARCHAR2 | 1 | Indicates whether the transaction has been created in the WIP layer table. N ??? layer not created Y ??? Layer created X ??? Excluded from layer creation. | ||
| 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 | The inventory transaction identifier that references costing's inventory transaction table. | ||
| CST_INV_TRANSACTION_DTL_ID | NUMBER | 18 | The source inventory transaction detail identifier that 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_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. Owning Cost Org is different from Cost Org for consignment transactions. | ||
| TRANSFER_CST_INV_TXN_ID | NUMBER | 18 | Source inventory transaction identifying the other leg of transfer transaction. | ||
| TRANSFER_VAL_UNIT_ID | NUMBER | 18 | Valuation unit identifier associated with the other leg of transfer transaction. | ||
| TRANSFER_UOM_CONVERSION_FACTOR | NUMBER | Conversion factor between primary UOM code of the issue transaction and the primary UOM code of the receipt 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 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. | ||
| CST_WORK_ORDER_ID | NUMBER | 18 | Single column FK indicating the work order associated with the transaction. | ||
| CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | Single column FK indicating the work order operation associated with the transaction. | ||
| SUPPLY_TYPE | VARCHAR2 | 30 | Indicates the supply type on WIP transactions. The various supply types are Assembly Pull, Operation Pull, Push and Phantom. | ||
| WORK_CENTER_ID | NUMBER | 18 | Surrogate ID identifying the work center where the operation is executed. | ||
| CST_WO_OPERATION_TXN_ID | NUMBER | 18 | Surrogate ID identifying the work order operation transaction. | ||
| WO_UPDATE_EVENT_TXN_ID | NUMBER | 18 | Surrogate ID identifying the work order close transaction. This reference is used to identify if a product transaction was available in the system during work order close. If this reference is missing and the work order is closed, a re-close of the work order is performed. | ||
| 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. | ||
| TRANSFER_PERCENTAGE | NUMBER | Percentage of value to attribute to transfer costs in an Inter-Org transfer. | |||
| 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. | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | 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. | ||
| 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. | ||
| VAL_UNIT_DETAIL_ID | NUMBER | 18 | Single column FK: Identifies the valuation unit detail line. | ||
| TRANSACTION_QTY | NUMBER | Yes | Transaction quantity of the inventory transaction. | ||
| TRANSACTION_UOM_CODE | VARCHAR2 | 3 | Yes | The unit of measure code in which transaction quantity is specified. | |
| PROCESS_DATE | TIMESTAMP | Date at which the average cost processor processed this transaction. It gives the sequence of transaction processing. | |||
| COGS_POSTED_FLAG | VARCHAR2 | 5 | Indicates whether or not cogs has been recognized for the transaction or not yet. | ||
| COSTED_QTY | NUMBER | Quantity that has been processed in costing. | |||
| COSTING_UOM_CODE | VARCHAR2 | 3 | Unit of measure for the costed quantity. | ||
| COSTING_STATUS | VARCHAR2 | 1 | Status of the transaction which denotes, whether a transaction has been pre-processed, processed by cost processors, distributions have been created or processed by sub-ledger accounting. | ||
| TRANSFER_CST_INV_TXN_DTL_ID | NUMBER | 18 | Source inventory transaction detail, such as lot or serial, identifying the other leg of transfer transaction. This is populated only if the item is lot or serial controlled in both source and destination organizations. | ||
| STAGED_FOR_TXFR_COST_FLAG | VARCHAR2 | 5 | Yes | Indicates if the physical transfer transaction has the cost staged in the cst_transfer_txn_costs tables for transfer cost pre-processing. | |
| COST_STATUS | VARCHAR2 | 1 | Current costing status of the transaction for display: N-Not Processed, P-Partially Processed, C-Fully Costed, E-Error, X-Excluded from Costing. | ||
| ACCOUNTING_STATUS | VARCHAR2 | 1 | Current accounting status of the transaction for display: N-Not Processed, D-Draft Accounted, F-Final Accounted, E-Error, X-Excluded from Accounting. | ||
| PROPAGATE_COST_ADJ_FLAG | VARCHAR2 | 1 | The values can be Y or N (Default) and dictates whether or not cost adjustments will be propagated. | ||
| RECEIPT_WITHOUT_COST_CODE | VARCHAR2 | 30 | The values can be either of FIRST, LAST, CURRENT (Default) and dictates which receipt cost will be used for a receipt without any cost. | ||
| REFERENCED_RMA_COST_CODE | VARCHAR2 | 30 | What cost to be used for referenced RMA transactions. The default value is SO_COST. | ||
| 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. | ||
| INTERCOMPANY_INVOICING_FLAG | VARCHAR2 | 1 | Indicates whether the transaction is eligible for intercompany invoicing or not. | ||
| CONSIGNED_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the transaction is consigned or owned. | |
| CONSIGNED_ACCT_DIST_BASIS | VARCHAR2 | 30 | Indicates the Consigned Accounting Distribution basis for the cost profile. | ||
| CREATE_ACCT_FOR_CONS_TXNS | VARCHAR2 | 1 | Creating accounting for consigned transactions Flag - Y or N. | ||
| PROVISIONAL_COMPLETION_TYPE | VARCHAR2 | 30 | Work order valuation option to for valuing work order partial completions into inventory. Following options will be available: - Value at standard cost (available for all cost methods) - Value at last actual cost (available for actual and perpetual average cost method) - Value at perpetual average cost ( available for perpetual average cost method). | ||
| OPERATION_SCRAP_COST_TYPE | VARCHAR2 | 30 | Work order valuation option for including scrap costs as a part of inventory or expensing out 'Operation Scrap' will have the following options available in a LOV choice list: - Include in Inventory - Expense Out. | ||
| CST_TRANSFER_ORDER_LINE_ID | NUMBER | 18 | Transfer order line identifier. | ||
| CST_TRANSFER_ORDER_DIST_ID | NUMBER | 18 | Transfer Order distribution identifier. | ||
| PARTIAL_COMPLETION_FLAG | VARCHAR2 | 1 | Indicates if a product completion transaction is processed as partial completion. Valid values are NULL, N and Y. | ||
| 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. | ||
| REFERENCE_DELIVERY_ID | NUMBER | 18 | This column has the reference delivery identifier that points to delivery identifier of the forward flow. | ||
| 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. | ||
| SIMPLE_PROC_FLAG | VARCHAR2 | 5 | Whether the Dropship Delivery is for Simple Procurement (Y) or for Global Procurement flow (N). | ||
| PROJECT_FLAG | VARCHAR2 | 1 | Flag for identifying if projects is enabled. Will be populated as Y for project enabled sales order issue transaction for now and later extended to all transactions types where projects is enabled. | ||
| 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. | ||
| DOO_SPLIT_FULFILL_LINE_ID | NUMBER | 18 | Reference to the distributed order orchestration split fulfillment line identifier. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Indicates the costing period in which the transaction is processed. | ||
| PERIOD_START_DATE | DATE | Identifies start date of costing period. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_TRANSACTIONS_S_GT_U1 | Unique | TRANSACTION_ID |