Print      Open PDF Version of Online Help


Previous Topic

Next Topic

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 company 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/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.