CST_TXN_COST_SERVICE_IN_GT
Global temporary table used in the bulk processing of transaction cost service requests
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CST_TXN_COST_SERVICE_ID | NUMBER | 18 | Yes | Unique identifier | |
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Reference Information from an External system (external to Cost Management) | ||
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Stores a value that uniquely identifies a certain instance of an object within the external system | ||
| TRANSACTION_TYPE | VARCHAR2 | 30 | Type of transaction to retrieve the cost for. Values are 'INVENTORY', 'TRADEEVENT','CONSIGNEDOWNERSHIPCHANGE'. | ||
| COST_BOOK_CODE | VARCHAR2 | 30 | Cost book code to retrieve the cost for | ||
| CURRENCY_CODE_IN | VARCHAR2 | 15 | Currency code passed to the transaction cost service | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Conversion type that should be used for currency conversion. | ||
| CURRENCY_CONVERSION_DATE | DATE | Date that should be used for currency conversion. | |||
| UOM_CODE_IN | VARCHAR2 | 3 | UOM code passed to the transaction cost service | ||
| UNIT_OF_MEASURE_IN | VARCHAR2 | 25 | Unit of measure |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_TXN_COST_SERVICE_IN_GT_U1 | Unique | CST_TXN_COST_SERVICE_ID |