Wiki source code of InvoiceJournalBilling

Last modified by Anders Göthberg on 2025/05/14 08:18
Show last authors
1 = =
2
3 (% class="jumbotron" %)
4 (((
5 (% class="container" %)
6 (((
7 After every billrun in PayEx Billing the system create the report InvoiceJournalBilling. The report contains the Invoice numbers created during the billing together with other information regarding the created invoices.
8 )))
9 )))
10
11
12
13 ----
14
15 == InvoiceJournalBilling ==
16
17
18 //Below diagram shows the structure of InvoiceJournalBilling in current version//
19
20 [[image:1747203137127-225.png||height="903" width="532"]]
21
22 (% id="HEncoding" %)
23 == Encoding ==
24
25 (((
26 (((
27 The file must use [[__UTF-8 encoding__>>url:https://en.wikipedia.org/wiki/UTF-8]].
28
29
30 ----
31 )))
32 )))
33
34
35 (% id="HNameconvention" %)
36 == Name convention ==
37
38 InvoiceJournalBilling<CompanyNumber>_<DateTime>_<SeqNr>[BathId].xml
39
40 (% class="table-bordered table-striped" %)
41 |=Names Component|=Description
42 |CompanyNumber|The company number in our ledger system
43 |DateTime|Date created, Should be in the format ISO 8601 format, YYYYMMDDhhmmss
44 |SerialNumber|(((
45 Should follow an uninterupted number series, 00001, and so on.
46 )))
47 |BatchId|(((
48 The identification number from the creation of the InvoiceJournal creation process ID
49
50 If billrun is based on credits made in billing web GUI, the file name for invoice journal will contain “CreateCreditInvoice_<BatchId>” within the brackets
51 )))
52
53 == General information and explanation of records ==
54
55 During every bill run in the PayEx Billing System an Invoice journal will be created. The invoice journal contains all invoice numbers together with information regarding the created invoices. File can be used for import into different accounting systems.
56
57 === CompanyNo ===
58
59 The identity of your accounts receivable at PayEx
60 String value max 6 characters restricted to "[0-9]"
61
62 === CompanyName ===
63
64 Your registered company name at PayEx
65 String value max 40 characters according to "xs:string"
66
67 === Date ===
68
69 The creation date for the InvoiceJournal. This is the date a billrun has been completed in the PayEx Billing System.
70 Date format YYYY-MM-DD
71
72 === CustomerName ===
73
74 The journal presents the customer name for which an invoice has been created..
75 CustomerName comes from the KUB-file, K-record, field 3
76
77 === CustomerNo ===
78
79 The journal presents the customer number for which an invoice has been created.
80 CustomerNo comes from the KUB-file, K-record, field 2
81
82 === RegNo ===
83
84 Social Security Number (SSN) or Corporate Identity Number
85 RegNo comes from the KUB-file, K-record, field 4
86
87 === RegNoCountrycode ===
88
89 Country code according to ISO3166 will be presented here
90 RegNoCountrycode comes from the KUB-file, K-record, field 7
91
92 === CustomerCategory ===
93
94 Customer category for reporting from revenue accounting reports and accounting reports from ledger
95
96 === InvoiceNo ===
97
98 The unique invoice number will be presented here.
99 String value max 15 signs restricted to "[A-Za-z0-9\-]"
100
101 === SubBillId ===
102
103 The internal identification number from the PayEx billing system will be presented here.
104 String value max 25 characters restricted to "[0-9]"
105
106 === Reseller ===
107
108 The reseller will be presented here
109 Reseller comes from the KUB-file, C1-record, field 6
110
111 === InvoiceDate ===
112
113 The invoice date for respective invoice will be presented here.
114 Date format YYYY-MM-DD
115
116 === DueDate ===
117
118 The due date for the mentioned invoice will be presented here.
119 Date format YYYY-MM-DD
120
121 === TotalAmount ===
122
123 Total invoiced amount including VAT
124 Decimal value according to "xs:decimal"
125
126 === Rounding ===
127
128 The amount to make the invoice amount without decimals
129 Decimal value according to "xs:decimal"
130
131 === CurrencyCode ===
132
133 Currency code according to ISO4217 for respective invoice will be presented here.
134
135 === Vatinfo ===
136
137 VAT info for each invoice
138
139
140 ==== //VatRate// ====
141
142 VAT rates for each VAT sum on the invoice will be presented here.
143
144
145 ==== ​//Amount// ====
146
147 Total Amount for each VAT rate on the invoice will be presented here.
148 Decimal value according to "xs:decimal"
149
150 ==== //VatAmount// ====
151
152 VAT amount for each VAT rate on the invoice will be presented here.
153 Decimal value according to "xs:decimal"
154
155 == Download current XML schema file ==
156
157
158 (% border="1" style="width:1023px" %)
159 |=(% style="width: 208px; background-color: rgb(237, 237, 237);" %)Fileversion|=(% style="width: 213px; background-color: rgb(237, 237, 237);" %)Version|=(% style="width: 288px; background-color: rgb(237, 237, 237);" %)Releasedate|=(% style="width: 585px; background-color: rgb(237, 237, 237);" %)Comment
160 |(% style="width:208px" %)[[InvoiceJournalBilling[2.0].xsd>>attach:Main.Invoicing.billing.technical-reference.WebHome@InvoiceJournalBilling[2.0].xsd]]|(% style="width:213px" %)2.0|(% style="width:288px" %)2025-05-27|(% style="width:585px" %)Updated with optional value "CustomerCategory" at customer level
161 |(% style="width:208px" %)[[InvoiceJournalBilling2.0].xsd>>attach:Main.billing.technical-reference.WebHome@InvoiceJournalBilling[2.0].xsd]]|(% style="width:213px" %)2.0|(% style="width:288px" %)2019|(% style="width:585px" %)Initial version
162
163 == Change Log ==
164
165 (% id="HJanuary2C2016" %)
166 ===== May, 2025 =====
167
168 [[InvoiceJournalBilling[2.0].xsd>>attach:Main.Invoicing.billing.technical-reference.WebHome@InvoiceJournalBilling[2.0].xsd]]
169
170 ===== April, 2019 =====
171
172 [[InvoiceJournalBilling[2.0].xsd>>attach:Main.billing.technical-reference.WebHome@InvoiceJournalBilling[2.0].xsd]]
173
174
175 Initial version (latest documented version)