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

Product:	AS - Sales Foundation
Description:	Contains collateral requests
Implementation/DBA Data:	OSM.AS_COLLATERAL_REQ_ALL

Primary Key: AS_COLLATERAL_REQUESTS_PK

COLLATERAL_REQUEST_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AS_COLLATERAL_REQ_ALL	AS_PROMOTIONS_ALL	AS_COLLATERAL_REQ_ALL.LIST_ID
AS_COLLATERAL_REQ_ALL	AS_PROMOTIONS_ALL	AS_COLLATERAL_REQ_ALL.MAIL_BLITZ_ID
AS_COLLATERAL_REQ_ALL	%	AS_COLLATERAL_REQ_ALL.CONTACT_ID
AS_COLLATERAL_REQ_ALL	RA_ADDRESSES_ALL	AS_COLLATERAL_REQ_ALL.ADDRESS_ID
AS_COLLATERAL_REQ_ALL	AS_PROMOTIONS_ALL	AS_COLLATERAL_REQ_ALL.LETTER_ID
AS_COLLATERAL_REQ_ALL	RA_CUSTOMERS	AS_COLLATERAL_REQ_ALL.CUSTOMER_ID
AS_COLLATERAL_REQ_ALL	AS_LIST_ENTRIES	AS_COLLATERAL_REQ_ALL.LIST_ENTRY_ID
AS_COLLATERAL_REQ_ALL	SO_HEADERS_ALL	AS_COLLATERAL_REQ_ALL.ORDER_NUMBER
AS_COLLATERAL_REQ_ITEMS	AS_COLLATERAL_REQ_ALL	AS_COLLATERAL_REQ_ITEMS.COLLATERAL_REQUEST_ID