Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Vehicle Fields: Import Preparation

The following table contains specific information about setting up your CSV file before importing vehicle 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 Vehicle Field Name

Data Type

Maximum Length

VIN

Text

100

Make

Text

30

Model

Text

30

Year

Text

22

Trim

Text

30

Door

Text

30

Exterior Color

Text

30

External Unique ID

Text

30

Owner External ID

Text

30

Account External ID

Text

30

Product External ID

Text

30

Selling Dealer External ID

Text

30

Service Dealer External ID

Text

30

Product Type

Text

30

Selling Dealer

Text

100

Status

Text

255

Account

Text

100

Account Type

Text

255

Contact

Text

255

License Number

Text

30

License State

Text

10

License Expiry

Date

32

Transmission

Text

30

Account Site

Text

50

Status

Text

30

Location

Text

30

Used/New

Text

30

Engine

Text

30

MSRP

Currency

25

Dealer Invoice Price

Currency

25

Owned By

Text

30

Modified: Date External

Date/Time

32

Modified By

Text

255

Vehicle Currency

Text

30

Interior Color

Text

30

Warranty Type

Text

30

Warranty Start Date

Date

32

Warranty End Date

Date

32

Current Mileage

Number

16

Mileage Reading Date

Date

32

Product Name

Text

100

Type

Text

255

Body

Text

30

Description

Text

250

Owner

Email

50

Created: Date External

Date/Time

32

Row Id

Id

15

Integration ID

Text

30

Account Id

Id

15

Account Integration Id

Text

30

Custom Object N

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 Picklist 6

Text

30

Indexed Number

Number

16

Indexed Date

Date/Time

32

Indexed Currency

Currency

25

Indexed Long Text

Text

255

Indexed Short Text 1

Text

100

Indexed Short Text 2

Text

100

Indexed Checkbox

Boolean

1

Product Category

Text

100

Part #

Text

50

Purchase Date

Date

32

Purchase Price

Currency

25

Quantity

Number

16

Ship Date

Date

32

Install Date

Date

32

Expiration Date

Date

32

Notify Date

Date

32

Contract

Text

30


Published 5/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.