| Print Open PDF Version of Online Help

##### Dealer Fields: Import Preparation 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. 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. NOTE: This section is specific to Oracle CRM On Demand Automotive Edition.
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

Published 5/23/2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.