CST_PREP_COST_CONV_GT
This is a global temporary table to help process cost element mapping and currency conversion. This table is to get the eligible reference RMA transactions for processing.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
TRANSACTION_ID | NUMBER | 18 | Yes | Transaction identifier which identifies the transaction in costing | |
TRANSACTION_DATE | TIMESTAMP | The date when transaction happened | |||
BASE_TXN_TYPE_ID | NUMBER | 18 | Inventory transaction type identifier | ||
BASE_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Inventory transaction source type identifier | ||
BASE_TXN_ACTION_ID | NUMBER | 18 | Inventory transaction action identifier | ||
INTERNAL_PROFIT_TRACKING | NUMBER | 18 | This column indicates whether profit tracking should be done or not. It can hold the values 'Y' and 'N' | ||
COST_TRANSACTION_TYPE | VARCHAR2 | 10 | Costing transaction type ISSUE or RECEIPT | ||
ADDITIONAL_PROCESSING_CODE | VARCHAR2 | 40 | 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 processor for additional processing | ||
LOGICAL_FLAG | VARCHAR2 | 1 | This column indicates whether this transaction type is logical. Logical transactions have no on-hand quantity impact | ||
COST_ORG_ID | NUMBER | 18 | Yes | Identifies the cost organization associated with the inventory organization for which the transaction is being processed | |
COST_BOOK_ID | NUMBER | 18 | Yes | Identifies the cost book associated with the cost organization | |
CST_INV_TRANSACTION_ID | NUMBER | 18 | Yes | The inventory transaction identifier that references costing's inventory transaction table | |
REFERENCE_DOO_FULFILL_LINE_ID | NUMBER | 18 | Referenced fulfillment identifier | ||
REFERENCE_DELIVERY_ID | NUMBER | 18 | This column has the reference delivery identifier that points to delivery identifier of the forward flow |