[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FV_CCR_VENDORS# |
|---|---|
| Object Type: | VIEW |
| Owner: | FV |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CCR_ID | NUMBER | Yes | ||
| ENABLED | VARCHAR2 | (1) | Yes | |
| EXTRACT_CODE | VARCHAR2 | (1) | ||
| VENDOR_ID | NUMBER | |||
| BANK_BRANCH_ID | NUMBER | |||
| LAST_IMPORT_DATE | DATE | |||
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | |
| CCR_FLAG | VARCHAR2 | (1) | Yes | |
| CCR_STATUS | VARCHAR2 | (1) | Yes | |
| DUNS | VARCHAR2 | (9) | Yes | |
| PLUS_FOUR | VARCHAR2 | (4) | ||
| CAGE_CODE | VARCHAR2 | (10) | ||
| 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_TYPE1 | VARCHAR2 | (2) | ||
| BUSINESS_TYPE2 | VARCHAR2 | (2) | ||
| BUSINESS_TYPE3 | VARCHAR2 | (2) | ||
| BUSINESS_TYPE4 | VARCHAR2 | (2) | ||
| BUSINESS_TYPE5 | VARCHAR2 | (2) | ||
| BUSINESS_TYPE6 | VARCHAR2 | (2) | ||
| BUSINESS_TYPE7 | VARCHAR2 | (2) | ||
| BUSINESS_TYPE8 | VARCHAR2 | (2) | ||
| BUSINESS_TYPE9 | VARCHAR2 | (2) | ||
| BUSINESS_TYPE10 | VARCHAR2 | (2) | ||
| SIC_CODE1 | VARCHAR2 | (8) | ||
| SIC_CODE2 | VARCHAR2 | (8) | ||
| SIC_CODE3 | VARCHAR2 | (8) | ||
| SIC_CODE4 | VARCHAR2 | (8) | ||
| SIC_CODE5 | VARCHAR2 | (8) | ||
| SIC_CODE6 | VARCHAR2 | (8) | ||
| SIC_CODE7 | VARCHAR2 | (8) | ||
| SIC_CODE8 | VARCHAR2 | (8) | ||
| SIC_CODE9 | VARCHAR2 | (8) | ||
| SIC_CODE10 | VARCHAR2 | (8) | ||
| SIC_CODE11 | VARCHAR2 | (8) | ||
| SIC_CODE12 | VARCHAR2 | (8) | ||
| SIC_CODE13 | VARCHAR2 | (8) | ||
| SIC_CODE14 | VARCHAR2 | (8) | ||
| SIC_CODE15 | VARCHAR2 | (8) | ||
| SIC_CODE16 | VARCHAR2 | (8) | ||
| SIC_CODE17 | VARCHAR2 | (8) | ||
| SIC_CODE18 | VARCHAR2 | (8) | ||
| SIC_CODE19 | VARCHAR2 | (8) | ||
| SIC_CODE20 | VARCHAR2 | (8) | ||
| NAICS_CODE1 | VARCHAR2 | (6) | ||
| NAICS_CODE2 | VARCHAR2 | (6) | ||
| NAICS_CODE3 | VARCHAR2 | (6) | ||
| NAICS_CODE4 | VARCHAR2 | (6) | ||
| NAICS_CODE5 | VARCHAR2 | (6) | ||
| NAICS_CODE6 | VARCHAR2 | (6) | ||
| NAICS_CODE7 | VARCHAR2 | (6) | ||
| NAICS_CODE8 | VARCHAR2 | (6) | ||
| NAICS_CODE9 | VARCHAR2 | (6) | ||
| NAICS_CODE10 | VARCHAR2 | (6) | ||
| NAICS_CODE11 | VARCHAR2 | (6) | ||
| NAICS_CODE12 | VARCHAR2 | (6) | ||
| NAICS_CODE13 | VARCHAR2 | (6) | ||
| NAICS_CODE14 | VARCHAR2 | (6) | ||
| NAICS_CODE15 | VARCHAR2 | (6) | ||
| NAICS_CODE16 | VARCHAR2 | (6) | ||
| NAICS_CODE17 | VARCHAR2 | (6) | ||
| NAICS_CODE18 | VARCHAR2 | (6) | ||
| NAICS_CODE19 | VARCHAR2 | (6) | ||
| NAICS_CODE20 | VARCHAR2 | (6) | ||
| PSC_CODE1 | VARCHAR2 | (4) | ||
| PSC_CODE2 | VARCHAR2 | (4) | ||
| PSC_CODE3 | VARCHAR2 | (4) | ||
| PSC_CODE4 | VARCHAR2 | (4) | ||
| PSC_CODE5 | VARCHAR2 | (4) | ||
| PSC_CODE6 | VARCHAR2 | (4) | ||
| PSC_CODE7 | VARCHAR2 | (4) | ||
| PSC_CODE8 | VARCHAR2 | (4) | ||
| PSC_CODE9 | VARCHAR2 | (4) | ||
| PSC_CODE10 | VARCHAR2 | (4) | ||
| FSC_CODE1 | VARCHAR2 | (4) | ||
| FSC_CODE2 | VARCHAR2 | (4) | ||
| FSC_CODE3 | VARCHAR2 | (4) | ||
| FSC_CODE4 | VARCHAR2 | (4) | ||
| FSC_CODE5 | VARCHAR2 | (4) | ||
| FSC_CODE6 | VARCHAR2 | (4) | ||
| FSC_CODE7 | VARCHAR2 | (4) | ||
| FSC_CODE8 | VARCHAR2 | (4) | ||
| FSC_CODE9 | VARCHAR2 | (4) | ||
| FSC_CODE10 | VARCHAR2 | (4) | ||
| 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_FAX | VARCHAR2 | (30) | ||
| ALT_CERTIFIER_EMAIL | VARCHAR2 | (80) | ||
| CORP_INFO_US_PHONE | VARCHAR2 | (30) | ||
| CORP_INFO_POC | VARCHAR2 | (60) | ||
| 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 | |||
| CONC_REQUEST_STATUS | VARCHAR2 | (1) | ||
| 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_NAME | VARCHAR2 | (60) | ||
| GLOBAL_PARENT_DUNS | VARCHAR2 | (9) | ||
| 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_NAME | VARCHAR2 | (60) | ||
| DOMESTIC_PARENT_DUNS | VARCHAR2 | (9) | ||
| 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 | |||
| DOMESTIC_PARENT_POC | VARCHAR2 | (60) | ||
| GLOBAL_PARENT_POC | VARCHAR2 | (60) |
Cut, paste (and edit) the following text to query this object:
SELECT CCR_ID
, ENABLED
, EXTRACT_CODE
, VENDOR_ID
, BANK_BRANCH_ID
, LAST_IMPORT_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CCR_FLAG
, CCR_STATUS
, DUNS
, PLUS_FOUR
, CAGE_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_TYPE1
, BUSINESS_TYPE2
, BUSINESS_TYPE3
, BUSINESS_TYPE4
, BUSINESS_TYPE5
, BUSINESS_TYPE6
, BUSINESS_TYPE7
, BUSINESS_TYPE8
, BUSINESS_TYPE9
, BUSINESS_TYPE10
, SIC_CODE1
, SIC_CODE2
, SIC_CODE3
, SIC_CODE4
, SIC_CODE5
, SIC_CODE6
, SIC_CODE7
, SIC_CODE8
, SIC_CODE9
, SIC_CODE10
, SIC_CODE11
, SIC_CODE12
, SIC_CODE13
, SIC_CODE14
, SIC_CODE15
, SIC_CODE16
, SIC_CODE17
, SIC_CODE18
, SIC_CODE19
, SIC_CODE20
, NAICS_CODE1
, NAICS_CODE2
, NAICS_CODE3
, NAICS_CODE4
, NAICS_CODE5
, NAICS_CODE6
, NAICS_CODE7
, NAICS_CODE8
, NAICS_CODE9
, NAICS_CODE10
, NAICS_CODE11
, NAICS_CODE12
, NAICS_CODE13
, NAICS_CODE14
, NAICS_CODE15
, NAICS_CODE16
, NAICS_CODE17
, NAICS_CODE18
, NAICS_CODE19
, NAICS_CODE20
, PSC_CODE1
, PSC_CODE2
, PSC_CODE3
, PSC_CODE4
, PSC_CODE5
, PSC_CODE6
, PSC_CODE7
, PSC_CODE8
, PSC_CODE9
, PSC_CODE10
, FSC_CODE1
, FSC_CODE2
, FSC_CODE3
, FSC_CODE4
, FSC_CODE5
, FSC_CODE6
, FSC_CODE7
, FSC_CODE8
, FSC_CODE9
, FSC_CODE10
, 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_FAX
, ALT_CERTIFIER_EMAIL
, CORP_INFO_US_PHONE
, CORP_INFO_POC
, 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
, CONC_REQUEST_STATUS
, 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_NAME
, 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_NAME
, 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
, DOMESTIC_PARENT_POC
, GLOBAL_PARENT_POC
FROM FV.FV_CCR_VENDORS#;
FV
FV_CCR_VENDORS
APPS
FV_CCR_VENDORS
|
|
|
|