Which table stores Account Contacts for a customer
Summary:
Which table stores Account Contacts for a customer
Content (required):
I need to display account contact for a list of customers but am not able to find out where the account contact is stored.
My current code pulls the customer, account number, phone number and email all correctly... but where is the first name and last name stored under account contacts
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
select hp.party_name,
hca.account_number,
phone.phone_number,
email.email_address
from hz_parties hp,
Tagged:
0