Explanation Word Template
General
Headers and footers
If a document consists of more than one page, the part between «HeaderStart»and«HeaderEnd»will automatically be copied to the header of the next pages. The same counts for a foot text. The appropriate fields are «FooterStart»and«FooterEnd».
Page numbers
You can show page numbers in your template: the current page and the total number of pages (e.g. ‘page 2 of 5’).
To besure that the page numbers are set right before printing, set the option (only for Word 2003): Tools Options Print Update field codes).
Tables
If you use tables with merge fields, you have to state where a table row starts and ends. Use the special fields «TableStart:tabel_naam»and«TableEnd:tabel_naam».Example:
Code / Quantity / Description / Price / Total«TableStart:lines»«lines_line_artcode» / «lines_line_qty» / «lines_line_descr» / «lines_line_unitsprice_@regional» / «lines_line_invvalue_@regional»«TableEnd:lines»
You can find these fields in the overview below. In a template you can only use a type of table once! The fieldnames differ per template.If a table field is positioned outside the TableStartandTableEndtags, these fields become the value of the first data row.
Supported character sets for electronic billing and dunning letters (PDF)
Electronic invoices and dunning letters are sent as PDF-files. The conversion from Word to PDF is possible for character sets that are installed on the Twinfield servers. If you use other sets, the most alike set will be used. This may give your documents a slightly different look.
Fully supported character sets:
ArialArial Black
Calibri
Cambria
Cambria Math
Candara
Comic Sans MS
Consolas
Constantia / Corbel
Courier New
Franklin Gothic Medium
Georgia
Impact
Lucida Console
Lucida Sans Unicode
Microsoft Sans Serif
Palatino Linotype / Sylfaen
Symbol
Tahoma
Times New Roman
Trebuchet MS
Verdana
Webdings
Wingdings
Billing
Billing addressPostal address
Customername: «addressinv_name»«addressdel_name»
Attn:«addressinv_addr1»«addressdel_addr1»
Address:«addressinv_addr2»«addressdel_addr2»
«addressinv_addr3»«addressdel_addr3»
Zip code:«addressinv_postcode»«addressdel_postcode»
City:«addressinv_city»«addressdel_city»
Country code:«addressinv_country_@code»«addressdel_country_@code»
Country name:«addressinv_country»«addressdel_country»
VAT number:«addressinv_addr4»«addressdel_addr4»
Chamber of Comm. number:«addressinv_addr5»«addressdel_addr5»
Invoice header
Invoice date:«header_invdate»
Due date:«header_duedate»
Performance date:«header_perfdate»
Invoice number:«header_invnum»
VAT number:«header_vatnumber»
Customer number:«header_customer»
Customer name:«header_customername»
Period:«header_period»
Invoice header:«header_headerdescr»
Invoice footer:«header_footerdescr»
Original / copy:«header_printstatus»
Payment method:«header_paycode»
Bankname:«bank_name»
Bank account:«bank_account»
Original / copy:«header_printstatus»
Copy:«header_print»
Number ofcopies:«header_printcount»
Invoice made by:«header_usrcode_@name»
Time authorizedby:«header_authoriser_@name»
Table fields
Start en end tablerow:«TableStart:lines», «TableEnd:lines»
Line numbering:«lines_line_@id»
Currency /total:«header_currency»
Article code:«lines_line_artcode»
Article subcode:«lines_line_subcode»
Article – name:«lines_line_name»
Article – short name:«lines_line_sname»
Free text 1:«lines_line_extref1»
Free text 2:«lines_line_extref2»
Free text 3:«lines_line_extref3»
Cost center code:«lines_line_dim2»
Cost center name:«lines_line_dim2_@name»
Projectcode:«lines_line_dim3»
Projectname:«lines_line_dim3_@name»
Activity code:«lines_line_dim4»
Activity name:«lines_line_dim4_@name»
Daybook code:«lines_line_fincode»
Journal number:«lines_line_finnumber»
Acc. payable name:«lines_line_acpay_@name»
Performance date:«lines_line_perfdate»
Quantity:«lines_line_qty»
Description:«lines_line_descr»
Price / article (excl.VAT)*:«lines_line_unitsprice_@regional»
Price / article (incl.VAT)**:«lines_line_unitspriceinc_@regional»
Currency / row:«lines_line_currency»
VAT %:«lines_line_taxrate»
VATamount:«lines_line_taxvalue_@regional»
Total per row (excl. VAT):«lines_line_invvalue_@regional»
Total per row (incl. VAT):«lines_line_invvalueinc_@regional»
VATrows
Start and end tablerow:«TableStart:taxlines», «TableEnd:taxlines»
Currency / VAT:«calclines_taxline_currency»
VATdescription:«calclines_taxline_taxname»
Performance type (for ICP):«calclines_taxline_perftype»
Perform. Yearmonth (ICP):«calclines_taxline_perfyearmonth»
VATover:«calclines_taxline_taxover_@regional»
VATamount:«calclines_taxline_taxvalue_@regional»
VAT incl.«calclines_taxline_valueincl_@regional»
Total excl. VAT:«calclines_totalline_valueexcl_@regional»
Total VAT:«calclines_totalline_taxvalue_@regional»
Total:«calclines_totalline_value_@regional»
Extra fields for time billing invoices
Start and end table row:«TableStart:lines», «TableEnd:lines»
Weeknumber:«lines_line_teq_week»
Month number:«lines_line_teq_month»
Quarter number:«lines_line_teq_quarter»
Project – code:«lines_line_dim1»
Project – name:«lines_line_dim1_@name»
Project – short name:«lines_line_dim1_@sname»
Project – invoice description:«lines_line_dim1_@prjinvdescr»
Activity – code:«lines_line_dim2»
Activity – name:«lines_line_dim2_@name»
Activity – short name:«lines_line_dim2_@sname»
Activity – invoice description:«lines_line_dim2_@prjinvdescr»
User:«lines_line_dim3»
Performance date:«lines_line_transdate»
Detail rows time billing invoices
Start and end table row:«TableStart:timelines», «TableEnd:timelines»
User – name:«time_line_user_@name»
User– short name:«time_line_user_@sname»
User– code:«time_line_user»
Transaction date:«time_line_transdate»
Project – name:«time_line_project_@name»
Project – short name:«time_line_project_@sname»
Project – invoice description:«time_line_project_@prjinvdescr»
Project – code:«time_line_project»
Activity – name:«time_line_activity_@name»
Activity – short name:«time_line_activity_@sname»
Activity – invoice description:«time_line_activity_@actinvdescr»
Activity – code:«time_line_activity»
Descriptiontime:«time_line_descr»
Quantity:«time_line_qty»
Price:«time_line_price»
Giro’s
Before the comma: «calclines_totalline_value_@predecimal»
After the comma:«calclines_totalline_value_@postdecimal»
Bank account number debtor:«header_customer_@account»
* This field can only be used for articles with a price without VAT.
** This field can only be used for articles with a price with VAT included.
Dunning letters
Customer name: / «customer_custname»Company name: / «customer_name»
Attn.: / «customer_addr1»
Address: / «customer_addr2», «customer_addr3»
Zip code: / «customer_postcode»
City: / «customer_city»
Country code: / «customer_country»
Country name: / «customer_country_@name»
Date: / «customer_modified»
Customer number: / «customer_dimcode»
Base currency code: / «customer_basecurrency»
Base currency name: / «customer_basecurrency_@name»
Base currency short name: / «customer_basecurrency_@shortname»
Reporting currency code: / «customer_reportingcurrency»
Reporting currency name: / «customer_reportingcurrency_@name»
Reporting currency short name: / «customer_reportingcurrency_@shortname»
Invoice currency code: / «customer_invoicecurrency»
Invoice currency name: / «customer_invoicecurrency_@name»
Invoice currency short name: / «customer_invoicecurrency_@shortname»
Total outstanding amount (base currency): / «customer_totalbasevalueopen»
Total outstanding amount (reporting currency): / «customer_totalrepvalueopen»
Total outstanding amount (invoice currency): / «customer_totalvalueopen»
* If a customer is billed for more than one currency, the fields customer_invoicecurrency and customer_totalvalueopen will contain the base currency values.
Table fields
Start and end table row: / «TableStart:customer», «TableEnd:customer»Invoice number: / «customer_detail_invnumber»
Invoice date: / «customer_detail_inpdate»
Outstanding amount (base currency): / «customer_detail_basevalueopen»
Outstanding amount (invoice currency): / «customer_detail_valueopen»
Outstanding amount (reporting currency): / «customer_detail_repvalueopen»
Invoice amount (base currency): / «customer_detail_basevalue»
Invoice amount (Invoice currency): / «customer_detail_value»
Invoice amount (reporting currency): / «customer_detail_repvalue»
Paid (base currency): / «customer_detail_basevaluepaid»
Paid(invoice currency): / «customer_detail_valuepaid»
Paid(reporting currency): / «customer_detail_repvaluepaid»
Nr of days due: / «customer_detail_days»
Due date: / «customer_detail_duedate»
Invoice currency code: / «customer_detail_currency»
Invoice currency name: / «customer_detail_currency_@name»
Invoice currency short name: / «customer_detail_currency_@shortname»
Invoice description: / «customer_detail_description»
Giro’s
Before the comma (base currency): / «customer_totalbasevalueopen_@predecimal»Before the comma (reporting currency): / «customer_totalrepvalueopen_@predecimal»
Before the comma (invoice currency): / «customer_totalvalueopen_@predecimal»
After the comma (base currency): / «customer_totalbasevalueopen_@postdecimal»
After the comma (reporting currency): / «customer_totalrepvalueopen_@postdecimal»
After the comma (invoice currency): / «customer_totalvalueopen_@postdecimal»
Bank account number debtor: / «customer_account»
Pay & Collect
Supplier / Customer fields
Supplier / Customer:«name»
Attn.:«addr1»
Address:«addr2»
«addr3»
VAT:«addr4»
Chamber of Commerce:«addr5»
Zip code:«postcode»
City:«city»
Country:«country»
Supplier / customer number:«dimcode»
Supplier / customer name:«dimname»
Pay date:«date»
Company fields
Code:«office_code»
Name:«office_name»
VAT-number:«office_vatnumber»
Address line 1:«office_address_line1»
Address line 2:«office_address_line2»
Address line 3:«office_address_line3»
Address line 4:«office_address_line4»
Address line 5:«office_address_line5»
Address line 6:«office_address_line6»
Zip code:«office_address_zipcode»
City:«office_address_city»
Country:«office_address_country»
Phone number:«office_address_telephone»
Faxnumber:«office_address_fax»
Bank fields
Code:«bank_code»
Name:«bank_name»
Ascription:«bank_ascription»
IBAN:«bank_iban»
Bank account number:«bank_accountnumber»
National branch identification code:«bank_nationalbic»
BIC:«bank_bic»
Address line 1:«bank_address_line1»
Address line 2:«bank_address_line2»
Address line 3:«bank_address_line3»
Address line 4:«bank_address_line4»
Address line 5:«bank_address_line5»
Address line 6:«bank_address_line6»
Zip code:«bank_address_zipcode»
City:«bank_address_city»
Country:«bank_address_country»
Phone number:«bank_address_telephone»
Faxnumber:«bank_address_fax»
Table fields
Start and end table row:«TableStart:details», «TableEnd:details»
Invoice date:«details_detail_invdate»
Due date:«details_detail_duedate»
Invoice number:«details_detail_invnumber»
Invoice amount:«details_detail_origvalue»
Amount paid:«details_detail_value»
Invoice amount (base currency):«details_detail_origbasevalue»
Amount paid (base currency):«details_detail_basevalue»
Transaction:«details_detail_trscode_@name»
Transaction number:«details_detail_trsnumber»
Total amount invoices:«origvalue»
Total amount paid:«value»
Total amount invoices (base curr.):«origvalue»
Total amount paid (base curr.): «value»
Currency:«currency»
Total amount to payin words:«valuetext»
Cheque production
Supplier fields
Supplier:«name»
Attn.:«addr1»
Address:«addr2»
«addr3»
VAT:«addr4»
Chamber of Commerce:«addr5»
Zip code:«postcode»
City:«city»
Country:«country»
Supplier number:«dimcode»
Supplier name:«dimname»
Pay date:«date»
Company fields
Code:«office_code»
Name:«office_name»
VAT-number:«office_vatnumber»
Address line 1:«office_address_line1»
Address line 2:«office_address_line2»
Address line 3:«office_address_line3»
Address line 4:«office_address_line4»
Address line 5:«office_address_line5»
Address line 6:«office_address_line6»
Zip code:«office_address_zipcode»
City:«office_address_city»
Country:«office_address_country»
Phone number:«office_address_telephone»
Faxnumber:«office_address_fax»
Table fields
Start and end table row:«TableStart:cheque_details», «TableEnd:cheque_details»
Invoice date:«cheque_details_detail_invdate»
Due date:«cheque_details_detail_duedate»
Invoice number:«cheque_details_detail_invnumber»
Invoice amount:«cheque_details_detail_origvalue»
Amount paid:«cheque_details_detail_value»
Invoice amount (base currency):«cheque_details_detail_origbasevalue»
Amount paid (base currency):«cheque_details_detail_basevalue»
Transaction:«cheque_details_detail_trscode_@name»
Transaction number:«cheque_details_detail_trsnumber»
Total amount invoices:«origvalue»
Total amount paid:«value»
Total amount invoices (base curr.):«origvalue»
Total amount paid (base curr.): «value»
Currency:«currency»
Total amount to payin words:«valuetext»
Millions in words:«millions»
Hundreds of thousands in words:«hundreds_of_thousands»
Tens of thousands in words:«tens_of_thousands»
Thousands in words:«thousands»
Hundreds in words:«hundreds»
Tensin words:«tens»
Units in words:«units»
Cents «cents»