This guide will be removed on April 29, 2022. Please use our new, easier-to-use Toast technical documentation site. All updated content is on the new site.
The payments data export includes information about the payments
applied to checks at your restaurant. The file name of the payments data
export is PaymentDetails.csv.
The following table shows details on what the payment data export contains.
|
Field |
Description |
Data Type |
|---|---|---|
|
Location |
Restaurant Location |
String |
|
Payment Id |
Payment ID |
Long |
|
Order Id |
Order ID |
Long |
|
Order # |
Order Number |
Integer |
|
Paid Date |
Timestamp for Order Paid Time |
Date (MM/DD/YYYY HH:MM:SS) |
|
Order Date |
Timestamp for Order Open Time |
Date (MM/DD/YYYY HH:MM:SS) |
|
Check Id |
Check ID |
Long |
|
Check # |
Check number |
Integer |
|
Tab Name |
Number of Table |
Integer |
|
Server |
Name of Server who created order |
String |
|
Table |
Number of Table |
String |
|
Dining Area |
Name of Dining Area |
String |
|
Service |
Day Part |
String |
|
Dining Option |
Dining Options (defined by restaurant) |
String |
|
House Acct # |
House Account number payment applied to |
Integer |
|
Amount |
Amount Value |
Number (2 decimals) |
|
Tip |
Tip Value |
Number (2 decimals) |
|
Gratuity |
Gratuity Value |
Number (2 decimals) |
|
Total |
Total Value |
Number (2 decimals) |
|
Swiped Card Amount |
Swiped Card Amount |
Number (2 decimals) |
|
Keyed Card Amount |
Keyed Card Amount |
Number (2 decimals) |
|
Amount Tendered |
Cash Amount Value |
Number (2 decimals) |
|
Refunded |
Status of Refund |
String |
|
Refund Date |
Timestamp of Refund Value |
Date (MM/DD/YYYY HH:MM:SS) |
|
Refund Amount |
Refund Value |
Number (2 decimals) |
|
Refund Tip Amount |
Refund Tip Amount |
Number (2 decimals) |
|
Void User |
Employee who voided the transaction |
String |
|
Void Approver |
Employee who approved the void transaction |
String |
|
Void Date |
Timestamp of the void transaction |
String |
|
Status |
CC Processing status |
String |
|
Type |
Payment type (Credit, Cash, Gift Card) |
String |
|
Cash Drawer |
Cash Drawer used for payment |
String |
|
Card Type |
Card Brand |
String |
|
Other Type |
Other type of payment |
String |
|
|
Email of customer for digital receipt |
String |
|
Phone |
Phone number of customer for digital receipt |
String |
|
Last 4 Card Digits |
Last 4 Card Digits of customer card |
String |
|
Receipt |
Receipt token for digital receipts |
String |
|
V/MC/D Fees |
CC processing fees for payment |
Number (2 decimals) |