Project

General

Profile

Invoice Templates » History » Version 6

Ward Vandewege, 04/24/2016 02:23 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
In this table, which must be in the PERSON section, each payment payment will be listed on a separate row.
16
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
h2. Variables (ODF_Billing_Profile_Invoice)
48
49
|_Variable_|_Meaning_|_Section_|_Table_|
50
|[NAME]|Name of person or organization the invoice is made out to|none|none|
51
|[ADDRESS]|Address for person or organization the invoice is made out to|none|none|
52
|[DATE]|Invoice date|none|none|
53
|[REFERENCE]|Invoice reference (if any)|none|none|
54
|[TITLE]|Invoice title (if any)|none|none|
55 4 Ward Vandewege
|[FIRST_NAME] ^1^|Participant first name|none|INVOICE_DETAILS|
56 3 Ward Vandewege
|[SURNAME] ^1^|Participant surname|none|INVOICE_DETAILS|
57
|[ARRIVAL] ^1^|Departure date|none|INVOICE_DETAILS|
58
|[DEPARTURE] ^1^|Departure date|none|INVOICE_DETAILS|
59
|[DESCRIPTION] ^1^|Reservation payment description|none|INVOICE_DETAILS|
60
|[NIGHTS] ^1^|Reservation payment nights (if applicable)|none|INVOICE_DETAILS|
61
|[RATE] ^1^|Reservation payment rate|none|INVOICE_DETAILS|
62
|[TOTAL] ^1^|Reservation payment total|none|INVOICE_DETAILS|
63
|[INVOICE_TOTAL]|Invoice total|none|none|
64
|[VAT_SPLITTING] ^2^|VAT rate|none|VAT|
65
|[VAT] ^2^|Total amount in VAT for this rate|none|VAT|
66
|[VAT_INCL] ^2^|Total amount for this VAT rate|none|VAT|
67
68
^1^ These variables are part of the INVOICE_DETAILS table, which will have one row for each reservation payment.
69
^2^ These variables are part of the VAT table, which will have one row for each VAT rate that applies to this invoice.