VIEW: FV.FV_CCR_PROCESS_GT#

Source

View Text - Preformatted

select DUNS DUNS, PLUS_FOUR PLUS_FOUR, CAGE_CODE CAGE_CODE, EXTRACT_CODE EXTRACT_CODE, REGISTRATION_DATE REGISTRATION_DATE, RENEWAL_DATE RENEWAL_DATE, LEGAL_BUS_NAME LEGAL_BUS_NAME, DBA_NAME DBA_NAME, DIVISION_NAME DIVISION_NAME, DIVISION_NUMBER DIVISION_NUMBER, ST_ADDRESS1 ST_ADDRESS1, ST_ADDRESS2 ST_ADDRESS2, CITY CITY, STATE STATE, POSTAL_CODE POSTAL_CODE, COUNTRY COUNTRY, BUSINESS_START_DATE BUSINESS_START_DATE, FISCAL_YR_CLOSE_DATE FISCAL_YR_CLOSE_DATE, CORP_SECURITY_LEVEL CORP_SECURITY_LEVEL, EMP_SECURITY_LEVEL EMP_SECURITY_LEVEL, WEB_SITE WEB_SITE, ORGANIZATIONAL_TYPE ORGANIZATIONAL_TYPE, STATE_OF_INC STATE_OF_INC, COUNTRY_OF_INC COUNTRY_OF_INC, BUSINESS_TYPES BUSINESS_TYPES, SIC_CODES SIC_CODES, NAICS_CODES NAICS_CODES, FSC_CODES FSC_CODES, PSC_CODES PSC_CODES, CREDIT_CARD_FLAG CREDIT_CARD_FLAG, CORRESPONDENCE_FLAG CORRESPONDENCE_FLAG, MAIL_POC MAIL_POC, MAIL_ADD1 MAIL_ADD1, MAIL_ADD2 MAIL_ADD2, MAIL_CITY MAIL_CITY, MAIL_POSTAL_CODE MAIL_POSTAL_CODE, MAIL_COUNTRY MAIL_COUNTRY, MAIL_STATE MAIL_STATE, PREV_BUS_POC PREV_BUS_POC, PREV_BUS_ADD1 PREV_BUS_ADD1, PREV_BUS_ADD2 PREV_BUS_ADD2, PREV_BUS_CITY PREV_BUS_CITY, PREV_BUS_POSTAL_CODE PREV_BUS_POSTAL_CODE, PREV_BUS_COUNTRY PREV_BUS_COUNTRY, PREV_BUS_STATE PREV_BUS_STATE, PARENT_POC PARENT_POC, PARENT_DUNS PARENT_DUNS, PARENT_ADD1 PARENT_ADD1, PARENT_ADD2 PARENT_ADD2, PARENT_CITY PARENT_CITY, PARENT_POSTAL_CODE PARENT_POSTAL_CODE, PARENT_COUNTRY PARENT_COUNTRY, PARENT_STATE PARENT_STATE, PARTY_PERF_POC PARTY_PERF_POC, PARTY_PERF_ADD1 PARTY_PERF_ADD1, PARTY_PERF_ADD2 PARTY_PERF_ADD2, PARTY_PERF_CITY PARTY_PERF_CITY, PARTY_PERF_POSTAL_CODE PARTY_PERF_POSTAL_CODE, PARTY_PERF_COUNTRY PARTY_PERF_COUNTRY, PARTY_PERF_STATE PARTY_PERF_STATE, GOV_PARENT_POC GOV_PARENT_POC, GOV_PARENT_ADD1 GOV_PARENT_ADD1, GOV_PARENT_ADD2 GOV_PARENT_ADD2, GOV_PARENT_CITY GOV_PARENT_CITY, GOV_PARENT_POSTAL_CODE GOV_PARENT_POSTAL_CODE, GOV_PARENT_COUNTRY GOV_PARENT_COUNTRY, GOV_PARENT_STATE GOV_PARENT_STATE, GOV_BUS_POC GOV_BUS_POC, GOV_BUS_ADD1 GOV_BUS_ADD1, GOV_BUS_ADD2 GOV_BUS_ADD2, GOV_BUS_CITY GOV_BUS_CITY, GOV_BUS_POSTAL_CODE GOV_BUS_POSTAL_CODE, GOV_BUS_COUNTRY GOV_BUS_COUNTRY, GOV_BUS_STATE GOV_BUS_STATE, GOV_BUS_US_PHONE GOV_BUS_US_PHONE, GOV_BUS_US_PHONE_EX GOV_BUS_US_PHONE_EX, GOV_BUS_NON_US_PHONE GOV_BUS_NON_US_PHONE, GOV_BUS_FAX GOV_BUS_FAX, GOV_BUS_EMAIL GOV_BUS_EMAIL, ALT_GOV_BUS_POC ALT_GOV_BUS_POC, ALT_GOV_BUS_ADD1 ALT_GOV_BUS_ADD1, ALT_GOV_BUS_ADD2 ALT_GOV_BUS_ADD2, ALT_GOV_BUS_CITY ALT_GOV_BUS_CITY, ALT_GOV_BUS_POSTAL_CODE ALT_GOV_BUS_POSTAL_CODE, ALT_GOV_BUS_COUNTRY ALT_GOV_BUS_COUNTRY, ALT_GOV_BUS_STATE ALT_GOV_BUS_STATE, ALT_GOV_BUS_US_PHONE ALT_GOV_BUS_US_PHONE, ALT_GOV_BUS_US_PHONE_EX ALT_GOV_BUS_US_PHONE_EX, ALT_GOV_BUS_NON_US_PHONE ALT_GOV_BUS_NON_US_PHONE, ALT_GOV_BUS_FAX ALT_GOV_BUS_FAX, ALT_GOV_BUS_EMAIL ALT_GOV_BUS_EMAIL, PAST_PERF_POC PAST_PERF_POC, PAST_PERF_ADD1 PAST_PERF_ADD1, PAST_PERF_ADD2 PAST_PERF_ADD2, PAST_PERF_CITY PAST_PERF_CITY, PAST_PERF_POSTAL_CODE PAST_PERF_POSTAL_CODE, PAST_PERF_COUNTRY PAST_PERF_COUNTRY, PAST_PERF_STATE PAST_PERF_STATE, PAST_PERF_US_PHONE PAST_PERF_US_PHONE, PAST_PERF_US_PHONE_EX PAST_PERF_US_PHONE_EX, PAST_PERF_NON_US_PHONE PAST_PERF_NON_US_PHONE, PAST_PERF_FAX PAST_PERF_FAX, PAST_PERF_EMAIL PAST_PERF_EMAIL, ALT_PAST_PERF_POC ALT_PAST_PERF_POC, ALT_PAST_PERF_ADD1 ALT_PAST_PERF_ADD1, ALT_PAST_PERF_ADD2 ALT_PAST_PERF_ADD2, ALT_PAST_PERF_CITY ALT_PAST_PERF_CITY, ALT_PAST_PERF_POSTAL_CODE ALT_PAST_PERF_POSTAL_CODE, ALT_PAST_PERF_COUNTRY ALT_PAST_PERF_COUNTRY, ALT_PAST_PERF_STATE ALT_PAST_PERF_STATE, ALT_PAST_PERF_US_PHONE ALT_PAST_PERF_US_PHONE, ALT_PAST_PERF_US_PHONE_EX ALT_PAST_PERF_US_PHONE_EX, ALT_PAST_PERF_NON_US_PHONE ALT_PAST_PERF_NON_US_PHONE, ALT_PAST_PERF_FAX ALT_PAST_PERF_FAX, ALT_PAST_PERF_EMAIL ALT_PAST_PERF_EMAIL, ELEC_BUS_POC ELEC_BUS_POC, ELEC_BUS_ADD1 ELEC_BUS_ADD1, ELEC_BUS_ADD2 ELEC_BUS_ADD2, ELEC_BUS_CITY ELEC_BUS_CITY, ELEC_BUS_POSTAL_CODE ELEC_BUS_POSTAL_CODE, ELEC_BUS_COUNTRY ELEC_BUS_COUNTRY, ELEC_BUS_STATE ELEC_BUS_STATE, ELEC_BUS_US_PHONE ELEC_BUS_US_PHONE, ELEC_BUS_US_PHONE_EX ELEC_BUS_US_PHONE_EX, ELEC_BUS_NON_US_PHONE ELEC_BUS_NON_US_PHONE, ELEC_BUS_FAX ELEC_BUS_FAX, ELEC_BUS_EMAIL ELEC_BUS_EMAIL, ALT_ELEC_BUS_POC ALT_ELEC_BUS_POC, ALT_ELEC_BUS_ADD1 ALT_ELEC_BUS_ADD1, ALT_ELEC_BUS_ADD2 ALT_ELEC_BUS_ADD2, ALT_ELEC_BUS_CITY ALT_ELEC_BUS_CITY, ALT_ELEC_BUS_POSTAL_CODE ALT_ELEC_BUS_POSTAL_CODE, ALT_ELEC_BUS_COUNTRY ALT_ELEC_BUS_COUNTRY, ALT_ELEC_BUS_STATE ALT_ELEC_BUS_STATE, ALT_ELEC_BUS_US_PHONE ALT_ELEC_BUS_US_PHONE, ALT_ELEC_BUS_US_PHONE_EX ALT_ELEC_BUS_US_PHONE_EX, ALT_ELEC_BUS_NON_US_PHONE ALT_ELEC_BUS_NON_US_PHONE, ALT_ELEC_BUS_FAX ALT_ELEC_BUS_FAX, ALT_ELEC_BUS_EMAIL ALT_ELEC_BUS_EMAIL, CERTIFIER_POC CERTIFIER_POC, CERTIFIER_US_PHONE CERTIFIER_US_PHONE, CERTIFIER_US_PHONE_EX CERTIFIER_US_PHONE_EX, CERTIFIER_NON_US_PHONE CERTIFIER_NON_US_PHONE, CERTIFIER_FAX CERTIFIER_FAX, CERTIFIER_EMAIL CERTIFIER_EMAIL, ALT_CERTIFIER_POC ALT_CERTIFIER_POC, ALT_CERTIFIER_US_PHONE ALT_CERTIFIER_US_PHONE, ALT_CERTIFIER_US_PHONE_EX ALT_CERTIFIER_US_PHONE_EX, ALT_CERTIFIER_NON_US_PHONE ALT_CERTIFIER_NON_US_PHONE, ALT_CERTIFIER_EMAIL ALT_CERTIFIER_EMAIL, ALT_CERTIFIER_FAX ALT_CERTIFIER_FAX, CORP_INFO_POC CORP_INFO_POC, CORP_INFO_US_PHONE CORP_INFO_US_PHONE, CORP_INFO_US_PHONE_EX CORP_INFO_US_PHONE_EX, CORP_INFO_NON_US_PHONE CORP_INFO_NON_US_PHONE, CORP_INFO_FAX CORP_INFO_FAX, CORP_INFO_EMAIL CORP_INFO_EMAIL, OWNER_INFO_POC OWNER_INFO_POC, OWNER_INFO_US_PHONE OWNER_INFO_US_PHONE, OWNER_INFO_US_PHONE_EX OWNER_INFO_US_PHONE_EX, OWNER_INFO_NON_US_PHONE OWNER_INFO_NON_US_PHONE, OWNER_INFO_FAX OWNER_INFO_FAX, OWNER_INFO_EMAIL OWNER_INFO_EMAIL, EDI EDI, TAXPAYER_ID TAXPAYER_ID, AVG_NUM_EMPLOYEES AVG_NUM_EMPLOYEES, ANNUAL_REVENUE ANNUAL_REVENUE, SOCIAL_SECURITY_NUMBER SOCIAL_SECURITY_NUMBER, FINANCIAL_INSTITUTE FINANCIAL_INSTITUTE, BANK_ACCT_NUMBER BANK_ACCT_NUMBER, ABA_ROUTING ABA_ROUTING, BANK_ACCT_TYPE BANK_ACCT_TYPE, LOCKBOX_NUMBER LOCKBOX_NUMBER, AUTHORIZATION_DATE AUTHORIZATION_DATE, EFT_WAIVER EFT_WAIVER, ACH_US_PHONE ACH_US_PHONE, ACH_NON_US_PHONE ACH_NON_US_PHONE, ACH_FAX ACH_FAX, ACH_EMAIL ACH_EMAIL, REMIT_POC REMIT_POC, REMIT_ADD1 REMIT_ADD1, REMIT_ADD2 REMIT_ADD2, REMIT_CITY REMIT_CITY, REMIT_STATE REMIT_STATE, REMIT_POSTAL_CODE REMIT_POSTAL_CODE, REMIT_COUNTRY REMIT_COUNTRY, AR_POC AR_POC, AR_US_PHONE AR_US_PHONE, AR_US_PHONE_EX AR_US_PHONE_EX, AR_NON_US_PHONE AR_NON_US_PHONE, AR_FAX AR_FAX, AR_EMAIL AR_EMAIL, MPIN MPIN, EDI_COORDINATOR EDI_COORDINATOR, EDI_US_PHONE EDI_US_PHONE, EDI_US_PHONE_EX EDI_US_PHONE_EX, EDI_NON_US_PHONE EDI_NON_US_PHONE, EDI_FAX EDI_FAX, EDI_EMAIL EDI_EMAIL, VAN VAN, ISA_QUALIFIER ISA_QUALIFIER, ISA_SENDER_QUALIFIER ISA_SENDER_QUALIFIER, GS02_IDENTIFIER GS02_IDENTIFIER, RECEIVE_820 RECEIVE_820, HQ_PARENT_NAME HQ_PARENT_NAME, HQ_PARENT_DUNS HQ_PARENT_DUNS, HQ_PARENT_ADD1 HQ_PARENT_ADD1, HQ_PARENT_ADD2 HQ_PARENT_ADD2, HQ_PARENT_CITY HQ_PARENT_CITY, HQ_PARENT_STATE HQ_PARENT_STATE, HQ_PARENT_POSTAL_CODE HQ_PARENT_POSTAL_CODE, HQ_PARENT_COUNTRY HQ_PARENT_COUNTRY, HQ_PARENT_PHONE HQ_PARENT_PHONE, HQ_PARENT_RECORD_DATE HQ_PARENT_RECORD_DATE, GLOBAL_ULT_NAME GLOBAL_ULT_NAME, GLOBAL_ULT_DUNS GLOBAL_ULT_DUNS, GLOBAL_ULT_ADD1 GLOBAL_ULT_ADD1, GLOBAL_ULT_ADD2 GLOBAL_ULT_ADD2, GLOBAL_ULT_CITY GLOBAL_ULT_CITY, GLOBAL_ULT_POSTAL_CODE GLOBAL_ULT_POSTAL_CODE, GLOBAL_ULT_COUNTRY GLOBAL_ULT_COUNTRY, GLOBAL_ULT_STATE GLOBAL_ULT_STATE, GLOBAL_ULT_PHONE GLOBAL_ULT_PHONE, GLOBAL_ULT_RECORD_DATE GLOBAL_ULT_RECORD_DATE, DOMESTIC_ULT_NAME DOMESTIC_ULT_NAME, DOMESTIC_ULT_DUNS DOMESTIC_ULT_DUNS, DOMESTIC_ULT_ADD1 DOMESTIC_ULT_ADD1, DOMESTIC_ULT_ADD2 DOMESTIC_ULT_ADD2, DOMESTIC_ULT_CITY DOMESTIC_ULT_CITY, DOMESTIC_ULT_POSTAL_CODE DOMESTIC_ULT_POSTAL_CODE, DOMESTIC_ULT_COUNTRY DOMESTIC_ULT_COUNTRY, DOMESTIC_ULT_STATE DOMESTIC_ULT_STATE, DOMESTIC_ULT_PHONE DOMESTIC_ULT_PHONE, DOMESTIC_ULT_RECORD_DATE DOMESTIC_ULT_RECORD_DATE, FILE_DATE FILE_DATE, DOMESTIC_PARENT_POC DOMESTIC_PARENT_POC, DOMESTIC_PARENT_DUNS DOMESTIC_PARENT_DUNS, DOMESTIC_PARENT_ADD1 DOMESTIC_PARENT_ADD1, DOMESTIC_PARENT_ADD2 DOMESTIC_PARENT_ADD2, DOMESTIC_PARENT_CITY DOMESTIC_PARENT_CITY, DOMESTIC_PARENT_POSTAL_CODE DOMESTIC_PARENT_POSTAL_CODE, DOMESTIC_PARENT_COUNTRY DOMESTIC_PARENT_COUNTRY, DOMESTIC_PARENT_STATE DOMESTIC_PARENT_STATE, DOMESTIC_PARENT_PHONE DOMESTIC_PARENT_PHONE, GLOBAL_PARENT_POC GLOBAL_PARENT_POC, GLOBAL_PARENT_DUNS GLOBAL_PARENT_DUNS, GLOBAL_PARENT_ADD1 GLOBAL_PARENT_ADD1, GLOBAL_PARENT_ADD2 GLOBAL_PARENT_ADD2, GLOBAL_PARENT_CITY GLOBAL_PARENT_CITY, GLOBAL_PARENT_POSTAL_CODE GLOBAL_PARENT_POSTAL_CODE, GLOBAL_PARENT_COUNTRY GLOBAL_PARENT_COUNTRY, GLOBAL_PARENT_STATE GLOBAL_PARENT_STATE, GLOBAL_PARENT_PHONE GLOBAL_PARENT_PHONE, DNB_MONITOR_LAST_UPDATED DNB_MONITOR_LAST_UPDATED, DNB_MONITOR_STATUS DNB_MONITOR_STATUS, DNB_MONITOR_CORP_NAME DNB_MONITOR_CORP_NAME, DNB_MONITOR_DBA DNB_MONITOR_DBA, DNB_MONITOR_ST_ADD1 DNB_MONITOR_ST_ADD1, DNB_MONITOR_ST_ADD2 DNB_MONITOR_ST_ADD2, DNB_MONITOR_CITY DNB_MONITOR_CITY, DNB_MONITOR_POSTAL_CODE DNB_MONITOR_POSTAL_CODE, DNB_MONITOR_COUNTRY_CODE DNB_MONITOR_COUNTRY_CODE, DNB_MONITOR_STATE DNB_MONITOR_STATE, HQ_PARENT_POC HQ_PARENT_POC, ANNUAL_RECEIPTS ANNUAL_RECEIPTS, AUSTIN_TETRA_NUMBER AUSTIN_TETRA_NUMBER, AUSTIN_TETRA_PARENT_NUMBER AUSTIN_TETRA_PARENT_NUMBER, AUSTIN_TETRA_ULTIMATE_NUMBER AUSTIN_TETRA_ULTIMATE_NUMBER, AUSTIN_TETRA_PCARD_FLAG AUSTIN_TETRA_PCARD_FLAG, PAYMENT_TYPE PAYMENT_TYPE from "FV"."FV_CCR_PROCESS_GT"

View Text - HTML Formatted

SELECT DUNS DUNS
, PLUS_FOUR PLUS_FOUR
, CAGE_CODE CAGE_CODE
, EXTRACT_CODE EXTRACT_CODE
, REGISTRATION_DATE REGISTRATION_DATE
, RENEWAL_DATE RENEWAL_DATE
, LEGAL_BUS_NAME LEGAL_BUS_NAME
, DBA_NAME DBA_NAME
, DIVISION_NAME DIVISION_NAME
, DIVISION_NUMBER DIVISION_NUMBER
, ST_ADDRESS1 ST_ADDRESS1
, ST_ADDRESS2 ST_ADDRESS2
, CITY CITY
, STATE STATE
, POSTAL_CODE POSTAL_CODE
, COUNTRY COUNTRY
, BUSINESS_START_DATE BUSINESS_START_DATE
, FISCAL_YR_CLOSE_DATE FISCAL_YR_CLOSE_DATE
, CORP_SECURITY_LEVEL CORP_SECURITY_LEVEL
, EMP_SECURITY_LEVEL EMP_SECURITY_LEVEL
, WEB_SITE WEB_SITE
, ORGANIZATIONAL_TYPE ORGANIZATIONAL_TYPE
, STATE_OF_INC STATE_OF_INC
, COUNTRY_OF_INC COUNTRY_OF_INC
, BUSINESS_TYPES BUSINESS_TYPES
, SIC_CODES SIC_CODES
, NAICS_CODES NAICS_CODES
, FSC_CODES FSC_CODES
, PSC_CODES PSC_CODES
, CREDIT_CARD_FLAG CREDIT_CARD_FLAG
, CORRESPONDENCE_FLAG CORRESPONDENCE_FLAG
, MAIL_POC MAIL_POC
, MAIL_ADD1 MAIL_ADD1
, MAIL_ADD2 MAIL_ADD2
, MAIL_CITY MAIL_CITY
, MAIL_POSTAL_CODE MAIL_POSTAL_CODE
, MAIL_COUNTRY MAIL_COUNTRY
, MAIL_STATE MAIL_STATE
, PREV_BUS_POC PREV_BUS_POC
, PREV_BUS_ADD1 PREV_BUS_ADD1
, PREV_BUS_ADD2 PREV_BUS_ADD2
, PREV_BUS_CITY PREV_BUS_CITY
, PREV_BUS_POSTAL_CODE PREV_BUS_POSTAL_CODE
, PREV_BUS_COUNTRY PREV_BUS_COUNTRY
, PREV_BUS_STATE PREV_BUS_STATE
, PARENT_POC PARENT_POC
, PARENT_DUNS PARENT_DUNS
, PARENT_ADD1 PARENT_ADD1
, PARENT_ADD2 PARENT_ADD2
, PARENT_CITY PARENT_CITY
, PARENT_POSTAL_CODE PARENT_POSTAL_CODE
, PARENT_COUNTRY PARENT_COUNTRY
, PARENT_STATE PARENT_STATE
, PARTY_PERF_POC PARTY_PERF_POC
, PARTY_PERF_ADD1 PARTY_PERF_ADD1
, PARTY_PERF_ADD2 PARTY_PERF_ADD2
, PARTY_PERF_CITY PARTY_PERF_CITY
, PARTY_PERF_POSTAL_CODE PARTY_PERF_POSTAL_CODE
, PARTY_PERF_COUNTRY PARTY_PERF_COUNTRY
, PARTY_PERF_STATE PARTY_PERF_STATE
, GOV_PARENT_POC GOV_PARENT_POC
, GOV_PARENT_ADD1 GOV_PARENT_ADD1
, GOV_PARENT_ADD2 GOV_PARENT_ADD2
, GOV_PARENT_CITY GOV_PARENT_CITY
, GOV_PARENT_POSTAL_CODE GOV_PARENT_POSTAL_CODE
, GOV_PARENT_COUNTRY GOV_PARENT_COUNTRY
, GOV_PARENT_STATE GOV_PARENT_STATE
, GOV_BUS_POC GOV_BUS_POC
, GOV_BUS_ADD1 GOV_BUS_ADD1
, GOV_BUS_ADD2 GOV_BUS_ADD2
, GOV_BUS_CITY GOV_BUS_CITY
, GOV_BUS_POSTAL_CODE GOV_BUS_POSTAL_CODE
, GOV_BUS_COUNTRY GOV_BUS_COUNTRY
, GOV_BUS_STATE GOV_BUS_STATE
, GOV_BUS_US_PHONE GOV_BUS_US_PHONE
, GOV_BUS_US_PHONE_EX GOV_BUS_US_PHONE_EX
, GOV_BUS_NON_US_PHONE GOV_BUS_NON_US_PHONE
, GOV_BUS_FAX GOV_BUS_FAX
, GOV_BUS_EMAIL GOV_BUS_EMAIL
, ALT_GOV_BUS_POC ALT_GOV_BUS_POC
, ALT_GOV_BUS_ADD1 ALT_GOV_BUS_ADD1
, ALT_GOV_BUS_ADD2 ALT_GOV_BUS_ADD2
, ALT_GOV_BUS_CITY ALT_GOV_BUS_CITY
, ALT_GOV_BUS_POSTAL_CODE ALT_GOV_BUS_POSTAL_CODE
, ALT_GOV_BUS_COUNTRY ALT_GOV_BUS_COUNTRY
, ALT_GOV_BUS_STATE ALT_GOV_BUS_STATE
, ALT_GOV_BUS_US_PHONE ALT_GOV_BUS_US_PHONE
, ALT_GOV_BUS_US_PHONE_EX ALT_GOV_BUS_US_PHONE_EX
, ALT_GOV_BUS_NON_US_PHONE ALT_GOV_BUS_NON_US_PHONE
, ALT_GOV_BUS_FAX ALT_GOV_BUS_FAX
, ALT_GOV_BUS_EMAIL ALT_GOV_BUS_EMAIL
, PAST_PERF_POC PAST_PERF_POC
, PAST_PERF_ADD1 PAST_PERF_ADD1
, PAST_PERF_ADD2 PAST_PERF_ADD2
, PAST_PERF_CITY PAST_PERF_CITY
, PAST_PERF_POSTAL_CODE PAST_PERF_POSTAL_CODE
, PAST_PERF_COUNTRY PAST_PERF_COUNTRY
, PAST_PERF_STATE PAST_PERF_STATE
, PAST_PERF_US_PHONE PAST_PERF_US_PHONE
, PAST_PERF_US_PHONE_EX PAST_PERF_US_PHONE_EX
, PAST_PERF_NON_US_PHONE PAST_PERF_NON_US_PHONE
, PAST_PERF_FAX PAST_PERF_FAX
, PAST_PERF_EMAIL PAST_PERF_EMAIL
, ALT_PAST_PERF_POC ALT_PAST_PERF_POC
, ALT_PAST_PERF_ADD1 ALT_PAST_PERF_ADD1
, ALT_PAST_PERF_ADD2 ALT_PAST_PERF_ADD2
, ALT_PAST_PERF_CITY ALT_PAST_PERF_CITY
, ALT_PAST_PERF_POSTAL_CODE ALT_PAST_PERF_POSTAL_CODE
, ALT_PAST_PERF_COUNTRY ALT_PAST_PERF_COUNTRY
, ALT_PAST_PERF_STATE ALT_PAST_PERF_STATE
, ALT_PAST_PERF_US_PHONE ALT_PAST_PERF_US_PHONE
, ALT_PAST_PERF_US_PHONE_EX ALT_PAST_PERF_US_PHONE_EX
, ALT_PAST_PERF_NON_US_PHONE ALT_PAST_PERF_NON_US_PHONE
, ALT_PAST_PERF_FAX ALT_PAST_PERF_FAX
, ALT_PAST_PERF_EMAIL ALT_PAST_PERF_EMAIL
, ELEC_BUS_POC ELEC_BUS_POC
, ELEC_BUS_ADD1 ELEC_BUS_ADD1
, ELEC_BUS_ADD2 ELEC_BUS_ADD2
, ELEC_BUS_CITY ELEC_BUS_CITY
, ELEC_BUS_POSTAL_CODE ELEC_BUS_POSTAL_CODE
, ELEC_BUS_COUNTRY ELEC_BUS_COUNTRY
, ELEC_BUS_STATE ELEC_BUS_STATE
, ELEC_BUS_US_PHONE ELEC_BUS_US_PHONE
, ELEC_BUS_US_PHONE_EX ELEC_BUS_US_PHONE_EX
, ELEC_BUS_NON_US_PHONE ELEC_BUS_NON_US_PHONE
, ELEC_BUS_FAX ELEC_BUS_FAX
, ELEC_BUS_EMAIL ELEC_BUS_EMAIL
, ALT_ELEC_BUS_POC ALT_ELEC_BUS_POC
, ALT_ELEC_BUS_ADD1 ALT_ELEC_BUS_ADD1
, ALT_ELEC_BUS_ADD2 ALT_ELEC_BUS_ADD2
, ALT_ELEC_BUS_CITY ALT_ELEC_BUS_CITY
, ALT_ELEC_BUS_POSTAL_CODE ALT_ELEC_BUS_POSTAL_CODE
, ALT_ELEC_BUS_COUNTRY ALT_ELEC_BUS_COUNTRY
, ALT_ELEC_BUS_STATE ALT_ELEC_BUS_STATE
, ALT_ELEC_BUS_US_PHONE ALT_ELEC_BUS_US_PHONE
, ALT_ELEC_BUS_US_PHONE_EX ALT_ELEC_BUS_US_PHONE_EX
, ALT_ELEC_BUS_NON_US_PHONE ALT_ELEC_BUS_NON_US_PHONE
, ALT_ELEC_BUS_FAX ALT_ELEC_BUS_FAX
, ALT_ELEC_BUS_EMAIL ALT_ELEC_BUS_EMAIL
, CERTIFIER_POC CERTIFIER_POC
, CERTIFIER_US_PHONE CERTIFIER_US_PHONE
, CERTIFIER_US_PHONE_EX CERTIFIER_US_PHONE_EX
, CERTIFIER_NON_US_PHONE CERTIFIER_NON_US_PHONE
, CERTIFIER_FAX CERTIFIER_FAX
, CERTIFIER_EMAIL CERTIFIER_EMAIL
, ALT_CERTIFIER_POC ALT_CERTIFIER_POC
, ALT_CERTIFIER_US_PHONE ALT_CERTIFIER_US_PHONE
, ALT_CERTIFIER_US_PHONE_EX ALT_CERTIFIER_US_PHONE_EX
, ALT_CERTIFIER_NON_US_PHONE ALT_CERTIFIER_NON_US_PHONE
, ALT_CERTIFIER_EMAIL ALT_CERTIFIER_EMAIL
, ALT_CERTIFIER_FAX ALT_CERTIFIER_FAX
, CORP_INFO_POC CORP_INFO_POC
, CORP_INFO_US_PHONE CORP_INFO_US_PHONE
, CORP_INFO_US_PHONE_EX CORP_INFO_US_PHONE_EX
, CORP_INFO_NON_US_PHONE CORP_INFO_NON_US_PHONE
, CORP_INFO_FAX CORP_INFO_FAX
, CORP_INFO_EMAIL CORP_INFO_EMAIL
, OWNER_INFO_POC OWNER_INFO_POC
, OWNER_INFO_US_PHONE OWNER_INFO_US_PHONE
, OWNER_INFO_US_PHONE_EX OWNER_INFO_US_PHONE_EX
, OWNER_INFO_NON_US_PHONE OWNER_INFO_NON_US_PHONE
, OWNER_INFO_FAX OWNER_INFO_FAX
, OWNER_INFO_EMAIL OWNER_INFO_EMAIL
, EDI EDI
, TAXPAYER_ID TAXPAYER_ID
, AVG_NUM_EMPLOYEES AVG_NUM_EMPLOYEES
, ANNUAL_REVENUE ANNUAL_REVENUE
, SOCIAL_SECURITY_NUMBER SOCIAL_SECURITY_NUMBER
, FINANCIAL_INSTITUTE FINANCIAL_INSTITUTE
, BANK_ACCT_NUMBER BANK_ACCT_NUMBER
, ABA_ROUTING ABA_ROUTING
, BANK_ACCT_TYPE BANK_ACCT_TYPE
, LOCKBOX_NUMBER LOCKBOX_NUMBER
, AUTHORIZATION_DATE AUTHORIZATION_DATE
, EFT_WAIVER EFT_WAIVER
, ACH_US_PHONE ACH_US_PHONE
, ACH_NON_US_PHONE ACH_NON_US_PHONE
, ACH_FAX ACH_FAX
, ACH_EMAIL ACH_EMAIL
, REMIT_POC REMIT_POC
, REMIT_ADD1 REMIT_ADD1
, REMIT_ADD2 REMIT_ADD2
, REMIT_CITY REMIT_CITY
, REMIT_STATE REMIT_STATE
, REMIT_POSTAL_CODE REMIT_POSTAL_CODE
, REMIT_COUNTRY REMIT_COUNTRY
, AR_POC AR_POC
, AR_US_PHONE AR_US_PHONE
, AR_US_PHONE_EX AR_US_PHONE_EX
, AR_NON_US_PHONE AR_NON_US_PHONE
, AR_FAX AR_FAX
, AR_EMAIL AR_EMAIL
, MPIN MPIN
, EDI_COORDINATOR EDI_COORDINATOR
, EDI_US_PHONE EDI_US_PHONE
, EDI_US_PHONE_EX EDI_US_PHONE_EX
, EDI_NON_US_PHONE EDI_NON_US_PHONE
, EDI_FAX EDI_FAX
, EDI_EMAIL EDI_EMAIL
, VAN VAN
, ISA_QUALIFIER ISA_QUALIFIER
, ISA_SENDER_QUALIFIER ISA_SENDER_QUALIFIER
, GS02_IDENTIFIER GS02_IDENTIFIER
, RECEIVE_820 RECEIVE_820
, HQ_PARENT_NAME HQ_PARENT_NAME
, HQ_PARENT_DUNS HQ_PARENT_DUNS
, HQ_PARENT_ADD1 HQ_PARENT_ADD1
, HQ_PARENT_ADD2 HQ_PARENT_ADD2
, HQ_PARENT_CITY HQ_PARENT_CITY
, HQ_PARENT_STATE HQ_PARENT_STATE
, HQ_PARENT_POSTAL_CODE HQ_PARENT_POSTAL_CODE
, HQ_PARENT_COUNTRY HQ_PARENT_COUNTRY
, HQ_PARENT_PHONE HQ_PARENT_PHONE
, HQ_PARENT_RECORD_DATE HQ_PARENT_RECORD_DATE
, GLOBAL_ULT_NAME GLOBAL_ULT_NAME
, GLOBAL_ULT_DUNS GLOBAL_ULT_DUNS
, GLOBAL_ULT_ADD1 GLOBAL_ULT_ADD1
, GLOBAL_ULT_ADD2 GLOBAL_ULT_ADD2
, GLOBAL_ULT_CITY GLOBAL_ULT_CITY
, GLOBAL_ULT_POSTAL_CODE GLOBAL_ULT_POSTAL_CODE
, GLOBAL_ULT_COUNTRY GLOBAL_ULT_COUNTRY
, GLOBAL_ULT_STATE GLOBAL_ULT_STATE
, GLOBAL_ULT_PHONE GLOBAL_ULT_PHONE
, GLOBAL_ULT_RECORD_DATE GLOBAL_ULT_RECORD_DATE
, DOMESTIC_ULT_NAME DOMESTIC_ULT_NAME
, DOMESTIC_ULT_DUNS DOMESTIC_ULT_DUNS
, DOMESTIC_ULT_ADD1 DOMESTIC_ULT_ADD1
, DOMESTIC_ULT_ADD2 DOMESTIC_ULT_ADD2
, DOMESTIC_ULT_CITY DOMESTIC_ULT_CITY
, DOMESTIC_ULT_POSTAL_CODE DOMESTIC_ULT_POSTAL_CODE
, DOMESTIC_ULT_COUNTRY DOMESTIC_ULT_COUNTRY
, DOMESTIC_ULT_STATE DOMESTIC_ULT_STATE
, DOMESTIC_ULT_PHONE DOMESTIC_ULT_PHONE
, DOMESTIC_ULT_RECORD_DATE DOMESTIC_ULT_RECORD_DATE
, FILE_DATE FILE_DATE
, DOMESTIC_PARENT_POC DOMESTIC_PARENT_POC
, DOMESTIC_PARENT_DUNS DOMESTIC_PARENT_DUNS
, DOMESTIC_PARENT_ADD1 DOMESTIC_PARENT_ADD1
, DOMESTIC_PARENT_ADD2 DOMESTIC_PARENT_ADD2
, DOMESTIC_PARENT_CITY DOMESTIC_PARENT_CITY
, DOMESTIC_PARENT_POSTAL_CODE DOMESTIC_PARENT_POSTAL_CODE
, DOMESTIC_PARENT_COUNTRY DOMESTIC_PARENT_COUNTRY
, DOMESTIC_PARENT_STATE DOMESTIC_PARENT_STATE
, DOMESTIC_PARENT_PHONE DOMESTIC_PARENT_PHONE
, GLOBAL_PARENT_POC GLOBAL_PARENT_POC
, GLOBAL_PARENT_DUNS GLOBAL_PARENT_DUNS
, GLOBAL_PARENT_ADD1 GLOBAL_PARENT_ADD1
, GLOBAL_PARENT_ADD2 GLOBAL_PARENT_ADD2
, GLOBAL_PARENT_CITY GLOBAL_PARENT_CITY
, GLOBAL_PARENT_POSTAL_CODE GLOBAL_PARENT_POSTAL_CODE
, GLOBAL_PARENT_COUNTRY GLOBAL_PARENT_COUNTRY
, GLOBAL_PARENT_STATE GLOBAL_PARENT_STATE
, GLOBAL_PARENT_PHONE GLOBAL_PARENT_PHONE
, DNB_MONITOR_LAST_UPDATED DNB_MONITOR_LAST_UPDATED
, DNB_MONITOR_STATUS DNB_MONITOR_STATUS
, DNB_MONITOR_CORP_NAME DNB_MONITOR_CORP_NAME
, DNB_MONITOR_DBA DNB_MONITOR_DBA
, DNB_MONITOR_ST_ADD1 DNB_MONITOR_ST_ADD1
, DNB_MONITOR_ST_ADD2 DNB_MONITOR_ST_ADD2
, DNB_MONITOR_CITY DNB_MONITOR_CITY
, DNB_MONITOR_POSTAL_CODE DNB_MONITOR_POSTAL_CODE
, DNB_MONITOR_COUNTRY_CODE DNB_MONITOR_COUNTRY_CODE
, DNB_MONITOR_STATE DNB_MONITOR_STATE
, HQ_PARENT_POC HQ_PARENT_POC
, ANNUAL_RECEIPTS ANNUAL_RECEIPTS
, AUSTIN_TETRA_NUMBER AUSTIN_TETRA_NUMBER
, AUSTIN_TETRA_PARENT_NUMBER AUSTIN_TETRA_PARENT_NUMBER
, AUSTIN_TETRA_ULTIMATE_NUMBER AUSTIN_TETRA_ULTIMATE_NUMBER
, AUSTIN_TETRA_PCARD_FLAG AUSTIN_TETRA_PCARD_FLAG
, PAYMENT_TYPE PAYMENT_TYPE
FROM "FV"."FV_CCR_PROCESS_GT"