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: AMS_OFFERS

Product:	AMS - Marketing
Description:	This is a surrogate table to QP_LIST_HEADERS_B for Offers related information. QP_LIST_HEADER_ID is the foreign key to QP_LIST_HEADERS_B. This table will capture status, peformance dates and lumpsum related offer types.
Implementation/DBA Data:	Not implemented in this database

Primary Key: AMS_OFFERS_PK

OFFER_ID

Primary Key: AMS_OFFERS_UK1

OFFER_CODE

Primary Key: AMS_OFFERS_UK2

QP_LIST_HEADER_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AMS_OFFERS	AMS_USER_STATUSES_B	AMS_OFFERS.USER_STATUS_ID
AMS_OFFERS	AMS_CUSTOM_SETUPS_B	AMS_OFFERS.CUSTOM_SETUP_ID
AMS_OFFERS	AMS_MEDIA_B	AMS_OFFERS.ACTIVITY_MEDIA_ID
AMS_OFFERS	JTF_RS_RESOURCE_EXTNS	AMS_OFFERS.OWNER_ID
AMS_OFFERS	HZ_PARTIES	AMS_OFFERS.BUYING_GROUP_CONTACT_ID
AMS_OFFERS	QP_LIST_HEADERS_B	AMS_OFFERS.QP_LIST_HEADER_ID