DOO_ORDER_CHARGE_COMPONENTS
Stores the detail information about the price waterfall for an order line.
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
DOO_ORDER_CHARGE_COMPONENTS_PK |
ORDER_CHARGE_COMPONENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ORDER_CHARGE_COMPONENT_ID | NUMBER | 18 | Yes | Unique Identifier of DOO_ORDER_CHARGE_COMPONENTS table | |
| ORDER_CHARGE_ID | NUMBER | 18 | Yes | Foreign Key to DOO_ORDER_CHARGES table | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CHARGE_CURRENCY_CODE | VARCHAR2 | 15 | Indicates the currency used in the charge component. Needed due to service standardization. | ||
| CHARGE_CURRENCY_EXT_AMOUNT | NUMBER | Indicates the extended amount in charge currency. Extended amount equals the unit price multiplied by the line requested quantity for simple products and equals the unit price multiplied by the line extended quantity for CP. | |||
| HEADER_CURRENCY_CODE | VARCHAR2 | 15 | Indicates the header currency. Needed due to service standardization. | ||
| HEADER_CURRENCY_EXT_AMOUNT | NUMBER | Indicates the extended amount in header currency | |||
| PERCENT_OF_COMPARISON_ELEMENT | NUMBER | The percentage that this unit price is of the basis charge component unit price. By default the basis is the List Price. This attribute captures the Margin %, the % the Net Price is of the List Price etc. | |||
| PRICE_ELEMENT_CODE | VARCHAR2 | 30 | Element reference to the Price Elements setup e.g.. LISTPRICE, NETPRICE etc. | ||
| PRICE_ELEMENT_USAGE_CODE | VARCHAR2 | 30 | Indicate how the charge component will be used. Values will come from a QP lookup. OOTB, the values will include "List Price" and "Invoice Price". | ||
| SEQUENCE_NUMBER | NUMBER | 9 | Yes | Sequence number for the charge component | |
| CHARGE_CURRENCY_UNIT_PRICE | NUMBER | Indicates the price or adjustment per unit in the charge currency for the line UOM. | |||
| HEADER_CURRENCY_UNIT_PRICE | NUMBER | Indicates the price or adjustment per unit in the header currency for the line UOM | |||
| ROLLUP_FLAG | VARCHAR2 | 1 | Yes | Marks a charge component as a rollup/aggregate value for the charge component price element code | |
| PARENT_CHARGE_COMPONENT_ID | NUMBER | 18 | Charge Component Id for contributing charge. Only populated for charge components where the parent charge is a rollup charge | ||
| SOURCE_CHARGE_COMPONENT_ID | VARCHAR2 | 50 | The unique internal identifier for the charge component as assigned by the system that captured the transaction | ||
| SOURCE_CHARGE_ID | VARCHAR2 | 120 | The unique internal identifier for the charge as assigned by the system that captured the transaction | ||
| SOURCE_MPA_ID | VARCHAR2 | 50 | The unique internal identifier for the Manual Price Adjustment as assigned by the system that captured the transaction. | ||
| SOURCE_PARENT_CHARGE_COMP_ID | VARCHAR2 | 50 | Charge Component Id of the contributing charge as assigned by the system that captured the transaction. Only populated for charge components where the parent charge is a rollup charge | ||
| PRICING_SOURCE_ID | VARCHAR2 | 30 | Id of the lowest level pricing source. E.g. priceListLineId, Tier Rule Id, CP Rule Id, Formula Id, AP Id, shipping line id, etc. | ||
| PRICING_SOURCE_TYPE_CODE | VARCHAR2 | 30 | Type of the Pricing source e.g.. Segment Price List Line etc. The values are from the lookup QP_ENTITY_TYPES plus manual adjustment | ||
| EXPLANATION | VARCHAR2 | 1000 | Message for display in a price breakdown or price waterfall UI. | ||
| EXPLANATION_MESSAGE_NAME | VARCHAR2 | 30 | Message name of the explanation for the price break down UI. | ||
| REFERENCE_ORDER_CHARGE_COMP_ID | NUMBER | 18 | Used by change mgmt to associate the change order's charge component id with the original order's charge component id. | ||
| DELTA_TYPE | NUMBER | 18 | Internal column used by change processing framework for tracking type of change like update, cancel..etc | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| TAX_INCLUDED_FLAG | VARCHAR2 | 1 | Yes | Indicates whether tax is included in the price for a given charge component. | |
| MODIFIED_FLAG | VARCHAR2 | 1 | Indicates that the row has been modified in the version currently submitted | ||
| CHARGE_CURR_DURATION_EXT_AMT | NUMBER | Identifies extended amount over the given duration in the charge currency. | |||
| HEADER_CURR_DURATION_EXT_AMT | NUMBER | Identifies extended amount over the given duration in the header currency. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| doo_order_tax_details | doo_order_charge_components | ORDER_CHARGE_COMPONENT_ID |
| doo_order_total_components | doo_order_charge_components | ORDER_CHARGE_COMPONENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| DOO_ORDER_CHARGE_COMPONENTS_N1 | Non Unique | Default | REFERENCE_ORDER_CHARGE_COMP_ID |
| DOO_ORDER_CHARGE_COMPONENTS_PK | Unique | Default | ORDER_CHARGE_COMPONENT_ID |
| DOO_ORDER_CHARGE_COMPS_N2 | Non Unique | Default | ORDER_CHARGE_ID, SEQUENCE_NUMBER |