FND Design Data [Home] [Help]

Table: OE_PRICE_ADJUSTMENTS

Product: ONT - Order Management
Description: This table is used to store price adjustments that have been applied to an order or a line. It is also used to store the freight and special charges, Tax on order line, and Shipping Costs captured at ship confirmation. For Tax records the
Implementation/DBA Data: TableONT.OE_PRICE_ADJUSTMENTS
Primary Key: OE_PRICE_ADJUSTMENTS_PK
  1. ColumnPRICE_ADJUSTMENT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
OE_PRICE_ADJUSTMENTS FK Joins to TableOE_ORDER_HEADERS_ALL OE_PRICE_ADJUSTMENTS.HEADER_ID
OE_PRICE_ADJUSTMENTS FK Joins to TableOE_ORDER_LINES_ALL OE_PRICE_ADJUSTMENTS.LINE_ID
OE_PRICE_ADJUSTMENTS FK Joins to TableQP_LIST_HEADERS_B OE_PRICE_ADJUSTMENTS.LIST_HEADER_ID
OE_PRICE_ADJUSTMENTS FK Joins to TableQP_LIST_LINES OE_PRICE_ADJUSTMENTS.LIST_LINE_ID
OE_PRICE_ADJUSTMENTS FK Joins to TableWSH_FREIGHT_COSTS OE_PRICE_ADJUSTMENTS.COST_ID
TableOE_PRICE_ADJ_ASSOCS FK Joins to OE_PRICE_ADJUSTMENTS OE_PRICE_ADJ_ASSOCS.PRICE_ADJUSTMENT_ID
TableOE_PRICE_ADJ_ASSOCS FK Joins to OE_PRICE_ADJUSTMENTS OE_PRICE_ADJ_ASSOCS.RLTD_PRICE_ADJ_ID
TableOE_PRICE_ADJ_ATTRIBS FK Joins to OE_PRICE_ADJUSTMENTS OE_PRICE_ADJ_ATTRIBS.PRICE_ADJUSTMENT_ID