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     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    

Copyright © 2019, 2023, Oracle and/or its affiliates.