Functional description
Difficulty level:
Price variables
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.