FND Design Data [Home] [Help]

Lookup Type: HZ_ORGANIZATION_PROFILES

Product: AR - Receivables
Meaning: List of attributes of the HZ_ORGANIZATION_PROFILES table
Description: A lookup table listing the attributes of the HZ_ORGANIZATION_PROFILES
Quick Codes
Code Meaning Description
ANALYSIS_FY Financial Information Fiscal Year Financial Information Fiscal Year
BANK_CODE Bank Code Bank Code
BANK_OR_BRANCH_NUMBER Bank or Branch Number Bank or Branch Number
BEST_TIME_CONTACT_BEGIN Beginning of Best Time to Contact Beginning of Best Time to Contact
BEST_TIME_CONTACT_END End of Best Time to Contact End of Best Time to Contact
BRANCH_CODE Branch Code Branch Code
BRANCH_FLAG Branch Indicator Branch Indicator
BUSINESS_SCOPE Business Scope Business Scope
CEO_NAME CEO Name CEO Name
CEO_TITLE CEO Title CEO Title
CONG_DIST_CODE Congressional District Code Congressional District Code
CONTROL_YR Control Year Control Year
CORPORATION_CLASS Corporation Class Corporation Class
CURR_FY_POTENTIAL_REVENUE Current Fiscal Year Potential Revenue Current Fiscal Year Potential Revenue
DB_RATING D&B Credit Rating D&B Credit Rating
DISADV_8A_IND Disadvantaged 8A Indicator Disadvantaged 8A Indicator
DISPLAYED_DUNS_PARTY_ID Displayed DUNS Party Identifier Displayed DUNS Party Identifier
DO_NOT_CONFUSE_WITH Similarly Named Business Similarly Named Business
DUNS_NUMBER_C DUNS Number DUNS Number
EMPLOYEES_TOTAL Total Employees Total Employees
EMP_AT_PRIMARY_ADR Employees at Primary Address Employees at Primary Address
EMP_AT_PRIMARY_ADR_EST_IND Employees at Primary Address Estimated Indicator Employees at Primary Address Estimated Indicator
EMP_AT_PRIMARY_ADR_MIN_IND Employees at Primary Address Minimum Indicator Employees at Primary Address Minimum Indicator
EMP_AT_PRIMARY_ADR_TEXT Employees at Primary Address Text Employees at Primary Address Text
ENQUIRY_DUNS Enquiry DUNS Number Enquiry DUNS Number
EXPORT_IND Export Indicator Export Indicator
FISCAL_YEAREND_MONTH Fiscal Year Ending Month Fiscal Year Ending Month
GSA_INDICATOR_FLAG GSA Indicator GSA Indicator
HOME_COUNTRY Home Country Home Country
HQ_BRANCH_IND Headquarters or Branch Indicator Headquarters or Branch Indicator
IMPORT_IND Import Indicator Import Indicator
INCORP_YEAR Incorporation Year Incorporation Year
INTERNAL_FLAG Internal Organization Indicator Internal Organization Indicator
JGZZ_FISCAL_CODE Taxpayer Identification Number Taxpayer Identification Number
KNOWN_AS Alias Alias
KNOWN_AS2 Alias 2 Alias 2
KNOWN_AS3 Alias 3 Alias 3
KNOWN_AS4 Alias 4 Alias 4
KNOWN_AS5 Alias 5 Alias 5
LABOR_SURPLUS_IND Labor Surplus Indicator Labor Surplus Indicator
LEGAL_STATUS Legal Status Legal Status
LINE_OF_BUSINESS Line of Business Line of Business
LOCAL_ACTIVITY_CODE Local Activity Code Local Activity Code
LOCAL_ACTIVITY_CODE_TYPE Local Activity Code Type Local Activity Code Type
LOCAL_BUS_IDENTIFIER Local Business Identifier Local Business Identifier
LOCAL_BUS_IDEN_TYPE Local Business Identifier Type Local Business Identifier Type
MINORITY_OWNED_IND Minority Owned Indicator Minority Owned Indicator
MINORITY_OWNED_TYPE Minority Owned Type Minority Owned Type
MISSION_STATEMENT Mission Statement Mission Statement
NEXT_FY_POTENTIAL_REVENUE Next Fiscal Year Potential Revenue Next Fiscal Year Potential Revenue
OOB_IND Out of Business Indicator Out of Business Indicator
ORGANIZATION_NAME Organization Name Organization Name
ORGANIZATION_NAME_PHONETIC Phonetic Organization Name Phonetic Organization Name
ORGANIZATION_TYPE Organization Type Organization Type
PARENT_SUB_IND Parent Subsidiary Indicator Parent Subsidiary Indicator
PREF_FUNCTIONAL_CURRENCY Preferred Functional Currency Preferred Functional Currency
PRINCIPAL_NAME Principal Name Principal Name
PRINCIPAL_TITLE Principal Title Principal Title
PUBLIC_PRIVATE_OWNERSHIP_FLAG Public or Private Ownership Indicator Public or Private Ownership Indicator
REGISTRATION_TYPE Registration Type Registration Type
RENT_OWN_IND Rent or Own Indicator Rent or Own Indicator
SIC_CODE SIC Code SIC Code
SIC_CODE_TYPE SIC Code Type SIC Code Type
SMALL_BUS_IND Small Business Indicator Small Business Indicator
TAX_NAME Tax Name Tax Name
TAX_REFERENCE Tax Reference Tax Reference
TOTAL_EMPLOYEES_IND Total Employees Indicator Total Employees Indicator
TOTAL_EMPLOYEES_TEXT Total Employees Text Total Employees Text
TOTAL_EMP_EST_IND Total Employees Estimated Indicator Total Employees Estimated Indicator
TOTAL_EMP_MIN_IND Total Employees Minimum Indicator Total Employees Minimum Indicator
TOTAL_PAYMENTS Total Payments Total Payments
WOMAN_OWNED_IND Woman Owned Indicator Woman Owned Indicator
YEAR_ESTABLISHED Year Established Year Established