| Print Open PDF Version of Online Help

##### Sample Request Fields: Import Preparation The following table contains specific information about setting up your CSV file before importing sample requests 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 information before importing data. 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 Sample Request Field Name | Data Type | Maximum Length | Comments
--- | --- | --- | ---
Account | Text | 15 | None.
Account: External Unique ID | Text | 30 | The unique external ID of the parent account record to which the sample request is linked.
Book | String | 150 | None
Book:ID | String | 15 | None
Billing Address | Text | 15 | The address to which the order is billed.
Contact | Text | 15 | This field is required.
Contact: External Unique ID | Text | 30 | The unique external ID of the parent contact record to which the sample request is linked.
Currency | Picklist | 15 | The values in this picklist are read-only. The values that you import must match the valid values in this picklist.
Description | Text | 255 | This field contains the description of the sample request record.
Division | Text | 50 | None
Exchange Date | Date | Not applicable | None
External Flag | Text | 1 | The values for this field are: Y and N. If the external flag has a value of Y, then it indicates that the sample request is created by an external system.
External Unique ID | Text | 30 | None.
Id | Text | 15 | This field is the sample request identifier.
Order Created | UTC Date Time | 7 | The date and time when the order was created.
Order Integration Message | Text | 255 | None.
Order Number | Text | 50 | The default value of this field is the order ID.
Owner | Text | 15 | This field displays the record owner.
Owner: External Unique ID | Text | 30 | The unique external ID of the parent owner record to which the sample request is linked.
Picklist Value Group | Text | 50 | None
Shipping Address | Text | 15 | The address to which the order is shipped. This field is required.
Shipping Address Id | Text | 15 | The ID field of the shipping address.
Status | Picklist | 30 | The status code for the sample request.
#### Related Topics See the following topics for related information: Field Type Guidelines for Importing Data Importing Your Data

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