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