Invoice Templates » History » Version 7
  Ward Vandewege, 04/24/2016 02:24 PM 
  
| 1 | 1 | Ward Vandewege | h1. Invoice Templates (ODF_Invoice and ODF_Billing_Profile_Invoice)  | 
|---|---|---|---|
| 2 | |||
| 3 | 5 | Ward Vandewege | h2. Sections (ODF_Invoice)  | 
| 4 | 1 | Ward Vandewege | |
| 5 | 5 | Ward Vandewege | h3. PERSON  | 
| 6 | 1 | Ward Vandewege | |
| 7 | This section is automatically repeated for every person who is listed on the invoice.  | 
||
| 8 | |||
| 9 | 6 | Ward Vandewege | It supports one table, PAYMENTS.  | 
| 10 | 1 | Ward Vandewege | |
| 11 | 6 | Ward Vandewege | h2. Tables (ODF_Invoice)  | 
| 12 | 1 | Ward Vandewege | |
| 13 | 6 | Ward Vandewege | h3. PAYMENTS  | 
| 14 | |||
| 15 | In this table, which must be in the PERSON section, each payment payment will be listed on a separate row.  | 
||
| 16 | |||
| 17 | h3. VAT  | 
||
| 18 | |||
| 19 | 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.  | 
||
| 20 | 1 | Ward Vandewege | |
| 21 | 3 | Ward Vandewege | h2. Variables (ODF_Invoice)  | 
| 22 | 1 | Ward Vandewege | |
| 23 | |_Variable_|_Meaning_|_Section_|_Table_|  | 
||
| 24 | |[NAME]|Name of person or organization the invoice is made out to|none|none|  | 
||
| 25 | |[ADDRESS]|Address for person or organization the invoice is made out to|none|none|  | 
||
| 26 | |[SURNAME]|Participant surname|none|none|  | 
||
| 27 | |[DATE]|Invoice date|none|none|  | 
||
| 28 | |[REFERENCE]|Invoice reference (if any)|none|none|  | 
||
| 29 | |[TITLE]|Invoice title (if any)|none|none|  | 
||
| 30 | 2 | Ward Vandewege | |[FIRST_NAME] ^1^|Participant first name|PERSON|none|  | 
| 31 | |[SURNAME] ^1^|Participant surname|PERSON|none|  | 
||
| 32 | |[ARRIVAL] ^1^|Departure date|PERSON|none|  | 
||
| 33 | |[DEPARTURE] ^1^|Departure date|PERSON|none|  | 
||
| 34 | |[DESCRIPTION] ^2^|Reservation payment description|PERSON|PAYMENTS|  | 
||
| 35 | |[NIGHTS] ^2^|Reservation payment nights (if applicable)|PERSON|PAYMENTS|  | 
||
| 36 | |[RATE] ^2^|Reservation payment rate|PERSON|PAYMENTS|  | 
||
| 37 | |[TOTAL] ^2^|Reservation payment total|PERSON|PAYMENTS|  | 
||
| 38 | 1 | Ward Vandewege | |[INVOICE_TOTAL]|Invoice total|none|none|  | 
| 39 | 2 | Ward Vandewege | |[VAT_SPLITTING] ^3^|VAT rate|none|VAT|  | 
| 40 | |[VAT] ^3^|Total amount in VAT for this rate|none|VAT|  | 
||
| 41 | |[VAT_INCL] ^3^|Total amount for this VAT rate|none|VAT|  | 
||
| 42 | 1 | Ward Vandewege | |
| 43 | 2 | Ward Vandewege | ^1^ These variables are part of the PERSON section which will be repeated for each person with reservation payment(s) the invoice.  | 
| 44 | ^2^ These variables are part of the PAYMENTS table, which will have one row for each reservation payment.  | 
||
| 45 | 1 | Ward Vandewege | ^3^ These variables are part of the VAT table, which will have one row for each VAT rate that applies to this invoice.  | 
| 46 | 3 | Ward Vandewege | |
| 47 | 7 | Ward Vandewege | h2. Tables (ODF_Billing_Profile_Invoice)  | 
| 48 | |||
| 49 | h3. VAT  | 
||
| 50 | |||
| 51 | 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.  | 
||
| 52 | |||
| 53 | 3 | Ward Vandewege | h2. Variables (ODF_Billing_Profile_Invoice)  | 
| 54 | |||
| 55 | |_Variable_|_Meaning_|_Section_|_Table_|  | 
||
| 56 | |[NAME]|Name of person or organization the invoice is made out to|none|none|  | 
||
| 57 | |[ADDRESS]|Address for person or organization the invoice is made out to|none|none|  | 
||
| 58 | |[DATE]|Invoice date|none|none|  | 
||
| 59 | |[REFERENCE]|Invoice reference (if any)|none|none|  | 
||
| 60 | |[TITLE]|Invoice title (if any)|none|none|  | 
||
| 61 | 4 | Ward Vandewege | |[FIRST_NAME] ^1^|Participant first name|none|INVOICE_DETAILS|  | 
| 62 | 3 | Ward Vandewege | |[SURNAME] ^1^|Participant surname|none|INVOICE_DETAILS|  | 
| 63 | |[ARRIVAL] ^1^|Departure date|none|INVOICE_DETAILS|  | 
||
| 64 | |[DEPARTURE] ^1^|Departure date|none|INVOICE_DETAILS|  | 
||
| 65 | |[DESCRIPTION] ^1^|Reservation payment description|none|INVOICE_DETAILS|  | 
||
| 66 | |[NIGHTS] ^1^|Reservation payment nights (if applicable)|none|INVOICE_DETAILS|  | 
||
| 67 | |[RATE] ^1^|Reservation payment rate|none|INVOICE_DETAILS|  | 
||
| 68 | |[TOTAL] ^1^|Reservation payment total|none|INVOICE_DETAILS|  | 
||
| 69 | |[INVOICE_TOTAL]|Invoice total|none|none|  | 
||
| 70 | |[VAT_SPLITTING] ^2^|VAT rate|none|VAT|  | 
||
| 71 | |[VAT] ^2^|Total amount in VAT for this rate|none|VAT|  | 
||
| 72 | |[VAT_INCL] ^2^|Total amount for this VAT rate|none|VAT|  | 
||
| 73 | |||
| 74 | ^1^ These variables are part of the INVOICE_DETAILS table, which will have one row for each reservation payment.  | 
||
| 75 | ^2^ These variables are part of the VAT table, which will have one row for each VAT rate that applies to this invoice.  |