Invoice Templates » History » Revision 3
Revision 2 (Ward Vandewege, 04/24/2016 02:14 PM) → Revision 3/14 (Ward Vandewege, 04/24/2016 02:21 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 (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. h2. 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|PERSON|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.