In this article you will find the complete list of keys available to create formulas in your export format
Reports fields:
report
- .id
- .submit_date
- .approve_date
- .booking_date
- .process_date
- .transaction.statement_date
- .created
- .title
- .total
- expense_count
report.account
- .id
- .firstname
- .surname
- .free_1
- .free_2
- .free_3
- .creditor_nr
report.account.establishment
- .name
- .code
- external_id
report.account.job_title
- .name
- .code
- external_id
report.approver
- .id
- .firstname
- .surname
- .creditor_nr
- .free_1
- .free_2
- .free_3
report.approver.establishment
- .name
- .code
- external_id
report.approver.job_title
- .name
- .code
- external_id
report.transaction.card
- .account_id
- .customer_id
- .external_id
- .issuer
- .name
- .type
- .card_number
- .number
- .holder_id
- .holder_name
- .created
- .modified
- .last_imported
transaction_report
- .report_id
- .currency_id
- .created
- .created_by_id
- .strict
transaction_report.card
- id
- .account_id
- .customer_id
- .external_id
- .card_number
- .holder_name
- .holder_id
- .issuer
- .name
- .type
- .created
Expense fields:
export
- vat_mileage - holds the vat code used for mileages
- payment_mileage - holds the payment method code used for mileages
- date_format - the date format for the current export format
- expense_types - the supported types for the current export format
export.currency
- .id - id used in our system for this currency
- .name - full name of the currency
- .symbol - For example $ or €
- .short - short code of the currency EUR, or USD for example
amount
- .amount - the real numeric amount.
- .vat_amount - the numeric vat amount.
- .minutes - minutes if the expense is a timesheet.
- .value - value is a reference to .amount and gives the same value.
amount.category
- .code
- .free_1
- .name
- .wkr_group
- .name
- .description
- .free_1
- .taxed_code
- .vat_category_id
- .created
- .modified
amount.category.travel_allowance
- distance_unit - 'km' or 'mi'
- amount - the real numeric amount
amount.vat
- .category_code
- .category_name
- .code
- .free_1
- .percentage
expense
- .id
- .audit_code
- .audit_trail
- .country
- .expense_date
- .description
- .distance_unit
- .exchange_rates.0.conversion_rate
- .type
- .vendor_project
- .rate_quantity - number of days (per diem)
expense.currency
- .short
expense.distance
- .amount
- .unit
expense.payment_method
- .code
- .free_1
- .name
- .type
expense.per_diem_rate
- .amount
- .code
- .name
expense.project
- .id
- .external_id
- .name
- .code
- .active
- .billable
- .free_1
- .customer_id
- .parent_id
- .expense_count
- .created
- .modified
expense.tag
- |extract_value('code', ', ')
- |extract_value('name', ', ')
expense.trip_type
- .code
- .name
expense.waypoints
- .location
expense.transaction
- .se_address
- .se_city
- .se_name
- .se_vat_number
- .se_zip
expense.transaction.card.id
- .account_id
- .customer_id
- .external_id
- .issuer
- .name
- .type
- .card_number
- .number
- .holder_id
- .holder_name
- .created
- .modified
- .last_imported
expense.free
- _field_1
- _field_2
- _field_3