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
Module: Order Management
ORDER_TOTAL_ID
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.