The following table contains specific information about setting up your CSV file before importing dealer fields 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.
Default Dealer Field Name
|
Data Type
|
Maximum Length
|
Comments
|
Name
|
Text
|
100
|
None
|
Site
|
Text
|
50
|
None
|
Site
|
Text
|
50
|
None
|
Parent Dealer
|
Text
|
100
|
None
|
Status
|
Text
|
255
|
None
|
Parent Site
|
Text
|
50
|
None
|
Phone Number
|
Phone
|
40
|
None
|
E-mail
|
Text
|
50
|
None
|
URL
|
Text
|
100
|
None
|
Status
|
Text
|
30
|
None
|
Fax Number
|
Phone
|
40
|
None
|
Currency
|
Text
|
20
|
None
|
Stage
|
Text
|
30
|
None
|
Ranking
|
Number
|
16
|
None
|
Billing Address
|
Picklist
|
100
|
This field is available only if shared addresses are set up for your company.
This value must match the Address Name field in the existing address record. Also, if the Validate Shared Addresses setting is enabled, then this value must match an existing validated address record.
|
Billing Address 1
|
Text
|
200
|
For a description of how to map address fields on a country-by-country basis, see About Countries and Address Mapping.
This field is not available if shared addresses are set up for your company.
|
Billing Address 2, 3
|
Text
|
100 each
|
This field is not available if shared addresses are set up for your company.
|
Billing City
|
Text
|
50
|
This field is not available if shared addresses are set up for your company.
|
Billing Country
|
Picklist
|
30
|
The default valid values are the names of all the countries in the world. The valid value for the U.S. is USA. Oracle CRM On Demand does not allow the modification of the valid values for this field. Make sure the import data matches the valid values for this field before importing data (see About Countries and Address Mapping).
This field is not available if shared addresses are set up for your company.
|
Billing PO Box/Sorting Code
|
Text
|
30
|
If your file contains non-U.S. addresses, then map the following address items to this field: Colonia/Section, CEDEX Code, Address 4, URB, and Township (see About Countries and Address Mapping).
This field is not available if shared addresses are set up for your company.
|
Billing Province
|
Text
|
50
|
If your file contains non-U.S. addresses, then map the following address items or their equivalents to the U.S. state to this field: MEX State, BRA State, Parish, Part of Territory, Island, Prefecture, Region, Emirate, and Oblast (see About Countries and Address Mapping).
This field is not available if shared addresses are set up for your company.
|
Billing US State
|
Picklist
|
2
|
The default valid values are standard two-letter abbreviations for all the U.S. states (all capital letters). Oracle CRM On Demand does not allow the modification of the valid values for this field. Make sure the import data matches the valid values for this field before importing data.
This field is not available if shared addresses are set up for your company.
|
Billing Zip/Post Code
|
Text
|
30
|
This field is not available if shared addresses are set up for your company.
|
Bill to Address External ID
|
Text
|
30
|
If shared addresses are enabled for your company, then the data type for this field becomes a picklist. The value for this field must match the External Unique Id of an existing address record. Also, if the Validate Shared Addresses setting is enabled, then this value must match an existing validated address record.
|
Shipping Address
|
Text
|
30
|
This field is available only if shared addresses are set up for your company.
This value must match the Address Name field in the existing Address record. Also, if the Validate Shared Addresses setting is enabled, then this value must match an existing validated address record.
|
Shipping Address 1
|
Text
|
200
|
For a description of how to map address fields on a country-by-country basis, see About Countries and Address Mapping.
This field is not available if shared addresses are set up for your company.
|
Shipping Address 2, 3
|
Text
|
100 each
|
For a description of how to map address fields on a country-by-country basis, see About Countries and Address Mapping.
This field is not available if shared addresses are set up for your company.
|
Shipping City
|
Text
|
50
|
This field is not available if shared addresses are set up for your company.
|
Shipping Country
|
Picklist
|
30
|
The default valid values are the names of all the countries in the world. The valid value for the U.S. is USA. Oracle CRM On Demand does not allow the modification of the valid values for this field. Make sure the import data matches the valid values for this field before importing data (see About Countries and Address Mapping).
This field is not available if shared addresses are set up for your company.
|
Shipping PO Box/Sorting Code
|
Text
|
30
|
If your file contains non-U.S. addresses, map the following address items to this field: Colonia/Section, CEDEX Code, Address 4, URB, and Township (see About Countries and Address Mapping).
This field is not available if shared addresses are set up for your company.
|
Shipping Province
|
Text
|
50
|
If your file contains non-U.S. addresses, then map the following address items or their equivalents to the U.S. state to this field: MEX State, BRA State, Parish, Part of Territory, Island, Prefecture, Region, Emirate, and Oblast (see About Countries and Address Mapping).
This field is not available if shared addresses are set up for your company.
|
Shipping US State
|
Picklist
|
2
|
The default valid values are standard two-letter abbreviations for all the U.S. states (all capital letters). Oracle CRM On Demand does not allow modification of valid values for this field. Make sure the import data matches the valid values for this field before importing data.
This field is not available if shared addresses are set up for your company.
|
Shipping Zip/Post Code
|
Text
|
30
|
This field is not available if shared addresses are set up for your company.
|
Shipping to Address External ID
|
Text
|
30
|
If shared addresses are enabled for your company, then the data type for this field becomes a picklist. The value for this field must match the External Unique Id of an existing address record. Also, if the Validate Shared Addresses setting is enabled, then this value must match an existing validated address record.
|
External Unique ID
|
Text
|
30
|
None
|
Parent Dealer External ID
|
Text
|
30
|
None
|
Primary Owner Id
|
Id
|
15
|
None
|
Dealer Type
|
Text
|
30
|
None
|
Modified: Date External
|
Date/Time
|
32
|
None
|
Owner
|
Email
|
50
|
None
|
Modified By
|
Text
|
255
|
None
|
Row Id
|
Id
|
15
|
None
|
Integration ID
|
Text
|
30
|
None
|
Custom Object N
|
Text
|
50
|
None
|
Indexed Picklist 1
|
Text
|
30
|
None
|
Indexed Picklist 2
|
Text
|
30
|
None
|
Indexed Picklist 3
|
Text
|
30
|
None
|
Indexed Picklist 4
|
Text
|
30
|
None
|
Indexed Picklist 5
|
Text
|
30
|
None
|
Indexed Picklist 6
|
Text
|
30
|
None
|
Indexed Number
|
Number
|
16
|
None
|
Indexed Date
|
Date/Time
|
32
|
None
|
Indexed Currency
|
Currency
|
25
|
None
|
Indexed Long Text
|
Text
|
255
|
None
|
Indexed Short Text 1
|
Text
|
100
|
None
|
Indexed Short Text 2
|
Text
|
100
|
None
|
Indexed Checkbox
|
Boolean
|
1
|
None
|