Administration d'Oracle CRM On Demand > Outils de gestion des données > Outils d'importation et d'exportation > Préparation de l'importation de données > 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.
REMARQUE : La colonne Champ par défaut du tableau suivant contient uniquement le nom (par défaut) d'origine de chaque champ. Elle ne contient pas les noms qui ont été modifiés pour votre société dans Oracle CRM On Demand. De ce fait, si vous ne voyez pas un champ spécifique lorsque vous tentez d'importer vos données, adressez-vous à l'administrateur pour connaître le nouveau nom du champ concerné.
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
|
100
|
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
|
100
|
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
|
|