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.
Problems that run through this table