FOS_COST_DETAILS_GT
Global temporary table used in costing to populate CST_I_TRADE_EVENT_COSTS and FOS_PRICING_DETAILS tables for cost based pricing option.
Details
-
Schema: FUSION
-
Object owner: FOS
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 18 | Reference to flow_instance_id or delivery_txn_id for customer drop ship or Physical Shipment Transaction ID for Shipment and IOT/IMT flows. | ||
| UNIT_COST | NUMBER | Yes | Unit Price for transaction_id calculated in UOM and Currency of the next financial trade relationship. | ||
| NEXT_FTR_ID | NUMBER | 18 | Yes | Reference to next financial trade relationship. | |
| UOM_CODE | VARCHAR2 | 3 | Unit of mesure for next financial trade relationship. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency code for next financial trade relationship. | |
| 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. | |||
| OWNERSHIP_CHANGE_EVENT_TYPE | VARCHAR2 | 100 | Yes | Represents the type of the event. | |
| OWNERSHIP_CHANGE_TXN_ID | VARCHAR2 | 100 | Yes | Represents the identifier of the event document that initiated the particular task. | |
| TRANSACTION_CONTEXT | VARCHAR2 | 30 | Used to identify if transaction_id is reference of flow_instance_id or delivery_txn_id or Physical Shipment Transaction ID. | ||
| SOURCE_DOCUMENT_ID | NUMBER | 18 | Reference to po_line_location_id in case of customer drop ship flow. | ||
| STATUS | VARCHAR2 | 1 | Current status of the transaction. NULL - not processed, S - SUCCESS, E - Error. | ||
| ERROR_MESSAGE | VARCHAR2 | 512 | Stores the error message for the records if any. | ||
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Costing inventory transaction identifier. |