Invoice Templates » History » Revision 2
Revision 1 (Ward Vandewege, 04/24/2016 02:11 PM) → Revision 2/14 (Ward Vandewege, 04/24/2016 02:14 PM)
h1. Invoice Templates (ODF_Invoice and ODF_Billing_Profile_Invoice) h2. Sections h3. PERSON (only for ODF_Invoice) This section is automatically repeated for every person who is listed on the invoice. It supports one table: Table: PAYMENTS In this table, each payment payment will be listed on a separate row. h2. Variables |_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]|Participant first name|PERSON|none| |[SURNAME] ^1^|Participant |[SURNAME]|Participant surname|PERSON|none| |[ARRIVAL] ^1^|Departure |[ARRIVAL]|Departure date|PERSON|none| |[DEPARTURE] ^1^|Departure |[DEPARTURE]|Departure date|PERSON|none| |[DESCRIPTION] ^2^|Reservation ^1^|Reservation payment description|PERSON|PAYMENTS| |[NIGHTS] ^2^|Reservation ^1^|Reservation payment nights (if applicable)|PERSON|PAYMENTS| |[RATE] ^2^|Reservation ^1^|Reservation payment rate|PERSON|PAYMENTS| |[TOTAL] ^2^|Reservation ^1^|Reservation payment total|PERSON|PAYMENTS| |[INVOICE_TOTAL]|Invoice total|none|none| |[VAT_SPLITTING] ^3^|VAT ^2^|VAT rate|none|VAT| |[VAT] ^3^|Total ^2^|Total amount in VAT for this rate|none|VAT| |[VAT_INCL] ^3^|Total ^2^|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. payment. ^2^ These variables are part of the PAYMENTS table, which will have one row be repeated 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.