Project

General

Profile

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.