[Home] [Help] [Dependency Information]

VIEW: FV.FV_CCR_PROCESS_GT#

Object Details

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

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

Dependencies

[top of page]

FV

FV_CCR_PROCESS_GT

APPS

FV_CCR_PROCESS_GT