Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Order Fields: Import Preparation

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

Default Order Field Name

Data Type

Maximum Length

Comments

Order ID

Text

30

The primary key to the order object. This field is read-only.

Order Number

Text

50

This field contains the order ID by default.

Description

Text

255

This field is the order description.

Owner

Varchar

15

The record owner.

Price List

Picklist

50

This picklist is read-only. The default values for this picklist are the names of the price lists.

Opportunity

Text

15

None.

Account

Text

15

None.

Final Account

Text

15

This field is used when the Ebiz PIP Integration value is selected for the Order Usage setting in the company profile.

Ebiz PIP Integration is the Oracle Lead to Order Integration Pack for Oracle CRM On Demand and Oracle E-Business Suite integration solution, and therefore this field is not available to Oracle CRM On Demand Order Management. For more information on Oracle Lead to Order Integration Pack for Oracle CRM On Demand and Oracle E-Business Suite, contact Customer Care.

Activity

Text

15

None.

Contact

Text

15

None.

Shipping Address

Text

15

The address to which the order is shipped.

Billing Address

Text

15

The address to which the order is billed.

Order Creation Status

Picklist

30

The status code for the order. For more information on this field, see Order Fields.

Order Integration Message

Text

255

This field is populated only when the Ebiz PIP Integration value is selected for the Order Usage setting in the company profile.

Ebiz PIP Integration is the Oracle Lead to Order Integration Pack for Oracle CRM On Demand and Oracle E-Business Suite integration solution, and therefore this field is not available to Oracle CRM On Demand Order Management. For more information on Oracle Lead to Order Integration Pack for Oracle CRM On Demand and Oracle E-Business Suite, contact Customer Care.


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