CST_TXN_SOURCE_ACTIONS
The Costing transaction types base table used to derive the costing transactions.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
CST_TXN_SOURCE_ACTIONS_PK |
BASE_TXN_SOURCE_TYPE_ID, BASE_TXN_ACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| 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 | Active | |
| LE_ENABLED_FLAG | VARCHAR2 | 1 | Indicates if the date for the transaction is expected to be in LE timezone. | |||
| 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. | Active | |
| COST_TRANSACTION_TYPE | VARCHAR2 | 10 | Costing transaction types are ISSUE, RECEIPT, RMA, COGS, ACCTGONLY | Active | ||
| 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. | Active | ||
| 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. | Active | |
| CHECK_QTY_SIGN_FLAG | VARCHAR2 | 1 | Yes | For certain transactions like transfers, the sign of the transaction quantity denotes whether the transaction is an issue or receipt. This flag indicates if the sign of the quantity needs to be checked for that. | Active | |
| INTRANSIT_FLAG | VARCHAR2 | 1 | Yes | Indicates whether this transaction is a intransit transaction | Active | |
| CREATE_TXN_FLAG | VARCHAR2 | 1 | Yes | Indicates whether or not to create additional transaction | Active | |
| CREATE_ISSUE_TXN_SOURCE_TYPE | NUMBER | 18 | BASE_TXN_SOURCE_TYPE_ID of the issue transaction that is created | Active | ||
| CREATE_ISSUE_TXN_ACTION | NUMBER | 18 | BASE_TXN_ACTION_ID of the issue transaction that is created | Active | ||
| CREATE_RECEIPT_TXN_SOURCE_TYPE | NUMBER | 18 | BASE_TXN_SOURCE_TYPE_ID of the receipt transaction that is created | Active | ||
| CREATE_RECEIPT_TXN_ACTION | NUMBER | 18 | BASE_TXN_ACTION_ID of the receipt transaction that is created | Active | ||
| START_DATE | DATE | Date that this transaction type will be activated | Active | |||
| END_DATE | DATE | Date that this transaction type will be disabled | Active | |||
| DIRECT_INTERFACE_COST_FLAG | VARCHAR2 | 1 | Indicates that this transaction can expect zero or more interface cost records in CST_I_INCOMING_TXN_COSTS directly tied to the external_system_ref_id in CST_I_INV_TRANSACTIONS.Valid values are 'N', 'Y' and 'C'. The column would be populated with 'C' for WIP Material Returns as the cost is computed by the cost processor using the Layering algorithm. | Active | ||
| MISC_INTERFACE_COST_FLAG | VARCHAR2 | 1 | Indicates that this transaction can expect zero or more interface cost records in CST_I_INCOMING_TXN_COSTS tied to the original_transaction_temp_id in CST_INV_TRANSACTIONS. This is the case for transaction costs entered through the Fusion Inventory miscellaneous transactions UI. | Active | ||
| PHYSICAL_ACQ_COST_FLAG | VARCHAR2 | 1 | Indicates that this transaction needs to be considered by the acquisition cost processor. Further restrictions apply (such as whether this is part of a global procurement flow). | Active | ||
| LOGICAL_ACQ_COST_FLAG | VARCHAR2 | 1 | Indicates that this transaction needs to be considered by the acquisition cost processor. | Active | ||
| ACQ_COST_PARENT_FLAG | VARCHAR2 | 1 | Indicates that this transaction is the level at which acquisition costs will be computed and persisted in CST_DELIVERY_ACQ_COST. | Active | ||
| COST_PREPROCESSING_FLAG | VARCHAR2 | 1 | Indicates that this transaction needs to set cost_preprocessing_status as 'UNPROCESSED' in CST_INV_TRANSACTIONS so this transaction is processed in pre-processors. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
| GP_FWD_FLOW_RCV_PARENT | NUMBER | 1 | If not null, it specifies if the transaction is a part of Global Procurement Forward Flow. Its values are -1 when parent rcv_transaction_id needs to be -1 and 1 when parent rcv_transaction_id is a number other than -1. | |||
| GP_FWD_FLOW_INV_ORG_TYPE | VARCHAR2 | 4 | Possible values are 'INV' which means transfer transaction is the same inv org, 'XFER' which means that transfer transaction is from the transfer organization specified in ORIG_TRANSFER_INV_ORG & Null whcih means that it is not a Forward Flow Global Procurement (GP) transaction. | |||
| GP_MAP_TO_XFER_GROUP | VARCHAR2 | 1 | It specifies the GP_XFER_GROUP to which a global procurement transaction type maps to. | |||
| GP_XFER_GROUP | VARCHAR2 | 1 | It gives the transfer group for global procurement transactions. This grouping helps in deriving the transfer transaction id for GP txns. | |||
| COGS_RECOGNITION_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate the transaction type that needs to be picked for COGS/RMA Recognition process | ||
| SFO_EVENT_COST_INTERFACE_FLAG | VARCHAR2 | 1 | Indicates that this transaction should expect one or more cost records in CST_TRADE_EVENT_COSTS. Further restrictions apply (such as whether the event belongs to the supplier facing node in a global procurement flow). | |||
| SFO_ACQ_COST_FLAG | VARCHAR2 | 1 | Indicates that this transaction needs to be considered by the acquisition cost processor. Further restrictions apply (such as whether the event belongs to the supplier facing node in a global procurement flow). | |||
| EXTERNAL_TXN_TYPE | VARCHAR2 | 30 | The column is used to map the transaction type as sent by the external system to costing transaction type with source_type and action. | |||
| 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. | |||
| CONSIGNED_TFR_TO_INV_INDICATOR | VARCHAR2 | 20 | TFR_TO_REGULAR - Indicates the goods are being transferred from Consigned Inventory to Regular Inventory. TFR_TO_CONSIGNED - Indicates the goods are being transferred from Regular Inventory to Consigned Inventory. NONE - Indicates the transaction is not related to transfer of goods between Consigned Inventory and Regular Inventory. | |||
| SINGLE_LEG_TRANSFER_SIGN | NUMBER | 1 | The sign of transaction qty (1 or -1) that specifies whether the issue (-1) or the receipt (1) leg is part of transfer flow for cost accounting. | |||
| INACTIVE_FLAG | VARCHAR2 | 1 | Marks the transaction types as inactive so that the preprocessors do not process such transaction types | |||
| CHECK_WITH_SFO_FLAG | VARCHAR2 | 1 | Indicates if the transaction type needs to be sent to SFO to check if it has a trade agreement. | |||
| WIP_COST_FLAG | VARCHAR2 | 1 | Indicates if the cost of this transaction would be derived by the work in process transaction processor. Possible values are NULL and Y. | |||
| TRANSFER_SHIP_RCPT_COEVAL | VARCHAR2 | 1 | Denotes whether both the shipping and receipt transactions of a transfer flow are created at the same time. Possible values are [Y]es, [N]o and NULL (not applicable) | |||
| COMPARE_VU_STR_LEVEL | VARCHAR2 | 1 | For transfers within a cost org, compare VU structure to ignore transaction from getting processed. Possible values are [C]ost Org, [I]nv Org and NULL (not applicable) | |||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | |||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | ||
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CST_TXN_SOURCE_ACTIONS | cst_internal_txn_types_b | BASE_TXN_SOURCE_TYPE_ID, BASE_TXN_ACTION_ID |
| cst_internal_txn_types_b | cst_txn_source_actions | BASE_TXN_SOURCE_TYPE_ID, BASE_TXN_ACTION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_TXN_SOURCE_ACTIONS_U1 | Unique | FUSION_TS_TX_DATA | BASE_TXN_SOURCE_TYPE_ID, BASE_TXN_ACTION_ID, ORA_SEED_SET1 |
| CST_TXN_SOURCE_ACTIONS_U11 | Unique | FUSION_TS_TX_DATA | BASE_TXN_SOURCE_TYPE_ID, BASE_TXN_ACTION_ID, ORA_SEED_SET2 |