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