# Export Templates (DOCX/XLSX) You can customize the Docx Exports to your individual needs. The following information will give you a detailed overview on how to use the different functions. # General You can find all variables that you can use here, depending on the document type:

Travel	Document
- [Document](https://help.advatra.com/books/technical-information/page/variables#bkmrk-document) - [Dossier](https://help.advatra.com/books/technical-information/page/variables#bkmrk-dossier) - [Customer](https://help.advatra.com/books/technical-information/page/variables#bkmrk-customer) - [TotalPrice](https://help.advatra.com/books/technical-information/page/variables#bkmrk-totalprice) - [Travellers](https://help.advatra.com/books/technical-information/page/variables#bkmrk-traveller) - Products	- [Document](https://help.advatra.com/books/technical-information/page/variables#bkmrk-document) - [Dossier](https://help.advatra.com/books/technical-information/page/variables#bkmrk-dossier) - [Customer](https://help.advatra.com/books/technical-information/page/variables#bkmrk-customer) - [TotalPrice](https://help.advatra.com/books/technical-information/page/variables#bkmrk-totalprice) - Positions

**Travel**

Document

- [Document](https://help.advatra.com/books/technical-information/page/variables#bkmrk-document) - [Dossier](https://help.advatra.com/books/technical-information/page/variables#bkmrk-dossier) - [Customer](https://help.advatra.com/books/technical-information/page/variables#bkmrk-customer) - [TotalPrice](https://help.advatra.com/books/technical-information/page/variables#bkmrk-totalprice) - [Travellers](https://help.advatra.com/books/technical-information/page/variables#bkmrk-traveller) - Products

If you want to get a deeper technology background, have a look at the [Apache FreeMarker Library.](https://freemarker.apache.org/) ## Date formatting For example, formatting the current date: ```JSON ${.now?string["dd.MM.YYYY"]} //returns 01.01.2022 ${.now?string["d. MMMM YYYY"]} //returns 1. January 2022 ```

See details about formatting

Format	Definition
Month
M	Month, from 1 through 12
MM	Two digit month, from 01 through 12
MMM	Abbreviated name of the month, for example: Jan, Feb, etc.
MMMM	Full name of the month, for example: January, February, etc.
Day
d	Day of the month from 1 through 31
dd	Day of the month from 01 through 31
ddd	Standard abbreviation for the day of the week, for example: Mon, Tue, etc.
dddd	Full name of the day of the week, for example: Monday, Tuesday, etc.
Year
y	Year from 0 to 99
yy	Year from 00 to 99
yyy	Year with minimum of 3 digits
yyyy	Year as a four digit number
Hour
h	Hour using 12-hour clock from 1 - 12
hh	Hour using 12-hour clock from 01 - 12
H	Hour using 24-hour clock from 0 - 24
HH	Hour using 24-hour clock from 00 - 24
Minute
m	Hour using 12-hour clock from 1 - 12
mm	Hour using 12-hour clock from 01 - 12
Second
s	Second, from 0 through 59
ss	Second, from 00 through 59
Other
t	First character of the AM/PM designator
tt	AM/PM designator
T	A literal to separate date and time in 8061 or other formats
z	Hours offset from UTC, with no leading zeros — Example: -5 or +530
zz	Hours offset from UTC, with leading zero — Example: -05 or +0530
zzz	Hours and minutes offset from UTC, with leading zeros — Example -0500 or +0530
g or gg	Period or era, such as A.D.
K	Zone information

## Lists If you want to repeat something, for example, all products in an offer. ```JavaScript [#list products as product] // Use "product" for one product [/#list] ```

## Sorting You can sort lists directly in the export, for example to display all products, sorted by the field start. ```JSON [#list products?sort_by('start') as product] // the products get listed, sorted by "start" [/#list] ```

# Variables ## Customer **Usage** ```JSON ${customer.VARIABLE} // Replace VARIABLE with the appropriate field ```

Definition	Description	Example
addressAddition		${customer.addressAddition}
addressFormatted	The default formatting for a customer address.	${customer.addressFormatted}
city		${customer.city}
country	The country of the customer	${customer.country}
creationDate	Date of the creation of the customer	${customer.creationDate?string\["dd.MM.YYYY"\]}
creator	Name of the creator of the customer	${customer.creator}
email		${customer.email}
firstName		${customer.firstName}
lastName		${customer.lastName}
name	Combination of firstName and lastName	${customer.name}
number	The customer number in advatra (K1000001)	${customer.number}
phone		${customer.phone}
state		${customer.state}
street		${customer.street}
website		${customer.website}
zipCode		${customer.zipCode}

## Document **Usage** ```JSON ${document.VARIABLE} // Replace VARIABLE with the appropriate field ```

Definition	Description	Example
travelStart	Start of the travel, only on travel documents	${document.travelStart?string\["dd.MM.YYYY"\]}
travelEnd	End of the travel, only on travel documents	${document.travelEnd?string\["dd.MM.YYYY"\]}
expirationDate	Date until the document is valid	${document.expirationDate?string\["dd.MM.YYYY"\]}
number	The document number (D1000001.101)	${document.number}
currency	The Currency of the document, ISO 4217	${document.currency}
note		${document.note}
type	Offer, Confirmation, Invoice, Deposit, Prepayment	${document.type}
language		${document.language}
locale	Can be used for the translation of the document	${document.locale}
date		${document.date?string\["dd.MM.YYYY"\]}
charged	Used for Deposit and Prepayment. Defines if they have been charged to an invoice.	${document.charged}
exportDate	Date, when the document have been exported to the accounting system	${document.exportDate?string\["dd.MM.YYYY"\]}
canton	Location	${document.canton}
image
days	List of days contained in the offer/confirmation

## Dossier **Usage** ```JSON ${dossier.VARIABLE} // Replace VARIABLE with the appropriate field ```

Definition	Description	Example
name
openingDate
status
employee
responsibleEmployee
travelAgent
number

## Product **Usage** ```JSON [#list products as product] ${product.VARIABLE} // Replace VARIABLE with the appropriate field [#/list] ```

Definition	Description	Example
note
start
end
title
description
voucherRelevant
voucherText
person
images
images3x2
type
travellers	[See details here](#bkmrk-guide)
customer	[See details here](#bkmrk-customer)
notes
prices	[See details here](#bkmrk-price)
guides	[See details here](#bkmrk-guide)
drivers	[See details here](#bkmrk-driver)
supplierNotes
locationSmall	only available, when a template is linked.
locationMedium	only available, when a template is linked.
locationLarge	only available, when a template is linked.
hasKickback	true, if any service has a commission

## Price **Usage** ```JSON [#list products as product] [#list product.prices as price] ${price.VARIABLE} // Replace VARIABLE with the appropriate field [/#list] [#/list] ```

Definition	Description	Example
name
person
quantity
price
type
discount
purchasingPrice
creditorInvoiceReceived
billingText
effectivePurchasingPrice
vat	Vat Object
kickback
kickbackAmount
kickbackInvoiceCreated
kickbackVat
total	TotalPrice Object
hotelNights
supplier	[See details here](#bkmrk-customer)

## TotalPrice **Usage** ```JSON ${totalPrice.VARIABLE} // Replace VARIABLE with the appropriate field ```

Definition	Description	Example
vats
surcharges
priceNetto
priceVat
priceBrutto
totalPriceBrutto
priceNettoFormatted
totalPriceFormatted

## Traveller **Usage** ```JSON [#list travellers as traveller] ${traveller.VARIABLE} // Replace VARIABLE with the appropriate field [#/list] ```

Definition	Description	Example
firstName
lastName
name
phone
email
passportNumber
placeOfIssue
birthday
arrivalType
arrivalDate
arrivalTime
arrivalNumber
arrivalFlightClass
arrivalSeat
departureType

## Guide **Usage** ```JSON [#list guides as guide] ${guide.VARIABLE} // Replace VARIABLE with the appropriate field [#/list] ```

Definition	Description	Example
firstName
lastName
name
phone
email

## Driver **Usage** ```JSON [#list drivers as driver] ${driver.VARIABLE} // Replace VARIABLE with the appropriate field [#/list] ```

Definition	Description	Example
firstName
lastName
name
phone
email