Invoice Templates » History » Version 10
Ward Vandewege, 05/03/2016 10:05 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 | 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 | 8 | Ward Vandewege | h2. Sections (ODF_Billing_Profile_Invoice) |
48 | |||
49 | There are no sections for this invoice template type. |
||
50 | |||
51 | 7 | Ward Vandewege | h2. Tables (ODF_Billing_Profile_Invoice) |
52 | |||
53 | 9 | Ward Vandewege | h3. INVOICE_DETAILS |
54 | |||
55 | In this table, which must not be in a named section, each reservation payment on the invoice will be listed on a separate row. |
||
56 | |||
57 | 7 | Ward Vandewege | h3. VAT |
58 | |||
59 | 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. |
||
60 | |||
61 | 3 | Ward Vandewege | h2. Variables (ODF_Billing_Profile_Invoice) |
62 | |||
63 | |_Variable_|_Meaning_|_Section_|_Table_| |
||
64 | |[NAME]|Name of person or organization the invoice is made out to|none|none| |
||
65 | |[ADDRESS]|Address for person or organization the invoice is made out to|none|none| |
||
66 | |[DATE]|Invoice date|none|none| |
||
67 | |[REFERENCE]|Invoice reference (if any)|none|none| |
||
68 | |[TITLE]|Invoice title (if any)|none|none| |
||
69 | 4 | Ward Vandewege | |[FIRST_NAME] ^1^|Participant first name|none|INVOICE_DETAILS| |
70 | 3 | Ward Vandewege | |[SURNAME] ^1^|Participant surname|none|INVOICE_DETAILS| |
71 | |[ARRIVAL] ^1^|Departure date|none|INVOICE_DETAILS| |
||
72 | |[DEPARTURE] ^1^|Departure date|none|INVOICE_DETAILS| |
||
73 | |[DESCRIPTION] ^1^|Reservation payment description|none|INVOICE_DETAILS| |
||
74 | |[NIGHTS] ^1^|Reservation payment nights (if applicable)|none|INVOICE_DETAILS| |
||
75 | |[RATE] ^1^|Reservation payment rate|none|INVOICE_DETAILS| |
||
76 | |[TOTAL] ^1^|Reservation payment total|none|INVOICE_DETAILS| |
||
77 | |[INVOICE_TOTAL]|Invoice total|none|none| |
||
78 | |[VAT_SPLITTING] ^2^|VAT rate|none|VAT| |
||
79 | |[VAT] ^2^|Total amount in VAT for this rate|none|VAT| |
||
80 | |[VAT_INCL] ^2^|Total amount for this VAT rate|none|VAT| |
||
81 | |||
82 | ^1^ These variables are part of the INVOICE_DETAILS table, which will have one row for each reservation payment. |
||
83 | ^2^ These variables are part of the VAT table, which will have one row for each VAT rate that applies to this invoice. |