The following table contains specific information about setting up your CSV file before importing market development fund (MDF) 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 import information before performing an import.
Default MDF Request Field Name
|
Data Type
|
Maximum Length
|
Comments
|
Amount PreApproved
|
Number
|
22
|
The total amount that the brand owner approved for the marketing activity.
|
Amount Requested
|
Number
|
22
|
The total amount that the partner is requesting for the marketing activity.
|
Approval Status
|
Varchar
|
30
|
The current approval status for the MDF request.
|
Approver
|
Varchar
|
15
|
The name of the current approver.
|
Campaign
|
Varchar
|
15
|
The campaign with which the MDF is associated.
|
Category
|
Varchar
|
30
|
The category to which the MDF request belongs.
|
Claim Decision Date
|
Date
|
7
|
The date on which a decision was made for the claim.
|
Claim Status
|
Varchar
|
30
|
Indicates the status of the MDF claim.
|
Description
|
Varchar
|
250
|
None
|
Division
|
Text
|
50
|
None
|
Due Date
|
Date
|
7
|
The date by which the request must be processed.
|
End Date
|
UTC Date Time
|
7
|
The date and time by which the marketing activity ends.
|
Expiration Date
|
UTC Date Time
|
7
|
The date after which the MDF request is no longer valid.
|
Fund
|
Varchar
|
15
|
The name of the fund associated with the MDF request.
|
Last Approved By
|
Varchar
|
15
|
The name of the person who most recently approved the request.
|
MDF Request Currency
|
Varchar
|
20
|
None
|
Marketing Purpose
|
Varchar
|
30
|
The marketing reason for the MDF request.
|
Owner
|
Varchar
|
15
|
The owner of the record.
|
Owner Partner Account
|
Varchar
|
15
|
The partner account for which the owner works.
|
Partner Program
|
Varchar
|
15
|
The partner program with which the request is associated.
|
Picklist Value Group
|
Text
|
50
|
None
|
Pre-Approval Date
|
Date
|
7
|
The date and time that the MDF request was preapproved.
|
Principal Partner Account
|
Varchar
|
15
|
The partner company that is leading the effort on the MDF request.
|
Reason Code
|
Varchar
|
30
|
The reason why a special pricing request was returned or rejected.
|
Region
|
Varchar
|
30
|
The region for which the MDF request is being made.
|
Request Date
|
Date
|
7
|
The date and time that the MDF request was created.
|
Request Name
|
Varchar
|
50
|
The name of the MDF request.
|
Start Date
|
UTC Date Time
|
7
|
The date and time when the marketing activity starts.
|
Submission Status
|
Varchar
|
30
|
The status of the submission, such as Not Submitted, Submitted, or Recalled.
|
Submitted Date
|
UTC Date
|
7
|
The date and time when the request was submitted.
|
Total Claim Amount Approved
|
Number
|
22
|
The total claim amount that was approved for the partner.
|
Total Claim Amount Requested
|
Number
|
22
|
The total claim amount that was requested by the partner.
|