# 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, 2025, Oracle and/or its affiliates.