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