HZ_PARTIES :
This table holds important information related to party like party name, party number and party type. Party type can be organization , person or relationship between organization and person. The primary key of the table is PARTY_ID.
HZ_CUST_ACCOUNTS
This table hold information related to customer account like account_number. The primary key in this table is cust_account_id. We can join this table with HZ_PARTIES using partying.
HZ_LOCATIONS:
This table holds the address information related to party . Important fields in this table are address, address2 , address3 , city, state, county , country, address_style. Primary key in this table location_id .
HZ_PARTY_SITES
HZ_PARTY_SITE_USES_ALL
HZ_CUST_ACCT_SITES_ALL
Hz_CUST_SITE_USES_ALL
HZ_RELATIONSHIPS
HZ_CONTACT_POINTS
HZ_CUST_ACCOUNT_ROLES
HZ_CUSTOMER_PROFILES
HZ_CUST_PROFILE_CLASSES
Query:
Select hp.party_name,hp.party_id,hca.account_number
,hca.cust_account_id
,hl.address1
, hl.address2
, hl.city
, hl.country
,hl.state
,hps.party_site_id
From
HZ_PARTIES hp
, HZ_CUST_ACCOUNTS hca
, HZ_LOCATIONS hl
, HZ_PARTY_SITES hps
Where 1=1
and hp.party_id=hca.party_id
and hp.party_id=hps.party_id
and hl.location_id=hps.location_id
This table holds important information related to party like party name, party number and party type. Party type can be organization , person or relationship between organization and person. The primary key of the table is PARTY_ID.
HZ_CUST_ACCOUNTS
This table hold information related to customer account like account_number. The primary key in this table is cust_account_id. We can join this table with HZ_PARTIES using partying.
HZ_LOCATIONS:
This table holds the address information related to party . Important fields in this table are address, address2 , address3 , city, state, county , country, address_style. Primary key in this table location_id .
HZ_PARTY_SITES
HZ_PARTY_SITE_USES_ALL
HZ_CUST_ACCT_SITES_ALL
Hz_CUST_SITE_USES_ALL
HZ_RELATIONSHIPS
HZ_CONTACT_POINTS
HZ_CUST_ACCOUNT_ROLES
HZ_CUSTOMER_PROFILES
HZ_CUST_PROFILE_CLASSES
Query:
Select hp.party_name,hp.party_id,hca.account_number
,hca.cust_account_id
,hl.address1
, hl.address2
, hl.city
, hl.country
,hl.state
,hps.party_site_id
From
HZ_PARTIES hp
, HZ_CUST_ACCOUNTS hca
, HZ_LOCATIONS hl
, HZ_PARTY_SITES hps
Where 1=1
and hp.party_id=hca.party_id
and hp.party_id=hps.party_id
and hl.location_id=hps.location_id