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