CST_CONSIGNED_TRADE_EVENTS_GT
Temporary table used to snapshot the trade events related to consigned inventory that need to be processed for acquisition cost calculation.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: TEMP3
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Single column FK: Identifies the trade event transaction whose incoming cost needs to be computed. | |
| PRIMARY_QTY | NUMBER | Trade event quantity in primary unit of measure. | ||
| CMR_PO_DISTRIBUTION_ID | NUMBER | 18 | Single column FK: Identifies the PO distribution associated with the transaction. | |
| CMR_ROOT_RCV_TXN_ID | NUMBER | 18 | Single column FK: Identifies the root receipt transaction associated with the transaction. | |
| TFR_TO_REG_CURRENCY_CONV_RATE | NUMBER | Currency conversion rate specified on the transfer to regular transaction associated with this trade event. | ||
| OWNERSHIP_CHANGE_CIT_ID | NUMBER | 18 | Identifies the 'transfer to regular'/'transfer to consigned' transaction that has triggered this trade event. | |
| OWNERSHIP_CHANGE_DATE | TIMESTAMP | Indicates the date of ownership change. Given the date effective pricing for consigned purchase orders, this date helps identify the applicable price. | ||
| PARENT_OWNER_CHANGE_CIT_ID | NUMBER | 18 | Identifies the 'transfer to regular' transaction that is being returned. This is only populated for Trade Intransit Return events. | |
| PARENT_TIR_CIT_ID | NUMBER | 18 | Identifies the trade event associated with the 'Transfer to regular' transaction that is being returned. This is only populated for Trade Intransit Return events. | |
| PO_PRICE_FLAG | VARCHAR2 | 1 | Indicates if the acquisition cost can directly be obtained from the PO price. This is the case when there are no invoices for the associated consumption advice. | |
| PRICE_CHANGE_EFFECTIVE_DATE | TIMESTAMP | The effective date of the latest price change that is relevant for this trade event. | ||
| TRANSFER_TO_OWNED_TXN_ID | NUMBER | 18 | Inventory transfer to owned transaction identifier with positive quantity to indicate quantity is moved to inventory from consigned. |