管理 Oracle CRM On Demand > 資料管理工具 > 匯入與匯出工具 > 資料匯入的準備工作 > 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.
附註:此表格中的「預設欄位」資料欄僅包含每個欄位的初始 (預設) 名稱。其中不包含您公司在 Oracle CRM On Demand 中已變更的任何名稱。因此,若您在嘗試匯入資料時沒有看到特定欄位,請洽詢管理員來判定欄位的新名稱。
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
|
|