Wiki source code of InvoiceJournalBilling

Last modified by Anders Göthberg on 2024/03/28 09:42
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:1608104825892-843.png||height="789" width="471"]]
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 === InvoiceNo ===
93
94 The unique invoice number will be presented here.
95 String value max 15 signs restricted to "[A-Za-z0-9\-]"
96
97 === SubBillId ===
98
99 The internal identification number from the PayEx billing system will be presented here.
100 String value max 25 characters restricted to "[0-9]"
101
102 === Reseller ===
103
104 The reseller will be presented here
105 Reseller comes from the KUB-file, C1-record, field 6
106
107 === InvoiceDate ===
108
109 The invoice date for respective invoice will be presented here.
110 Date format YYYY-MM-DD
111
112 === DueDate ===
113
114 The due date for the mentioned invoice will be presented here.
115 Date format YYYY-MM-DD
116
117 === TotalAmount ===
118
119 Total invoiced amount including VAT
120 Decimal value according to "xs:decimal"
121
122 === Rounding ===
123
124 The amount to make the invoice amount without decimals
125 Decimal value according to "xs:decimal"
126
127 === CurrencyCode ===
128
129 Currency code according to ISO4217 for respective invoice will be presented here.
130
131 === Vatinfo ===
132
133 VAT info for each invoice
134
135
136 ==== //VatRate// ====
137
138 VAT rates for each VAT sum on the invoice will be presented here.
139
140
141 ==== ​//Amount// ====
142
143 Total Amount for each VAT rate on the invoice will be presented here.
144 Decimal value according to "xs:decimal"
145
146 ==== //VatAmount// ====
147
148 VAT amount for each VAT rate on the invoice will be presented here.
149 ​​​​​​​Decimal value according to "xs:decimal"
150
151 == Download current XML schema file ==
152
153
154 (% border="0" style="width:1023px" %)
155 |=(% 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
156 |(% 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" %)
157
158 == Change Log ==
159
160 (% id="HJanuary2C2016" %)
161 ===== April, 2019 =====
162
163 [[InvoiceJournalBilling[2.0].xsd>>attach:Main.billing.technical-reference.WebHome@InvoiceJournalBilling[2.0].xsd]]
164
165
166 Initial version (latest documented version)