[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | HZ_PARTY_INTERFACE# |
|---|---|
| Object Type: | VIEW |
| Owner: | AR |
| Subobject Name: | |
| Status: | VALID |
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
APPS
HZ_PARTY_INTERFACE
|
|
|
|