[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | HZ_PARTY_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | AR |
| FND Design Data: |  AR.HZ_PARTY_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
The HZ_PARTY_INTERFACE table stores information about a party that was retrieved from an external source. Currently this data can be retrieved from Dun & Bradstreet using either the Dun & Bradstreet online or batch download methods. The columns in this table include all the Dun & Bradstreet data elements that are available in the Dun & Bradstreet Global Data Products. The column names are from our data model, but the column definitions currently are based on the data dictionary provided by Dun & Bradstreet.
.
The primary key for this table is PARTY_INTERFACE_ID.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| HZ_PARTY_INTERFACE_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 PARTY_INTERFACE_ID
|
| SYS_IL0000107588C00221$$ | LOB | UNIQUE |
APPS_TS_INTERFACE
|
|
| HZ_PARTY_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
PARTY_ID
|
| HZ_PARTY_INTERFACE_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
GROUP_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PARTY_INTERFACE_ID | NUMBER | (15) | Yes | Party interface identifier |
| PARTY_ID | NUMBER | (15) | Unique party indentifier. Foreign key to the HZ_PARTIES table | |
| DUNS_NUMBER | NUMBER | The DUNS number, a unique, nine-digit identification number assigned to business entities by Dun & Bradstreet | ||
| ENQUIRY_DUNS | NUMBER | 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. | ||
| PARTY_NAME | VARCHAR2 | (360) | Name retrieved from Dun & Bradstreet | |
| KNOWN_AS1 | VARCHAR2 | (240) | An alias or other name by which an organization is known. | |
| KNOWN_AS2 | VARCHAR2 | (240) | An alias or other name by which an organization is known. | |
| KNOWN_AS3 | VARCHAR2 | (240) | An alias or other name by which an organization is known. | |
| KNOWN_AS4 | VARCHAR2 | (240) | An alias or other name by which an organization is known. | |
| KNOWN_AS5 | VARCHAR2 | (240) | An alias or other name by which an organization is known. | |
| ADDRESS1 | VARCHAR2 | (240) | First line of the Identifying address | |
| ADDRESS2 | VARCHAR2 | (240) | Second line of the Identifying address | |
| ADDRESS3 | VARCHAR2 | (240) | Third line of the Identifying address | |
| ADDRESS4 | VARCHAR2 | (240) | Fourth line of the Identifying address | |
| CITY | VARCHAR2 | (60) | City of the Identifying address | |
| STATE | VARCHAR2 | (60) | State of the Identifying address | |
| PROVINCE | VARCHAR2 | (60) | Province of the Identifying address | |
| COUNTY | VARCHAR2 | (60) | County of the Identifying address | |
| POSTAL_CODE | VARCHAR2 | (60) | Postal code of the Identifying address | |
| COUNTRY | VARCHAR2 | (60) | Country of the Identifying address | |
| TELEPHONE_NUMBER | VARCHAR2 | (30) | A telephone number formatted in the local format. The number should not include the country code. | |
| FAX_NUMBER | VARCHAR2 | (30) | A fascimile number formatted in the local format. The number should not include the country code. | |
| PHONE_COUNTRY_CODE | VARCHAR2 | (10) | Country code for international phone numbers. For example, the country code for France is 33. | |
| LOCAL_BUS_IDENTIFIER | VARCHAR2 | (60) | Primary identifier assigned to businesses by government agency, Chamber of Commerce, or other authority. Generally used outside US. | |
| 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. | |
| PREF_FUNCTIONAL_CURRENCY | VARCHAR2 | (30) | Organization's default ISO currency code. | |
| CONTROL_YR | NUMBER | Year when current ownership gained control | ||
| INCORP_YEAR | NUMBER | Year that the business was incorporated. | ||
| YEAR_ESTABLISHED | NUMBER | Year that the organization began doing business. | ||
| EMPLOYEES_TOTAL | NUMBER | Total number of employees | ||
| TOTAL_EMPLOYEES_TEXT | VARCHAR2 | (60) | Total number of employees that cannot be mapped to numeric field. | |
| TOTAL_EMPLOYEES_IND | VARCHAR2 | (30) | Indicates if subsidiaries are included in the calculation of total employees. A for totals that do not include subsidiaries, B for totals that include subsidiaries. | |
| TOTAL_EMP_EST_IND | VARCHAR2 | (30) | Indicates if the employee total is estimated. Y for estimated, N for not either estimated or actual. | |
| TOTAL_EMP_MIN_IND | VARCHAR2 | (30) | Indicates if the number is a minimum, maximum, or average number of total employees. A for minimum, B for maximum, and C for average. | |
| 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 that cannot be mapped to numeric field. | |
| 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 | |
| SIC_CODE1 | VARCHAR2 | (30) | Standard Industry Classification (SIC) code. | |
| SIC_CODE_TYPE | VARCHAR2 | (30) | Version of Standard Industry Classification (SIC) code | |
| LOCAL_ACTIVITY_CODE | VARCHAR2 | (30) | Local activity classification code | |
| LOCAL_ACTIVITY_CODE_TYPE | VARCHAR2 | (30) | Local activity classification code type identifier | |
| LINE_OF_BUSINESS | VARCHAR2 | (240) | Type of business activities performed at this site. | |
| BRANCH_FLAG | VARCHAR2 | (1) | Signifies if this is a branch location. | |
| HQ_BRANCH_IND | VARCHAR2 | (30) | Status of this site. Identifies if the location is the HQ, a branch, or a single location. | |
| LEGAL_STATUS | VARCHAR2 | (30) | Legal structure. For example, partnership, corporation, and so on. | |
| REGISTRATION_TYPE | VARCHAR2 | (30) | Legal Structure. For example partnership, corporation, and so on. | |
| 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. | |
| CEO_NAME | VARCHAR2 | (240) | Name of the chief executive officer | |
| CEO_TITLE | VARCHAR2 | (240) | Formal title of the chief executive officer | |
| PRINCIPAL_TITLE | VARCHAR2 | (240) | Title of the highest ranking person | |
| PRINCIPAL_NAME | VARCHAR2 | (240) | Name of the highest ranking person | |
| PAYDEX_SCORE | VARCHAR2 | (3) | Paydex score for the last 12 months experiences. | |
| PAYDEX_THREE_MONTHS_AGO | VARCHAR2 | (3) | Paydex score three months ago. | |
| PAYDEX_NORM | VARCHAR2 | (3) | Median or average Paydex score for the industry. | |
| AVG_HIGH_CREDIT | NUMBER | Average of all high credit experiences. | ||
| HIGH_CREDIT | NUMBER | Maximum credit of any payment experience. | ||
| TOTAL_PAYMENTS | NUMBER | Total number of payment experiences. | ||
| FINCL_EMBT_IND | VARCHAR2 | (30) | Indicates if open bankruptcy, receivership liquidation, or equivalent exist. Y for situation exists, N for no information. | |
| OOB_IND | VARCHAR2 | (30) | Indicates if this organization is out of business. Y for businesses that are out of business, N for active | |
| CRIMINAL_PROCEEDING_IND | VARCHAR2 | (30) | Indicates if criminal proceedings exist against this party. Y for criminal proceedings exist, N for no information. | |
| DISASTER_IND | VARCHAR2 | (30) | Indicates if information exists about disasters such as fires, hurricanes, and so on. Y for diaster information exists available, N for no information. | |
| FINCL_LGL_EVENT_IND | VARCHAR2 | (30) | Indicates if special events are available including financial embarrassment and legal filings. Y for legal filings exist, N for no information. | |
| OPRG_SPEC_EVNT_IND | VARCHAR2 | (30) | Indicates if information exists about operational changes such as name changes and management changes. Y for information about changes exist, N for no information. | |
| OTHER_SPEC_EVNT_IND | VARCHAR2 | (30) | Indicates if special events exist that are not otherwise specified. Y for information about events exists, N for no information. | |
| DET_HISTORY_IND | VARCHAR2 | (30) | Code that indicates if detrimental information exists for the party and whether complete details exist on management and the party. Y for information is available, N for no information. | |
| SUIT_JUDGE_IND | VARCHAR2 | (30) | Indicates if open suits, judgments, petitions, or payment remarks exist for the party and whether complete details exist on management and the party. Y for information is available, N for no information. | |
| CLAIMS_IND | VARCHAR2 | (30) | Indicates if open claims, legal claims, liens, protested bills or equivalent exist for the party and whether complete details exist on management and the party. Y for claims information exists, N for no information. | |
| SECURED_FLNG_IND | VARCHAR2 | (30) | Indicates if open secured filings such as UCC filings, secured charges/mortgages pledgings or equivalent exist for the party and whether complete details exist on management and the party. Y for information about filings exist, N for no information. | |
| CASH_LIQ_ASSETS | NUMBER | Cash and other liquid assets. Lookup code stored in the FINANCIAL_NUMBER and HZ_PARTY_INTERFACE, FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| ACCOUNTS_RECEIVABLE | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and HZ_PARTY_INTERFACE FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| ACCOUNTS_PAYABLE | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| CAPITAL_AMOUNT | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| CAPITAL_TYPE_IND | VARCHAR2 | (30) | Lookup signifying type of Capital. | |
| CAPITAL_CURRENCY_CODE | VARCHAR2 | (30) | Currency code for the currency used for the CAPITAL_AMOUNT column | |
| INVENTORY | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| FIXED_ASSETS | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| TOTAL_CURRENT_ASSETS | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS | ||
| TOTAL_CURR_LIABILITIES | NUMBER | Total current liabilities. Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| TOTAL_ASSETS | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| INTANGIBLE_ASSETS | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| LONG_TERM_DEBT | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| TOT_LONG_TERM_LIAB | NUMBER | Total long-term liabilities. Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| TOTAL_LIABILITIES | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| RETAINED_EARNINGS | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| DIVIDENDS | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| NET_WORTH | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| TANGIBLE_NET_WORTH | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| TANGIBLE_NET_WORTH_IND | VARCHAR2 | (30) | Indicates if the party has tangible net worth information. | |
| TANGIBLE_NET_WORTH_CURR | VARCHAR2 | (30) | Currency code that the tangible net worth is displayed in | |
| TOTAL_LIAB_EQUITY | NUMBER | Total liabilities and equity. Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_PARTY_INTERFACE HZ_FINANCIAL_NUMBERS table. | ||
| SALES | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| ANNUAL_SALES_VOLUME | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| ANNUAL_SALES_EST_IND | VARCHAR2 | (30) | Indicates if annual sales are estimated or not. Y for estimated, N for either not estimated or actual. | |
| ANNUAL_SALES_CONSOL_IND | VARCHAR2 | (30) | Indicates if annual sales are consolidated or not. Y for consolidated, N for not consolidated. | |
| ANNUAL_SALES_CURRENCY | VARCHAR2 | (30) | Currency code that the sales amount is displayed in. | |
| COST_OF_SALES | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| GROSS_INCOME | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| NET_INCOME | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| FINANCIAL_NUMBER_CURRENCY | VARCHAR2 | (240) | Currency code that the financial numbers are displayed in. | |
| INCOME_STMT_START_DATE | DATE | Start date of the income statement for the period | ||
| INCOME_STMT_END_DATE | DATE | End date of the income statement for the period | ||
| INCOME_STMT_DATE | DATE | Date that the Income Statement was issued. | ||
| STATEMENT_DATE | DATE | Date that the Financial Statement was issued. | ||
| AUDIT_IND | VARCHAR2 | (30) | Indicates if the accounts are audited or not. Y for audited, N for not audited. | |
| CONSOLIDATED_IND | VARCHAR2 | (30) | Indicates if the data is consolidated or not. Y for consolidated, N for not consolidated. | |
| ESTIMATED_IND | VARCHAR2 | (30) | Indicates if the data is estimated or not. Y for estimated, N for a number that is measured or actual. | |
| FORECAST_IND | VARCHAR2 | (30) | Indicates if the data is a future projection or not. Y for forecast, N for historical data. | |
| FISCAL_IND | VARCHAR2 | (30) | Indicates if the data is for a fiscal year accounting period. Y for a fiscal year, N for a calendar year. | |
| FINAL_IND | VARCHAR2 | (30) | Indicates if the data is from the final closing statement for a business which has ceased operations. Y for a final statement, N for normal business activity. | |
| SIGNED_BY_PRINCIPALS_IND | VARCHAR2 | (30) | Indicates if the financial reports were signed by the principals of the organization. Y for signed reports, N for unsigned reports. | |
| RESTATED_IND | VARCHAR2 | (30) | Indicates if the financial reports include data that was corrected after the original financial reports. Y for restated, N for the original numbers. | |
| UNBALANCED_IND | VARCHAR2 | (30) | Indicates if the financial reports include balance sheet accounts that do not balance. Y for reports that include unbalanced balance sheet accounts. N for reports that only include balanced accounts. | |
| QUALIFIED_IND | VARCHAR2 | (30) | Indicates if the financial reports include qualifying remarks from auditors about the fairness and accuracy of the numbers. Y for reports qualified by auditors, N for reports that have nott been qualified. | |
| OPENING_IND | VARCHAR2 | (30) | Indicates if the financial reports are the opening statements for a business. Y for opening statements, N for normal operations. | |
| PROFORMA_IND | VARCHAR2 | (30) | A value of "Y" means that the numbers are pro forma numbers, "N" means the numbers are normal numbers. | |
| TRIAL_BALANCE_IND | VARCHAR2 | (30) | Indicates if the financial reports include trial balance numbers. Y for trial balance numbers, N for normal numbers. | |
| CURRENT_RATIO | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| QUICK_RATIO | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| 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 a firm that does not export. | |
| DB_RATING | VARCHAR2 | (5) | Dun & Bradstreet credit rating. | |
| GLOBAL_FAILURE_SCORE | VARCHAR2 | (5) | Global score that indicates the risk of business default. | |
| MAX_CREDIT_RECOMMEND | NUMBER | Maximum credit recommended for this organization. | ||
| MAX_CREDIT_CURRENCY | VARCHAR2 | (30) | Currency code that the sales amount is displayed in. | |
| HQ_DUNS_NUMBER | NUMBER | DUNS number of the headquarters company | ||
| HQ_NAME | VARCHAR2 | (360) | Name of the headquarters company | |
| HQ_COUNTRY | VARCHAR2 | (60) | Country where the headquarters ultimate company is based. | |
| PARENT_DUNS_NUMBER | NUMBER | DUNS number of the parent company | ||
| PARENT_NAME | VARCHAR2 | (360) | Name of the parent company | |
| PARENT_COUNTRY | VARCHAR2 | (60) | Country where the parent company is based. | |
| DOM_ULT_DUNS_NUMBER | NUMBER | DUNS number of the domestic ultimate company | ||
| DOM_ULT_NAME | VARCHAR2 | (360) | Name of the domestic ultimate company | |
| DOM_ULT_COUNTRY | VARCHAR2 | (60) | Country where the domestic ultimate company is based. | |
| GLB_ULT_DUNS_NUMBER | NUMBER | DUNS number of the global ultimate company | ||
| GLB_ULT_NAME | VARCHAR2 | (360) | Name of the global ultimate company. | |
| GLB_ULT_COUNTRY | VARCHAR2 | (60) | Country where the global ultimate company is based. | |
| PARENT_SUB_IND | VARCHAR2 | (30) | Indicates if organization is a parent or subsidiary. P for parent, S for subsidiary. | |
| CONG_DIST_CODE1 | VARCHAR2 | (2) | US Congressional District | |
| 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. | |
| 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. | |
| 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. | |
| 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. | |
| 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. | |
| DEBARMENTS_COUNT | NUMBER | Count of filings by government agencies in the United States that prohibit the party from entering into contracts or transactions with those agencies. | ||
| DEBARMENTS_DATE | DATE | Date of the most recent filing to prohibit the party from entering into contracts or transactions with a government agency in the United States. | ||
| PROFIT_BEFORE_TAX | NUMBER | Lookup code that gets stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| PREVIOUS_NET_WORTH | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| PREVIOUS_SALES | NUMBER | Lookup code stored in the FINANCIAL_NUMBER and FINANCIAL_NUMBER_NAME columns of the HZ_FINANCIAL_NUMBERS table. | ||
| CREDIT_SCORE | VARCHAR2 | (30) | Value calculated by Dun & Bradstreet to predict the probability of delinquent payments by this party. | |
| CREDIT_SCORE_COMMENTARY1 | VARCHAR2 | (30) | Comments explaining the credit score | |
| CREDIT_SCORE_COMMENTARY2 | VARCHAR2 | (30) | Comments explaining the credit score | |
| CREDIT_SCORE_COMMENTARY3 | VARCHAR2 | (30) | Comments explaining the credit score | |
| CREDIT_SCORE_COMMENTARY4 | VARCHAR2 | (30) | Comments explaining the credit score | |
| CREDIT_SCORE_COMMENTARY5 | VARCHAR2 | (30) | Comments explaining the credit score | |
| CREDIT_SCORE_COMMENTARY6 | VARCHAR2 | (30) | Comments explaining the credit score | |
| CREDIT_SCORE_COMMENTARY7 | VARCHAR2 | (30) | Comments explaining the credit score | |
| CREDIT_SCORE_COMMENTARY8 | VARCHAR2 | (30) | Comments explaining the credit score | |
| CREDIT_SCORE_COMMENTARY9 | VARCHAR2 | (30) | Comments explaining the credit score | |
| CREDIT_SCORE_COMMENTARY10 | VARCHAR2 | (30) | Comments explaining the credit score | |
| CREDIT_SCORE_CLASS | NUMBER | For US-based parties the possible values of 1 to 5 indicate credit score classes. | ||
| CREDIT_SCORE_NATL_PERCENTILE | NUMBER | Credit score national percentile | ||
| CREDIT_SCORE_INCD_DEFAULT | NUMBER | Credit score incidence of default | ||
| CREDIT_SCORE_AGE | NUMBER | Not currently used | ||
| CREDIT_SCORE_DATE | DATE | Not currently used | ||
| FAILURE_SCORE | VARCHAR2 | (30) | Value calculated by Dun & Bradstreet to predict the probability of severe financial distress or failure. For US-based parties the possible values of 1 to 5 indicate Failure Risk Classes. For Canadian parties, the possible values of 1 to 10 is the Stability Score which indicates the risk of business closure. For Australian parties, this field contains the failure score expressed as a percentage probability of failure. | |
| FAILURE_SCORE_COMMENTARY1 | VARCHAR2 | (30) | Indicator explaining failure score | |
| FAILURE_SCORE_COMMENTARY2 | VARCHAR2 | (30) | Indicator explaining failure score | |
| FAILURE_SCORE_COMMENTARY3 | VARCHAR2 | (30) | Indicator explaining failure score | |
| FAILURE_SCORE_COMMENTARY4 | VARCHAR2 | (30) | Indicator explaining failure score | |
| FAILURE_SCORE_COMMENTARY5 | VARCHAR2 | (30) | Indicator explaining failure score | |
| FAILURE_SCORE_COMMENTARY6 | VARCHAR2 | (30) | Indicator explaining failure score | |
| FAILURE_SCORE_COMMENTARY7 | VARCHAR2 | (30) | Indicator explaining failure score | |
| FAILURE_SCORE_COMMENTARY8 | VARCHAR2 | (30) | Indicator explaining failure score | |
| FAILURE_SCORE_COMMENTARY9 | VARCHAR2 | (30) | Indicator explaining failure score | |
| FAILURE_SCORE_COMMENTARY10 | VARCHAR2 | (30) | Indicator explaining failure score | |
| FAILURE_SCORE_CLASS | NUMBER | Value calculated by Dun & Bradstreet to predict the probability of severe financial distress or failure. For US-based parties, the possible values of 1 to 5 indicate failure risk classes. | ||
| FAILURE_SCORE_NATL_PERCENTILE | NUMBER | National percentile that reflects the relative ranking of a company among all the companies scored in the local country database. | ||
| FAILURE_SCORE_INCD_DEFAULT | NUMBER | Failure score incidence of default | ||
| FAILURE_SCORE_AGE | NUMBER | Not currently used | ||
| FAILURE_SCORE_OVERRIDE_CODE | VARCHAR2 | (30) | In Europe, this code indicates the reason for variance between the Dun & Bradstreet rating and failure score. In the US,the code indicates the reason no score was calculated, or that the score is equal to zero. | |
| FAILURE_SCORE_DATE | DATE | Not currently used | ||
| SIC_CODE2 | VARCHAR2 | (30) | Standard Industry Classification (SIC) code | |
| HQ_ADDRESS1 | VARCHAR2 | (240) | First line of the address for the party that serves as the headquarters for this party. | |
| HQ_CITY | VARCHAR2 | (60) | City location of the party that serves as the headquarters for this party. | |
| HQ_PRIMARY_GEO_AREA | VARCHAR2 | (60) | Geographic area of the location of the party that serves as the headquarters for this party. | |
| HQ_COUNTY | VARCHAR2 | (60) | County location the party that serves as the headquarters for this party. | |
| HQ_POSTAL_CODE | VARCHAR2 | (60) | Postal code of the party that serves as the headquarters for this party. | |
| HQ_PHONE_NUMBER | VARCHAR2 | (60) | Headquarters phone number | |
| PARENT_ADDRESS1 | VARCHAR2 | (240) | Address line 1 for the parent company. | |
| PARENT_CITY | VARCHAR2 | (60) | City where parent company is located. | |
| PARENT_PRIMARY_GEO_AREA | VARCHAR2 | (60) | Primary geographic area where parent company is located. | |
| PARENT_COUNTY | VARCHAR2 | (60) | County where parent company is located. | |
| PARENT_POSTAL_CODE | VARCHAR2 | (60) | Parent company location's postal code. | |
| PARENT_PHONE_NUMBER | VARCHAR2 | (60) | Telephone number of the party that has a parent relationship to this party | |
| DOM_ULT_ADDRESS1 | VARCHAR2 | (240) | Address line 1 for the domestic ultimate company. | |
| DOM_ULT_CITY | VARCHAR2 | (60) | City where domestic ultimate company is located | |
| DOM_ULT_PRIMARY_GEO_AREA | VARCHAR2 | (60) | Primary geographic area where domestic ultimate company is located | |
| DOM_ULT_COUNTY | VARCHAR2 | (60) | County where domestic ultimate company is located | |
| DOM_ULT_POSTAL_CODE | VARCHAR2 | (60) | Domestic ultimate company location's postal code | |
| DOM_ULT_PHONE_NUMBER | VARCHAR2 | (60) | Domestic ultimate company's phone number | |
| GLB_ULT_ADDRESS1 | VARCHAR2 | (240) | Address line 1 for the global ultimate company | |
| GLB_ULT_CITY | VARCHAR2 | (60) | City where global ultimate company is located | |
| GLB_ULT_PRIMARY_GEO_AREA | VARCHAR2 | (60) | Primary geographic area where global ultimate company is located | |
| GLB_ULT_COUNTY | VARCHAR2 | (60) | County where global ultimate company is located | |
| GLB_ULT_POSTAL_CODE | VARCHAR2 | (60) | Global ultimate company location's postal code | |
| GLB_ULT_PHONE_NUMBER | VARCHAR2 | (60) | Global ultimate company's phone number | |
| CONTENT_SOURCE_TYPE | VARCHAR2 | (30) | Source of data content | |
| STATUS | VARCHAR2 | (30) | Status | |
| GDP_NAME | VARCHAR2 | (30) | Name of Dun & Bradstreet Global Data Product | |
| GROUP_ID | NUMBER | (15) | Group identifier | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| 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). | |
| 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). | ||
| BUSINESS_REPORT | CLOB | (4000) | Dun & Bradstreet Business Information Report. | |
| REQUEST_LOG_ID | NUMBER | (15) | Foreign key reference to the HZ_DNB_REQUEST_LOG table | |
| PREVIOUS_WORKING_CAPITAL | NUMBER | Working Capital (Current Assets minus Current Liabilities) for previous period. | ||
| ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) | Unique party identifier from foreign or legacy system | |
| SIC_CODE3 | VARCHAR2 | (30) | Standard Industry Classification (SIC) code | |
| SIC_CODE4 | VARCHAR2 | (30) | Standard Industry Classification (SIC) code | |
| SIC_CODE5 | VARCHAR2 | (30) | Standard Industry Classification (SIC) code | |
| DO_NOT_CONFUSE_WITH | VARCHAR2 | (255) | Indicates existence of similarly named business. | |
| CREDIT_SCORE_OVERRIDE_CODE | VARCHAR2 | (30) | Credit Score. In the US, indicates why no score was calculated, or why score equals zero. | |
| CR_SCR_CLAS_EXPL | VARCHAR2 | (30) | Explains numeric credit risk score, which estimates the risk of delinquent payment over the next 12 months. | |
| LOW_RNG_DELQ_SCR | NUMBER | Specifies the low end of the range of the Commercial Credit Score. | ||
| HIGH_RNG_DELQ_SCR | NUMBER | Specifies the high end of the range of the Commercial Credit Score. | ||
| DELQ_PMT_RNG_PRCNT | NUMBER | Specifies a delinquency percentage for a Credit Score range. | ||
| DELQ_PMT_PCTG_FOR_ALL_FIRMS | NUMBER | Specifies a delinquency percentage for all firms. | ||
| NUM_TRADE_EXPERIENCES | NUMBER | Payment information experienced by a company's creditors. | ||
| PAYDEX_FIRM_DAYS | VARCHAR2 | (15) | Number of days used in the Paydex score. | |
| PAYDEX_FIRM_COMMENT | VARCHAR2 | (60) | Comment on the Paydex score for the organization. | |
| PAYDEX_INDUSTRY_DAYS | VARCHAR2 | (15) | Number of days used in the Paydex score for the industry. | |
| PAYDEX_INDUSTRY_COMMENT | VARCHAR2 | (50) | Comment on the Paydex score for the industry. | |
| PAYDEX_COMMENT | VARCHAR2 | (240) | Additional Paydex information. | |
| SUIT_IND | VARCHAR2 | (1) | Indicates if open suits exist. Y if any open suit exists, N if no open suits exist. | |
| LIEN_IND | VARCHAR2 | (1) | Indicates if open liens exist. Y if any open lien exists, N if no open liens exist. | |
| JUDGEMENT_IND | VARCHAR2 | (1) | Indicates if open judgements exist. Y if any open judgements exist, N if no open judgements exist. | |
| BANKRUPTCY_IND | VARCHAR2 | (1) | Indicates if open bankruptcy exists. Y if any open bankruptcy exists, N if no open bankruptcy exists. | |
| NO_TRADE_IND | VARCHAR2 | (1) | Indicates no trade experiences exist in the D&B database. | |
| PRNT_HQ_BKCY_IND | VARCHAR2 | (1) | Indicates if Parent (P) or Headquarters (H) entered into bankruptcy. | |
| NUM_PRNT_BKCY_FILING | NUMBER | Number of bankruptcies filed by the parent. | ||
| PRNT_BKCY_FILG_TYPE | VARCHAR2 | (20) | Type of bankruptcy filed by the parent. | |
| PRNT_BKCY_FILG_CHAPTER | NUMBER | Chapter number of the bankruptcy filed by the parent under US Uniform Commercial Code. | ||
| PRNT_BKCY_FILG_DATE | DATE | Bankruptcy filing date of the parent. | ||
| NUM_PRNT_BKCY_CONVS | NUMBER | Number of parent bankruptcy conversions. | ||
| PRNT_BKCY_CONV_DATE | DATE | Date the bankruptcy converted from one type to another. | ||
| PRNT_BKCY_CHAPTER_CONV | VARCHAR2 | (60) | Change of bankruptcy type. | |
| SLOW_TRADE_EXPL | VARCHAR2 | (100) | Conditional comment generated when Paydex score indicates slow trade experiences are present. | |
| NEGV_PMT_EXPL | VARCHAR2 | (150) | Conditional comment generated when negative payments are present. | |
| PUB_REC_EXPL | VARCHAR2 | (150) | Conditional comment generated if suits, liens, and judgments exist. | |
| BUSINESS_DISCONTINUED | VARCHAR2 | (240) | Business discontinued at the listed location. Prompts reader to contact D&B Customer Service Center if this business may be operating. | |
| SPCL_EVENT_COMMENT | VARCHAR2 | (150) | Comment generated if special event section exists. | |
| NUM_SPCL_EVENT | NUMBER | Number of occurrences of the special events. | ||
| SPCL_EVENT_UPDATE_DATE | DATE | Date this special event was updated. | ||
| SPCL_EVNT_TXT | VARCHAR2 | (2000) | Narrative of the special event. | |
| SIC_CODE6 | VARCHAR2 | (30) | Standard Industry Classification (SIC) code |
Cut, paste (and edit) the following text to query this object:
SELECT PARTY_INTERFACE_ID
, PARTY_ID
, DUNS_NUMBER
, ENQUIRY_DUNS
, PARTY_NAME
, KNOWN_AS1
, KNOWN_AS2
, KNOWN_AS3
, KNOWN_AS4
, KNOWN_AS5
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, STATE
, PROVINCE
, COUNTY
, POSTAL_CODE
, COUNTRY
, TELEPHONE_NUMBER
, FAX_NUMBER
, PHONE_COUNTRY_CODE
, LOCAL_BUS_IDENTIFIER
, LOCAL_BUS_IDEN_TYPE
, PREF_FUNCTIONAL_CURRENCY
, CONTROL_YR
, INCORP_YEAR
, YEAR_ESTABLISHED
, EMPLOYEES_TOTAL
, TOTAL_EMPLOYEES_TEXT
, TOTAL_EMPLOYEES_IND
, TOTAL_EMP_EST_IND
, TOTAL_EMP_MIN_IND
, EMP_AT_PRIMARY_ADR
, EMP_AT_PRIMARY_ADR_TEXT
, EMP_AT_PRIMARY_ADR_EST_IND
, EMP_AT_PRIMARY_ADR_MIN_IND
, SIC_CODE1
, SIC_CODE_TYPE
, LOCAL_ACTIVITY_CODE
, LOCAL_ACTIVITY_CODE_TYPE
, LINE_OF_BUSINESS
, BRANCH_FLAG
, HQ_BRANCH_IND
, LEGAL_STATUS
, REGISTRATION_TYPE
, RENT_OWN_IND
, CEO_NAME
, CEO_TITLE
, PRINCIPAL_TITLE
, PRINCIPAL_NAME
, PAYDEX_SCORE
, PAYDEX_THREE_MONTHS_AGO
, PAYDEX_NORM
, AVG_HIGH_CREDIT
, HIGH_CREDIT
, TOTAL_PAYMENTS
, FINCL_EMBT_IND
, OOB_IND
, CRIMINAL_PROCEEDING_IND
, DISASTER_IND
, FINCL_LGL_EVENT_IND
, OPRG_SPEC_EVNT_IND
, OTHER_SPEC_EVNT_IND
, DET_HISTORY_IND
, SUIT_JUDGE_IND
, CLAIMS_IND
, SECURED_FLNG_IND
, CASH_LIQ_ASSETS
, ACCOUNTS_RECEIVABLE
, ACCOUNTS_PAYABLE
, CAPITAL_AMOUNT
, CAPITAL_TYPE_IND
, CAPITAL_CURRENCY_CODE
, INVENTORY
, FIXED_ASSETS
, TOTAL_CURRENT_ASSETS
, TOTAL_CURR_LIABILITIES
, TOTAL_ASSETS
, INTANGIBLE_ASSETS
, LONG_TERM_DEBT
, TOT_LONG_TERM_LIAB
, TOTAL_LIABILITIES
, RETAINED_EARNINGS
, DIVIDENDS
, NET_WORTH
, TANGIBLE_NET_WORTH
, TANGIBLE_NET_WORTH_IND
, TANGIBLE_NET_WORTH_CURR
, TOTAL_LIAB_EQUITY
, SALES
, ANNUAL_SALES_VOLUME
, ANNUAL_SALES_EST_IND
, ANNUAL_SALES_CONSOL_IND
, ANNUAL_SALES_CURRENCY
, COST_OF_SALES
, GROSS_INCOME
, NET_INCOME
, FINANCIAL_NUMBER_CURRENCY
, INCOME_STMT_START_DATE
, INCOME_STMT_END_DATE
, INCOME_STMT_DATE
, STATEMENT_DATE
, AUDIT_IND
, CONSOLIDATED_IND
, ESTIMATED_IND
, FORECAST_IND
, FISCAL_IND
, FINAL_IND
, SIGNED_BY_PRINCIPALS_IND
, RESTATED_IND
, UNBALANCED_IND
, QUALIFIED_IND
, OPENING_IND
, PROFORMA_IND
, TRIAL_BALANCE_IND
, CURRENT_RATIO
, QUICK_RATIO
, IMPORT_IND
, EXPORT_IND
, DB_RATING
, GLOBAL_FAILURE_SCORE
, MAX_CREDIT_RECOMMEND
, MAX_CREDIT_CURRENCY
, HQ_DUNS_NUMBER
, HQ_NAME
, HQ_COUNTRY
, PARENT_DUNS_NUMBER
, PARENT_NAME
, PARENT_COUNTRY
, DOM_ULT_DUNS_NUMBER
, DOM_ULT_NAME
, DOM_ULT_COUNTRY
, GLB_ULT_DUNS_NUMBER
, GLB_ULT_NAME
, GLB_ULT_COUNTRY
, PARENT_SUB_IND
, CONG_DIST_CODE1
, LABOR_SURPLUS_IND
, SMALL_BUS_IND
, WOMAN_OWNED_IND
, MINORITY_OWNED_IND
, DISADV_8A_IND
, DEBARMENTS_COUNT
, DEBARMENTS_DATE
, PROFIT_BEFORE_TAX
, PREVIOUS_NET_WORTH
, PREVIOUS_SALES
, CREDIT_SCORE
, CREDIT_SCORE_COMMENTARY1
, 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
, CREDIT_SCORE_CLASS
, CREDIT_SCORE_NATL_PERCENTILE
, CREDIT_SCORE_INCD_DEFAULT
, CREDIT_SCORE_AGE
, CREDIT_SCORE_DATE
, FAILURE_SCORE
, FAILURE_SCORE_COMMENTARY1
, 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
, FAILURE_SCORE_CLASS
, FAILURE_SCORE_NATL_PERCENTILE
, FAILURE_SCORE_INCD_DEFAULT
, FAILURE_SCORE_AGE
, FAILURE_SCORE_OVERRIDE_CODE
, FAILURE_SCORE_DATE
, SIC_CODE2
, HQ_ADDRESS1
, HQ_CITY
, HQ_PRIMARY_GEO_AREA
, HQ_COUNTY
, HQ_POSTAL_CODE
, HQ_PHONE_NUMBER
, PARENT_ADDRESS1
, PARENT_CITY
, PARENT_PRIMARY_GEO_AREA
, PARENT_COUNTY
, PARENT_POSTAL_CODE
, PARENT_PHONE_NUMBER
, DOM_ULT_ADDRESS1
, DOM_ULT_CITY
, DOM_ULT_PRIMARY_GEO_AREA
, DOM_ULT_COUNTY
, DOM_ULT_POSTAL_CODE
, DOM_ULT_PHONE_NUMBER
, GLB_ULT_ADDRESS1
, GLB_ULT_CITY
, GLB_ULT_PRIMARY_GEO_AREA
, GLB_ULT_COUNTY
, GLB_ULT_POSTAL_CODE
, GLB_ULT_PHONE_NUMBER
, CONTENT_SOURCE_TYPE
, STATUS
, GDP_NAME
, GROUP_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, BUSINESS_REPORT
, REQUEST_LOG_ID
, PREVIOUS_WORKING_CAPITAL
, ORIG_SYSTEM_REFERENCE
, SIC_CODE3
, SIC_CODE4
, SIC_CODE5
, DO_NOT_CONFUSE_WITH
, CREDIT_SCORE_OVERRIDE_CODE
, CR_SCR_CLAS_EXPL
, LOW_RNG_DELQ_SCR
, HIGH_RNG_DELQ_SCR
, DELQ_PMT_RNG_PRCNT
, DELQ_PMT_PCTG_FOR_ALL_FIRMS
, NUM_TRADE_EXPERIENCES
, PAYDEX_FIRM_DAYS
, PAYDEX_FIRM_COMMENT
, PAYDEX_INDUSTRY_DAYS
, PAYDEX_INDUSTRY_COMMENT
, PAYDEX_COMMENT
, SUIT_IND
, LIEN_IND
, JUDGEMENT_IND
, BANKRUPTCY_IND
, NO_TRADE_IND
, PRNT_HQ_BKCY_IND
, NUM_PRNT_BKCY_FILING
, PRNT_BKCY_FILG_TYPE
, PRNT_BKCY_FILG_CHAPTER
, PRNT_BKCY_FILG_DATE
, NUM_PRNT_BKCY_CONVS
, PRNT_BKCY_CONV_DATE
, PRNT_BKCY_CHAPTER_CONV
, SLOW_TRADE_EXPL
, NEGV_PMT_EXPL
, PUB_REC_EXPL
, BUSINESS_DISCONTINUED
, SPCL_EVENT_COMMENT
, NUM_SPCL_EVENT
, SPCL_EVENT_UPDATE_DATE
, SPCL_EVNT_TXT
, SIC_CODE6
FROM AR.HZ_PARTY_INTERFACE;
AR.HZ_PARTY_INTERFACE does not reference any database object
AR.HZ_PARTY_INTERFACE is referenced by following:
AR
HZ_PARTY_INTERFACE#
|
|
|
|