Project

General

Profile

Invoice Templates » History » Version 13

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