Invoice Templates » History » Version 13
  Ward Vandewege, 05/03/2016 10:53 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 | 10 | Ward Vandewege | In this table, which must be in the PERSON section, each payment for that person will be listed on a separate row.  | 
| 16 | 6 | Ward Vandewege | |
| 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 | 12 | Ward Vandewege | h3. PAID  | 
| 22 | |||
| 23 | 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.  | 
||
| 24 | |||
| 25 | 3 | Ward Vandewege | h2. Variables (ODF_Invoice)  | 
| 26 | 1 | Ward Vandewege | |
| 27 | |_Variable_|_Meaning_|_Section_|_Table_|  | 
||
| 28 | |[NAME]|Name of person or organization the invoice is made out to|none|none|  | 
||
| 29 | |[ADDRESS]|Address for person or organization the invoice is made out to|none|none|  | 
||
| 30 | |[SURNAME]|Participant surname|none|none|  | 
||
| 31 | |[DATE]|Invoice date|none|none|  | 
||
| 32 | |[REFERENCE]|Invoice reference (if any)|none|none|  | 
||
| 33 | |[TITLE]|Invoice title (if any)|none|none|  | 
||
| 34 | 2 | Ward Vandewege | |[FIRST_NAME] ^1^|Participant first name|PERSON|none|  | 
| 35 | |[SURNAME] ^1^|Participant surname|PERSON|none|  | 
||
| 36 | |[ARRIVAL] ^1^|Departure date|PERSON|none|  | 
||
| 37 | |[DEPARTURE] ^1^|Departure date|PERSON|none|  | 
||
| 38 | |[DESCRIPTION] ^2^|Reservation payment description|PERSON|PAYMENTS|  | 
||
| 39 | |[NIGHTS] ^2^|Reservation payment nights (if applicable)|PERSON|PAYMENTS|  | 
||
| 40 | |[RATE] ^2^|Reservation payment rate|PERSON|PAYMENTS|  | 
||
| 41 | |[TOTAL] ^2^|Reservation payment total|PERSON|PAYMENTS|  | 
||
| 42 | 1 | Ward Vandewege | |[INVOICE_TOTAL]|Invoice total|none|none|  | 
| 43 | 11 | Ward Vandewege | |[INVOICE_BALANCE]|Invoice balance|none|none|  | 
| 44 | 2 | Ward Vandewege | |[VAT_SPLITTING] ^3^|VAT rate|none|VAT|  | 
| 45 | |[VAT] ^3^|Total amount in VAT for this rate|none|VAT|  | 
||
| 46 | |[VAT_INCL] ^3^|Total amount for this VAT rate|none|VAT|  | 
||
| 47 | 11 | Ward Vandewege | |[PAYMENT_METHOD] ^4^|Payment method for this payment|none|PAID|  | 
| 48 | |[PAYMENT_DATE] ^4^|Payment date for this payment|none|PAID|  | 
||
| 49 | |[PAYMENT_AMOUNT] ^4^|Payment amount for this payment|none|PAID|  | 
||
| 50 | 1 | Ward Vandewege | |
| 51 | 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.  | 
| 52 | ^2^ These variables are part of the PAYMENTS table, which will have one row for each reservation payment.  | 
||
| 53 | 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.  | 
| 54 | 11 | Ward Vandewege | ^4^ These variables are part of the PAID table, which will have one row for each payment that was applied to this invoice.  | 
| 55 | 3 | Ward Vandewege | |
| 56 | 8 | Ward Vandewege | h2. Sections (ODF_Billing_Profile_Invoice)  | 
| 57 | |||
| 58 | There are no sections for this invoice template type.  | 
||
| 59 | |||
| 60 | 7 | Ward Vandewege | h2. Tables (ODF_Billing_Profile_Invoice)  | 
| 61 | |||
| 62 | 9 | Ward Vandewege | h3. INVOICE_DETAILS  | 
| 63 | |||
| 64 | In this table, which must not be in a named section, each reservation payment on the invoice will be listed on a separate row.  | 
||
| 65 | |||
| 66 | 7 | Ward Vandewege | h3. VAT  | 
| 67 | |||
| 68 | 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.  | 
||
| 69 | |||
| 70 | 13 | Ward Vandewege | h3. PAID  | 
| 71 | |||
| 72 | 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.  | 
||
| 73 | |||
| 74 | 3 | Ward Vandewege | h2. Variables (ODF_Billing_Profile_Invoice)  | 
| 75 | |||
| 76 | |_Variable_|_Meaning_|_Section_|_Table_|  | 
||
| 77 | |[NAME]|Name of person or organization the invoice is made out to|none|none|  | 
||
| 78 | |[ADDRESS]|Address for person or organization the invoice is made out to|none|none|  | 
||
| 79 | |[DATE]|Invoice date|none|none|  | 
||
| 80 | |[REFERENCE]|Invoice reference (if any)|none|none|  | 
||
| 81 | |[TITLE]|Invoice title (if any)|none|none|  | 
||
| 82 | 4 | Ward Vandewege | |[FIRST_NAME] ^1^|Participant first name|none|INVOICE_DETAILS|  | 
| 83 | 3 | Ward Vandewege | |[SURNAME] ^1^|Participant surname|none|INVOICE_DETAILS|  | 
| 84 | |[ARRIVAL] ^1^|Departure date|none|INVOICE_DETAILS|  | 
||
| 85 | |[DEPARTURE] ^1^|Departure date|none|INVOICE_DETAILS|  | 
||
| 86 | |[DESCRIPTION] ^1^|Reservation payment description|none|INVOICE_DETAILS|  | 
||
| 87 | |[NIGHTS] ^1^|Reservation payment nights (if applicable)|none|INVOICE_DETAILS|  | 
||
| 88 | |[RATE] ^1^|Reservation payment rate|none|INVOICE_DETAILS|  | 
||
| 89 | |[TOTAL] ^1^|Reservation payment total|none|INVOICE_DETAILS|  | 
||
| 90 | |[INVOICE_TOTAL]|Invoice total|none|none|  | 
||
| 91 | |[VAT_SPLITTING] ^2^|VAT rate|none|VAT|  | 
||
| 92 | |[VAT] ^2^|Total amount in VAT for this rate|none|VAT|  | 
||
| 93 | |[VAT_INCL] ^2^|Total amount for this VAT rate|none|VAT|  | 
||
| 94 | 13 | Ward Vandewege | |[PAYMENT_METHOD] ^3^|Payment method for this payment|none|PAID|  | 
| 95 | |[PAYMENT_DATE] ^3^|Payment date for this payment|none|PAID|  | 
||
| 96 | |[PAYMENT_AMOUNT] ^3^|Payment amount for this payment|none|PAID|  | 
||
| 97 | 3 | Ward Vandewege | |
| 98 | ^1^ These variables are part of the INVOICE_DETAILS table, which will have one row for each reservation payment.  | 
||
| 99 | ^2^ These variables are part of the VAT table, which will have one row for each VAT rate that applies to this invoice.  | 
||
| 100 | 13 | Ward Vandewege | ^3^ These variables are part of the PAID table, which will have one row for each payment that was applied to this invoice.  |