Project

General

Profile

Actions

Invoice Templates » History » Revision 12

« Previous | Revision 12/14 (diff) | Next »
Ward Vandewege, 05/03/2016 10:13 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 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.

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 almost 8 years ago · 12 revisions