eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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:	ONT.OE_PRICE_ADJUSTMENTS

Primary Key: OE_PRICE_ADJUSTMENTS_PK

PRICE_ADJUSTMENT_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
OE_PRICE_ADJUSTMENTS	OE_ORDER_HEADERS_ALL	OE_PRICE_ADJUSTMENTS.HEADER_ID
OE_PRICE_ADJUSTMENTS	OE_ORDER_LINES_ALL	OE_PRICE_ADJUSTMENTS.LINE_ID
OE_PRICE_ADJUSTMENTS	QP_LIST_HEADERS_B	OE_PRICE_ADJUSTMENTS.LIST_HEADER_ID
OE_PRICE_ADJUSTMENTS	QP_LIST_LINES	OE_PRICE_ADJUSTMENTS.LIST_LINE_ID
OE_PRICE_ADJUSTMENTS	WSH_FREIGHT_COSTS	OE_PRICE_ADJUSTMENTS.COST_ID
OE_PRICE_ADJ_ASSOCS	OE_PRICE_ADJUSTMENTS	OE_PRICE_ADJ_ASSOCS.PRICE_ADJUSTMENT_ID
OE_PRICE_ADJ_ASSOCS	OE_PRICE_ADJUSTMENTS	OE_PRICE_ADJ_ASSOCS.RLTD_PRICE_ADJ_ID
OE_PRICE_ADJ_ATTRIBS	OE_PRICE_ADJUSTMENTS	OE_PRICE_ADJ_ATTRIBS.PRICE_ADJUSTMENT_ID