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 |
|
| Expense ID |
|
| Expense line ID |
|
| Expense 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 |
|
| Expense owner external ID |
|
| Due date |
|
| Settlement date |
|
| 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 |
|
| Expense 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 |
|
|
| |
|
| |
|
| |
|
| |
|
|