The following table contains specific information about setting up your CSV file before importing special pricing 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 Special Pricing Request Field Name
|
Data Type
|
Maximum Length
|
Comments
|
Approval Status
|
Varchar
|
30
|
The approval status for the special pricing request.
|
Approver
|
Varchar
|
15
|
The name of the approver.
|
Authorized Date
|
UTC Date Time
|
7
|
The date and time when the special pricing request was approved.
|
Claim Decision Date
|
Date
|
7
|
The date on which a decision was made for the claim.
|
Claim Status
|
Date
|
7
|
The status of the special pricing claim.
|
Currency
|
Varchar
|
20
|
The currency of the special pricing request.
|
Deal Registration
|
Varchar
|
15
|
The deal registration that is associated with the special pricing request.
|
Description
|
Varchar
|
15
|
None
|
Due Date
|
Date
|
7
|
The date by which the request must be processed.
|
End Customer
|
Varchar
|
15
|
The customer for the request. If the request is associated with an opportunity, then you can select opportunity account.
|
End Date
|
UTC Date
|
7
|
The date and time after which the special pricing is no longer effective.
|
Fund
|
Varchar
|
15
|
The name of the fund associated with the special pricing request.
|
Last Approved By
|
Varchar
|
15
|
The name of the person who most recently approved the request.
|
Opportunity
|
Varchar
|
15
|
The opportunity to which the request is related.
|
Originating Partner Account
|
Varchar
|
15
|
The partner who originated the special pricing request.
|
Owner
|
Varchar
|
15
|
The record owner.
|
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.
|
Principal Partner Account
|
Varchar
|
15
|
The partner company that is leading the effort on the special pricing request.
|
Reason Code
|
Varchar
|
30
|
The reason why a special pricing request was returned or rejected.
|
Request Date
|
Date
|
7
|
The date and time that the special pricing request was created.
|
Request Name
|
Varchar
|
50
|
The name of the request.
|
Start Date
|
UTC Date Time
|
7
|
The date and time from which the special pricing starts.
|
Submission Status
|
Varchar
|
30
|
The status of the submission, such as Not Submitted, Submitted, or Recalled.
|
Submitted Date
|
UTC Date Time
|
7
|
The date and time that the request was submitted.
|
Total Amount Authorized
|
Number
|
22
|
The total amount that is being authorized.
|
Total Amount Requested
|
Number
|
22
|
The total amount that was requested by the partner.
|
Total Claim Amount Approved
|
Number
|
22
|
The total claim amount that was approved for the partner.
|
Total Claim Amount Req.
|
Number
|
22
|
The total claim amount that is requested by the partner.
|