Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Application Fields: Import Preparation

The following table contains specific information about setting up your CSV file before importing application records into Oracle CRM On Demand. This information supplements the guidelines given in the topic Field Type Guidelines for Importing Data. You must review the following import information before performing an import.

NOTE: The Default Field column in this table contains only the initial (default) name for each field. It does not contain any names that have been changed for your company in Oracle CRM On Demand. Therefore, if you do not see a specific field when you try to import your data, check with your company administrator to determine the new name for the field.

Default Application Field Name

Data Type

Maximum Length

Comments

Address Address 1

Varchar

200

The number and street of the company's address from whom the application is made.

Address Address 2

Varchar

100

None

Address Address 3

Varchar

100

None

Address City

Varchar

50

None

Address Country

Varchar

30

None

Address PO Box/Sorting Code

Varchar

200

None

Address Province

Varchar

50

None

Address US State

Varchar

10

None

Address Zip/Post Code

Varchar

30

None

Annual Revenue

Number

22

The total annual revenue for the company.

Approval Status

Varchar

30

The current approval status for the application.

Approved Date

Date

7

The date and time that the application was approved.

Campaign

Varchar

15

This is the name of the campaign that attracted the partner to make the partner application.

Cellular Phone #

Varchar

40

The submitter's cellular phone number.

Current Approver

Varchar

15

The name of the current approver.

Email Address

Varchar

100

The submitter's email address.

Existing Partnerships

Varchar

 

The list of existing partnerships.

Expected Partnership Benefits

Varchar

500

The list of expected benefits from this partnership.

First Name

Varchar

50

The submitter's first name.

Industry

Varchar

50

The industry in which the company competes.

Job Title

Varchar

75

The submitter's job title.

Last Name

Varchar

50

The submitter's last name.

Location

Varchar

50

The location of the company.

Main Fax #

Varchar

40

The primary fax number for the company.

Main Phone #

Varchar

40

The primary phone number used to reach the company.

Name

Varchar

50

The name of the company.

Number of Employees

Number

22

The total number of employees in the company.

Owner

Varchar

15

The owner of the record.

Partner

Varchar

15

The partner who is associated with this application.

Partner Program

Varchar

15

The name of the partner program associated with the application.

Partner Type

Varchar

30

The type of partner for which the application is being submitted.

Program Level

Varchar

30

The level of the partner program associated with the application.

Reject Reason

Varchar

30

The reason why the application was rejected.

Source

Varchar

30

The source from which this application comes, for example, Web site, direct mail, email, and so on.

Submission Status

Varchar

30

The status of the submission, such as Not Submitted, Submitted, or Recalled.

Submitted Date

Date

7

The submission date and time of the application.

Web Site

Varchar

100

The URL address for the company.

Work Fax #

Varchar

40

The submitter's work fax number.

Work Phone #

Varchar

40

The submitter's work phone number.

Related Topics

See the following topics for related information:


Published 5/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.