All fields

For Reports Fields

report

  • .id
  • .approve_date
  • .booking_date
  • .process_date
  • .submit_date
  • .created
  • .title
  • .total
  • expense_count

report.account

  • .id
  • .firstname
  • .surname
  • .free_1
  • .free_2
  • .free_3
  • .creditor_nr
  • .email

report.account.establishment

  • .name
  • .code

report.account.job_title

  • .name
  • .code

report.approver

  • .creditor_nr
  • .email
  • .free_1
  • .free_2
  • .free_3
  • .id
  • .surname

report.approver.establishment

  • .name
  • .code

report.approver.job_title

  • .name
  • .code

report.transaction.card

  • .account_id
  • .customer_id
  • .external_id
  • .issuer
  • .name
  • .type
  • .card_number
  • .number
  • .holder_id
  • .holder_name
  • .created
  • .modified
  • .last_imported

For Expenses Fields - Only

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

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
Did this answer your question?