DW_OM_ORDER_TOTALS_CF
This fact Stores the total amounts calculated by pricing and give a place to attach the charges summarized in the total and any negotiated discounts to be associated to the totals
Details
Module: Order Management
Key Columns
ORDER_TOTAL_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ORDER_TOTAL_ID | NUMBER | 38 | 0 | True | Unique Identifier for an order total | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. System Identifier | ||||
| HEADER_ID | NUMBER | 38 | 0 | Unique identifier of the orchestration order | |||
| CURRENCY_CODE | VARCHAR2 | 16 | The currency which the total represents | ||||
| GLOBAL_CURRENCY_CODE | VARCHAR2 | 32 | The global currency which the total represents | ||||
| GLOBAL_CURRENCY_EXCH_RATE | NUMBER | Global currency exchange rate | |||||
| TOTAL_CODE | VARCHAR2 | 32 | The code for the total definition that defines the properties of this total | ||||
| TOTAL_DEFINITION_ID | NUMBER | 38 | 0 | Id of the pricing total definition | DW_QP_TOTAL_DEFINITIONS_TL | TOTAL_DEFINITION_ID | |
| TOTAL_AMOUNT | NUMBER | This is the aggregated amount calculated for the total | |||||
| GLOBAL_TOTAL_AMOUNT | NUMBER | This is the aggregated amount calculated for the total in global currency | |||||
| CREATION_DATE | TIMESTAMP | Creation date |