Oracle E-Business Suite · Schema

Oracle EBS Customer

Schema representing a customer record in Oracle E-Business Suite Trading Community Architecture (TCA). Maps to HZ_PARTIES, HZ_CUST_ACCOUNTS, HZ_PARTY_SITES, HZ_CUST_ACCT_SITES_ALL, and HZ_CUST_SITE_USES_ALL tables. TCA provides a unified model for managing customer, supplier, and partner data.

Business ApplicationsE-Business SuiteEnterpriseERPOracle

Properties

Name Type Description
partyId integer Party identifier (HZ_PARTIES.PARTY_ID)
partyNumber string Party number (system-generated unique identifier)
partyName string Party name (organization name or person full name)
partyType string Party type
category stringnull Customer category code
status string Party status
organizationProfile object Organization profile (when partyType is ORGANIZATION)
personProfile object Person profile (when partyType is PERSON)
customerAccounts array Customer accounts associated with this party
partySites array Party site/address records
contactPoints array Contact points (phone, email, web, etc.)
relationships array Party relationships (contacts, hierarchies)
dunsBNumber stringnull DUNS number
taxPayerIdentificationNumber stringnull Tax identification number
jgzzFiscalCode stringnull Fiscal code (localization)
url stringnull Website URL
emailAddress stringnull Primary email address
primaryPhoneNumber stringnull Primary phone number
createdBy integer
creationDate string
lastUpdatedBy integer
lastUpdateDate string
View JSON Schema on GitHub