Project

General

Profile

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.