Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Asset Fields: Import Preparation

The following table contains specific information about setting up your CSV file before importing assets 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.

Default Asset Field Name

Data Type

Maximum Length

Comments

Account

Text

100

None

Account External ID

Text

30

None

Asset Currency

Picklist

20

You are not able to edit this picklist. Therefore, the values you import must exactly match the valid values.

Contract

Text

30

None

Customer Contact

Text

255

None

Description

Text

250

None

Expiration Date

Date

7

None

External Unique ID

Text

30

None

Install Date

Date

7

This field is automatically populated with the current date when you import assets into Oracle CRM On Demand.

Integration ID

Text

30

None

Notify Date

Date

7

Specific to Oracle CRM On Demand High Tech Edition.

Operating Status

Text

30

None

Product External ID

Text

30

None

Product Name

Text

100

Required field by default.

Purchase Date

Date

7

None

Purchase Price

Currency

15

None

Quantity

Number

15

None

Serial #

Text

100

None

Ship Date

Date

7

None

Warranty

Text

30

None

Related Topics

See the following topics for related information:


Published 6/21/2021 Copyright © 2005, 2021, Oracle and/or its affiliates. Legal Notices.