CST_CONSIGNED_INV_TXN_COSTS_GT
Global temporary table used in the cost preprocessor. It holds the acquisition costs for consigned transactions and the related ownership change trade events.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: TEMP3
Columns
| Name | Datatype | Precision | Comments |
|---|---|---|---|
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Single column FK: Identifies the trade event transaction whose incoming cost needs to be computed. |
| ACQUISITION_COST | NUMBER | Unit acquisition cost. | |
| COST_COMPONENT_ID | NUMBER | 18 | Cost component identifier |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_CONS_INV_TXN_COSTS_GT_N1 | Non Unique | CST_INV_TRANSACTION_ID |