[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FV_CCR_FILE_TEMP |
|---|---|
| Object Type: | TABLE |
| Owner: | FV |
| FND Design Data: |  FV.FV_CCR_FILE_TEMP
|
| Subobject Name: | |
| Status: | VALID |
The FV_CCR_FILE_TEMP table definition includes all the fields present in the complete CCR extract file. The data from the extract files is first loaded into this table and then later copied to the FV_CCR_VENDORS process by the data load process.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FV_CCR_FILE_TEMP_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 DUNS
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| 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 | |
| EXTRACT_CODE | VARCHAR2 | (1) | Extract code contains the status of the DUNS record | |
| 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 | (2) | Physical address state | |
| POSTAL_CODE | VARCHAR2 | (35) | Physical address postal code | |
| COUNTRY | VARCHAR2 | (3) | Country | |
| BUSINESS_START_DATE | DATE | Business Start Date | ||
| FISCAL_YR_CLOSE_DATE | VARCHAR2 | (4) | Fiscal Year Close Date | |
| CORP_SECURITY_LEVEL | VARCHAR2 | (15) | Corporate Security Level | |
| EMP_SECURITY_LEVEL | VARCHAR2 | (15) | Employee Security Level | |
| WEB_SITE | VARCHAR2 | (200) | Web Site | |
| ORGANIZATIONAL_TYPE | VARCHAR2 | (2) | Extract file only | |
| STATE_OF_INC | VARCHAR2 | (2) | Extract file only | |
| COUNTRY_OF_INC | VARCHAR2 | (3) | Extract file only | |
| BUSINESS_TYPES | VARCHAR2 | (20) | 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_CODES | VARCHAR2 | (160) | This field contains all the SIC codes the registrant has entered. SIC codes are four- or eight-digit numbers and should be separated by commas. One is required, with a maximum of 20. | |
| NAICS_CODES | VARCHAR2 | (120) | This field contains all the NAICS codes the registrant has entered. NAICS codes are six-digits and should be separated by commas. One is required, with a maximum of 20. | |
| FSC_CODES | VARCHAR2 | (40) | This field contains all the FSC codes the registrant has entered. FSC codes are four-digits and should be separated by commas. They are optional, with a maximum of 10. | |
| PSC_CODES | VARCHAR2 | (40) | This field contains all the PSC codes the registrant has entered. PSC codes are four-characters and should be separated by commas. They are optional, with a maximum of 10. | |
| CREDIT_CARD_FLAG | VARCHAR2 | (1) | Extract file only | |
| CORRESPONDENCE_FLAG | VARCHAR2 | (1) | Extract file only | |
| MAIL_POC | VARCHAR2 | (60) | Extract file Only | |
| MAIL_ADD1 | VARCHAR2 | (55) | Mailing address line1 | |
| MAIL_ADD2 | VARCHAR2 | (55) | Mailing address line2 | |
| MAIL_CITY | VARCHAR2 | (35) | Mailing city | |
| MAIL_POSTAL_CODE | VARCHAR2 | (35) | Mailing postal code | |
| MAIL_COUNTRY | VARCHAR2 | (3) | Mailing country | |
| MAIL_STATE | VARCHAR2 | (2) | Mailing state | |
| PREV_BUS_POC | VARCHAR2 | (60) | Previous business point of contact | |
| PREV_BUS_ADD1 | VARCHAR2 | (55) | Previous business address line1 | |
| PREV_BUS_ADD2 | VARCHAR2 | (55) | Previous business address line2 | |
| 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 | (2) | Previous business state | |
| PARENT_POC | VARCHAR2 | (60) | Parent point of contact | |
| PARENT_DUNS | VARCHAR2 | (13) | Parent duns number | |
| PARENT_ADD1 | VARCHAR2 | (55) | Parent address line1 | |
| PARENT_ADD2 | VARCHAR2 | (55) | Parent address line2 | |
| PARENT_CITY | VARCHAR2 | (35) | Parent city | |
| PARENT_POSTAL_CODE | VARCHAR2 | (35) | Parent postal code | |
| PARENT_COUNTRY | VARCHAR2 | (3) | Parent country | |
| PARENT_STATE | VARCHAR2 | (2) | Parent state | |
| PARTY_PERF_POC | VARCHAR2 | (60) | Performance administrator contact name | |
| 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 | (2) | Performance administrator state | |
| GOV_PARENT_POC | VARCHAR2 | (60) | Government parent contact name | |
| 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 | (2) | Government parent state | |
| GOV_BUS_POC | VARCHAR2 | (60) | Government business contact name | |
| 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 | (2) | 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 exension | |
| 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 name | |
| 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 | (2) | 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) | Past performance administrator name | |
| 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 | (2) | 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 | (2) | 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) | Electronic business systems authorizer name | |
| 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 | (2) | 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 systems authorizer name | |
| 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 | (2) | 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) | Certifier point of contact | |
| CERTIFIER_US_PHONE | VARCHAR2 | (30) | Certifier US phone number | |
| CERTIFIER_US_PHONE_EX | VARCHAR2 | (10) | Certifier US phone extension number | |
| 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 certifier name | |
| 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_EMAIL | VARCHAR2 | (80) | Alternate certifier email address | |
| ALT_CERTIFIER_FAX | VARCHAR2 | (30) | Alternate certifier fax number | |
| CORP_INFO_POC | VARCHAR2 | (60) | Corporate information provider name | |
| CORP_INFO_US_PHONE | VARCHAR2 | (30) | Corporate information provider US phone number | |
| CORP_INFO_US_PHONE_EX | VARCHAR2 | (10) | Corporate information provider US phone number extension | |
| CORP_INFO_NON_US_PHONE | VARCHAR2 | (30) | Corporate information provider Non-US phone number | |
| 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) | Owner name | |
| 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) | Taxpayer identifier | |
| AVG_NUM_EMPLOYEES | VARCHAR2 | (15) | Average number of employees | |
| ANNUAL_REVENUE | VARCHAR2 | (15) | Annual revenue | |
| SOCIAL_SECURITY_NUMBER | VARCHAR2 | (9) | Social security number | |
| FINANCIAL_INSTITUTE | VARCHAR2 | (30) | Financial institute | |
| BANK_ACCT_NUMBER | VARCHAR2 | (30) | Bank account number | |
| ABA_ROUTING | VARCHAR2 | (9) | Bank ABA routing number | |
| BANK_ACCT_TYPE | VARCHAR2 | (1) | Bank account type | |
| LOCKBOX_NUMBER | VARCHAR2 | (20) | Lockbox number | |
| AUTHORIZATION_DATE | DATE | Authorization date | ||
| 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) | Remit to name for the DUNS number | |
| REMIT_ADD1 | VARCHAR2 | (55) | Remit to address line 1 | |
| REMIT_ADD2 | VARCHAR2 | (55) | Remit to address line 2 | |
| REMIT_CITY | VARCHAR2 | (35) | Remit to city | |
| REMIT_STATE | VARCHAR2 | (2) | Remit to state | |
| REMIT_POSTAL_CODE | VARCHAR2 | (35) | Remit to postal code | |
| REMIT_COUNTRY | VARCHAR2 | (3) | Remit to country | |
| AR_POC | VARCHAR2 | (60) | Accounts receivable contact name (Contact within 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), shared with authorized partner applications | |
| EDI_COORDINATOR | VARCHAR2 | (60) | 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) | XML only | |
| 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 | (2) | 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) | XML only | |
| GLOBAL_ULT_DUNS | VARCHAR2 | (9) | XML only | |
| GLOBAL_ULT_ADD1 | VARCHAR2 | (55) | XML only | |
| GLOBAL_ULT_ADD2 | VARCHAR2 | (55) | XML only | |
| GLOBAL_ULT_CITY | VARCHAR2 | (35) | XML only | |
| GLOBAL_ULT_POSTAL_CODE | VARCHAR2 | (35) | XML only | |
| GLOBAL_ULT_COUNTRY | VARCHAR2 | (3) | XML only | |
| GLOBAL_ULT_STATE | VARCHAR2 | (2) | XML only | |
| GLOBAL_ULT_PHONE | VARCHAR2 | (30) | XML only | |
| GLOBAL_ULT_RECORD_DATE | DATE | XML only | ||
| DOMESTIC_ULT_NAME | VARCHAR2 | (60) | XML only | |
| DOMESTIC_ULT_DUNS | VARCHAR2 | (9) | XML only | |
| DOMESTIC_ULT_ADD1 | VARCHAR2 | (55) | XML only | |
| DOMESTIC_ULT_ADD2 | VARCHAR2 | (55) | XML only | |
| DOMESTIC_ULT_CITY | VARCHAR2 | (35) | XML only | |
| DOMESTIC_ULT_POSTAL_CODE | VARCHAR2 | (35) | XML only | |
| DOMESTIC_ULT_COUNTRY | VARCHAR2 | (3) | XML only | |
| DOMESTIC_ULT_STATE | VARCHAR2 | (2) | XML only | |
| DOMESTIC_ULT_PHONE | VARCHAR2 | (30) | XML only | |
| DOMESTIC_ULT_RECORD_DATE | DATE | XML only | ||
| FILE_DATE | DATE | This field stores information on the date of extract file. |
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
FROM FV.FV_CCR_FILE_TEMP;
FV.FV_CCR_FILE_TEMP does not reference any database object
FV.FV_CCR_FILE_TEMP is referenced by following:
APPS
FV_CCR_FILE_TEMP
|
|
|
|