CST_TRANSACTIONS_INT
This interface table is used to temporarily store a subset of data from cst_transactions table to support internal processing within the Cost Processor.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
CST_TRANSACTIONS_INT_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. | |
| 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_UNIT_ID | NUMBER | 18 | Indicates Valuation unit identifier for transaction. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Value that identifies the inventory item associated with the transaction. | |
| INVENTORY_ORG_ID | NUMBER | 18 | Identifier for the inventory organization 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 | Indicates if the transaction is an 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. | |||
| PERIOD_NAME | VARCHAR2 | 15 | Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method. | ||
| PERIOD_START_DATE | DATE | Indicates the start date of the costing period. | |||
| 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. | |
| QUANTITY | NUMBER | Value that identifies the transaction quantity. | |||
| UOM_CODE | VARCHAR2 | 3 | Unit of measure code of the transaction quantity. | ||
| POSTED_FLAG | VARCHAR2 | 5 | Indicates if the transaction has been posted to quantity layers. Updated by Cost Method processors. | ||
| 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. | ||
| 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. | |
| 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. | ||
| CONSIGNED_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the transaction is consigned or owned. | |
| PAC_PROCESSED_FLAG | VARCHAR2 | 1 | This column indicates if the transaction has been included for PAC calculation. Possible values are null/N - transaction is not eligible for PAC or is not yet included in PAC calculation, Y - transaction is included in PAC calculation. | ||
| PAC_TXN_GROUP_ID_1 | NUMBER | 18 | Unique identifier for the set of transactions that needs to be used for computing/recomputing the Periodic Average Cost. | ||
| PAC_TXN_GROUP_ID_2 | NUMBER | 18 | Unique identifier for the set of transactions that needs to be used for computing/recomputing the Periodic Average Cost. | ||
| PAC_TXN_GROUP_ID_3 | NUMBER | 18 | Unique identifier for the set of transactions that needs to be used for computing/recomputing the Periodic Average Cost. | ||
| PAC_IMPACT_FLAG | VARCHAR2 | 1 | Indicates if the transaction impacts PAC computation. Possible values are: Y- Transaction impacts PAC computation. N- Transaction does not impact PAC computation. P- Interim status set in PAC Preprocessor for transactions that are cost owned but does not have cost associated with them (exclude manufacturing product completions and product return transactions). This will be updated to Y in PAC Processor in case cost rows are available for such transactions. R- Interim status set in PAC Preprocessor for manufacturing product completions and product return transactions. This will be updated to Y in PAC Processor. | ||
| CTSA_ADDTNL_PRCESSNG_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. | ||
| CTSA_COST_TRANSACTION_TYPE | VARCHAR2 | 10 | Costing transaction type ISSUE or RECEIPT. | ||
| CST_WORK_ORDER_ID | NUMBER | 18 | Surrogate identifier for the work order associated with the transaction. | ||
| CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | Surrogate identifying a work order operation associated with the transaction in costing. | ||
| PARTIAL_COMPLETION_FLAG | VARCHAR2 | 1 | Indicates if a product completion transaction is processed as partial completion. Valid values are NULL, N and Y. | ||
| PO_ITEM_DESCRIPTION | VARCHAR2 | 240 | Item description for purchase orders where purchase is made for non inventory items. | ||
| 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. | ||
| PROVISIONAL_COMPLETION_TYPE | VARCHAR2 | 30 | Work order valuation option 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) - Value at prior periodic average cost (available only for periodic average cost method) | ||
| COST_PROFILE_ID | NUMBER | 18 | Identifies Cost Profile associated with the transaction. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_TRANSACTIONS_INT_N1 | Non Unique | Default | REQUEST_ID |
| CST_TRANSACTIONS_INT_N2 | Non Unique | Default | PAC_TXN_GROUP_ID_1 |
| CST_TRANSACTIONS_INT_N3 | Non Unique | Default | PAC_TXN_GROUP_ID_2 |
| CST_TRANSACTIONS_INT_N4 | Non Unique | Default | PAC_TXN_GROUP_ID_3 |
| CST_TRANSACTIONS_INT_N5 | Non Unique | DEFAULT | INVENTORY_ITEM_ID, VAL_UNIT_ID, PAC_IMPACT_FLAG |
| CST_TRANSACTIONS_INT_U1 | Unique | Default | TRANSACTION_ID |