DBA Data[Home] [Help] [Dependency Information]

TABLE: FV.FV_CCR_VENDORS

Object Details
Object Name: FV_CCR_VENDORS
Object Type: TABLE
Owner: FV
FND Design Data: TableFV.FV_CCR_VENDORS
Subobject Name:
Status: VALID


The FV_CCR_VENDORS table stores all the data from CCR that does not have a logical place in the Payables data model. It also stores a supplier reference, and its primary key is the internal identifier CCR_ID


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FV_CCR_VENDORS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDUNS
Columns
CCR_ID NUMBER
Yes Internal identifier derived from a sequence
ENABLED VARCHAR2 (1) Yes Internal indicator of Y/N, set to N when a record is deleted from CCR.
EXTRACT_CODE VARCHAR2 (1)
Extract code indicating type of changes contained for row in daily file, extract file only
VENDOR_ID NUMBER

Internal identifier for a supplier
BANK_BRANCH_ID NUMBER

Internal identifier for a bank/bank branch
LAST_IMPORT_DATE DATE

This stores the date on which the CCR Data was last imported.
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CCR_FLAG VARCHAR2 (1) Yes Flag denoting whether vendor is exempt or required to register in CCR.
CCR_STATUS VARCHAR2 (1) Yes Status of CCR registration, active, deleted, expired, unregistered, unknown
DUNS VARCHAR2 (9) Yes Contains the DUNS Number
PLUS_FOUR VARCHAR2 (4)
CCR passes a field with four spaces if the registrant has not chosen a DUNS+4. This should be converted to NULL.
CAGE_CODE VARCHAR2 (10)
Government Entity Code
REGISTRATION_DATE DATE

Extract file only
RENEWAL_DATE DATE

Extract file only
LEGAL_BUS_NAME VARCHAR2 (120)
Legal business name
DBA_NAME VARCHAR2 (60)
Doing business as name, if different than legal business name
DIVISION_NAME VARCHAR2 (60)
Used to identify a division of a larger company.
DIVISION_NUMBER VARCHAR2 (10)
Used to identify a division by number of a larger company.
ST_ADDRESS1 VARCHAR2 (55)
Physical address line 1
ST_ADDRESS2 VARCHAR2 (55)
Physical address line 2
CITY VARCHAR2 (35)
Physical address city
STATE VARCHAR2 (60)
Physical address state
POSTAL_CODE VARCHAR2 (35)
Physical address postal code
COUNTRY VARCHAR2 (3)
Physical Address Country
BUSINESS_START_DATE DATE

Date business was started or acquired, required for CCR vendors
FISCAL_YR_CLOSE_DATE VARCHAR2 (4)
MM/DD format, date business accounting fiscal year closes, required for CCR vendors.
CORP_SECURITY_LEVEL VARCHAR2 (15)
Security level of the facility.
EMP_SECURITY_LEVEL VARCHAR2 (15)
Highest level of security for an employee located at the facility.
WEB_SITE VARCHAR2 (200)
Corporate website
ORGANIZATIONAL_TYPE VARCHAR2 (2)
Two-character code to indicate legal form of business, one is required for CCR vendors.
STATE_OF_INC VARCHAR2 (60)
Mandatory for US registrants. Extract file only
COUNTRY_OF_INC VARCHAR2 (3)
Mandatory for foreign registrants, ISO3166 standard country code. Extract file only
BUSINESS_TYPE1 VARCHAR2 (2)
This field contains all the business types the registrant has entered. Business types are two-characters and should be separated by commas. One is required, with a maximum of 10.
BUSINESS_TYPE2 VARCHAR2 (2)
This field contains all the business types the registrant has entered. Business types are two-characters and should be separated by commas. One is required, with a maximum of 10.
BUSINESS_TYPE3 VARCHAR2 (2)
This field contains all the business types the registrant has entered. Business types are two-characters and should be separated by commas. One is required, with a maximum of 10.
BUSINESS_TYPE4 VARCHAR2 (2)
This field contains all the business types the registrant has entered. Business types are two-characters and should be separated by commas. One is required, with a maximum of 10.
BUSINESS_TYPE5 VARCHAR2 (2)
This field contains all the business types the registrant has entered. Business types are two-characters and should be separated by commas. One is required, with a maximum of 10.
BUSINESS_TYPE6 VARCHAR2 (2)
This field contains all the business types the registrant has entered. Business types are two-characters and should be separated by commas. One is required, with a maximum of 10.
BUSINESS_TYPE7 VARCHAR2 (2)
This field contains all the business types the registrant has entered. Business types are two-characters and should be separated by commas. One is required, with a maximum of 10.
BUSINESS_TYPE8 VARCHAR2 (2)
This field contains all the business types the registrant has entered. Business types are two-characters and should be separated by commas. One is required, with a maximum of 10.
BUSINESS_TYPE9 VARCHAR2 (2)
This field contains all the business types the registrant has entered. Business types are two-characters and should be separated by commas. One is required, with a maximum of 10.
BUSINESS_TYPE10 VARCHAR2 (2)
This field contains all the business types the registrant has entered. Business types are two-characters and should be separated by commas. One is required, with a maximum of 10.
SIC_CODE1 VARCHAR2 (8)
Four or eight digits, any valid digit. At least one occurrence must be entered for CCR vendors. No Spaces allowed, maximum of twenty.
SIC_CODE2 VARCHAR2 (8)
Four or eight digits, any valid digit. At least one occurrence must be entered for CCR vendors. No Spaces allowed, maximum of twenty.
SIC_CODE3 VARCHAR2 (8)
Four or eight digits, any valid digit. At least one occurrence must be entered for CCR vendors. No Spaces allowed, maximum of twenty.
SIC_CODE4 VARCHAR2 (8)
Four or eight digits, any valid digit. At least one occurrence must be entered for CCR vendors. No Spaces allowed, maximum of twenty.
SIC_CODE5 VARCHAR2 (8)
Four or eight digits, any valid digit. At least one occurrence must be entered for CCR vendors. No Spaces allowed, maximum of twenty.
SIC_CODE6 VARCHAR2 (8)
Four or eight digits, any valid digit. At least one occurrence must be entered for CCR vendors. No Spaces allowed, maximum of twenty.
SIC_CODE7 VARCHAR2 (8)
Four or eight digits, any valid digit. At least one occurrence must be entered for CCR vendors. No Spaces allowed, maximum of twenty.
SIC_CODE8 VARCHAR2 (8)
Four or eight digits, any valid digit. At least one occurrence must be entered for CCR vendors. No Spaces allowed, maximum of twenty.
SIC_CODE9 VARCHAR2 (8)
Four or eight digits, any valid digit. At least one occurrence must be entered for CCR vendors. No Spaces allowed, maximum of twenty.
SIC_CODE10 VARCHAR2 (8)
Four or eight digits, any valid digit. At least one occurrence must be entered for CCR vendors. No Spaces allowed, maximum of twenty.
SIC_CODE11 VARCHAR2 (8)
Four or eight digits, any valid digit. At least one occurrence must be entered for CCR vendors. No Spaces allowed, maximum of twenty.
SIC_CODE12 VARCHAR2 (8)
Four or eight digits, any valid digit. At least one occurrence must be entered for CCR vendors. No Spaces allowed, maximum of twenty.
SIC_CODE13 VARCHAR2 (8)
Four or eight digits, any valid digit. At least one occurrence must be entered for CCR vendors. No Spaces allowed, maximum of twenty.
SIC_CODE14 VARCHAR2 (8)
Four or eight digits, any valid digit. At least one occurrence must be entered for CCR vendors. No Spaces allowed, maximum of twenty.
SIC_CODE15 VARCHAR2 (8)
Four or eight digits, any valid digit. At least one occurrence must be entered for CCR vendors. No Spaces allowed, maximum of twenty.
SIC_CODE16 VARCHAR2 (8)
Four or eight digits, any valid digit. At least one occurrence must be entered for CCR vendors. No Spaces allowed, maximum of twenty.
SIC_CODE17 VARCHAR2 (8)
Four or eight digits, any valid digit. At least one occurrence must be entered for CCR vendors. No Spaces allowed, maximum of twenty.
SIC_CODE18 VARCHAR2 (8)
Four or eight digits, any valid digit. At least one occurrence must be entered for CCR vendors. No Spaces allowed, maximum of twenty.
SIC_CODE19 VARCHAR2 (8)
Four or eight digits, any valid digit. At least one occurrence must be entered for CCR vendors. No Spaces allowed, maximum of twenty.
SIC_CODE20 VARCHAR2 (8)
Four or eight digits, any valid digit. At least one occurrence must be entered for CCR vendors. No Spaces allowed, maximum of twenty.
NAICS_CODE1 VARCHAR2 (6)
Valid six-digit codes only, must be found in the NAICS_DATA table, maximum of twenty, required for CCR vendors.
NAICS_CODE2 VARCHAR2 (6)
Valid six-digit codes only, must be found in the NAICS_DATA table, maximum of twenty, required for CCR vendors.
NAICS_CODE3 VARCHAR2 (6)
Valid six-digit codes only, must be found in the NAICS_DATA table, maximum of twenty, required for CCR vendors.
NAICS_CODE4 VARCHAR2 (6)
Valid six-digit codes only, must be found in the NAICS_DATA table, maximum of twenty, required for CCR vendors.
NAICS_CODE5 VARCHAR2 (6)
Valid six-digit codes only, must be found in the NAICS_DATA table, maximum of twenty, required for CCR vendors.
NAICS_CODE6 VARCHAR2 (6)
Valid six-digit codes only, must be found in the NAICS_DATA table, maximum of twenty, required for CCR vendors.
NAICS_CODE7 VARCHAR2 (6)
Valid six-digit codes only, must be found in the NAICS_DATA table, maximum of twenty, required for CCR vendors.
NAICS_CODE8 VARCHAR2 (6)
Valid six-digit codes only, must be found in the NAICS_DATA table, maximum of twenty, required for CCR vendors.
NAICS_CODE9 VARCHAR2 (6)
Valid six-digit codes only, must be found in the NAICS_DATA table, maximum of twenty, required for CCR vendors.
NAICS_CODE10 VARCHAR2 (6)
Valid six-digit codes only, must be found in the NAICS_DATA table, maximum of twenty, required for CCR vendors.
NAICS_CODE11 VARCHAR2 (6)
Valid six-digit codes only, must be found in the NAICS_DATA table, maximum of twenty, required for CCR vendors.
NAICS_CODE12 VARCHAR2 (6)
Valid six-digit codes only, must be found in the NAICS_DATA table, maximum of twenty, required for CCR vendors.
NAICS_CODE13 VARCHAR2 (6)
Valid six-digit codes only, must be found in the NAICS_DATA table, maximum of twenty, required for CCR vendors.
NAICS_CODE14 VARCHAR2 (6)
Valid six-digit codes only, must be found in the NAICS_DATA table, maximum of twenty, required for CCR vendors.
NAICS_CODE15 VARCHAR2 (6)
Valid six-digit codes only, must be found in the NAICS_DATA table, maximum of twenty, required for CCR vendors.
NAICS_CODE16 VARCHAR2 (6)
Valid six-digit codes only, must be found in the NAICS_DATA table, maximum of twenty, required for CCR vendors.
NAICS_CODE17 VARCHAR2 (6)
Valid six-digit codes only, must be found in the NAICS_DATA table, maximum of twenty, required for CCR vendors.
NAICS_CODE18 VARCHAR2 (6)
Valid six-digit codes only, must be found in the NAICS_DATA table, maximum of twenty, required for CCR vendors.
NAICS_CODE19 VARCHAR2 (6)
Valid six-digit codes only, must be found in the NAICS_DATA table, maximum of twenty, required for CCR vendors.
NAICS_CODE20 VARCHAR2 (6)
Valid six-digit codes only, must be found in the NAICS_DATA table, maximum of twenty, required for CCR vendors.
PSC_CODE1 VARCHAR2 (4)
Any valid four position PSC code. No Spaces. Maximum of ten.
PSC_CODE2 VARCHAR2 (4)
Any valid four position PSC code. No Spaces. Maximum of ten.
PSC_CODE3 VARCHAR2 (4)
Any valid four position PSC code. No Spaces. Maximum of ten.
PSC_CODE4 VARCHAR2 (4)
Any valid four position PSC code. No Spaces. Maximum of ten.
PSC_CODE5 VARCHAR2 (4)
Any valid four position PSC code. No Spaces. Maximum of ten.
PSC_CODE6 VARCHAR2 (4)
Any valid four position PSC code. No Spaces. Maximum of ten.
PSC_CODE7 VARCHAR2 (4)
Any valid four position PSC code. No Spaces. Maximum of ten.
PSC_CODE8 VARCHAR2 (4)
Any valid four position PSC code. No Spaces. Maximum of ten.
PSC_CODE9 VARCHAR2 (4)
Any valid four position PSC code. No Spaces. Maximum of ten.
PSC_CODE10 VARCHAR2 (4)
Any valid four position PSC code. No Spaces. Maximum of ten.
FSC_CODE1 VARCHAR2 (4)
Any valid four position Federal Supply Classification code. No spaces. Maximum of ten.
FSC_CODE2 VARCHAR2 (4)
Any valid four position Federal Supply Classification code. No spaces. Maximum of ten.
FSC_CODE3 VARCHAR2 (4)
Any valid four position Federal Supply Classification code. No spaces. Maximum of ten.
FSC_CODE4 VARCHAR2 (4)
Any valid four position Federal Supply Classification code. No spaces. Maximum of ten.
FSC_CODE5 VARCHAR2 (4)
Any valid four position Federal Supply Classification code. No spaces. Maximum of ten.
FSC_CODE6 VARCHAR2 (4)
Any valid four position Federal Supply Classification code. No spaces. Maximum of ten.
FSC_CODE7 VARCHAR2 (4)
Any valid four position Federal Supply Classification code. No spaces. Maximum of ten.
FSC_CODE8 VARCHAR2 (4)
Any valid four position Federal Supply Classification code. No spaces. Maximum of ten.
FSC_CODE9 VARCHAR2 (4)
Any valid four position Federal Supply Classification code. No spaces. Maximum of ten.
FSC_CODE10 VARCHAR2 (4)
Any valid four position Federal Supply Classification code. No spaces. Maximum of ten.
CREDIT_CARD_FLAG VARCHAR2 (1)
This vendor accepts/does not accept credit cards. Extract file only
CORRESPONDENCE_FLAG VARCHAR2 (1)
Single alpha character M = US Mail, F = Fax, and E = Email. Used to discern the preferred correspondence type, required for CCR vendors. Extract file only
MAIL_POC VARCHAR2 (60)
Extract file Only
MAIL_ADD1 VARCHAR2 (55)
Mailing address line 1
MAIL_ADD2 VARCHAR2 (55)
Mailing address line 2
MAIL_CITY VARCHAR2 (35)
Mailing city
MAIL_POSTAL_CODE VARCHAR2 (35)
Mailing postal code
MAIL_COUNTRY VARCHAR2 (3)
Mailing country
MAIL_STATE VARCHAR2 (60)
Mailing state
PREV_BUS_POC VARCHAR2 (60)
Previous business information, if the business was formerly known by a different name or had a different physical address.
PREV_BUS_ADD1 VARCHAR2 (55)
Previous business address line 1
PREV_BUS_ADD2 VARCHAR2 (55)
Previous business address line 2
PREV_BUS_CITY VARCHAR2 (35)
Previous business city
PREV_BUS_POSTAL_CODE VARCHAR2 (35)
Previous business postal code
PREV_BUS_COUNTRY VARCHAR2 (3)
Previous business country
PREV_BUS_STATE VARCHAR2 (60)
Previous business state
PARENT_POC VARCHAR2 (60)
Parent company information.
PARENT_DUNS VARCHAR2 (13)
Parent company DUNS number
PARENT_ADD1 VARCHAR2 (55)
Parent company address line 1
PARENT_ADD2 VARCHAR2 (55)
Parent company address line 2
PARENT_CITY VARCHAR2 (35)
Parent company city
PARENT_POSTAL_CODE VARCHAR2 (35)
Parent company postal code
PARENT_COUNTRY VARCHAR2 (3)
Parent company country
PARENT_STATE VARCHAR2 (60)
Parent company state
PARTY_PERF_POC VARCHAR2 (60)
Certifying party information for specific business types, like 8(a) program participants.
PARTY_PERF_ADD1 VARCHAR2 (55)
Performance administrator address line 1
PARTY_PERF_ADD2 VARCHAR2 (55)
Performance administrator address line 2
PARTY_PERF_CITY VARCHAR2 (35)
Performance administrator city
PARTY_PERF_POSTAL_CODE VARCHAR2 (35)
Performance administrator postal code
PARTY_PERF_COUNTRY VARCHAR2 (3)
Performance administrator country
PARTY_PERF_STATE VARCHAR2 (60)
Performance administrator state
GOV_PARENT_POC VARCHAR2 (60)
Government parent information
GOV_PARENT_ADD1 VARCHAR2 (55)
Government parent address line 1
GOV_PARENT_ADD2 VARCHAR2 (55)
Government parent address line 2
GOV_PARENT_CITY VARCHAR2 (35)
Government parent city
GOV_PARENT_POSTAL_CODE VARCHAR2 (35)
Government parent postal code
GOV_PARENT_COUNTRY VARCHAR2 (3)
Government parent country
GOV_PARENT_STATE VARCHAR2 (60)
Government parent state
GOV_BUS_POC VARCHAR2 (60)
Government business contact within the company
GOV_BUS_ADD1 VARCHAR2 (55)
Government business contact address line 1
GOV_BUS_ADD2 VARCHAR2 (55)
Government business contact address line 2
GOV_BUS_CITY VARCHAR2 (35)
Government business contact city
GOV_BUS_POSTAL_CODE VARCHAR2 (35)
Government business contact postal code
GOV_BUS_COUNTRY VARCHAR2 (3)
Government business contact country
GOV_BUS_STATE VARCHAR2 (60)
Government business contact state
GOV_BUS_US_PHONE VARCHAR2 (30)
Government business contact US phone number
GOV_BUS_US_PHONE_EX VARCHAR2 (10)
Government business contact US phone number extension
GOV_BUS_NON_US_PHONE VARCHAR2 (30)
Government business contact Non-US phone number
GOV_BUS_FAX VARCHAR2 (30)
Government business contact fax number
GOV_BUS_EMAIL VARCHAR2 (80)
Government business contact email address
ALT_GOV_BUS_POC VARCHAR2 (60)
Alternate government business contact
ALT_GOV_BUS_ADD1 VARCHAR2 (55)
Alternate government business contact address line 1
ALT_GOV_BUS_ADD2 VARCHAR2 (55)
Alternate government business contact address line 2
ALT_GOV_BUS_CITY VARCHAR2 (35)
Alternate government business contact city
ALT_GOV_BUS_POSTAL_CODE VARCHAR2 (35)
Alternate government business contact postal code
ALT_GOV_BUS_COUNTRY VARCHAR2 (3)
Alternate government business contact country
ALT_GOV_BUS_STATE VARCHAR2 (60)
Alternate government business contact state
ALT_GOV_BUS_US_PHONE VARCHAR2 (30)
Alternate government business contact US phone number
ALT_GOV_BUS_US_PHONE_EX VARCHAR2 (10)
Alternate government business contact US phone number extension
ALT_GOV_BUS_NON_US_PHONE VARCHAR2 (30)
Alternate government business contact Non-US phone number
ALT_GOV_BUS_FAX VARCHAR2 (30)
Alternate government business contact fax number
ALT_GOV_BUS_EMAIL VARCHAR2 (80)
Alternate government business contact email address
PAST_PERF_POC VARCHAR2 (60)
Contact within the company responsible for maintain government past performance reports and response efforts.
PAST_PERF_ADD1 VARCHAR2 (55)
Past performance administrator address line 1
PAST_PERF_ADD2 VARCHAR2 (55)
Past performance administrator address line 2
PAST_PERF_CITY VARCHAR2 (35)
Past performance administrator city
PAST_PERF_POSTAL_CODE VARCHAR2 (35)
Past performance administrator postal code
PAST_PERF_COUNTRY VARCHAR2 (3)
Past performance administrator country
PAST_PERF_STATE VARCHAR2 (60)
Past performance administrator state
PAST_PERF_US_PHONE VARCHAR2 (30)
Past performance administrator US phone number
PAST_PERF_US_PHONE_EX VARCHAR2 (10)
Past performance administrator US phone number extension
PAST_PERF_NON_US_PHONE VARCHAR2 (30)
Past performance administrator Non-US phone number
PAST_PERF_FAX VARCHAR2 (30)
Past performance administrator fax number
PAST_PERF_EMAIL VARCHAR2 (80)
Past performance administrator email address
ALT_PAST_PERF_POC VARCHAR2 (60)
Alternate past performance administrator name
ALT_PAST_PERF_ADD1 VARCHAR2 (55)
Alternate past performance administrator address line 1
ALT_PAST_PERF_ADD2 VARCHAR2 (55)
Alternate past performance administrator address line 2
ALT_PAST_PERF_CITY VARCHAR2 (35)
Alternate past performance administrator city
ALT_PAST_PERF_POSTAL_CODE VARCHAR2 (35)
Alternate past performance administrator postal code
ALT_PAST_PERF_COUNTRY VARCHAR2 (3)
Alternate past performance administrator country
ALT_PAST_PERF_STATE VARCHAR2 (60)
Alternate past performance administrator state
ALT_PAST_PERF_US_PHONE VARCHAR2 (30)
Alternate past performance administrator US phone number
ALT_PAST_PERF_US_PHONE_EX VARCHAR2 (10)
Alternate past performance administrator US phone number extension
ALT_PAST_PERF_NON_US_PHONE VARCHAR2 (30)
Alternate past performance administrator Non-US phone number
ALT_PAST_PERF_FAX VARCHAR2 (30)
Alternate past performance administrator fax number
ALT_PAST_PERF_EMAIL VARCHAR2 (80)
Alternate past performance administrator email address
ELEC_BUS_POC VARCHAR2 (60)
Contact within the company responsible for authorizing access within the company to government electronic business systems.
ELEC_BUS_ADD1 VARCHAR2 (55)
Electronic business systems authorizer address line 1
ELEC_BUS_ADD2 VARCHAR2 (55)
Electronic business systems authorizer address line 2
ELEC_BUS_CITY VARCHAR2 (35)
Electronic business systems authorizer city
ELEC_BUS_POSTAL_CODE VARCHAR2 (35)
Electronic business systems authorizer postal code
ELEC_BUS_COUNTRY VARCHAR2 (3)
Electronic business systems authorizer country
ELEC_BUS_STATE VARCHAR2 (60)
Electronic business systems authorizer state
ELEC_BUS_US_PHONE VARCHAR2 (30)
Electronic business systems authorizer US phone number
ELEC_BUS_US_PHONE_EX VARCHAR2 (10)
Electronic business systems authorizer US phone number extension
ELEC_BUS_NON_US_PHONE VARCHAR2 (30)
Electronic business systems authorizer Non-US phone number
ELEC_BUS_FAX VARCHAR2 (30)
Electronic business systems authorizer fax number
ELEC_BUS_EMAIL VARCHAR2 (80)
Electronic business systems authorizer email address
ALT_ELEC_BUS_POC VARCHAR2 (60)
Alternate electronic business contact.
ALT_ELEC_BUS_ADD1 VARCHAR2 (55)
Alternate electronic business systems authorizer address line 1
ALT_ELEC_BUS_ADD2 VARCHAR2 (55)
Alternate electronic business systems authorizer address line 2
ALT_ELEC_BUS_CITY VARCHAR2 (35)
Alternate electronic business systems authorizer city
ALT_ELEC_BUS_POSTAL_CODE VARCHAR2 (35)
Alternate electronic business systems authorizer postal code
ALT_ELEC_BUS_COUNTRY VARCHAR2 (3)
Alternate electronic business systems authorizer country
ALT_ELEC_BUS_STATE VARCHAR2 (60)
Alternate electronic business systems authorizer state
ALT_ELEC_BUS_US_PHONE VARCHAR2 (30)
Alternate electronic business systems authorizer US phone number
ALT_ELEC_BUS_US_PHONE_EX VARCHAR2 (10)
Alternate electronic business systems authorizer US phone number extension
ALT_ELEC_BUS_NON_US_PHONE VARCHAR2 (30)
Alternate electronic business systems authorizer Non-US phone number
ALT_ELEC_BUS_FAX VARCHAR2 (30)
Alternate electronic business systems authorizer fax number
ALT_ELEC_BUS_EMAIL VARCHAR2 (80)
Alternate electronic business systems authorizer email address
CERTIFIER_POC VARCHAR2 (60)
CCR registrant within the company, this contact maintains the CCR registration.
CERTIFIER_US_PHONE VARCHAR2 (30)
Certifier US phone number
CERTIFIER_US_PHONE_EX VARCHAR2 (10)
Certifier US phone number extension
CERTIFIER_NON_US_PHONE VARCHAR2 (30)
Certifier Non-US phone number
CERTIFIER_FAX VARCHAR2 (30)
Certifier fax number
CERTIFIER_EMAIL VARCHAR2 (80)
Certifier email address
ALT_CERTIFIER_POC VARCHAR2 (60)
Alternate CCR registrant.
ALT_CERTIFIER_US_PHONE VARCHAR2 (30)
Alternate certifier US phone number
ALT_CERTIFIER_US_PHONE_EX VARCHAR2 (10)
Alternate certifier US phone number extension
ALT_CERTIFIER_NON_US_PHONE VARCHAR2 (30)
Alternate certifier Non-US phone number
ALT_CERTIFIER_FAX VARCHAR2 (30)
Alternate certifier fax number
ALT_CERTIFIER_EMAIL VARCHAR2 (80)
Alternate certifier email address
CORP_INFO_US_PHONE VARCHAR2 (30)
Corporate information provider US phone number
CORP_INFO_POC VARCHAR2 (60)
Contact within the company responsible for providing company information to external parties
CORP_INFO_US_PHONE_EX VARCHAR2 (10)
Corporate information provider US phone number extension
CORP_INFO_NON_US_PHONE VARCHAR2 (30)
c
CORP_INFO_FAX VARCHAR2 (30)
Corporate information provider fax number
CORP_INFO_EMAIL VARCHAR2 (80)
Corporate information provider email address
OWNER_INFO_POC VARCHAR2 (60)
For a sole proprietorship, the owner's contact information.
OWNER_INFO_US_PHONE VARCHAR2 (30)
Owner US phone number
OWNER_INFO_US_PHONE_EX VARCHAR2 (10)
Owner US phone number extension
OWNER_INFO_NON_US_PHONE VARCHAR2 (30)
Owner Non-US phone number
OWNER_INFO_FAX VARCHAR2 (30)
Owner fax number
OWNER_INFO_EMAIL VARCHAR2 (80)
Owner email address
EDI VARCHAR2 (1)
Denotes whether EDI is in use with this vendor
TAXPAYER_ID VARCHAR2 (9)
Redundant in PO_VENDORS.NUM_1099.
AVG_NUM_EMPLOYEES VARCHAR2 (15)
Average employee total from the previous year, required for CCR vendors.
ANNUAL_REVENUE VARCHAR2 (15)
SOCIAL_SECURITY_NUMBER VARCHAR2 (9)
Full 9 digit numeric value assigned to an individual by the US Government, used when taxpayer ID number (TIN) is not available. Used only on a USA trading partner profile with an organizational type of "Sole Proprietorship".
FINANCIAL_INSTITUTE VARCHAR2 (30)
Redundant in AP_BANK_BRANCHES.BANK_NAME
BANK_ACCT_NUMBER VARCHAR2 (30)
Redundant in AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_NUM
ABA_ROUTING VARCHAR2 (9)
Redundant in AP_BANK_BRANCHES.EFT_USER_NUMBER
BANK_ACCT_TYPE VARCHAR2 (1)
LOCKBOX_NUMBER VARCHAR2 (20)
Any valid alphanumeric value assigned by a financial institute. Note: Can only be entered if a financial institute was entered.
AUTHORIZATION_DATE DATE

Effective date of EFT account authorization in MMDDYYYY format. This date will be displayed in MM/DD/YYYY format. Note: Authorization Date will be entered automatically each time the CCR registration is updated/ renewed. The Authorization Date will be the same as the date updated. Must be present if an ABA Routing Number/financial institute was entered.
EFT_WAIVER VARCHAR2 (1)
Extract file Only
ACH_US_PHONE VARCHAR2 (30)
Automated clearing house US phone number
ACH_NON_US_PHONE VARCHAR2 (30)
Automated clearing house Non-US phone number
ACH_FAX VARCHAR2 (30)
Automated clearing house fax number
ACH_EMAIL VARCHAR2 (80)
Automated clearing house email address
REMIT_POC VARCHAR2 (60)
The remit-to address for this DUNS number, redundant in PO_VENDOR_SITES_ALL.ADDRESS_LINE1 on the pay site
REMIT_ADD1 VARCHAR2 (55)
Redundant in PO_VENDOR_SITES_ALL.ADDRESS_LINE2 on the pay site
REMIT_ADD2 VARCHAR2 (55)
Redundant in PO_VENDOR_SITES_ALL.ADDRESS_LINE3 on the pay site
REMIT_CITY VARCHAR2 (35)
Redundant in PO_VENDOR_SITES_ALL.CITY on the pay site
REMIT_STATE VARCHAR2 (60)
Redundant in PO_VENDOR_SITES_ALL.STATE or PO_VENDOR_SITES_ALL.PROVINCE for Canadian vendors on the pay site
REMIT_POSTAL_CODE VARCHAR2 (35)
Redundant in PO_VENDOR_SITES_ALL.ZIP on the pay site
REMIT_COUNTRY VARCHAR2 (3)
Redundant in PO_VENDOR_SITES_ALL.COUNTRY on the pay site
AR_POC VARCHAR2 (60)
Contact within the company that handles Accounts Receivable communication.
AR_US_PHONE VARCHAR2 (30)
Accounts receivable contact US phone number
AR_US_PHONE_EX VARCHAR2 (10)
Accounts receivable contact US phone number extension
AR_NON_US_PHONE VARCHAR2 (30)
Accounts receivable contact Non-US phone number
AR_FAX VARCHAR2 (30)
Accounts receivable contact fax number
AR_EMAIL VARCHAR2 (80)
Accounts receivable contact email address
MPIN VARCHAR2 (9)
Self-defined access code, nine characters mixed alphanumeric (one letter and one number required), share with authorized partner applications. MPIN is a password for those applications.
EDI_COORDINATOR VARCHAR2 (60)
Contact within the company that administers EDI transactions. XML only.
EDI_US_PHONE VARCHAR2 (30)
XML only
EDI_US_PHONE_EX VARCHAR2 (10)
XML only
EDI_NON_US_PHONE VARCHAR2 (30)
XML only
EDI_FAX VARCHAR2 (30)
XML only
EDI_EMAIL VARCHAR2 (80)
XML only
VAN VARCHAR2 (60)
XML only
ISA_QUALIFIER VARCHAR2 (2)
XML only
ISA_SENDER_QUALIFIER VARCHAR2 (15)
XML only
GS02_IDENTIFIER VARCHAR2 (15)
XML only
RECEIVE_820 VARCHAR2 (1)
XML only
HQ_PARENT_NAME VARCHAR2 (60)
HQ_PARENT_DUNS VARCHAR2 (9)
XML only
HQ_PARENT_ADD1 VARCHAR2 (55)
XML only
HQ_PARENT_ADD2 VARCHAR2 (55)
XML only
HQ_PARENT_CITY VARCHAR2 (35)
XML only
HQ_PARENT_STATE VARCHAR2 (60)
XML only
HQ_PARENT_POSTAL_CODE VARCHAR2 (35)
XML only
HQ_PARENT_COUNTRY VARCHAR2 (3)
XML only
HQ_PARENT_PHONE VARCHAR2 (30)
XML only
HQ_PARENT_RECORD_DATE DATE

XML only
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)
CONC_REQUEST_STATUS indicates the status of the CCR Data Processing concurrent program that processes the assignments for the DUNS record.Valid values, if present, are : S - Submitted ; C - Completed ; E - Errored
DNB_MONITOR_LAST_UPDATED VARCHAR2 (60)
DNB Monitor Last Updated
DNB_MONITOR_STATUS VARCHAR2 (60)
DNB Monitor Status
DNB_MONITOR_CORP_NAME VARCHAR2 (120)
DNB Monitor Corp Name
DNB_MONITOR_DBA VARCHAR2 (60)
DNB Monitor DBA
DNB_MONITOR_ST_ADD1 VARCHAR2 (60)
DNB Monitor St Add1
DNB_MONITOR_ST_ADD2 VARCHAR2 (60)
DNB Monitor St Add2
DNB_MONITOR_CITY VARCHAR2 (60)
DNB Monitor City
DNB_MONITOR_POSTAL_CODE VARCHAR2 (60)
DNB Monitor Postal Code
DNB_MONITOR_COUNTRY_CODE VARCHAR2 (60)
DNB Monitor Country Code
DNB_MONITOR_STATE VARCHAR2 (60)
DNB Monitor State
AUSTIN_TETRA_NUMBER VARCHAR2 (10)
Austin Tetra Number
AUSTIN_TETRA_PARENT_NUMBER VARCHAR2 (10)
Austin Tetra Parent Number
AUSTIN_TETRA_ULTIMATE_NUMBER VARCHAR2 (10)
Austin Tetra Ultimate Number
AUSTIN_TETRA_PCARD_FLAG VARCHAR2 (1)
Austin Tetra Pcard Flag
ANNUAL_RECEIPTS VARCHAR2 (15)
Average yearly receipts for the past three years, required for CCR vendors.
PAYMENT_TYPE VARCHAR2 (1)
Redundant in AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_TYPE
HQ_PARENT_POC VARCHAR2 (60)
From D&B, a business establishment where the executive offices of the corporation are located. XML only.
GLOBAL_PARENT_NAME VARCHAR2 (60)
From D&B, the top-most responsible entity within the global family tree. XML only.
GLOBAL_PARENT_DUNS VARCHAR2 (9)
XML only
GLOBAL_PARENT_ADD1 VARCHAR2 (55)
XML only
GLOBAL_PARENT_ADD2 VARCHAR2 (55)
XML only
GLOBAL_PARENT_CITY VARCHAR2 (35)
XML only
GLOBAL_PARENT_POSTAL_CODE VARCHAR2 (35)
XML only
GLOBAL_PARENT_COUNTRY VARCHAR2 (3)
XML only
GLOBAL_PARENT_STATE VARCHAR2 (60)
XML only
GLOBAL_PARENT_PHONE VARCHAR2 (30)
XML only
GLOBAL_PARENT_RECORD_DATE DATE

XML only
DOMESTIC_PARENT_NAME VARCHAR2 (60)
From D&B, the highest ranking subsidiary within the global family tree in a given country. XML only.
DOMESTIC_PARENT_DUNS VARCHAR2 (9)
XML only
DOMESTIC_PARENT_ADD1 VARCHAR2 (55)
XML only
DOMESTIC_PARENT_ADD2 VARCHAR2 (55)
XML only
DOMESTIC_PARENT_CITY VARCHAR2 (35)
XML only
DOMESTIC_PARENT_POSTAL_CODE VARCHAR2 (35)
XML only
DOMESTIC_PARENT_COUNTRY VARCHAR2 (3)
XML only
DOMESTIC_PARENT_STATE VARCHAR2 (60)
XML only
DOMESTIC_PARENT_PHONE VARCHAR2 (30)
XML only
DOMESTIC_PARENT_RECORD_DATE DATE

XML only
DOMESTIC_PARENT_POC VARCHAR2 (60)
Domestic Parent Point of Contact
GLOBAL_PARENT_POC VARCHAR2 (60)
Global Parent Point of Contact
Name Datatype Length Mandatory Comments
Query Text

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;

Dependencies

[top of page]

FV.FV_CCR_VENDORS does not reference any database object

FV.FV_CCR_VENDORS is referenced by following:

SchemaFV
ViewFV_CCR_VENDORS#