Administering Oracle CRM On Demand > Data Management Tools > Import and Export Tools > Preparing for Data Importing > HCP Contact Allocation Fields: Import Preparation
HCP Contact Allocation Fields: Import Preparation
The following table contains specific information about setting up your CSV file before importing HCP contact allocation fields 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 HCP Contact Allocation Field Name
|
Data Type
|
Maximum Length
|
Comments
|
HCP Contact Allocation ID
|
Varchar
|
15
|
Indicates the row identification number.
|
Allocation Type
|
Picklist
|
30
|
The default values for this field are Detail Allocation, Sample Allocation, Promotional Item Allocation, and Sample Request Allocation.
|
Start Date
|
Date Time
|
7
|
This field is required.
|
Currency
|
Picklist
|
15
|
None.
|
Exchange Date
|
Date
|
Not applicable
|
None.
|
Division
|
Text
|
50
|
None.
|
End Date
|
Date Time
|
7
|
If an end date is defined for the HCP Contact Allocation record, then the end date must be later than the start date.
|
Qty Remaining
|
Number
|
22
|
When the HCP contact allocation is first created, the Allocation Qty and Qty Remaining fields must have the same positive value. Quantity fields must have integer values.
|
Qty Distributed
|
Number
|
22
|
When the HCP contact allocation is first created, the Qty Distributed field must be zero. Quantity fields must have integer values.
|
Allocation Qty
|
Number
|
22
|
When the HCP contact allocation is first created, the Allocation Qty and Qty Remaining fields must have the same positive value. Quantity fields must have integer values.
|
Contact ID
|
Varchar
|
15
|
Indicates the row identifier for the contact or health care professional for whom the allocations are defined.
|
Product ID
|
Varchar
|
15
|
Indicates the row identifier for the product or sample for which the allocations are defined for the specific contact or health care professional.
|
Picklist Value Group
|
Text
|
50
|
None.
|
Related Topics
See the following topics for related information:
|