In the export file, the Rows group cell type includes the available options groups and their options that allow you to configure the export field data without any line item-specific information.
Options group | Options | Options' settings |
FUNCTIONS | ||
| ||
| ||
PAYHAWK ACCOUNT | ||
Name | ||
Street name and number | ||
City | ||
Country | ||
Account base currency | ||
| ||
ACCOUNTS MAPPING | ||
General account | ||
Fees account | ||
Accounts payable - Bank | ||
Accounts payable - Cash | ||
Accounts payable - Mileage | ||
Accounts payable - Per Diem | ||
Accounts payable - Reimbursable | ||
CATEGORIZATION | ||
Account code | ||
Category name | ||
Amortization schedule | ||
Amortization external ID | ||
Amortization start | ||
Amortization end | ||
EXPENSE | ||
Approval status | ||
Review status | ||
Created date | ||
Spend ID | ||
Expense line ID | ||
Spend external ID | ||
Note | ||
Document currency | ||
Payment wallet currency | ||
Last review date | ||
Last reviewer name | ||
Last reviewer external ID | ||
VAT name | ||
VAT code | ||
VAT rate % | ||
Expense owner name | ||
Expense owner external ID | ||
Due date | ||
Settlement date | ||
Expense total amount (Base Currency) | ||
Net amount (Base Currency) | ||
Tax amount (Base Currency) | ||
Expense discount amount (Base Currency) | ||
Expense total amount (Document Currency) | ||
Expense net amount (Document Currency) | ||
Expense tax amount (Document Currency) | ||
Expense discount amount (Document Currency) | ||
Payment wallet amount with fees | ||
Payment fees | ||
Expense total amount (Payment Currency) | ||
Expense net amount (Payment Currency) | ||
Expense tax amount (Payment Currency) | ||
Document date FX rate | ||
Payment FX rate | ||
Date of payment | ||
Payment source | ||
Payment reference | ||
Spend type | ||
Expense URL | ||
Last exported at | ||
Last exported by | ||
PAYMENT | ||
Card name | ||
Cardholder name | ||
Card last 4 digits | ||
Payment paid currency | ||
Merchant category code | ||
Card transaction location | ||
Card transaction country code | ||
Merchant name | ||
SUPPLIER | ||
Supplier name | ||
Supplier VAT number | ||
Supplier external ID | ||
Supplier country | ||
Supplier payment currency | ||
Supplier bank account holder name | ||
Supplier bank account IBAN | ||
Supplier bank account BIC/SWIFT | ||
Supplier bank account number | ||
Supplier bank account routing number | ||
Supplier bank account sort code | ||
DOCUMENT | ||
Document number | ||
Document type | ||
Document date | ||
Service period | ||
CUSTOM FIELDS | ||
Dynamic list of custom fields | ||