Oracle Fusion · Data dictionary
HZ_PARTIES
Trading CommunityUsed in 144 subject areas81 reporting columnsBICC incremental-ready
Trading Community (HZ) — the master party table. Every customer, supplier, or organization starts here.
Primary key: PARTY_ID · Incremental key: LAST_UPDATE_DATE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ADDRESS1 | ● | Address1. | |
| ADDRESS2 | ● | Address2. | |
| ADDRESS3 | ● | Address3. | |
| ADDRESS4 | ● | Address4. | |
| ANALYSIS_FY | ● | Analysis fy. | |
| CATEGORY_CODE | ● | Code identifying the category. | |
| CEO_NAME | ● | Name of the ceo. | |
| CERTIFICATION_LEVEL | ● | Certification level. | |
| CERT_REASON_CODE | ● | Code identifying the cert reason. | |
| CITY | ● | City. | |
| COMMENTS | ● | Comments. | |
| COUNTRY | ● | Country. | |
| COUNTY | ● | County. | |
| CREATED_BY | ● | User who created the row. | |
| CREATED_BY_MODULE | ● | Created by module. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CURR_FY_POTENTIAL_REVENUE | ● | Currency fy potential revenue. | |
| DATE_OF_BIRTH | ● | Date of birth. | |
| DUNS_NUMBER_C | ● | Duns number c. | |
| EMAIL_ADDRESS | ● | Email address. | |
| EMPLOYEES_TOTAL | ● | Employees total. | |
| FISCAL_YEAREND_MONTH | ● | Fiscal yearend month. | |
| GENDER | ● | Gender. | |
| GROUP_TYPE | ● | Type of group. | |
| GSA_INDICATOR_FLAG | ● | Indicator (Y/N) for the gsa indicator. | |
| HOME_COUNTRY | ● | Home country. | |
| HQ_BRANCH_IND | ● | Hq branch ind. | |
| IDEN_ADDR_LOCATION_ID | ● | Identifier for the iden addr location. | |
| IDEN_ADDR_PARTY_SITE_ID | ● | Identifier for the iden addr party site. | |
| INTERNAL_FLAG | ● | Indicator (Y/N) for the internal. | |
| JGZZ_FISCAL_CODE | ● | Code identifying the jgzz fiscal. | |
| LANGUAGE_NAME | ● | Name of the language. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | INCR | ● | Date and time the row was last updated (the incremental-extract key). |
| LAST_UPDATE_LOGIN | ● | Session login of the user who last updated the row. | |
| MARITAL_STATUS | ● | Status of the marital. | |
| MISSION_STATEMENT | ● | Mission statement. | |
| NEXT_FY_POTENTIAL_REVENUE | ● | Next fy potential revenue. | |
| ORIG_SYSTEM_REFERENCE | ● | Orig system reference. | |
| PARTY_ID | PK | ● | Identifier for the party. |
| PARTY_NAME | ● | Name of the party. | |
| PARTY_NUMBER | ● | Party number. | |
| PARTY_TYPE | ● | Type of party. | |
| PARTY_UNIQUE_NAME | ● | Name of the party unique. | |
| PERSON_ACADEMIC_TITLE | ● | Person academic title. | |
| PERSON_FIRST_NAME | ● | Name of the person first. | |
| PERSON_LAST_NAME | ● | Name of the person last. | |
| PERSON_LAST_NAME_PREFIX | ● | Person last name prefix. | |
| PERSON_MIDDLE_NAME | ● | Name of the person middle. | |
| PERSON_NAME_SUFFIX | ● | Person name suffix. | |
| PERSON_PREVIOUS_LAST_NAME | ● | Name of the person previous last. | |
| PERSON_PRE_NAME_ADJUNCT | ● | Person pre name adjunct. | |
| PERSON_SECOND_LAST_NAME | ● | Name of the person second last. | |
| PERSON_TITLE | ● | Person title. | |
| POSTAL_CODE | ● | Code identifying the postal. | |
| PREFERRED_CONTACT_METHOD | ● | Preferred contact method. | |
| PREFERRED_CONTACT_PERSON_ID | ● | Identifier for the preferred contact person. | |
| PREFERRED_NAME | ● | Name of the preferred. | |
| PREFERRED_NAME_ID | ● | Identifier for the preferred name. | |
| PREF_FUNCTIONAL_CURRENCY | ● | Pref functional currency. | |
| PRIMARY_EMAIL_CONTACT_PT_ID | ● | Identifier for the primary email contact pt. | |
| PRIMARY_PHONE_AREA_CODE | ● | Code identifying the primary phone area. | |
| PRIMARY_PHONE_CONTACT_PT_ID | ● | Identifier for the primary phone contact pt. | |
| PRIMARY_PHONE_COUNTRY_CODE | ● | Code identifying the primary phone country. | |
| PRIMARY_PHONE_EXTENSION | ● | Primary phone extension. | |
| PRIMARY_PHONE_LINE_TYPE | ● | Type of primary phone line. | |
| PRIMARY_PHONE_NUMBER | ● | Primary phone number. | |
| PRIMARY_PHONE_PURPOSE | ● | Primary phone purpose. | |
| PRIMARY_URL_CONTACT_PT_ID | ● | Identifier for the primary url contact pt. | |
| PROVINCE | ● | Province. | |
| SALUTATION | ● | Salutation. | |
| SIC_CODE | ● | Code identifying the sic. | |
| SIC_CODE_TYPE | ● | Type of sic code. | |
| STATE | ● | State. | |
| STATUS | ● | Status. | |
| THIRD_PARTY_FLAG | ● | Indicator (Y/N) for the third party. | |
| TRADING_PARTNER_IDENTIFIER | ● | Trading partner identifier. | |
| URL | ● | Url. | |
| USER_GUID | ● | User guid. | |
| VALIDATED_FLAG | ● | Indicator (Y/N) for the validated. | |
| YEAR_ESTABLISHED | ● | Year established. |
10 reports read from this table
Change a column here and these are the reports that move with it — the blast radius for any change to HZ_PARTIES.
- Spain SII Report
- AP Disbursements Report
- Supplier Detail Report
- AR Customer Query Report
- AR Open Claim Summary and Detail Report
- Receipt History Report
- Unclaimed Property Report (United States)
- Receivables Aging Report
- Bad Debt Provision Report
- Customer Account Status Report
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.
- Budgetary Control - Transactions Real Time
- Costing - COGS and Gross Margin Real Time
- Costing - Cost Accounting Real Time
- Costing - Cost Rollup Details Real Time
- Costing - Landed Costs Real Time
- Costing - New COGS and Gross Margin Details Real Time
- Costing - Receipt Accounting Real Time
- Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time
- Costing - Standard Cost Real Time
- Costing - Transfer Order Receipt Landed Cost Charges Real Time
- Costing - Where Used Details Real Time
- Costing - Work Order Costs Real Time
- Distributed Order Orchestration - Fulfillment Lines Real Time
- Distributed Order Orchestration - Order Headers Real Time
- Distributed Order Orchestration - Order Holds Real Time
- Distributed Order Orchestration - Order Lines Real Time
- Distributed Order Orchestration - Price Adjustments Real Time
- Distributed Order Orchestration - Process Instances Real Time
- Enterprise Contracts - Contract Requests Real Time
- Enterprise Contracts - Contracts Real Time
Need the extract + dbt staging for HZ_PARTIES?
We ship parameterized SQL, BICC config, and dbt models you own.