On this page
No Headings
Last updated: July 6, 2026
The Order report (ORT) gives merchants and processing partners detailed information about outstanding authorized orders that can be captured. This page describes the report's structure, file naming conventions, delivery details, and field definitions.
PayPal delivers the ORT through the Secure FTP Server, reports.paypal.com, which requires a separate user account. A user account that is enabled for the ORT is also enabled to create user accounts for the Secure Drop-Box. To ensure data security, ORT users must generate their own user accounts for the Secure Drop-Box.
To set up and access the Secure FTP Server, see Access SFTP reports.
Keep in mind the following details about the ORT:
The file naming convention depends on whether you are using Multiple Account Management (MAM).
The file name for a single account ORT report follows this naming convention:
ORT-yyyymmdd.sequenceNumber.version.format
| Field | Description |
|---|---|
ORT | An abbreviation for "Downloadable Order Report" |
yyyymmdd | The date of the data in the report. This date stamp represents the latest, or ending date, of the data. |
sequenceNumber | The sequence number of this file. 3 characters, right-justified, and zero-filled. The sequence number begins with 01 and continues until all parts are recorded in files. The sequence number is always present in the report file name, even if there is only 1 file. |
version | The version of the report. 3 characters, right-justified, and zero-filled. |
format | One of the following: comma-separated value file (CSV) or tab-delimited-field file (TAB) |
The file name for a Multiple Account Management (MAM) ORT report follows this naming convention:
ORT-yyyymmdd.reportingWindow.sequenceNumber.totalFiles.version.format
| Field | Description |
|---|---|
ORT | An abbreviation for "Downloadable Order Report" |
yyyymmdd | The date of the data in the report. This date stamp represents the latest, or ending date, of the data. |
reportingWindow | The window of time when the report was generated: X (GMT 00:00 to GMT -0500), A (GMT -0500 to GMT -0800), H (GMT -0800 to GMT +0800), or R (GMT +0800 to GMT 00:00) |
sequenceNumber | The sequence number of this file. 3 characters, right-justified, and zero-filled. The sequence number begins with 01 and continues until all parts are recorded in files. The sequence number is always present in the report file name, even if there is only 1 file. |
totalFiles | The total number of files in the report for this date. Always 2 digits and zero-padded. For example, for 2 total files, totalFiles is 02. |
version | The version of the report. 3 characters, right-justified, and zero-filled. |
format | One of the following: comma-separated value file (CSV) or tab-delimited-field file (TAB) |
When PayPal supports multiple versions of the ORT, PayPal will notify you of the creation of any new version and of the deprecation of older versions. When multiple versions exist, you can receive 2 versions of the same report concurrently to test and integrate a new version. You can also receive non-consecutive versions of the same report concurrently. To enable different versions or request changes in report distribution, contact your PayPal account manager or customer support.
PayPal operationally monitors the generation and delivery of the ORT on a daily basis. PayPal maintains 2 contact points for report notifications:
PayPal notifies you of the following types of events:
This report is organized by section, where each section represents a single PayPal account. If you are not using PayPal Multiple Account Management, the report contains a single section.
Each row of the report consists of a 2-letter row type, followed by the details that are specific to that row type. The following table lists the valid row types.
| Code | Description | Section |
|---|---|---|
RH | Report header | Report header data |
FH | File header | File header data |
SH | Section header | Section header data |
CH | Column header | Section body data |
SB | Row data | Section body data |
SF | Section footer | Section footer data |
SC | Section record count | Section record count data |
RF | Report footer | Report footer data |
RC | Report record count | Report footer data |
FF | File footer | File footer data |
A single-file report with 1 section is organized as follows.
Report Header (RH)
File Header (FH)
Section Header (SH)
Column Header (CH)
Row Data (SB)
...
Row Data (SB)
Section Footer (SF)
Section Record Count (SC)
Report Footer (RF)
Report Record Count (RC)
File Footer (FF)A report with two sections that split across two files is organized as follows.
| File 1 | File 2 |
|---|---|
Report Header (RH) | File Header (FH) |
File Header (FH) | Row Data (SB) |
Section Header (SH) | ... |
Column Header (CH) | Row Data (SB) |
Row Data (SB) | Section Footer (SF) |
... | Section Record Count (SC) |
Row Data (SB) | Report Footer (RF) |
Section Footer (SF) | Report Record Count (RC) |
Section Record Count (SC) | File Footer (FF) |
Section Header (SH) | |
Column Header (CH) | |
Row Data (SB) | |
... | |
File Footer (FF) |
This section describes the columns and data that PayPal delivers in the report header, report footer, and report record count.
Report header data exists in 1 row with data elements separated by the file delimiter.
| Position | Column name | Data type | Description |
|---|---|---|---|
| 1 | Column Type | Literal | The column type (report header, RH) |
| 2 | Report Generation Date | Date-time | The date and time when the report file was generated, in the following format: YYYY/MM/DD HH:MM:SS offset, where offset is the five-character signed offset from GMT, such as +0800 |
| 3 | Reporting Window | Varchar | The window of time when the report was generated: X (GMT 00:00 to GMT -0500), A (GMT -0500 to GMT -0800), H (GMT -0800 to GMT +0800), or R (GMT +0800 to GMT 00:00) |
| 4 | Account ID | Varchar | Account number that receives the report (Payer ID is the encrypted hash of the PayPal account.) |
| 5 | Report Version | Varchar | The version number of the report |
Report footer data exists in 1 row with data elements separated by the file delimiter.
| Position | Column name | Data type | Description |
|---|---|---|---|
| 1 | Column Type | Literal | The column type (report footer, RF) |
| 2 | Row Count | Number | The number of body data rows in the report. You can use this value for reconciliation. The report may span multiple files. |
Report record count data exists in 1 row with data elements separated by the file delimiter.
| Position | Column name | Data type | Description |
|---|---|---|---|
| 1 | Column Type | Literal | The column type (report record count, RC) |
| 2 | Row Count | Number | The number of body data rows in the report. You can use this value for reconciliation. The report may span multiple files. |
This section describes the columns and data that PayPal delivers in the file header and file footer records.
File header data exists in 1 row with data elements separated by the file delimiter.
| Position | Column name | Data type | Description |
|---|---|---|---|
| 1 | Column Type | Literal | The column type (file header, FH) |
| 2 | File Count | Number | The sequence number of the file in the report. You can use this value for reconciliation. |
File footer data exists in 1 row with data elements separated by the file delimiter.
| Position | Column name | Data type | Description |
|---|---|---|---|
| 1 | Column Type | Literal | The column type (file footer, FF) |
| 2 | Row Count | Number | The number of body data rows in the file, used for reconciliation. |
This section describes the columns and data delivered in the section header, section footer, section record count, and section body records.
Section header data exists in 1 row with data elements separated by the file delimiter.
| Position | Column name | Data type | Description |
|---|---|---|---|
| 1 | Column Type | Literal | The column type (section header, SH) |
| 2 | Reporting Period Start Date | Date-time | The beginning of the reporting period in this format: YYYY/MM/DD HH:MM:SS offset, where YYYY is the four-digit year, MM is the two-digit month, DD is the two-digit day, HH is the hour in 24-hour notation, MM is minutes, SS is seconds, and offset is the five-character signed offset from GMT, for example +0800 |
| 3 | Reporting Period End Date | Date-time | The end of the reporting period in the same format as Reporting Period Start Date |
| 4 | Account ID | Varchar | Account number that PayPal generated |
Body data exists in 1 row with data elements separated by the file delimiter.
Before any rows of body data, a column header row lists the name of each field. For example:
"CH","Order ID","Order Action Type","Order Currency","Order Creation Date",
"Order Payer PayPal Account ID","Order Payer Email Address","Order Payer Name",
"Order Payer Business Name","Shipping Address Line1","Shipping Address City",
"Shipping Address State","Shipping Address Zip","Shipping Address Country",
"Order Description","Order Memo","Order Custom Field"The following table describes the fields that PayPal can deliver in the body data rows of the ORT. Each row of body data represents 1 order.
| Position | Column name | Data type | Description |
|---|---|---|---|
| 1 | Column Type | Literal | SB |
| 2 | Order ID | Varchar, max 24 characters, may be blank | The authorization identification number of the payment you want to capture. This can be an order number, an order authorization number, or a reauthorization number. |
| 3 | Order Action Type | Alphanumeric, max 5 characters | One of the following values: O0000 (Order Created: general), O0100 (Order Canceled: general), or O0200 (Order Voided: general) |
| 4 | Order Creation Date | Date-time, max 25 characters | The date and time of order creation in the following format: YYYY/MM/DD HH:MM:SS offset, where YYYY is the four-digit year, MM is the two-digit month, DD is the two-digit day, HH is the hour in 24-hour notation, MM is minutes, SS is seconds, and offset is the five-character signed offset from GMT, for example +0800 |
| 5 | Order Currency | Three-character currency code, max 3 characters | Currency of the transaction. For a list of possible values, see PayPal-supported currencies. |
| 6 | Order Payer PayPal Account ID | Varchar, max 24 characters, may be blank | Unique PayPal customer account number |
| 7 | Order Payer Email Address | Varchar, max 127 characters | Email address of the payer |
| 8 | Order Payer Name | Varchar, max 55 characters, may be blank | Full name of the payer as associated with their PayPal account |
| 9 | Order Payer Business Name | Varchar, max 127 characters, may be blank | Payer's business name |
| 10 | Shipping Address Line 1 | Varchar, max 300 characters, may be blank | Street address of the shipping address as specified by the buyer |
| 11 | Shipping Address Line 2 | Text, max 300 characters, may be blank | Street address line 2 of the shipping address as specified by the buyer |
| 12 | Shipping Address City | Text, max 120 characters, may be blank | City of the shipping address as specified by the buyer |
| 13 | Shipping Address State | Text, max 120 characters, may be blank | State, province, or territory of the shipping address as specified by the payer |
| 14 | Shipping Address Zip | Varchar, max 60 characters, may be blank | Postal code of the shipping address as specified by the payer |
| 15 | Shipping Address Country | Varchar, max 64 characters, may be blank | Country of the shipping address as specified by the payer |
| 16 | Order Description | Alphanumeric, max 200 characters, may be blank | Description of the order as specified by the merchant |
| 17 | Order Memo | Varchar, max 4000 characters, may be blank | Text that the payer entered in the Memo field during enrollment |
| 18 | Order Custom Field | Varchar, max 256 characters, may be blank | Custom content that the originator of the agreement specified. Reserved for merchant use. |
Section footer data exists in 1 row with data elements separated by the file delimiter.
| Position | Column name | Data type | Description |
|---|---|---|---|
| 1 | Column Type | Literal | SF |
| 2 | Row Count | Number | The number of body data rows in the section. You can use this value for reconciliation. |
Section record count data exists in 1 row with data elements separated by the file delimiter.
| Position | Column name | Data type | Description |
|---|---|---|---|
| 1 | Column Type | Literal | SC |
| 2 | Row Count | Number | The number of body data rows in the section. You can use this value for reconciliation. |