CST_TRADE_EVENT_PREPROCESS_GT
It stores all trade events during cost pre-processing.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: TEMP3
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Yes | Transaction identifier of the trade intransit receipt or trade intransit return whose acquisition cost needs to be computed. | |
| PRIMARY_QTY | NUMBER | Transaction quantity in primary unit of measure. | |||
| PRIMARY_UOM | VARCHAR2 | 25 | Primary unit of measure of the inventory item. | ||
| CMR_PO_LINE_LOCATION_ID | NUMBER | 18 | Identifies the PO schedule that is the source document of the trade events. | ||
| PO_PRICE_FLAG | VARCHAR2 | 1 | Indicates if the transaction cost can directly be obtained from the PO price. This is the case when there are no invoices for the associated PO. | ||
| SOURCE_DOC_QTY | NUMBER | Source document quantity. e.g. Purchase Order Quantity. | |||
| SOURCE_DOC_UOM | VARCHAR2 | 25 | Source document Unit of Measure code. | ||
| SECONDARY_QTY | NUMBER | Transaction quantity in secondary unit of measure. | |||
| SECONDARY_UOM | VARCHAR2 | 25 | Secondary unit of measure of the inventory item. |