| 0 | Settlement Date | Date | Date of settlement. Example: 4/21/2024 |
| 1 | Order Date and Time | Datetime | Order placed timestamp. Example: 4/20/2024 5:28:00 |
| 2 | Order Month | String | Order placed month. Example: Apr |
| 3 | Order Year | Int | Order placed year. Example: 2024 |
| 4 | Afterpay Order ID | String | A unique ID generated by Afterpay to identify orders Example: 3398663780 |
| 5 | Merchant Order ID | String | A unique ID generated by the seller to identify orders Example: fasdfas123122 |
| 6 | Merchant Refund ID | String | A unique id generated by the seller’s system to identify refunds Example: 32123123xddff |
| 7 | Presentment Amount | Decimal | The full order amount displayed to the customer Example: 30.00 |
| 8 | Presentment Currency | String | Currency displayed to the customer in the three-letter ISO 4217 currency code. Example: USD |
| 9 | Settlement Exchange Rate | Decimal | The exchange rate used to convert the presentment currency to the settlement currency. This applies to Cross Border Trade (CBT) orders only. Default value is 1. Example: 1 |
| 10 | Order Amount | Decimal | Total order amount after the settlement exchange rate is applied. This amount is different from Presentment Amount only in cases of Cross Border Trade (CBT) orders. Example: 30.00 |
| 11 | Settlement Amount | Decimal | Settlement amount usually equals the Order Amount. It may be different than the Order Amount if partial or multi capture is used. Example: 30.00 |
| 12 | Variable Rate | Decimal | Variable part of the buy rate associated with the seller. Example: 0.05 |
| 13 | Fixed Rate | Decimal | Fixed part of the buy rate associated with the seller expressed in Fee Currency. Example: 0.3 |
| 14 | Fee Amount | Decimal | (Settlement Amount * Variable Rate) + Fixed Rate expressed in Fee Currency. |
| 15 | CBT Rate | Decimal | Cross Border Trade (CBT) fee if applicable. Example: 0.01 |
| 16 | CBT Fee Amount | Decimal | Settlement Amount * CBT Rate expressed in Fee Currency. Example: 0.01 |
| 17 | Merchant Fee excl Tax | Decimal | Fee Amount + CBT Fee Amount expressed in Fee Currency. Example: 0.9 |
| 18 | Tax Rate OR VAT Rate OR GST Rate | Decimal | Indirect transaction tax rate on the Merchant Fee excl Tax. Example: 0.2 |
| 19 | Merchant Fee Tax | Decimal | Merchant Fee excl Tax * Tax Rate expressed in Fee Currency. Example: 0.18 |
| 20 | Merchant Fee incl Tax | Decimal | Merchant Fee Excl Tax + Merchant Fee Tax Example: 1.09 |
| 21 | Fee Currency | String | Currency fee is calculated in the three-letter ISO 4217 currency code. Example: USD |
| 22 | Net Settlement Amount | Decimal | Settlement Amount - Merchant Fee incl Tax Example: 8.92 |
| 23 | Net Settlement Currency | String | Currency to be settled to the partner in the three-letter ISO 4217 currency code. Example: USD |
| 24 | Type | String | Line item event (i.e. “Order”, “Refund”) Example: Order |
| 25 | Channel | String | Line item source (i.e. “Online”, or “In-store”) Example: Online |
| 26 | Store Name | String | Store name for partners using the in-store channel only. |
| 27 | Store ID | String | Store ID for partners using the in-store channel only. |
| 28 | Device Name | String | Device name for partners using the in-store channel only. |
| 29 | Device ID | String | Store name for partners using the in-store channel only. |
| 30 | Afterpay Refund ID | String | A |
