Smart Strings - All keys

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
• .email

report.account.establishment

• .name
• .code
• external_id

report.account.job_title

• .name
• .code
• external_id

report.approver

• .id
• .firstname
• .surname
• .creditor_nr
• .email
• .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