Print      Open PDF Version of Online Help


Previous Topic

Next Topic

MDF Request Fields: Import Preparation

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.

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 company administrator to determine the new name for the field.

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

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.

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.

Related Topics

See the following topics for related information:


Published 5/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.