Invoice Templates » History » Revision 6
« Previous |
Revision 6/14
(diff)
| Next »
Ward Vandewege, 04/24/2016 02:23 PM
Invoice Templates (ODF_Invoice and ODF_Billing_Profile_Invoice)¶
Sections (ODF_Invoice)¶
PERSON¶
This section is automatically repeated for every person who is listed on the invoice.
It supports one table, PAYMENTS.
Tables (ODF_Invoice)¶
PAYMENTS¶
In this table, which must be in the PERSON section, each payment payment will be listed on a separate row.
VAT¶
In this table, which must not be in a named section, each VAT rate that applies to the invoice will be listed on a separate row.
Variables (ODF_Invoice)¶
| Variable | Meaning | Section | Table |
| [NAME] | Name of person or organization the invoice is made out to | none | none |
| [ADDRESS] | Address for person or organization the invoice is made out to | none | none |
| [SURNAME] | Participant surname | none | none |
| [DATE] | Invoice date | none | none |
| [REFERENCE] | Invoice reference (if any) | none | none |
| [TITLE] | Invoice title (if any) | none | none |
| [FIRST_NAME] 1 | Participant first name | PERSON | none |
| [SURNAME] 1 | Participant surname | PERSON | none |
| [ARRIVAL] 1 | Departure date | PERSON | none |
| [DEPARTURE] 1 | Departure date | PERSON | none |
| [DESCRIPTION] 2 | Reservation payment description | PERSON | PAYMENTS |
| [NIGHTS] 2 | Reservation payment nights (if applicable) | PERSON | PAYMENTS |
| [RATE] 2 | Reservation payment rate | PERSON | PAYMENTS |
| [TOTAL] 2 | Reservation payment total | PERSON | PAYMENTS |
| [INVOICE_TOTAL] | Invoice total | none | none |
| [VAT_SPLITTING] 3 | VAT rate | none | VAT |
| [VAT] 3 | Total amount in VAT for this rate | none | VAT |
| [VAT_INCL] 3 | Total amount for this VAT rate | none | VAT |
1 These variables are part of the PERSON section which will be repeated for each person with reservation payment(s) the invoice.
2 These variables are part of the PAYMENTS table, which will have one row for each reservation payment.
3 These variables are part of the VAT table, which will have one row for each VAT rate that applies to this invoice.
Variables (ODF_Billing_Profile_Invoice)¶
| Variable | Meaning | Section | Table |
| [NAME] | Name of person or organization the invoice is made out to | none | none |
| [ADDRESS] | Address for person or organization the invoice is made out to | none | none |
| [DATE] | Invoice date | none | none |
| [REFERENCE] | Invoice reference (if any) | none | none |
| [TITLE] | Invoice title (if any) | none | none |
| [FIRST_NAME] 1 | Participant first name | none | INVOICE_DETAILS |
| [SURNAME] 1 | Participant surname | none | INVOICE_DETAILS |
| [ARRIVAL] 1 | Departure date | none | INVOICE_DETAILS |
| [DEPARTURE] 1 | Departure date | none | INVOICE_DETAILS |
| [DESCRIPTION] 1 | Reservation payment description | none | INVOICE_DETAILS |
| [NIGHTS] 1 | Reservation payment nights (if applicable) | none | INVOICE_DETAILS |
| [RATE] 1 | Reservation payment rate | none | INVOICE_DETAILS |
| [TOTAL] 1 | Reservation payment total | none | INVOICE_DETAILS |
| [INVOICE_TOTAL] | Invoice total | none | none |
| [VAT_SPLITTING] 2 | VAT rate | none | VAT |
| [VAT] 2 | Total amount in VAT for this rate | none | VAT |
| [VAT_INCL] 2 | Total amount for this VAT rate | none | VAT |
1 These variables are part of the INVOICE_DETAILS table, which will have one row for each reservation payment.
2 These variables are part of the VAT table, which will have one row for each VAT rate that applies to this invoice.
Updated by Ward Vandewege about 8 years ago · 6 revisions