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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed 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
- Enterprise Contracts - Contract Requests Real Time
- Enterprise Contracts - Contracts Real Time
- Order Management - Fulfillment Lines Real Time
- Order Management - Order Headers Real Time
- Order Management - Order Holds Real Time
- Order Management - Order Lines Real Time
- Order Management - Price Adjustments Real Time
- Order Management - Process Instances 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