| This manual is deprecated. Please visit https://groupoffice.readthedocs.io for the latest documentation. |
Difference between revisions of "Billing E-mail template variables"
From Group-Office Groupware and CRM Documentation
(→Order data) |
|||
| Line 3: | Line 3: | ||
{company_id} The company id | {company_id} The company id | ||
{contact_id} The contact id | {contact_id} The contact id | ||
| − | {id} | + | {id} The database id of the order |
| − | {order_id} | + | {order_id} The textual order ID |
| − | {po_id} | + | {po_id} The purchase order ID |
{btime} The date of the order | {btime} The date of the order | ||
| − | {reference} | + | {reference} The order reference |
| − | {total} | + | {total} The gross amount of the order |
| − | {subtotal} | + | {subtotal} The nett amount of the order |
{vat} | {vat} | ||
| + | {due_date} The due date field value | ||
| + | {due_days} The due days field value | ||
</pre> | </pre> | ||
Revision as of 08:18, 2 April 2015
Contents
Order data
{company_id} The company id
{contact_id} The contact id
{id} The database id of the order
{order_id} The textual order ID
{po_id} The purchase order ID
{btime} The date of the order
{reference} The order reference
{total} The gross amount of the order
{subtotal} The nett amount of the order
{vat}
{due_date} The due date field value
{due_days} The due days field value
Custom fields
Lookup the database name in the custom fields module and use {col_x}.
Customer
{customer_salutation}
{customer_name}
{customer_address}
{customer_address_no}
{customer_zip}
{customer_city}
{customer_state}
{customer_vat_no}
{customer_country}
{customer_countryname} (since 4.1.30)
Logged in user
For the logged in user fields see this page: Addressbook#Document_templates
Invoice items
You can generate a table of the invoice items like this:
{items_table_start}
<table style="width: 100%;">
<tbody>
<tr>
<td><strong>Description</strong></td>
<td style="text-align: center;"><strong>Amount</strong></td>
<td style="text-align: right;"><strong>Unit price</strong></td>
<td style="text-align: right;"><strong>Price</strong></td>
</tr>
<tr>
<td>{item_description}</td>
<td style="text-align: center;">{item_amount}</td>
<td style="text-align: right;">{item_unit_price}</td>
<td style="text-align: right;">{item_total}</td>
</tr>
<tr>
<td colspan="3" style="font-weight: bold;"><br />
Totaal (including VAT):</td>
<td style="border-top: 1px solid black; font-weight: bold; text-align: right;"><br />
€ {order_total}</td>
</tr>
</tbody>
</table>
{items_table_end}
Invoice item rows in ODF templates
{amount_delivered}
{markup}
{cost_code}
{discount}
{vat} VAT Percentage. eg. 19 for 19%
{amount}
{unit_total} The unit price including VAT.
{unit_list} The unit price from the catalog.
{unit_price} The unit price without VAT
{unit_cost} The unit cost price without VAT
{description}
{item_total} The localized item total (amount*unit_total) incl. VAT
{item_subtotal} The localized item total (amount*unit_price) excl. VAT
