Functional description

The derivative variable column contains the prepared variation of the variable. Example: if the price is €12.50, a value of '12.50' is entered in TOTAL_PRICE. So you see "€ 12.50" in the FORMAT_TOTAL_PRICE.

There is also a column available for the detail rows.

Variable Derivative variable / total Description Example
{TOTAL_PRICE} {FORMAT_TOTAL_PRICE} The price of a booking/invoice
{TOTAL_PRICETO_BE_RECEIVED} {FORMAT_TOTAL_PRICETO_BE_RECEIVED} The sum still to be received (only the sum to be received is entered)
{TOTAL_PRICETO_BE_PAID} {FORMAT_TOTAL_PRICETO_BE_PAID} The sum still to be paid (only the sum still to be paid is entered)
{TOTAL_PRICE_WITHOUT_OPTIONS} {FORMAT_TOTAL_PRICE_WITHOUT_OPTIONS} Total price of the booking/invoice, without options, also known as the entire sum
{TOTAL_PRICE_PAID} {FORMAT_TOTAL_PRICE_PAID} How much has been paid
{TOTAL_PRICE_LEFT} {FORMAT_TOTAL_PRICE_LEFT} Amount without minus sign, whether it is to be paid or received. generally used in combination with PAYMENT_TEXT
{TOTAL_PRICE_FEE} {FORMAT_TOTAL_PRICE_FEE}

Total commission

{S_DETAIL} A control variable to show the price has been entered True / False
{PAYMENT_TEXT} Derived from invoice settings
{detail.VAT} {TOTAL_VAT} VAT € 8.68
{detail.VAT_EXCLUSIVE} {TOTAL_VAT_EXCLUSIVE} excluding VAT € 41.32
{detail.VAT_DESCRIPTION} {TOTAL_VAT_DESCRIPTION} description VAT VAT high
{detail.TILL} {TOTAL_TILL} Date till 20 May 2013
{detail.TILLTIME} {TOTAL_TILLTIME} Time from 12:00
{detail.SUBTOTAL} {TOTAL_SUBTOTAL} Sub-total € 50.00
{detail.PROD_DESC} {TOTAL_PROD_DESC} Description product Tennis
{detail.PRICE} {TOTAL_PRICE} Price € 50.00
{detail.PER_DESC} {TOTAL_PER_DESC} Description period Hour
{detail.PARTICIPANTS} {TOTAL_PARTICIPANTS} Number of participants 3
{detail.PART_DESC} {TOTAL_PART_DESC} Description participants Adult
{detail.NUMBER_OF_PLACES} {TOTAL_NUMBER_OF_PLACES} Number of places 1
{detail.NIGHTS} {TOTAL_NIGHTS} Number of nights 0
{detail.FROM} {TOTAL_FROM} Date from 20 May 2013
{detail.FROMTIME} {TOTAL_FROMTIME} Time from 10:00
{detail.FEE_VAT} {TOTAL_FEE_VAT} Commission VAT € 1.23
{detail.FEE_VAT_EXCLUSIVE} {TOTAL_FEE_VAT_EXCLUSIVE} Net commission € 1.23
{detail.FEE_SUB} {TOTAL_FEE_SUB} Sub-total commission € 10.98
{detail.FEE_DESC} {TOTAL_FEE_DESC} Description comission Contribution owner
{detail.FEE_AMOUNT} {TOTAL_FEE_AMOUNT} Amount of commission € 10.98
{detail.EXT_DESC} {TOTAL_EXT_DESC} Description option Racket
{detail.DISCOUNT} {TOTAL_DISCOUNT} Description of discount 10 % last minute
{detail.DISCOUNT_TOTAL} {TOTAL_DISCOUNT_TOTAL} Discount € 15.96
{detail.DESCRIPTION} {TOTAL_DESCRIPTION} Description Tennis
{detail.DAYS} {TOTAL_DAYS} Number of days 1
{detail.CURRENCY} {TOTAL_CURRENCY} Currency EUR
{detail.COM_DESC} {TOTAL_COM_DESC} Description arrangement Arrangement
{detail.ACCOUNT_CODE} {TOTAL_ACCOUNT_CODE} The acount code 8000
{detail.ACCOUNT_SIGN} {TOTAL_ACCOUNT_SIGN} The account sign DB

A sample table with price rows:

<table align="center" border="0" cellpadding="0" cellspacing="1" style="width:100%">
	<tbody>
		<tr>
			<td>Description</td>
			<td>Number</td>
			<td>From</td>
			<td>Till</td>
			<td>Price</td>
			<td>VAT</td>
			<td>Total</td>
		</tr>
		<!-- BEGIN detail -->
		<tr>
			<td>{detail.DESCRIPTION}</td>
			<td>{detail.NUMBER_OF_PLACES}</td>
			<td>{detail.FROM}</td>
			<td>{detail.TILL}</td>
			<td>{detail.VAT_EXCLUDED}</td>
			<td>{detail.VAT}</td>
			<td>{detail.SUB-TOTAL}</td>
		</tr>
		<!-- END detail -->
		<tr>
			<td>Totaal</td>
			<td>{TOTAL_NUMBER_OF_PLACES}</td>
			<td>{FROMDATE}</td>
			<td>{TILLDATE}</td>
			<td>{TOTAL_VAT_EXCLUDED}</td>
			<td>{TOTAL_VAT}</td>
			<td>{TOTAL_TOTAL}</td>
		</tr>
	</tbody>
</table>

A popular option is to record the VAT totals as a separate table.
Creating a VAT totals block makes this possible.
A sample table with VAT totals:

<table class="vat_summary">
	<tbody>
		<tr>
			<th>Description</th>
			<th>Base amount</th>
			<th>Total amount</th>
		</tr>
		<!-- BEGIN vattotals -->
		<tr>
			<td>{vattotals.VAT_ID} - {vattotals.VAT_DESC}</td>
			<td>{vattotals.VAT_BASE}</td>
			<td>{vattotals.VAT_AMOUNT}</td>
		</tr>
		<!-- END vattotals -->
	</tbody>
</table>

Take note: using detail variables requires knowledge of the effect of detail rows.