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

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