Pricing transaction revision report
Last updated: Nov 4th, 11:12am
This report provides a detailed view of a revised or updated cost for a transaction that happened prior to the current month for partners on interchange plus pricing. Use this report to review updated details about your transactions.
Know before you begin
- Ensure you are an approved partner to use this report.
- This report is generated and placed on PayPal's secure file transfer protocol (SFTP) server by the second day of each month by 9:00 AM in the leading time zone of the reporting window.
- This report includes alternative payment methods (APMs). See the list of supported APMs.
- The actual amounts in this report are multiplied by 100 to represent the amounts as cents. For instance, a $10 entry shows up as 1000 on the report.
- To maintain backward compatibility, read the report data by column header name instead of column index.
- For any transaction in this report, the interchange details are the updated and revised details. If the transaction has received any interchange prior to this report, then that value has to be discarded, and new details are to be applied.
- Blank values indicate that there is no interchange program applicable as of now, and any details received prior to this report should be nullified.
- This report is only available to partners who are on gross billing fees or a net settlement revenue share model and have interchange plus pricing.
Section 1: Report file name
The file name of the Pricing Transaction Revision Report for a single account follows this naming convention:
PRICING_TXN_REVISION.yyyymm.PartnerIdentifier.ReportingWindow.SequenceNumber.MajorVersion.MinorVersion.Format
Field | Information |
---|---|
PRICING_TXN_REVISION |
An abbreviation for Pricing Transaction Revision Report. |
yyyymm |
The month for the data in the report. |
PartnerIdentifier |
The partner's button source code or the name of the partner's organization. |
ReportingWindow |
The window of time when the report was generated. |
SequenceNumber |
The sequence number of the report file. The sequence number begins with
0 and continues until all parts of the report are recorded
in files. The sequence number is always present in the report filename
even if there is only one file.
|
MajorVersion |
The major version of the report. |
MinorVersion |
The minor version of the report. |
Format |
The report format is CSV (comma-separated values). |
Section 2: Report format
Each row of the report consists of a two-letter row type, followed by the details specific to that row type. The following table lists the valid row types and the sections that describe the data for that row type.
Code | Description |
---|---|
FH | File header |
SH | Section header |
CH | Column header |
SB | Section body |
SF | Section footer |
FF | File footer |
File header data
Position | Column name | Data type | Description |
---|---|---|---|
1 | Column Type | Literal |
The column type (FH ). |
2 | Report Generation Date Date-time |
The date and time at which the report file was generated, in the
following format: YYYY/MM/DDHH:MM:SS offset , where offset is the five-character signed
offset from GMT. For example, +0800 .
|
|
3 | Reporting Window |
Varchar , single character, one of: A ,
H , R , X .
|
The window of time in which the report was generated, as follows:
|
4 | Report Period Start Date | Date-time |
The beginning date and time for which to include transactions in the
report, in the following format:
YYYY/MM/DDHH:MM:SS offset , where offset is the five-character signed
offset from GMT. For example, +0800 .
|
5 | Report Period End Date | Date-time |
The final date and time for which to include transactions in the report,
in the following format: YYYY/MM/DDHH:MM:SS offset , where offset is the five-character signed
offset from GMT. For example, +0800 .
|
Section header data
Position | Column name | Data type | Description |
---|---|---|---|
1 | Column Type | Literal |
SH |
Section body data
Position | Column name | Data type | Description |
---|---|---|---|
1 | Column Type | Literal |
The column type (CH ). |
2 | TRANSACTION_TYPE | Varchar |
The type of transaction. One of:
|
3 | TRANSACTION_SUBTYPE | Varchar |
The Subtype of Transaction. One of:
|
4 | PRICING_FEE_TYPE | Varchar |
One of the following fee types, based on transaction and forward or
reverse money movement
|
5 | SELLER_ACCOUNT_ID | Varchar |
Merchant's PayPal encrypted account number. |
6 | PAYPAL_REFERENCE_ID | String |
Original PayPal transaction ID to which this event is related. |
7 | PAYPAL_TRANSACTION _ID |
Varchar |
PayPal transaction ID of the transaction. |
8 | INVOICE_ID | Varchar |
Invoice ID of the transaction. |
9 | CUSTOM_FIELD | Varchar |
A field for custom data. |
10 | TRANSACTION_DATE | Date-time |
The date and time the transaction was initiated, in the following
format: YYYY/MM/DD HH:MM:SS offset . YYYY is
the four-digit year.MM is two-digit month of the year.DD
is the two-digit day of the month. HH is the hour in
24-hour notation. MM is minutes. SS is
seconds. offset is the five-character signed offset from
GMT, such as +0800 .
|
11 | INTEGRATION_IDENTIFIER | Varchar |
Button Source code or Organisation name of partner. |
12 | PAYMENT_INSTRUMENT _TYPE |
Varchar |
A high-level classification of the type of financial instrument that was
used to fund a payment, such as the following:
|
13 | PAYMENT_INSTRUMENT _SUBTYPE |
Varchar |
One of the following detailed classifications of the financial
instrument used to fund a payment:
For example:
|
14 | TRANSACTION_AMOUNT | Money |
The Transaction Amount. |
15 | TRANSACTION_CURRENCY | Three character currency code | The currency of the transaction. |
16 | TRANSACTION_DEBIT _CREDIT_CODE |
Varchar |
Indicates if money has been credited or debited from the account.
|
17 | PRICING_MODEL | Varchar |
Denotes if there is a revenue share on the transaction or if the fees
are gross billed through invoices.
|
18 | INTERCHANGE_PROGRAM | varchar |
This denotes the updated interchange program received for the transaction. If the transaction has received any interchange prior to this, then that value has to be discarded and new details are to be applied. A blank value means that there is no interchange program applicable as of now and partners should nullify the interchange details received prior to this. |
19 | INTERCHANGE_COST _PERCENTAGE |
varchar |
Percentage of transaction amount charged as the revised interchange cost. If the transaction has received any interchange prior to this, then that value has to be discarded and new details are to be applied. Blank values should also be updated. |
20 | INTERCHANGE_COST _FIXED_AMOUNT |
Money |
Fixed amount component of the revised interchange cost. If the transaction has received any interchange prior to this, then that value has to be discarded and new details are to be applied. Blank values should also be updated. |
21 | INTERCHANGE_COST | Money |
Total revised interchange cost. If the transaction has received any interchange prior to this then that value has to be discarded and new details are to be applied. Blank values should also be updated. |
22 | NETWORK_NAME | varchar |
Pinless debit network name such as the following:
|
Section footer data
Position | Column name | Data type | Description |
---|---|---|---|
1 | Column Type | Literal |
The column type (SF ). |
File footer data
Position | Column name | Data type | Description |
---|---|---|---|
1 | Column Type | Literal |
The column type (FF ). |