DW_OM_DRAFT_ORDER_TOTALS_CF (Preview)

This table requires activation of Draft Order Management functional area. 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 for draft sales orders

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    

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