eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: AR.HZ_PARTY_INTERFACE#

Source

View Text - Preformatted


select PARTY_INTERFACE_ID PARTY_INTERFACE_ID, PARTY_ID PARTY_ID, DUNS_NUMBER DUNS_NUMBER, ENQUIRY_DUNS ENQUIRY_DUNS, PARTY_NAME PARTY_NAME, KNOWN_AS1 KNOWN_AS1, KNOWN_AS2 KNOWN_AS2, KNOWN_AS3 KNOWN_AS3, KNOWN_AS4 KNOWN_AS4, KNOWN_AS5 KNOWN_AS5, ADDRESS1 ADDRESS1, ADDRESS2 ADDRESS2, ADDRESS3 ADDRESS3, ADDRESS4 ADDRESS4, CITY CITY, STATE STATE, PROVINCE PROVINCE, COUNTY COUNTY, POSTAL_CODE POSTAL_CODE, COUNTRY COUNTRY, TELEPHONE_NUMBER TELEPHONE_NUMBER, FAX_NUMBER FAX_NUMBER, PHONE_COUNTRY_CODE PHONE_COUNTRY_CODE, LOCAL_BUS_IDENTIFIER LOCAL_BUS_IDENTIFIER, LOCAL_BUS_IDEN_TYPE LOCAL_BUS_IDEN_TYPE, PREF_FUNCTIONAL_CURRENCY PREF_FUNCTIONAL_CURRENCY, CONTROL_YR CONTROL_YR, INCORP_YEAR INCORP_YEAR, YEAR_ESTABLISHED YEAR_ESTABLISHED, EMPLOYEES_TOTAL EMPLOYEES_TOTAL, TOTAL_EMPLOYEES_TEXT TOTAL_EMPLOYEES_TEXT, TOTAL_EMPLOYEES_IND TOTAL_EMPLOYEES_IND, TOTAL_EMP_EST_IND TOTAL_EMP_EST_IND, TOTAL_EMP_MIN_IND TOTAL_EMP_MIN_IND, EMP_AT_PRIMARY_ADR EMP_AT_PRIMARY_ADR, EMP_AT_PRIMARY_ADR_TEXT EMP_AT_PRIMARY_ADR_TEXT, EMP_AT_PRIMARY_ADR_EST_IND EMP_AT_PRIMARY_ADR_EST_IND, EMP_AT_PRIMARY_ADR_MIN_IND EMP_AT_PRIMARY_ADR_MIN_IND, SIC_CODE1 SIC_CODE1, SIC_CODE_TYPE SIC_CODE_TYPE, LOCAL_ACTIVITY_CODE LOCAL_ACTIVITY_CODE, LOCAL_ACTIVITY_CODE_TYPE LOCAL_ACTIVITY_CODE_TYPE, LINE_OF_BUSINESS LINE_OF_BUSINESS, BRANCH_FLAG BRANCH_FLAG, HQ_BRANCH_IND HQ_BRANCH_IND, LEGAL_STATUS LEGAL_STATUS, REGISTRATION_TYPE REGISTRATION_TYPE, RENT_OWN_IND RENT_OWN_IND, CEO_NAME CEO_NAME, CEO_TITLE CEO_TITLE, PRINCIPAL_TITLE PRINCIPAL_TITLE, PRINCIPAL_NAME PRINCIPAL_NAME, PAYDEX_SCORE PAYDEX_SCORE, PAYDEX_THREE_MONTHS_AGO PAYDEX_THREE_MONTHS_AGO, PAYDEX_NORM PAYDEX_NORM, AVG_HIGH_CREDIT AVG_HIGH_CREDIT, HIGH_CREDIT HIGH_CREDIT, TOTAL_PAYMENTS TOTAL_PAYMENTS, FINCL_EMBT_IND FINCL_EMBT_IND, OOB_IND OOB_IND, CRIMINAL_PROCEEDING_IND CRIMINAL_PROCEEDING_IND, DISASTER_IND DISASTER_IND, FINCL_LGL_EVENT_IND FINCL_LGL_EVENT_IND, OPRG_SPEC_EVNT_IND OPRG_SPEC_EVNT_IND, OTHER_SPEC_EVNT_IND OTHER_SPEC_EVNT_IND, DET_HISTORY_IND DET_HISTORY_IND, SUIT_JUDGE_IND SUIT_JUDGE_IND, CLAIMS_IND CLAIMS_IND, SECURED_FLNG_IND SECURED_FLNG_IND, CASH_LIQ_ASSETS CASH_LIQ_ASSETS, ACCOUNTS_RECEIVABLE ACCOUNTS_RECEIVABLE, ACCOUNTS_PAYABLE ACCOUNTS_PAYABLE, CAPITAL_AMOUNT CAPITAL_AMOUNT, CAPITAL_TYPE_IND CAPITAL_TYPE_IND, CAPITAL_CURRENCY_CODE CAPITAL_CURRENCY_CODE, INVENTORY INVENTORY, FIXED_ASSETS FIXED_ASSETS, TOTAL_CURRENT_ASSETS TOTAL_CURRENT_ASSETS, TOTAL_CURR_LIABILITIES TOTAL_CURR_LIABILITIES, TOTAL_ASSETS TOTAL_ASSETS, INTANGIBLE_ASSETS INTANGIBLE_ASSETS, LONG_TERM_DEBT LONG_TERM_DEBT, TOT_LONG_TERM_LIAB TOT_LONG_TERM_LIAB, TOTAL_LIABILITIES TOTAL_LIABILITIES, RETAINED_EARNINGS RETAINED_EARNINGS, DIVIDENDS DIVIDENDS, NET_WORTH NET_WORTH, TANGIBLE_NET_WORTH TANGIBLE_NET_WORTH, TANGIBLE_NET_WORTH_IND TANGIBLE_NET_WORTH_IND, TANGIBLE_NET_WORTH_CURR TANGIBLE_NET_WORTH_CURR, TOTAL_LIAB_EQUITY TOTAL_LIAB_EQUITY, SALES SALES, ANNUAL_SALES_VOLUME ANNUAL_SALES_VOLUME, ANNUAL_SALES_EST_IND ANNUAL_SALES_EST_IND, ANNUAL_SALES_CONSOL_IND ANNUAL_SALES_CONSOL_IND, ANNUAL_SALES_CURRENCY ANNUAL_SALES_CURRENCY, COST_OF_SALES COST_OF_SALES, GROSS_INCOME GROSS_INCOME, NET_INCOME NET_INCOME, FINANCIAL_NUMBER_CURRENCY FINANCIAL_NUMBER_CURRENCY, INCOME_STMT_START_DATE INCOME_STMT_START_DATE, INCOME_STMT_END_DATE INCOME_STMT_END_DATE, INCOME_STMT_DATE INCOME_STMT_DATE, STATEMENT_DATE STATEMENT_DATE, AUDIT_IND AUDIT_IND, CONSOLIDATED_IND CONSOLIDATED_IND, ESTIMATED_IND ESTIMATED_IND, FORECAST_IND FORECAST_IND, FISCAL_IND FISCAL_IND, FINAL_IND FINAL_IND, SIGNED_BY_PRINCIPALS_IND SIGNED_BY_PRINCIPALS_IND, RESTATED_IND RESTATED_IND, UNBALANCED_IND UNBALANCED_IND, QUALIFIED_IND QUALIFIED_IND, OPENING_IND OPENING_IND, PROFORMA_IND PROFORMA_IND, TRIAL_BALANCE_IND TRIAL_BALANCE_IND, CURRENT_RATIO CURRENT_RATIO, QUICK_RATIO QUICK_RATIO, IMPORT_IND IMPORT_IND, EXPORT_IND EXPORT_IND, DB_RATING DB_RATING, GLOBAL_FAILURE_SCORE GLOBAL_FAILURE_SCORE, MAX_CREDIT_RECOMMEND MAX_CREDIT_RECOMMEND, MAX_CREDIT_CURRENCY MAX_CREDIT_CURRENCY, HQ_DUNS_NUMBER HQ_DUNS_NUMBER, HQ_NAME HQ_NAME, HQ_COUNTRY HQ_COUNTRY, PARENT_DUNS_NUMBER PARENT_DUNS_NUMBER, PARENT_NAME PARENT_NAME, PARENT_COUNTRY PARENT_COUNTRY, DOM_ULT_DUNS_NUMBER DOM_ULT_DUNS_NUMBER, DOM_ULT_NAME DOM_ULT_NAME, DOM_ULT_COUNTRY DOM_ULT_COUNTRY, GLB_ULT_DUNS_NUMBER GLB_ULT_DUNS_NUMBER, GLB_ULT_NAME GLB_ULT_NAME, GLB_ULT_COUNTRY GLB_ULT_COUNTRY, PARENT_SUB_IND PARENT_SUB_IND, CONG_DIST_CODE1 CONG_DIST_CODE1, LABOR_SURPLUS_IND LABOR_SURPLUS_IND, SMALL_BUS_IND SMALL_BUS_IND, WOMAN_OWNED_IND WOMAN_OWNED_IND, MINORITY_OWNED_IND MINORITY_OWNED_IND, DISADV_8A_IND DISADV_8A_IND, DEBARMENTS_COUNT DEBARMENTS_COUNT, DEBARMENTS_DATE DEBARMENTS_DATE, PROFIT_BEFORE_TAX PROFIT_BEFORE_TAX, PREVIOUS_NET_WORTH PREVIOUS_NET_WORTH, PREVIOUS_SALES PREVIOUS_SALES, CREDIT_SCORE CREDIT_SCORE, CREDIT_SCORE_COMMENTARY1 CREDIT_SCORE_COMMENTARY1, CREDIT_SCORE_COMMENTARY2 CREDIT_SCORE_COMMENTARY2, CREDIT_SCORE_COMMENTARY3 CREDIT_SCORE_COMMENTARY3, CREDIT_SCORE_COMMENTARY4 CREDIT_SCORE_COMMENTARY4, CREDIT_SCORE_COMMENTARY5 CREDIT_SCORE_COMMENTARY5, CREDIT_SCORE_COMMENTARY6 CREDIT_SCORE_COMMENTARY6, CREDIT_SCORE_COMMENTARY7 CREDIT_SCORE_COMMENTARY7, CREDIT_SCORE_COMMENTARY8 CREDIT_SCORE_COMMENTARY8, CREDIT_SCORE_COMMENTARY9 CREDIT_SCORE_COMMENTARY9, CREDIT_SCORE_COMMENTARY10 CREDIT_SCORE_COMMENTARY10, CREDIT_SCORE_CLASS CREDIT_SCORE_CLASS, CREDIT_SCORE_NATL_PERCENTILE CREDIT_SCORE_NATL_PERCENTILE, CREDIT_SCORE_INCD_DEFAULT CREDIT_SCORE_INCD_DEFAULT, CREDIT_SCORE_AGE CREDIT_SCORE_AGE, CREDIT_SCORE_DATE CREDIT_SCORE_DATE, FAILURE_SCORE FAILURE_SCORE, FAILURE_SCORE_COMMENTARY1 FAILURE_SCORE_COMMENTARY1, FAILURE_SCORE_COMMENTARY2 FAILURE_SCORE_COMMENTARY2, FAILURE_SCORE_COMMENTARY3 FAILURE_SCORE_COMMENTARY3, FAILURE_SCORE_COMMENTARY4 FAILURE_SCORE_COMMENTARY4, FAILURE_SCORE_COMMENTARY5 FAILURE_SCORE_COMMENTARY5, FAILURE_SCORE_COMMENTARY6 FAILURE_SCORE_COMMENTARY6, FAILURE_SCORE_COMMENTARY7 FAILURE_SCORE_COMMENTARY7, FAILURE_SCORE_COMMENTARY8 FAILURE_SCORE_COMMENTARY8, FAILURE_SCORE_COMMENTARY9 FAILURE_SCORE_COMMENTARY9, FAILURE_SCORE_COMMENTARY10 FAILURE_SCORE_COMMENTARY10, FAILURE_SCORE_CLASS FAILURE_SCORE_CLASS, FAILURE_SCORE_NATL_PERCENTILE FAILURE_SCORE_NATL_PERCENTILE, FAILURE_SCORE_INCD_DEFAULT FAILURE_SCORE_INCD_DEFAULT, FAILURE_SCORE_AGE FAILURE_SCORE_AGE, FAILURE_SCORE_OVERRIDE_CODE FAILURE_SCORE_OVERRIDE_CODE, FAILURE_SCORE_DATE FAILURE_SCORE_DATE, SIC_CODE2 SIC_CODE2, HQ_ADDRESS1 HQ_ADDRESS1, HQ_CITY HQ_CITY, HQ_PRIMARY_GEO_AREA HQ_PRIMARY_GEO_AREA, HQ_COUNTY HQ_COUNTY, HQ_POSTAL_CODE HQ_POSTAL_CODE, HQ_PHONE_NUMBER HQ_PHONE_NUMBER, PARENT_ADDRESS1 PARENT_ADDRESS1, PARENT_CITY PARENT_CITY, PARENT_PRIMARY_GEO_AREA PARENT_PRIMARY_GEO_AREA, PARENT_COUNTY PARENT_COUNTY, PARENT_POSTAL_CODE PARENT_POSTAL_CODE, PARENT_PHONE_NUMBER PARENT_PHONE_NUMBER, DOM_ULT_ADDRESS1 DOM_ULT_ADDRESS1, DOM_ULT_CITY DOM_ULT_CITY, DOM_ULT_PRIMARY_GEO_AREA DOM_ULT_PRIMARY_GEO_AREA, DOM_ULT_COUNTY DOM_ULT_COUNTY, DOM_ULT_POSTAL_CODE DOM_ULT_POSTAL_CODE, DOM_ULT_PHONE_NUMBER DOM_ULT_PHONE_NUMBER, GLB_ULT_ADDRESS1 GLB_ULT_ADDRESS1, GLB_ULT_CITY GLB_ULT_CITY, GLB_ULT_PRIMARY_GEO_AREA GLB_ULT_PRIMARY_GEO_AREA, GLB_ULT_COUNTY GLB_ULT_COUNTY, GLB_ULT_POSTAL_CODE GLB_ULT_POSTAL_CODE, GLB_ULT_PHONE_NUMBER GLB_ULT_PHONE_NUMBER, CONTENT_SOURCE_TYPE CONTENT_SOURCE_TYPE, STATUS STATUS, GDP_NAME GDP_NAME, GROUP_ID GROUP_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, BUSINESS_REPORT BUSINESS_REPORT, REQUEST_LOG_ID REQUEST_LOG_ID, PREVIOUS_WORKING_CAPITAL PREVIOUS_WORKING_CAPITAL, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE, SIC_CODE3 SIC_CODE3, SIC_CODE4 SIC_CODE4, SIC_CODE5 SIC_CODE5, DO_NOT_CONFUSE_WITH DO_NOT_CONFUSE_WITH, CREDIT_SCORE_OVERRIDE_CODE CREDIT_SCORE_OVERRIDE_CODE, CR_SCR_CLAS_EXPL CR_SCR_CLAS_EXPL, LOW_RNG_DELQ_SCR LOW_RNG_DELQ_SCR, HIGH_RNG_DELQ_SCR HIGH_RNG_DELQ_SCR, DELQ_PMT_RNG_PRCNT DELQ_PMT_RNG_PRCNT, DELQ_PMT_PCTG_FOR_ALL_FIRMS DELQ_PMT_PCTG_FOR_ALL_FIRMS, NUM_TRADE_EXPERIENCES NUM_TRADE_EXPERIENCES, PAYDEX_FIRM_DAYS PAYDEX_FIRM_DAYS, PAYDEX_FIRM_COMMENT PAYDEX_FIRM_COMMENT, PAYDEX_INDUSTRY_DAYS PAYDEX_INDUSTRY_DAYS, PAYDEX_INDUSTRY_COMMENT PAYDEX_INDUSTRY_COMMENT, PAYDEX_COMMENT PAYDEX_COMMENT, SUIT_IND SUIT_IND, LIEN_IND LIEN_IND, JUDGEMENT_IND JUDGEMENT_IND, BANKRUPTCY_IND BANKRUPTCY_IND, NO_TRADE_IND NO_TRADE_IND, PRNT_HQ_BKCY_IND PRNT_HQ_BKCY_IND, NUM_PRNT_BKCY_FILING NUM_PRNT_BKCY_FILING, PRNT_BKCY_FILG_TYPE PRNT_BKCY_FILG_TYPE, PRNT_BKCY_FILG_CHAPTER PRNT_BKCY_FILG_CHAPTER, PRNT_BKCY_FILG_DATE PRNT_BKCY_FILG_DATE, NUM_PRNT_BKCY_CONVS NUM_PRNT_BKCY_CONVS, PRNT_BKCY_CONV_DATE PRNT_BKCY_CONV_DATE, PRNT_BKCY_CHAPTER_CONV PRNT_BKCY_CHAPTER_CONV, SLOW_TRADE_EXPL SLOW_TRADE_EXPL, NEGV_PMT_EXPL NEGV_PMT_EXPL, PUB_REC_EXPL PUB_REC_EXPL, BUSINESS_DISCONTINUED BUSINESS_DISCONTINUED, SPCL_EVENT_COMMENT SPCL_EVENT_COMMENT, NUM_SPCL_EVENT NUM_SPCL_EVENT, SPCL_EVENT_UPDATE_DATE SPCL_EVENT_UPDATE_DATE, SPCL_EVNT_TXT SPCL_EVNT_TXT, SIC_CODE6 SIC_CODE6 from "AR"."HZ_PARTY_INTERFACE"

View Text - HTML Formatted

SELECT PARTY_INTERFACE_ID PARTY_INTERFACE_ID
, PARTY_ID PARTY_ID
, DUNS_NUMBER DUNS_NUMBER
, ENQUIRY_DUNS ENQUIRY_DUNS
, PARTY_NAME PARTY_NAME
, KNOWN_AS1 KNOWN_AS1
, KNOWN_AS2 KNOWN_AS2
, KNOWN_AS3 KNOWN_AS3
, KNOWN_AS4 KNOWN_AS4
, KNOWN_AS5 KNOWN_AS5
, ADDRESS1 ADDRESS1
, ADDRESS2 ADDRESS2
, ADDRESS3 ADDRESS3
, ADDRESS4 ADDRESS4
, CITY CITY
, STATE STATE
, PROVINCE PROVINCE
, COUNTY COUNTY
, POSTAL_CODE POSTAL_CODE
, COUNTRY COUNTRY
, TELEPHONE_NUMBER TELEPHONE_NUMBER
, FAX_NUMBER FAX_NUMBER
, PHONE_COUNTRY_CODE PHONE_COUNTRY_CODE
, LOCAL_BUS_IDENTIFIER LOCAL_BUS_IDENTIFIER
, LOCAL_BUS_IDEN_TYPE LOCAL_BUS_IDEN_TYPE
, PREF_FUNCTIONAL_CURRENCY PREF_FUNCTIONAL_CURRENCY
, CONTROL_YR CONTROL_YR
, INCORP_YEAR INCORP_YEAR
, YEAR_ESTABLISHED YEAR_ESTABLISHED
, EMPLOYEES_TOTAL EMPLOYEES_TOTAL
, TOTAL_EMPLOYEES_TEXT TOTAL_EMPLOYEES_TEXT
, TOTAL_EMPLOYEES_IND TOTAL_EMPLOYEES_IND
, TOTAL_EMP_EST_IND TOTAL_EMP_EST_IND
, TOTAL_EMP_MIN_IND TOTAL_EMP_MIN_IND
, EMP_AT_PRIMARY_ADR EMP_AT_PRIMARY_ADR
, EMP_AT_PRIMARY_ADR_TEXT EMP_AT_PRIMARY_ADR_TEXT
, EMP_AT_PRIMARY_ADR_EST_IND EMP_AT_PRIMARY_ADR_EST_IND
, EMP_AT_PRIMARY_ADR_MIN_IND EMP_AT_PRIMARY_ADR_MIN_IND
, SIC_CODE1 SIC_CODE1
, SIC_CODE_TYPE SIC_CODE_TYPE
, LOCAL_ACTIVITY_CODE LOCAL_ACTIVITY_CODE
, LOCAL_ACTIVITY_CODE_TYPE LOCAL_ACTIVITY_CODE_TYPE
, LINE_OF_BUSINESS LINE_OF_BUSINESS
, BRANCH_FLAG BRANCH_FLAG
, HQ_BRANCH_IND HQ_BRANCH_IND
, LEGAL_STATUS LEGAL_STATUS
, REGISTRATION_TYPE REGISTRATION_TYPE
, RENT_OWN_IND RENT_OWN_IND
, CEO_NAME CEO_NAME
, CEO_TITLE CEO_TITLE
, PRINCIPAL_TITLE PRINCIPAL_TITLE
, PRINCIPAL_NAME PRINCIPAL_NAME
, PAYDEX_SCORE PAYDEX_SCORE
, PAYDEX_THREE_MONTHS_AGO PAYDEX_THREE_MONTHS_AGO
, PAYDEX_NORM PAYDEX_NORM
, AVG_HIGH_CREDIT AVG_HIGH_CREDIT
, HIGH_CREDIT HIGH_CREDIT
, TOTAL_PAYMENTS TOTAL_PAYMENTS
, FINCL_EMBT_IND FINCL_EMBT_IND
, OOB_IND OOB_IND
, CRIMINAL_PROCEEDING_IND CRIMINAL_PROCEEDING_IND
, DISASTER_IND DISASTER_IND
, FINCL_LGL_EVENT_IND FINCL_LGL_EVENT_IND
, OPRG_SPEC_EVNT_IND OPRG_SPEC_EVNT_IND
, OTHER_SPEC_EVNT_IND OTHER_SPEC_EVNT_IND
, DET_HISTORY_IND DET_HISTORY_IND
, SUIT_JUDGE_IND SUIT_JUDGE_IND
, CLAIMS_IND CLAIMS_IND
, SECURED_FLNG_IND SECURED_FLNG_IND
, CASH_LIQ_ASSETS CASH_LIQ_ASSETS
, ACCOUNTS_RECEIVABLE ACCOUNTS_RECEIVABLE
, ACCOUNTS_PAYABLE ACCOUNTS_PAYABLE
, CAPITAL_AMOUNT CAPITAL_AMOUNT
, CAPITAL_TYPE_IND CAPITAL_TYPE_IND
, CAPITAL_CURRENCY_CODE CAPITAL_CURRENCY_CODE
, INVENTORY INVENTORY
, FIXED_ASSETS FIXED_ASSETS
, TOTAL_CURRENT_ASSETS TOTAL_CURRENT_ASSETS
, TOTAL_CURR_LIABILITIES TOTAL_CURR_LIABILITIES
, TOTAL_ASSETS TOTAL_ASSETS
, INTANGIBLE_ASSETS INTANGIBLE_ASSETS
, LONG_TERM_DEBT LONG_TERM_DEBT
, TOT_LONG_TERM_LIAB TOT_LONG_TERM_LIAB
, TOTAL_LIABILITIES TOTAL_LIABILITIES
, RETAINED_EARNINGS RETAINED_EARNINGS
, DIVIDENDS DIVIDENDS
, NET_WORTH NET_WORTH
, TANGIBLE_NET_WORTH TANGIBLE_NET_WORTH
, TANGIBLE_NET_WORTH_IND TANGIBLE_NET_WORTH_IND
, TANGIBLE_NET_WORTH_CURR TANGIBLE_NET_WORTH_CURR
, TOTAL_LIAB_EQUITY TOTAL_LIAB_EQUITY
, SALES SALES
, ANNUAL_SALES_VOLUME ANNUAL_SALES_VOLUME
, ANNUAL_SALES_EST_IND ANNUAL_SALES_EST_IND
, ANNUAL_SALES_CONSOL_IND ANNUAL_SALES_CONSOL_IND
, ANNUAL_SALES_CURRENCY ANNUAL_SALES_CURRENCY
, COST_OF_SALES COST_OF_SALES
, GROSS_INCOME GROSS_INCOME
, NET_INCOME NET_INCOME
, FINANCIAL_NUMBER_CURRENCY FINANCIAL_NUMBER_CURRENCY
, INCOME_STMT_START_DATE INCOME_STMT_START_DATE
, INCOME_STMT_END_DATE INCOME_STMT_END_DATE
, INCOME_STMT_DATE INCOME_STMT_DATE
, STATEMENT_DATE STATEMENT_DATE
, AUDIT_IND AUDIT_IND
, CONSOLIDATED_IND CONSOLIDATED_IND
, ESTIMATED_IND ESTIMATED_IND
, FORECAST_IND FORECAST_IND
, FISCAL_IND FISCAL_IND
, FINAL_IND FINAL_IND
, SIGNED_BY_PRINCIPALS_IND SIGNED_BY_PRINCIPALS_IND
, RESTATED_IND RESTATED_IND
, UNBALANCED_IND UNBALANCED_IND
, QUALIFIED_IND QUALIFIED_IND
, OPENING_IND OPENING_IND
, PROFORMA_IND PROFORMA_IND
, TRIAL_BALANCE_IND TRIAL_BALANCE_IND
, CURRENT_RATIO CURRENT_RATIO
, QUICK_RATIO QUICK_RATIO
, IMPORT_IND IMPORT_IND
, EXPORT_IND EXPORT_IND
, DB_RATING DB_RATING
, GLOBAL_FAILURE_SCORE GLOBAL_FAILURE_SCORE
, MAX_CREDIT_RECOMMEND MAX_CREDIT_RECOMMEND
, MAX_CREDIT_CURRENCY MAX_CREDIT_CURRENCY
, HQ_DUNS_NUMBER HQ_DUNS_NUMBER
, HQ_NAME HQ_NAME
, HQ_COUNTRY HQ_COUNTRY
, PARENT_DUNS_NUMBER PARENT_DUNS_NUMBER
, PARENT_NAME PARENT_NAME
, PARENT_COUNTRY PARENT_COUNTRY
, DOM_ULT_DUNS_NUMBER DOM_ULT_DUNS_NUMBER
, DOM_ULT_NAME DOM_ULT_NAME
, DOM_ULT_COUNTRY DOM_ULT_COUNTRY
, GLB_ULT_DUNS_NUMBER GLB_ULT_DUNS_NUMBER
, GLB_ULT_NAME GLB_ULT_NAME
, GLB_ULT_COUNTRY GLB_ULT_COUNTRY
, PARENT_SUB_IND PARENT_SUB_IND
, CONG_DIST_CODE1 CONG_DIST_CODE1
, LABOR_SURPLUS_IND LABOR_SURPLUS_IND
, SMALL_BUS_IND SMALL_BUS_IND
, WOMAN_OWNED_IND WOMAN_OWNED_IND
, MINORITY_OWNED_IND MINORITY_OWNED_IND
, DISADV_8A_IND DISADV_8A_IND
, DEBARMENTS_COUNT DEBARMENTS_COUNT
, DEBARMENTS_DATE DEBARMENTS_DATE
, PROFIT_BEFORE_TAX PROFIT_BEFORE_TAX
, PREVIOUS_NET_WORTH PREVIOUS_NET_WORTH
, PREVIOUS_SALES PREVIOUS_SALES
, CREDIT_SCORE CREDIT_SCORE
, CREDIT_SCORE_COMMENTARY1 CREDIT_SCORE_COMMENTARY1
, CREDIT_SCORE_COMMENTARY2 CREDIT_SCORE_COMMENTARY2
, CREDIT_SCORE_COMMENTARY3 CREDIT_SCORE_COMMENTARY3
, CREDIT_SCORE_COMMENTARY4 CREDIT_SCORE_COMMENTARY4
, CREDIT_SCORE_COMMENTARY5 CREDIT_SCORE_COMMENTARY5
, CREDIT_SCORE_COMMENTARY6 CREDIT_SCORE_COMMENTARY6
, CREDIT_SCORE_COMMENTARY7 CREDIT_SCORE_COMMENTARY7
, CREDIT_SCORE_COMMENTARY8 CREDIT_SCORE_COMMENTARY8
, CREDIT_SCORE_COMMENTARY9 CREDIT_SCORE_COMMENTARY9
, CREDIT_SCORE_COMMENTARY10 CREDIT_SCORE_COMMENTARY10
, CREDIT_SCORE_CLASS CREDIT_SCORE_CLASS
, CREDIT_SCORE_NATL_PERCENTILE CREDIT_SCORE_NATL_PERCENTILE
, CREDIT_SCORE_INCD_DEFAULT CREDIT_SCORE_INCD_DEFAULT
, CREDIT_SCORE_AGE CREDIT_SCORE_AGE
, CREDIT_SCORE_DATE CREDIT_SCORE_DATE
, FAILURE_SCORE FAILURE_SCORE
, FAILURE_SCORE_COMMENTARY1 FAILURE_SCORE_COMMENTARY1
, FAILURE_SCORE_COMMENTARY2 FAILURE_SCORE_COMMENTARY2
, FAILURE_SCORE_COMMENTARY3 FAILURE_SCORE_COMMENTARY3
, FAILURE_SCORE_COMMENTARY4 FAILURE_SCORE_COMMENTARY4
, FAILURE_SCORE_COMMENTARY5 FAILURE_SCORE_COMMENTARY5
, FAILURE_SCORE_COMMENTARY6 FAILURE_SCORE_COMMENTARY6
, FAILURE_SCORE_COMMENTARY7 FAILURE_SCORE_COMMENTARY7
, FAILURE_SCORE_COMMENTARY8 FAILURE_SCORE_COMMENTARY8
, FAILURE_SCORE_COMMENTARY9 FAILURE_SCORE_COMMENTARY9
, FAILURE_SCORE_COMMENTARY10 FAILURE_SCORE_COMMENTARY10
, FAILURE_SCORE_CLASS FAILURE_SCORE_CLASS
, FAILURE_SCORE_NATL_PERCENTILE FAILURE_SCORE_NATL_PERCENTILE
, FAILURE_SCORE_INCD_DEFAULT FAILURE_SCORE_INCD_DEFAULT
, FAILURE_SCORE_AGE FAILURE_SCORE_AGE
, FAILURE_SCORE_OVERRIDE_CODE FAILURE_SCORE_OVERRIDE_CODE
, FAILURE_SCORE_DATE FAILURE_SCORE_DATE
, SIC_CODE2 SIC_CODE2
, HQ_ADDRESS1 HQ_ADDRESS1
, HQ_CITY HQ_CITY
, HQ_PRIMARY_GEO_AREA HQ_PRIMARY_GEO_AREA
, HQ_COUNTY HQ_COUNTY
, HQ_POSTAL_CODE HQ_POSTAL_CODE
, HQ_PHONE_NUMBER HQ_PHONE_NUMBER
, PARENT_ADDRESS1 PARENT_ADDRESS1
, PARENT_CITY PARENT_CITY
, PARENT_PRIMARY_GEO_AREA PARENT_PRIMARY_GEO_AREA
, PARENT_COUNTY PARENT_COUNTY
, PARENT_POSTAL_CODE PARENT_POSTAL_CODE
, PARENT_PHONE_NUMBER PARENT_PHONE_NUMBER
, DOM_ULT_ADDRESS1 DOM_ULT_ADDRESS1
, DOM_ULT_CITY DOM_ULT_CITY
, DOM_ULT_PRIMARY_GEO_AREA DOM_ULT_PRIMARY_GEO_AREA
, DOM_ULT_COUNTY DOM_ULT_COUNTY
, DOM_ULT_POSTAL_CODE DOM_ULT_POSTAL_CODE
, DOM_ULT_PHONE_NUMBER DOM_ULT_PHONE_NUMBER
, GLB_ULT_ADDRESS1 GLB_ULT_ADDRESS1
, GLB_ULT_CITY GLB_ULT_CITY
, GLB_ULT_PRIMARY_GEO_AREA GLB_ULT_PRIMARY_GEO_AREA
, GLB_ULT_COUNTY GLB_ULT_COUNTY
, GLB_ULT_POSTAL_CODE GLB_ULT_POSTAL_CODE
, GLB_ULT_PHONE_NUMBER GLB_ULT_PHONE_NUMBER
, CONTENT_SOURCE_TYPE CONTENT_SOURCE_TYPE
, STATUS STATUS
, GDP_NAME GDP_NAME
, GROUP_ID GROUP_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, BUSINESS_REPORT BUSINESS_REPORT
, REQUEST_LOG_ID REQUEST_LOG_ID
, PREVIOUS_WORKING_CAPITAL PREVIOUS_WORKING_CAPITAL
, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, SIC_CODE3 SIC_CODE3
, SIC_CODE4 SIC_CODE4
, SIC_CODE5 SIC_CODE5
, DO_NOT_CONFUSE_WITH DO_NOT_CONFUSE_WITH
, CREDIT_SCORE_OVERRIDE_CODE CREDIT_SCORE_OVERRIDE_CODE
, CR_SCR_CLAS_EXPL CR_SCR_CLAS_EXPL
, LOW_RNG_DELQ_SCR LOW_RNG_DELQ_SCR
, HIGH_RNG_DELQ_SCR HIGH_RNG_DELQ_SCR
, DELQ_PMT_RNG_PRCNT DELQ_PMT_RNG_PRCNT
, DELQ_PMT_PCTG_FOR_ALL_FIRMS DELQ_PMT_PCTG_FOR_ALL_FIRMS
, NUM_TRADE_EXPERIENCES NUM_TRADE_EXPERIENCES
, PAYDEX_FIRM_DAYS PAYDEX_FIRM_DAYS
, PAYDEX_FIRM_COMMENT PAYDEX_FIRM_COMMENT
, PAYDEX_INDUSTRY_DAYS PAYDEX_INDUSTRY_DAYS
, PAYDEX_INDUSTRY_COMMENT PAYDEX_INDUSTRY_COMMENT
, PAYDEX_COMMENT PAYDEX_COMMENT
, SUIT_IND SUIT_IND
, LIEN_IND LIEN_IND
, JUDGEMENT_IND JUDGEMENT_IND
, BANKRUPTCY_IND BANKRUPTCY_IND
, NO_TRADE_IND NO_TRADE_IND
, PRNT_HQ_BKCY_IND PRNT_HQ_BKCY_IND
, NUM_PRNT_BKCY_FILING NUM_PRNT_BKCY_FILING
, PRNT_BKCY_FILG_TYPE PRNT_BKCY_FILG_TYPE
, PRNT_BKCY_FILG_CHAPTER PRNT_BKCY_FILG_CHAPTER
, PRNT_BKCY_FILG_DATE PRNT_BKCY_FILG_DATE
, NUM_PRNT_BKCY_CONVS NUM_PRNT_BKCY_CONVS
, PRNT_BKCY_CONV_DATE PRNT_BKCY_CONV_DATE
, PRNT_BKCY_CHAPTER_CONV PRNT_BKCY_CHAPTER_CONV
, SLOW_TRADE_EXPL SLOW_TRADE_EXPL
, NEGV_PMT_EXPL NEGV_PMT_EXPL
, PUB_REC_EXPL PUB_REC_EXPL
, BUSINESS_DISCONTINUED BUSINESS_DISCONTINUED
, SPCL_EVENT_COMMENT SPCL_EVENT_COMMENT
, NUM_SPCL_EVENT NUM_SPCL_EVENT
, SPCL_EVENT_UPDATE_DATE SPCL_EVENT_UPDATE_DATE
, SPCL_EVNT_TXT SPCL_EVNT_TXT
, SIC_CODE6 SIC_CODE6
FROM "AR"."HZ_PARTY_INTERFACE"