Recursive tables, as well as Context blocks, work with five categories.
Listing of the fields will be done by category. Some Fields require additional selection(s). These sub selections are described in the table, when no sub selections are shown there are none applicable.

Note: all dates are in the format dd-mm-yyyy

Rooms

Field Name Sub selection Field notation Description
Arrival Date {{ Arrival Date }} Display the date of the arrival of the reservation
Departure date {{ Departure date }} Displays the date of the departure of the reservation
Booking Currency {{ Booking Currency }} Displays the currency used for the reservation
Total Roomrate {{ Total Roomrate }} Displays the total room rent for the reservation
Discount {{ Discount }} Displays the total amount discount for the reservation
Room Number {{ Room Number }} Displays the room number assigned to the reservation
Room Type {{ Room Type }} Displays the Room type Code for the reservation
Room Type Name {{ Room Type Name }} Displays the full Room Type name for the reservation
Room Rates Adds the ‘Room rates’ table and will only show the name. Data is added by selecting sub selection(s)
Rate – Start Date {{ Rate – Start Date }} Displays the start date of the used rate
Rate – End Date {{ Rate – End Date }} Displays the end date of the used rate
Rate Currency {{ Rate Currency }} Displays the currency of the used rate
Rates Per Night {{ Rates Per Night }} Displays the price for the used rate per period
Room Rates Per Date Adds the ‘Room rates per Date’ table and will only show the name. Data is added by selecting sub selection(s)
Rate – Date Rate {{ Rate – Date }} Displays all dates, per date, for the reservation
Rate Currency {{ Rate Currency }} Displays the currency of the used rate
Rates Per Night {{ Rates Per Night }} Displays the price for the used rate per period
Guests Adds the ‘ Guests’ table and will only show the name. Data is added by selecting sub selection(s)
Guest – Age Group {{ Guest – Age Group }} Displays the age group of the guest(s) (adult / child / infant )
Guest – Title {{ Guest – Title }} Displays the Guest(s)’ title (Mr. / Miss / Mrs. / Ms. )
Guest – Full Name {{ Guest – Full Name }} Displays the full name of the Guest(s) (First – middle and last name)
Guest – First Name {{ Guest – First Name }} Displays the First name of the Guest(s) only
Guest – Last Name {{ Guest – Last Name }} Displays the Last name of the Guest(s) only
Guest – Address Line 1 {{ Guest – Address Line 1 }} Displays the first Address line of the guest(s)
Guest – Address Line 2 {{ Guest – Address Line 2 }} Displays the second Address line of the guest(s)
Guest – Postal Code {{ Guest – Postal Code }} Displays the Postal Code of the guest(s)
Guest – City {{ Guest – City }} Displays the City of the guest(s)
Guest – State {{ Guest – State }} Displays the State of the guest(s)
Guest – Country Code {{ Guest – Country Code }} Displays the Country code of the guest(s), format is two digits (e.g. NL for the Netherlands)
Guest – Country Name {{ Guest – Country Name }} Displays the full Country name of the guest(s)
Guest – E-Mail Address {{ Guest – E-Mail Address }} Displays the e-mail address of the guest(s)
Guest – Telephone Number {{ Guest – Telephone Number }} Displays the telephone number of the guest(s)
Room Notes {{ Room Notes }} Displays the Room Notes as set on the reservation under the Comment section
Main Guest Adds the ‘Main Guest’ table and will only show the name. Data is added by selecting sub selection(s)
Main Guest – Age Group {{ Main Guest – Age Group }} Displays the age group of the Main guest (adult / child / infant)
Main Guest – Title {{ Main Guest – Title }} Displays the Main Guests’ title (Mr. / Miss / Mrs. / Ms.)
Main Guest – Full Name {{ Main Guest – Full Name }} Displays the Full name of the Main Guest (First – middle and last name)
Main Guest – First Name {{ Main Guest – First Name }} Displays the First name of the Main Guest only
Main Guest – Last Name {{ Main Guest – Last Name }} Displays the Last name of the Main Guest only
Main Guest – Address Line 2 {{ Main Guest – Address Line 2 }} Displays the second Address line of the Main Guest
Main Guest – Address Line 1 {{ Main Guest – Address Line 1 }} Displays the first Address line of the Main Guest
Main Guest – Postal Code {{ Main Guest – Postal Code }} Displays the Postal Code of the Main Guest
Main Guest – City {{ Main Guest – City }} Displays the City of the Main Guest
Main Guest – State {{ Main Guest – State }} Displays the State of the Main Guest
Main Guest – Country Code {{ Main Guest – Country Code }} Displays the Country code of the main guest, format is two digits (e.g. NL for the Netherlands)
Main Guest – Country Name {{ Main Guest – Country Name }} Displays the full Country name of the Main Guest
Main Guest – E-Mail Address {{ Main Guest – E-Mail Address }} Displays the e-mail address of the Main Guest
Main Guest – Telephone Number {{ Main Guest – Telephone Number }} Displays the Telephone Number of the Main Guest

Invoice Taxes

Invoices taxes are all taxes as set under taxes and VAT, but not the City tax.

Field Name Field notation Description
Tax – Description {{ Tax – Description }} Displays the description of the applicable Tax
Tax – Amount {{ Tax – Amount }}
Tax – Net Selling Amount {{ Tax – Net Selling Amount }} Displays the net amount due (so total sales minus tax – amount), in the hotel native currency
Tax – Amount, Hotel Currency {{ Tax – Amount, Hotel Currency }} Displays the amount set for the Tax, can be Amount or Percentage – as set/shown under Tax -Type
Tax – Type {{ Tax – Type }} Displays the type set for the Tax (amount or percentage)
Tax – Net Selling Amount in Invoice currency {{ Tax – Net Selling Amount in Invoice currency }} Displays the net amount due (so total sales minus tax – amount), in the currency set for the invoice
Tax – Amount Inclusive in Invoice currency {{ Tax – Amount Inclusive in Invoice currency }} Displays the amount due for the applicable tax(es), in the currency set for the invoice. Amount is calculated over the Total minus city tax

All Invoice Items / Invoice Sales Items

Field Name Field notation Description
Item – Code {{ Item – Code }} Displays the Code for the item
Item – Date Added {{ Item – Date Added }} Displays the date and time the item was added to the invoice
Item – Description {{ Item – Description }} Displays the Description of the item
Item – Number of Items {{ Item – Number of Items }} Displays the number of items on the invoice
Item – Purchase Currency {{ Item – Purchase Currency }} Displays the currency in which the item was added to the invoice
Item – Unit Price, Purchase Currency {{ Item – Unit Price, Purchase Currency }} Displays the price per item, in the currency the item was added to the invoice
Item – Total Gross Amount, Purchase Currency {{ Item – Total Gross Amount, Purchase Currency }} Displays total Gross amount (so tax/VAT included) for the item, in the currency the item was added to the invoice
Item – Total Net Amount, Purchase Currency {{ Item – Total Net Amount, Purchase Currency }} Displays total NET amount (so tax/VAT excluded) for the item, in the currency the item was added to the invoice
Hotel Currency {{ Hotel Currency }} Displays the Currency Code for the hotel native currency
Item – Unit Price, Hotel Currency {{ Item – Unit Price, Hotel Currency }} Displays the price per item, in the hotel native currency the item was added to the invoice
Item – Total Gross Amount, Hotel Currency {{ Item – Total Gross Amount, Hotel Currency }} Displays total Gross amount (so tax/VAT included) for the item, in the hotel native currency
Item – Total Net Amount, Hotel Currency {{ Item – Total Net Amount, Hotel Currency }} Displays total NET amount (so tax/VAT excluded) for the item, in the hotel native currency
Exchange Rate, Purchase Currency – Hotel Currency {{ Exchange Rate, Purchase Currency – Hotel Currency }} Displays the exchange rate used for converting the hotel native currency to the currency used when the item was added to the invoice. When they are the same 1 is displayed
Item – Invoice Currency {{ Item – Invoice Currency }} Displays, per item, the Currency code used on the invoice
Item – Unit Price, Invoice Currency {{ Item – Unit Price, Invoice Currency }} Displays the price per item in the currency used on the invoice
Item – Total Gross Amount, Invoice Currency {{ Item – Total Gross Amount, Invoice Currency }} Displays total Gross amount (so tax/VAT included) for the item, in the currency used on the invoice
Item – Total Net Amount, Invoice Currency {{ Item – Total Net Amount, Invoice Currency }} Displays total NET amount (so tax/VAT excluded) for the item, in the currency used on the invoice
Exchange Rate, Invoice Currency – Hotel Currency {{ Exchange Rate, Invoice Currency – Hotel Currency }} Displays the exchange rate used for converting the hotel native currency to the currency used on the invoice. When they are the same 1 is displayed

Invoice payments

The ‘Invoice Payments’ fields are used to display details about payments done. Per invoice multiple payments can be done and thus displayed.

Field Name Field notation Description
Payment – Code {{ Payment – Code }} Displays the Code for the payment method used for the payment
Payment – Date / Time added {{ Payment – Date / Time added }} Displays the date and time the payment was done
Payment – Description {{ Payment – Description }} Displays the Description as set when processing the Payment
Payment – Original charge amount {{ Payment – Original charge amount }} Displays the amount of the payment, in the currency the charge was processed
Payment – Hotel Native amount {{ Payment – Hotel Native amount }} Displays the amount of the payment, in the hotel native currency
Payment – Invoice amount {{ Payment – Invoice amount }} Displays the amount of the payment, in the currency set for the invoice
Payment – Charge Currency Rate {{ Payment – Charge Currency Rate }} Displays the exchange rate used at moment the charge was done – charging currency to hotel native currency
Payment – Invoice Currency Rate {{ Payment – Invoice Currency Rate }} Displays the exchange rate used for converting the hotel native currency to the currency used for the invoice
Payment – Charge Currency {{ Payment – Charge Currency }} Displays the Currency code used for the charge
Payment – Invoice Currency {{ Payment – Invoice Currency }} Displays the Currency code used on the invoice

Reactie

Was dit nuttig?

Ja Nee
U heeft aangegeven dat u dit onderwerp niet nuttig vond ...
Zou u hieronder willen uitleggen waarom niet? Bij voorbaat dank!
Dank voor uw reactie.

Geef uw reactie op dit onderwerp.

Verstuur Reactie