Administering Oracle CRM On Demand > Data Management Tools > Import and Export Tools > Preparing for Data Importing > Order Fields: Import Preparation
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 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.
|
Book
|
String
|
150
|
None
|
Book:ID
|
String
|
15
|
None
|
Order Number
|
Text
|
50
|
This field contains the order ID by default.
|
Description
|
Text
|
255
|
This field is the order description.
|
Division
|
Text
|
50
|
None
|
Owner
|
Varchar
|
15
|
The record owner.
|
Picklist Value Group
|
Text
|
50
|
None
|
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.
|
|