[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#;
|
|
|