Administering Oracle CRM On Demand > Data Management Tools > Import and Export Tools > Preparing for Data Importing > Allocation Fields: Import Preparation
Allocation Fields: Import Preparation
The following table contains specific information about setting up your CSV file before importing allocations 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 Allocation Field Name
|
Data Type
|
Maximum Length
|
Comments
|
Allocation Type
|
Text
|
30
|
None
|
Allocation Qty
|
Number
|
22
|
The quantity of the product that is allocated to the sales representative from the administrator.
|
Distributed Qty
|
Number
|
22
|
The quantity of the product that the sales representative dropped off within the allocation period.
|
End Date
|
Date/Time
|
7
|
The last date on which the product can be disbursed.
|
Max Qty
|
Number
|
22
|
The quantity of the product that the sales representative can distribute at a given time to a customer.
|
Order By
|
Number
|
22
|
The order in which the user can see the products in the list.
|
Remaining Qty
|
Number
|
22
|
The quantity of the product that remains available for the sales representative to drop off within the allocation period.
|
Sample
|
Text
|
15
|
The product name associated with the allocation.
|
Start Date
|
Date/Time
|
7
|
The date on which the distribution starts.
|
Stop Sampling Flag
|
Boolean
|
1
|
When this field is selected, it indicates that the product can no longer be disbursed.
|
Related Topics
See the following topics for related information:
|