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