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. |