Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Custom Object Field: Import Preparation

The following tables contain specific information about setting up your CSV file before importing custom object fields for custom objects into Oracle CRM On Demand. This information supplements the guidelines given in the topic Field Type Guidelines for Importing Data. First, 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.

Custom Object 01, Custom Object 02, and Custom Object 03

The information in the following table is valid for Custom Object 01, Custom Object 02, and Custom Object 03 only.

Default Custom Object Field Name

Data Type

Maximum Length

Name

Text

50

Account Location

Text

50

Description

Text

16,350

Custom Objects 04-15

Text

50

Custom Objects 04-15 External Unique ID

Text

30

Integration ID

Text

30

External Unique ID

Text

30

Owner

Email

50

Currency

Text

20

Quick Search 1

Text

50

Quick Search 2

Text

50

Indexed Picklist 1

Text

30

Indexed Picklist 2

Text

30

Indexed Picklist 3

Text

30

Indexed Picklist 4

Text

30

Indexed Picklist 5

Text

30

Indexed Number

Number

16

Indexed Date

Date/Time

32

Indexed Currency

Currency

25

Indexed Checkbox

Boolean

1

Type

Text

30

Account

Text

100

Campaign

Text

100

Contact

Text

255

Custom Object 01

Text

50

Custom Object 02

Text

50

Custom Object 03

Text

50

Dealer

Text

100

Fund

Text

50

Household

Text

50

Lead

Text

255

MedEd Event

Text

50

Opportunity

Text

100

Portfolio

Text

100

Product

Text

100

Service Request

Text

64

Solution

Text

100

Vehicle

Text

100

Account External ID

Text

30

Campaign External ID

Text

30

Contact External ID

Text

30

Custom Object 01 External ID

Text

30

Custom Object 02 External ID

Text

30

Custom Object 03 External ID

Text

30

Lead External ID

Text

30

Opportunity External ID

Text

30

Owner External ID

Text

30

Portfolio External ID

Text

30

Product External ID

Text

30

Service Request External ID

Text

30

Solution External ID

Text

30

Custom Objects 04 and higher

The information in the following table is valid for custom objects 04 and higher only.

Default Custom Object Field Name

Data Type

Maximum Length

Account

Text

100

Activity

Text

100

Campaign

Text

100

Custom Objects 01-15

Text

50

Dealer

Text

100

Description

Text

16,350

Exchange Date

Date

30

External Unique ID

Text

30

Fund

Text

50

Fund Request

Text

50

Household

Text

1

Indexed Checkbox

Boolean

1

Indexed Currency

Currency

25

Indexed Date

DateTime

32

Indexed Number

Number

16

Indexed Picklist 1

Text

30

Indexed Picklist 2

Text

30

Indexed Picklist 3

Text

30

Indexed Picklist 4

Text

30

Indexed Picklist 5

Text

30

Integration ID

Text

30

Lead

Text

225

MedEd Event

Text

50

Name

Text

50

Opportunity

Text

100

Owner

Email

50

Portfolio

Text

100

Product

Text

100

Quick Search 1

Text

50

Quick Search 2

Text

50

Service Request

Text

64

Type

Text

30

Vehicle

Text

100

Account External Unique ID

Text

30

Activity External Unique ID

Text

30

Asset External System ID

Text

30

Campaign External Unique ID

Text

30

Company External System ID

Text

30

Contact External Unique ID

Text

30

Custom Objects 01-15 External Unique IDs

Text

30

Dealer External Unique ID

Text

30

Fund Request External Unique ID

Text

30

Household External Unique ID

Text

30

Opportunity External Unique ID

Text

30

Owner External Unique ID

Text

30

Portfolio External Unique ID

Text

30

Product External Unique ID

Text

30

Service Request External Unique ID

Text

30

Solution Request External Unique ID

Text

30

Vehicle External Unique ID

Text

30


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