[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | HZ_ORGANIZATION_PROFILES |
|---|---|
| Object Type: | TABLE |
| Owner: | AR |
| FND Design Data: |  AR.HZ_ORGANIZATION_PROFILES
|
| Subobject Name: | |
| Status: | VALID |
The HZ_ORGANIZATION_PROFILES table stores a variety of information about a party. This table gets populated when a party of the Organization type is created. This table also contains data retrieved from Dun & Bradstreet using either the Dun & Bradstreet online or batch download methods. Historical data for the organization can also be stored in this table. Each time organization information is changed, the effective end date column for the original record is updated and a new record that contains the updated information is created.
.
The primary key for this table is ORGANIZATION_PROFILE_ID.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| HZ_ORGANIZATION_PROFILES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ORGANIZATION_PROFILE_ID
|
| SYS_IL0000028679C00174$$ | LOB | UNIQUE |
APPS_TS_TX_DATA
|
|
| HZ_ORGANIZATION_PROFILES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARTY_ID
|
| HZ_ORGANIZATION_PROFILES_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DISPLAYED_DUNS_PARTY_ID
|
| HZ_ORGANIZATION_PROFILES_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DUNS_NUMBER_C
|
| HZ_ORGANIZATION_PROFILES_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BANK_OR_BRANCH_NUMBER
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORGANIZATION_PROFILE_ID | NUMBER | (15) | Yes | Unique identifier for organization profiles. |
| PARTY_ID | NUMBER | (15) | Yes | Unique party indentifier. Foreign key to the HZ_PARTIES table |
| ORGANIZATION_NAME | VARCHAR2 | (360) | Yes | Name of a party of the Organization party type |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Not currently used | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Not currently used | |
| DUNS_NUMBER | NUMBER | DUNS number, a unique, nine-digit identification number that is assigned to business entities by Dun & Bradstreet | ||
| ENQUIRY_DUNS | VARCHAR2 | (15) | Identifier used to query the Dun & Bradstreet data. If a location is a branch, then in some countries the headquarters DUNS number is used to do the query. Otherwise it is the same as the DUNS number. | |
| CEO_NAME | VARCHAR2 | (240) | Name of the chief executive officer | |
| CEO_TITLE | VARCHAR2 | (240) | Formal title of the chief executive officer | |
| PRINCIPAL_NAME | VARCHAR2 | (240) | Name of the highest ranking person in the company | |
| PRINCIPAL_TITLE | VARCHAR2 | (240) | Title of the highest ranking person in the company | |
| LEGAL_STATUS | VARCHAR2 | (30) | Legal structure. For example, partnership, corporation, and so on. | |
| CONTROL_YR | NUMBER | Year when current ownership gained control | ||
| EMPLOYEES_TOTAL | NUMBER | Total number of employees | ||
| HQ_BRANCH_IND | VARCHAR2 | (30) | Status of this site. Identifies if the location is the HQ, a branch, or a single location. | |
| BRANCH_FLAG | VARCHAR2 | (1) | Indicates if this is a branch location. Y for branch locations, N for all other locations. | |
| OOB_IND | VARCHAR2 | (30) | Indicates if this organization is out of business. Y for businesses that are out of business, N for active businesses. | |
| LINE_OF_BUSINESS | VARCHAR2 | (240) | Type of business activities performed at this site | |
| CONG_DIST_CODE | VARCHAR2 | (2) | U.S. Congressional District | |
| SIC_CODE | VARCHAR2 | (30) | Standard Industry Classification (SIC) code | |
| IMPORT_IND | VARCHAR2 | (30) | Indicates if this company is an importer. Y for an importer, N for an organization that does not import. | |
| EXPORT_IND | VARCHAR2 | (30) | Indicates if this company is an exporter. Y for an exporter, N for an organization that does not export. | |
| LABOR_SURPLUS_IND | VARCHAR2 | (30) | Indicates if this company operates in an area with a labor surplus. Y for a surplus, N for no surplus exists. | |
| DEBARMENT_IND | VARCHAR2 | (30) | No longer used | |
| MINORITY_OWNED_IND | VARCHAR2 | (30) | Indicates if this company is primarily owned by ethnic or racial minorities. Y for a minority-owned frim, N for a firm that is not owned by minorities | |
| MINORITY_OWNED_TYPE | VARCHAR2 | (30) | The type of minority-owned frim | |
| WOMAN_OWNED_IND | VARCHAR2 | (30) | Indicates if this company is primarily owned by women. Y for a women-owned frim, N for a firm that is not primarily owned by women. | |
| DISADV_8A_IND | VARCHAR2 | (30) | Indicates if this company is considered disadvantaged by the US governement under Title 8A. Y for a Title 8A disadvantaged firm, N for all other firms. | |
| SMALL_BUS_IND | VARCHAR2 | (30) | Indicates if this company is considered to be a small business. Y for small businesses, N for all other firms. | |
| RENT_OWN_IND | VARCHAR2 | (30) | Indicates if this company owns or rents its place of business. Lookup of values for rent, own, lease, and so on. | |
| DEBARMENTS_COUNT | NUMBER | No longer used | ||
| DEBARMENTS_DATE | DATE | No longer used | ||
| FAILURE_SCORE | VARCHAR2 | (30) | No longer used | |
| FAILURE_SCORE_NATL_PERCENTILE | VARCHAR2 | (3) | No longer used | |
| FAILURE_SCORE_OVERRIDE_CODE | VARCHAR2 | (30) | No longer used | |
| FAILURE_SCORE_COMMENTARY | VARCHAR2 | (30) | No longer used | |
| GLOBAL_FAILURE_SCORE | VARCHAR2 | (5) | No longer used | |
| DB_RATING | VARCHAR2 | (5) | Dun & Bradstreet credit rating | |
| CREDIT_SCORE | VARCHAR2 | (30) | No longer used | |
| CREDIT_SCORE_COMMENTARY | VARCHAR2 | (30) | No longer used | |
| PAYDEX_SCORE | VARCHAR2 | (3) | No longer used. | |
| PAYDEX_THREE_MONTHS_AGO | VARCHAR2 | (3) | No longer used. | |
| PAYDEX_NORM | VARCHAR2 | (3) | No longer used. | |
| BEST_TIME_CONTACT_BEGIN | DATE | Beginning of the best period of time to contact the organization | ||
| BEST_TIME_CONTACT_END | DATE | End of the best period of time to contact the organization. | ||
| ORGANIZATION_NAME_PHONETIC | VARCHAR2 | (320) | Japanese Kana, or phonetic representation of organization name | |
| TAX_NAME | VARCHAR2 | (60) | No longer used | |
| TAX_REFERENCE | VARCHAR2 | (50) | Taxpayer registration number, also known as the VAT number. | |
| GSA_INDICATOR_FLAG | VARCHAR2 | (1) | Indicates if this is a US federal agency supported by the General Services Administration (GSA). Y for organizations served by the GSA, N for organizations that are not served by the GSA. | |
| JGZZ_FISCAL_CODE | VARCHAR2 | (20) | Taxpayer identification number, often unique identifier of person or organization. Can be SSN or income taxpayer ID in US, fiscal code or NIF in Europe | |
| ANALYSIS_FY | VARCHAR2 | (5) | Fiscal year used as the source for financial information | |
| FISCAL_YEAREND_MONTH | VARCHAR2 | (30) | Month that the fiscal year ends for organization | |
| CURR_FY_POTENTIAL_REVENUE | NUMBER | Organization's potential revenue for this fiscal year | ||
| NEXT_FY_POTENTIAL_REVENUE | NUMBER | Organization's potential revenue for next fiscal year | ||
| YEAR_ESTABLISHED | NUMBER | (4) | Year that the organization began doing business | |
| MISSION_STATEMENT | VARCHAR2 | (2000) | Corporate charter of organization | |
| ORGANIZATION_TYPE | VARCHAR2 | (30) | User-defined organization types such as region, division, and department | |
| BUSINESS_SCOPE | VARCHAR2 | (20) | The physical class of business in which a business participates. For example, local, national, or international. | |
| CORPORATION_CLASS | VARCHAR2 | (60) | Taxation classification for corporation entities. For example, Chapter S in the US. | |
| KNOWN_AS | VARCHAR2 | (240) | An alias or other name by which an organization is known. | |
| LOCAL_BUS_IDEN_TYPE | VARCHAR2 | (30) | Lookup that represents most common business identifier in a country. For example, Chamber of Commerce Number in Italy, Government Registration Number in Taiwan. | |
| LOCAL_BUS_IDENTIFIER | VARCHAR2 | (60) | Primary identifier assigned to businesses by government agency, Chamber of Commerce, or other authority. Generally used outside US. | |
| PREF_FUNCTIONAL_CURRENCY | VARCHAR2 | (30) | Organization's default currency code. | |
| REGISTRATION_TYPE | VARCHAR2 | (30) | Lookup for type of registration, such as nonprofit. | |
| TOTAL_EMPLOYEES_TEXT | VARCHAR2 | (60) | Total number of personnel employeed if can not be mapped to numeric field. | |
| TOTAL_EMPLOYEES_IND | VARCHAR2 | (30) | Lookup that indicates whether subsidiaries are included in the calculation of total employees A for totals without subsidiaries, B for totals with subsidiaries. | |
| TOTAL_EMP_EST_IND | VARCHAR2 | (30) | Lookup that indicates whether the employee total is estimated. A for estimated, N for not estimated or actual. | |
| TOTAL_EMP_MIN_IND | VARCHAR2 | (30) | Lookup that indicates whether the number is a minimum, maximum, or average number of total employees. A for minimum, B for maximum, and C for average. | |
| PARENT_SUB_IND | VARCHAR2 | (30) | Lookup that indicates if organization is a parent or subsidiary location | |
| INCORP_YEAR | NUMBER | (4) | Year that the business was incorporated | |
| PRIMARY_CONTACT_ID | NUMBER | (15) | No longer used | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| WH_UPDATE_DATE | DATE | No longer used | ||
| REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
| PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
| CONTENT_SOURCE_TYPE | VARCHAR2 | (30) | Yes | Source of data content. |
| CONTENT_SOURCE_NUMBER | VARCHAR2 | (30) | Unique foreign key to data source, such as DUNS number | |
| EFFECTIVE_START_DATE | DATE | Yes | Used for date tracking capabilities | |
| EFFECTIVE_END_DATE | DATE | Used for date tracking capabilities | ||
| SIC_CODE_TYPE | VARCHAR2 | (30) | Version of Standard Industry Classification (SIC) code | |
| PUBLIC_PRIVATE_OWNERSHIP_FLAG | VARCHAR2 | (1) | Indicates if the organization is privately owned. Y for a privately owned organization, N for a publicly owned organization. | |
| LOCAL_ACTIVITY_CODE_TYPE | VARCHAR2 | (30) | Local activity classification code type identifier | |
| LOCAL_ACTIVITY_CODE | VARCHAR2 | (30) | Local activity classification code | |
| EMP_AT_PRIMARY_ADR | VARCHAR2 | (10) | Number of employees at the referenced address | |
| EMP_AT_PRIMARY_ADR_TEXT | VARCHAR2 | (12) | Number of employees at the referenced address which cannot be mapped to a number | |
| EMP_AT_PRIMARY_ADR_EST_IND | VARCHAR2 | (30) | Qualifies calculation of employees at the primary address as estimated | |
| EMP_AT_PRIMARY_ADR_MIN_IND | VARCHAR2 | (30) | Qualifies calculation of employees at the primary address as minimum | |
| INTERNAL_FLAG | VARCHAR2 | (1) | Indicates if this is an internal organization. Y for internal, N for external. | |
| HIGH_CREDIT | NUMBER | No longer used. | ||
| AVG_HIGH_CREDIT | NUMBER | No longer used | ||
| TOTAL_PAYMENTS | NUMBER | Total number of payment experiences | ||
| KNOWN_AS2 | VARCHAR2 | (240) | An alias or other name by which a party is known | |
| KNOWN_AS3 | VARCHAR2 | (240) | An alias or other name by which a party is known | |
| KNOWN_AS4 | VARCHAR2 | (240) | An alias or other name by which a party is known | |
| KNOWN_AS5 | VARCHAR2 | (240) | An alias or other name by which a party is known | |
| CREDIT_SCORE_CLASS | NUMBER | No longer used | ||
| CREDIT_SCORE_NATL_PERCENTILE | NUMBER | No longer used | ||
| CREDIT_SCORE_INCD_DEFAULT | NUMBER | No longer used | ||
| CREDIT_SCORE_AGE | NUMBER | No longer used | ||
| CREDIT_SCORE_DATE | DATE | No longer used | ||
| FAILURE_SCORE_CLASS | NUMBER | No longer used | ||
| FAILURE_SCORE_INCD_DEFAULT | NUMBER | No longer used | ||
| FAILURE_SCORE_AGE | NUMBER | No longer used | ||
| FAILURE_SCORE_DATE | DATE | No longer used | ||
| FAILURE_SCORE_COMMENTARY2 | VARCHAR2 | (30) | No longer used | |
| FAILURE_SCORE_COMMENTARY3 | VARCHAR2 | (30) | No longer used | |
| FAILURE_SCORE_COMMENTARY4 | VARCHAR2 | (30) | No longer used | |
| FAILURE_SCORE_COMMENTARY5 | VARCHAR2 | (30) | No longer used | |
| FAILURE_SCORE_COMMENTARY6 | VARCHAR2 | (30) | No longer used | |
| FAILURE_SCORE_COMMENTARY7 | VARCHAR2 | (30) | No longer used | |
| FAILURE_SCORE_COMMENTARY8 | VARCHAR2 | (30) | No longer used | |
| FAILURE_SCORE_COMMENTARY9 | VARCHAR2 | (30) | No longer used | |
| FAILURE_SCORE_COMMENTARY10 | VARCHAR2 | (30) | No longer used | |
| CREDIT_SCORE_COMMENTARY2 | VARCHAR2 | (30) | No longer used | |
| CREDIT_SCORE_COMMENTARY3 | VARCHAR2 | (30) | No longer used | |
| CREDIT_SCORE_COMMENTARY4 | VARCHAR2 | (30) | No longer used | |
| CREDIT_SCORE_COMMENTARY5 | VARCHAR2 | (30) | No longer used | |
| CREDIT_SCORE_COMMENTARY6 | VARCHAR2 | (30) | No longer used | |
| CREDIT_SCORE_COMMENTARY7 | VARCHAR2 | (30) | No longer used | |
| CREDIT_SCORE_COMMENTARY8 | VARCHAR2 | (30) | No longer used | |
| CREDIT_SCORE_COMMENTARY9 | VARCHAR2 | (30) | No longer used | |
| CREDIT_SCORE_COMMENTARY10 | VARCHAR2 | (30) | No longer used | |
| MAXIMUM_CREDIT_RECOMMENDATION | NUMBER | No longer used. | ||
| MAXIMUM_CREDIT_CURRENCY_CODE | VARCHAR2 | (240) | No longer used. | |
| DISPLAYED_DUNS_PARTY_ID | NUMBER | (15) | Dun & Bradstreet does not maintain data for the branch offices of companies that are located outside of North America. Data is only maintained for the company's headquarters. If the data pertains only to a company's headquarters, this column stores the headquarter's PARTY_ID. If the data pertains to a branch office, this column stores the branch's PARTY_ID. | |
| FAILURE_SCORE_NATNL_PERCENTILE | NUMBER | No longer used | ||
| STATUS | VARCHAR2 | (1) | Record status flag | |
| BUSINESS_REPORT | CLOB | (4000) | Dun & Bradstreet Business Information Report | |
| DUNS_NUMBER_C | VARCHAR2 | (30) | DUNS_NUMBER in VARCHAR format. Column value not restricted to nine digit DUNS Number. | |
| OBJECT_VERSION_NUMBER | NUMBER | This column is used for locking purposes | ||
| CREATED_BY_MODULE | VARCHAR2 | (150) | TCA Who column | |
| APPLICATION_ID | NUMBER | TCA Who column | ||
| BANK_OR_BRANCH_NUMBER | VARCHAR2 | (30) | Stores bank number for banks and branch number for bank branches, primarily ABA number for US bank branches. | |
| BANK_CODE | VARCHAR2 | (30) | Identifies bank in several countries, typically for regulatory purposes. | |
| BRANCH_CODE | VARCHAR2 | (30) | Identifies bank branch in several countries, typically for regulatory purposes. | |
| DO_NOT_CONFUSE_WITH | VARCHAR2 | (255) | Indicates existence of similarly named business. | |
| ACTUAL_CONTENT_SOURCE | VARCHAR2 | (30) | Yes | Additional Content Source Type column for backward compatibility. |
| VERSION_NUMBER | NUMBER | Organization's profile version number | ||
| HOME_COUNTRY | VARCHAR2 | (2) | HOME COUNTRY |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_PROFILE_ID
, PARTY_ID
, ORGANIZATION_NAME
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, DUNS_NUMBER
, ENQUIRY_DUNS
, CEO_NAME
, CEO_TITLE
, PRINCIPAL_NAME
, PRINCIPAL_TITLE
, LEGAL_STATUS
, CONTROL_YR
, EMPLOYEES_TOTAL
, HQ_BRANCH_IND
, BRANCH_FLAG
, OOB_IND
, LINE_OF_BUSINESS
, CONG_DIST_CODE
, SIC_CODE
, IMPORT_IND
, EXPORT_IND
, LABOR_SURPLUS_IND
, DEBARMENT_IND
, MINORITY_OWNED_IND
, MINORITY_OWNED_TYPE
, WOMAN_OWNED_IND
, DISADV_8A_IND
, SMALL_BUS_IND
, RENT_OWN_IND
, DEBARMENTS_COUNT
, DEBARMENTS_DATE
, FAILURE_SCORE
, FAILURE_SCORE_NATL_PERCENTILE
, FAILURE_SCORE_OVERRIDE_CODE
, FAILURE_SCORE_COMMENTARY
, GLOBAL_FAILURE_SCORE
, DB_RATING
, CREDIT_SCORE
, CREDIT_SCORE_COMMENTARY
, PAYDEX_SCORE
, PAYDEX_THREE_MONTHS_AGO
, PAYDEX_NORM
, BEST_TIME_CONTACT_BEGIN
, BEST_TIME_CONTACT_END
, ORGANIZATION_NAME_PHONETIC
, TAX_NAME
, TAX_REFERENCE
, GSA_INDICATOR_FLAG
, JGZZ_FISCAL_CODE
, ANALYSIS_FY
, FISCAL_YEAREND_MONTH
, CURR_FY_POTENTIAL_REVENUE
, NEXT_FY_POTENTIAL_REVENUE
, YEAR_ESTABLISHED
, MISSION_STATEMENT
, ORGANIZATION_TYPE
, BUSINESS_SCOPE
, CORPORATION_CLASS
, KNOWN_AS
, LOCAL_BUS_IDEN_TYPE
, LOCAL_BUS_IDENTIFIER
, PREF_FUNCTIONAL_CURRENCY
, REGISTRATION_TYPE
, TOTAL_EMPLOYEES_TEXT
, TOTAL_EMPLOYEES_IND
, TOTAL_EMP_EST_IND
, TOTAL_EMP_MIN_IND
, PARENT_SUB_IND
, INCORP_YEAR
, PRIMARY_CONTACT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, WH_UPDATE_DATE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CONTENT_SOURCE_TYPE
, CONTENT_SOURCE_NUMBER
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, SIC_CODE_TYPE
, PUBLIC_PRIVATE_OWNERSHIP_FLAG
, LOCAL_ACTIVITY_CODE_TYPE
, LOCAL_ACTIVITY_CODE
, EMP_AT_PRIMARY_ADR
, EMP_AT_PRIMARY_ADR_TEXT
, EMP_AT_PRIMARY_ADR_EST_IND
, EMP_AT_PRIMARY_ADR_MIN_IND
, INTERNAL_FLAG
, HIGH_CREDIT
, AVG_HIGH_CREDIT
, TOTAL_PAYMENTS
, KNOWN_AS2
, KNOWN_AS3
, KNOWN_AS4
, KNOWN_AS5
, CREDIT_SCORE_CLASS
, CREDIT_SCORE_NATL_PERCENTILE
, CREDIT_SCORE_INCD_DEFAULT
, CREDIT_SCORE_AGE
, CREDIT_SCORE_DATE
, FAILURE_SCORE_CLASS
, FAILURE_SCORE_INCD_DEFAULT
, FAILURE_SCORE_AGE
, FAILURE_SCORE_DATE
, FAILURE_SCORE_COMMENTARY2
, FAILURE_SCORE_COMMENTARY3
, FAILURE_SCORE_COMMENTARY4
, FAILURE_SCORE_COMMENTARY5
, FAILURE_SCORE_COMMENTARY6
, FAILURE_SCORE_COMMENTARY7
, FAILURE_SCORE_COMMENTARY8
, FAILURE_SCORE_COMMENTARY9
, FAILURE_SCORE_COMMENTARY10
, CREDIT_SCORE_COMMENTARY2
, CREDIT_SCORE_COMMENTARY3
, CREDIT_SCORE_COMMENTARY4
, CREDIT_SCORE_COMMENTARY5
, CREDIT_SCORE_COMMENTARY6
, CREDIT_SCORE_COMMENTARY7
, CREDIT_SCORE_COMMENTARY8
, CREDIT_SCORE_COMMENTARY9
, CREDIT_SCORE_COMMENTARY10
, MAXIMUM_CREDIT_RECOMMENDATION
, MAXIMUM_CREDIT_CURRENCY_CODE
, DISPLAYED_DUNS_PARTY_ID
, FAILURE_SCORE_NATNL_PERCENTILE
, STATUS
, BUSINESS_REPORT
, DUNS_NUMBER_C
, OBJECT_VERSION_NUMBER
, CREATED_BY_MODULE
, APPLICATION_ID
, BANK_OR_BRANCH_NUMBER
, BANK_CODE
, BRANCH_CODE
, DO_NOT_CONFUSE_WITH
, ACTUAL_CONTENT_SOURCE
, VERSION_NUMBER
, HOME_COUNTRY
FROM AR.HZ_ORGANIZATION_PROFILES;
AR.HZ_ORGANIZATION_PROFILES does not reference any database object
AR.HZ_ORGANIZATION_PROFILES is referenced by following:
APPS
HZ_ORGANIZATION_PROFILES
|
|
|
|