| Print Open PDF Version of Online Help

##### 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.

Published 5/23/2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.