Administering Oracle CRM On Demand > Data Management Tools > Import and Export Tools > Preparing for Data Importing > Sample Request Item Fields: Import Preparation
Sample Request Item Fields: Import Preparation
The following table contains specific information about setting up your CSV file before importing sample request items 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 Items Field Name
|
Data Type
|
Maximum Length
|
Comments
|
Contact: External Unique ID
|
Text
|
30
|
None.
|
Currency
|
Picklist
|
15
|
The values in this picklist are read-only. The values that you import must match the valid values in this picklist.
|
Discount Amount
|
Number
|
22
|
None.
|
Discount Percent
|
Number
|
22
|
None.
|
Division
|
Text
|
50
|
None.
|
Id
|
Text
|
15
|
This field is the sample request item identifier.
|
Order
|
Text
|
15
|
This field contains the Sample Request ID. This field is required.
|
Order Item Number
|
Text
|
15
|
This field contains the Sample Request Item ID.
|
Owner: External Unique ID
|
Text
|
30
|
The unique external ID of the parent sample request record to which the sample request item is linked.
|
Picklist Value Item
|
Text
|
50
|
None.
|
Price
|
Number
|
22
|
None.
|
Price After Discount
|
Number
|
22
|
None.
|
Product
|
Text
|
15
|
This field contains the foreign key for the product ID. It is a required field.
|
Product: External Unique ID
|
Text
|
30
|
The unique external ID of the parent product record to which the sample request item is linked.
|
Quantity
|
Number
|
22
|
This field contains the quantity of products ordered. It is a required field, and the value must be greater than zero.
NOTE: If a Sample Request Allocation record type is defined, then the value in the Quantity field is validated against its corresponding Allocation Qty, Max Qty and Max Qty per Customer fields. If this validation fails, then you cannot import the Sample Request Item record type into Oracle CRM On Demand.
|
Status
|
Picklist
|
30
|
The status code for the sample request item.
|
NOTE: If a product is blocked for a contact, then you cannot import a sample request item for that product for the contact. If you attempt to do so, then the record is not imported, and an error message is recorded in the log file for the import request. For more information about blocking products for contacts, see Blocked Products.
Related Topics
See the following topics for related information:
|