|
Administering Oracle CRM On Demand > Data Management Tools > Import and Export Tools > Preparing for Data Importing > Custom Object Field: Import Preparation
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 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
|
Division
|
Text
|
50
|
Custom Objects 04-15 External Unique ID
|
Text
|
30
|
Integration ID
|
Text
|
30
|
External Unique ID
|
Text
|
30
|
Owner
|
Email
|
50
|
Picklist Value Group
|
Text
|
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
|
Event
|
Text
|
50
|
Fund
|
Text
|
50
|
Household
|
Text
|
50
|
Lead
|
Text
|
255
|
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
|
Book
|
String
|
150
|
Book:ID
|
String
|
15
|
Campaign
|
Text
|
100
|
Custom Objects 01-15
|
Text
|
50
|
Dealer
|
Text
|
100
|
Description
|
Text
|
16,350
|
Exchange Date
|
Date
|
32
|
External Unique ID
|
Text
|
30
|
Event
|
Text
|
50
|
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
|
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
|
| 
