[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FV_CCR_FILE_TEMP# |
|---|---|
| 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 | (60) | ||
| 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 | (2) | ||
| 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 | (2) | ||
| DOMESTIC_ULT_PHONE | VARCHAR2 | (30) | ||
| DOMESTIC_ULT_RECORD_DATE | DATE | |||
| FILE_DATE | DATE | |||
| 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) | ||
| AUSTIN_TETRA_NUMBER | VARCHAR2 | (10) | ||
| AUSTIN_TETRA_PARENT_NUMBER | VARCHAR2 | (10) | ||
| AUSTIN_TETRA_ULTIMATE_NUMBER | VARCHAR2 | (10) | ||
| AUSTIN_TETRA_PCARD_FLAG | VARCHAR2 | (1) | ||
| ANNUAL_RECEIPTS | VARCHAR2 | (15) | ||
| PAYMENT_TYPE | VARCHAR2 | (1) | ||
| HQ_PARENT_POC | VARCHAR2 | (60) | ||
| 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) | ||
| GLOBAL_PARENT_RECORD_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) | ||
| DOMESTIC_PARENT_RECORD_DATE | DATE |
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
, 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
, AUSTIN_TETRA_NUMBER
, AUSTIN_TETRA_PARENT_NUMBER
, AUSTIN_TETRA_ULTIMATE_NUMBER
, AUSTIN_TETRA_PCARD_FLAG
, ANNUAL_RECEIPTS
, PAYMENT_TYPE
, HQ_PARENT_POC
, 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
, GLOBAL_PARENT_RECORD_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
, DOMESTIC_PARENT_RECORD_DATE
FROM FV.FV_CCR_FILE_TEMP#;
FV
FV_CCR_FILE_TEMP
APPS
FV_CCR_FILE_TEMP
|
|
|
|