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_ACCESSES_ALL_ALL

Product:	AS - Sales Foundation
Description:	Contains employee and partner access records for customers, sales leads and opportunities
Implementation/DBA Data:	OSM.AS_ACCESSES_ALL_ALL

Primary Key: AS_ACCESSES_ALL_PK

ACCESS_ID

Primary Key: AS_ACCESSES_PK

ACCESS_ID

Primary Key: AS_ACCESSES_UK

PERSON_ID
CUSTOMER_ID
ADDRESS_ID
LEAD_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AS_ACCESSES_ALL_ALL	AS_LEADS_ALL	AS_ACCESSES_ALL_ALL.LEAD_ID
AS_ACCESSES_ALL_ALL	AS_SALES_LEADS	AS_ACCESSES_ALL_ALL.SALES_LEAD_ID
AS_ACCESSES_ALL_ALL	JTF_RS_GROUPS_B	AS_ACCESSES_ALL_ALL.SALES_GROUP_ID
AS_ACCESSES_ALL_ALL	HZ_PARTIES	AS_ACCESSES_ALL_ALL.CUSTOMER_ID
AS_ACCESSES_ALL_ALL	HZ_PARTY_SITES	AS_ACCESSES_ALL_ALL.ADDRESS_ID
AS_ACCESSES_ALL_ALL	HZ_PARTIES	AS_ACCESSES_ALL_ALL.PARTNER_CUSTOMER_ID
AS_ACCESSES_ALL_ALL	HZ_PARTY_SITES	AS_ACCESSES_ALL_ALL.PARTNER_ADDRESS_ID
AS_ACCESSES_ALL_ALL	JTF_RS_GROUPS_B	AS_ACCESSES_ALL_ALL.SALES_GROUP_ID
AS_ACCESSES_ALL_ALL	JTF_RS_RESOURCE_EXTNS	AS_ACCESSES_ALL_ALL.SALESFORCE_ID
AS_ACCESSES_ALL_ALL	AS_LEADS_ALL	AS_ACCESSES_ALL_ALL.LEAD_ID
AS_ACCESSES_ALL_ALL	RA_CUSTOMERS	AS_ACCESSES_ALL_ALL.CUSTOMER_ID
AS_ACCESSES_ALL_ALL	RA_ADDRESSES_ALL	AS_ACCESSES_ALL_ALL.ADDRESS_ID
AS_TERRITORY_ACCESSES	AS_ACCESSES_ALL_ALL	AS_TERRITORY_ACCESSES.ACCESS_ID
PV_ACCESS_MIGRATION_LOG	AS_ACCESSES_ALL_ALL	PV_ACCESS_MIGRATION_LOG.ACCESS_ID