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 for that person 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.
PAID¶
In this table, which must not be in a named section, each each payment that was applied to this 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 |
| [INVOICE_BALANCE] | Invoice balance | 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 |
| [PAYMENT_METHOD] 4 | Payment method for this payment | none | PAID |
| [PAYMENT_DATE] 4 | Payment date for this payment | none | PAID |
| [PAYMENT_AMOUNT] 4 | Payment amount for this payment | none | PAID |
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.
4 These variables are part of the PAID table, which will have one row for each payment that was applied to this invoice.
Sections (ODF_Billing_Profile_Invoice)¶
There are no sections for this invoice template type.
Tables (ODF_Billing_Profile_Invoice)¶
INVOICE_DETAILS¶
In this table, which must not be in a named section, each reservation payment on the invoice 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.
PAID¶
In this table, which must not be in a named section, each each payment that was applied to this invoice will be listed on a separate row.
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 |
| [INVOICE_BALANCE] | Invoice balance | 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 |
| [PAYMENT_METHOD] 3 | Payment method for this payment | none | PAID |
| [PAYMENT_DATE] 3 | Payment date for this payment | none | PAID |
| [PAYMENT_AMOUNT] 3 | Payment amount for this payment | none | PAID |
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.
3 These variables are part of the PAID table, which will have one row for each payment that was applied to this invoice.
Updated by Ward Vandewege over 8 years ago · 14 revisions