FND Design Data [Home] [Help]

Table: JTA_SYNC_CONTACT_MAPPING

Product: JTF - CRM Foundation
Description: This table is needed to store mapping of SUNC_CONTACT_ID to PARTY_ID but also to store any other foreign key against the TCA tables.
Implementation/DBA Data: Not implemented in this database
Primary Key: JTA_SYNC_CONTACT_MAPPING_PK
  1. ColumnSYNC_CONTACT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
JTA_SYNC_CONTACT_MAPPING FK Joins to TableHZ_LOCATIONS JTA_SYNC_CONTACT_MAPPING.BUSINESS_PARTY_LOCATION_ID
JTA_SYNC_CONTACT_MAPPING FK Joins to TableHZ_PARTY_SITES JTA_SYNC_CONTACT_MAPPING.BUSINESS_PARTY_SITE_ID
JTA_SYNC_CONTACT_MAPPING FK Joins to TableHZ_PARTIES JTA_SYNC_CONTACT_MAPPING.CONTACT_PARTY_ID
JTA_SYNC_CONTACT_MAPPING FK Joins to TableHZ_LOCATIONS JTA_SYNC_CONTACT_MAPPING.HOME_PARTY_LOCATION_ID
JTA_SYNC_CONTACT_MAPPING FK Joins to TableHZ_PARTY_SITES JTA_SYNC_CONTACT_MAPPING.HOME_PARTY_SITE_ID
JTA_SYNC_CONTACT_MAPPING FK Joins to TableHZ_PARTIES JTA_SYNC_CONTACT_MAPPING.ORGANIZATION_PARTY_ID
JTA_SYNC_CONTACT_MAPPING FK Joins to TableHZ_PARTIES JTA_SYNC_CONTACT_MAPPING.PERSON_PARTY_ID