Changes for page Delete Customer (DKUB)

Last modified by Anders Göthberg on 2024/03/14 10:45
From empty
To version 8.1
edited by Anders Göthberg
on 2021/04/21 14:29
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,0 +1,1 @@
1 +Delete Customer (DKUB)
Parent
... ... @@ -1,0 +1,1 @@
1 +Main.Invoicing.billing.technical-reference.Costumer information.WebHome
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.XWikiGuest
1 +xwiki:XWiki.ang
Default language
... ... @@ -1,0 +1,1 @@
1 +en
Tags
... ... @@ -1,0 +1,1 @@
1 +px-custom-page-content
Content
... ... @@ -1,0 +1,100 @@
1 += Name convention =
2 +
3 +DKUB_<CompanyNumber>_<DateTime>_<SEQNO>.DAT
4 +
5 +
6 +(% border="1" %)
7 +|=Names Component|=Description
8 +|CompanyNumber|The company number in PayEx ledger system
9 +|DateTime|Date created in format YYMMDDHHMMSS
10 +|SEQNO|Unbroken serial number sequence.
11 +
12 +**For example: DKUB_1234_20210226124421_1.DAT**
13 +
14 +
15 += Change log =
16 +
17 +(% border="1" %)
18 +|=**Version**|=**Date**|=**Description**|=**Created by**
19 +|1.0|2021-03-05|(((
20 +Created document
21 +)))|Jakob Flodman
22 +
23 +(% id="HGeneralinformationandexplanationofrecords" %)
24 +=
25 +General information and explanation of records =
26 +
27 +The input file (DKUB) specifies which customers should be set to inactive and marked for removal in the billing system (D-record).
28 +
29 +In order to change a customer status to inactive, it is required that there are no unbilled records for usage or non recurring fees for actual customer.
30 +
31 +Recurring fees need to be completed with an end -date before deactivation is done. This applies for all recurring fees except recurring fees that are typed as "invoice fees". These fees are cleared automatically in case of inactivation.
32 +
33 +In case of inactivation and closed fees all customer information will be considered as not existing. After a given number of days, the customer will be removed entirely from the system. The recommended number of days is 40 days**.**
34 +
35 +Within this mentioned number of days the inactivated customer can be activated again. Please note that a cleared invoice fee needs to be added to the customer again.
36 +
37 +== Limitation ==
38 +
39 +Max number of records for DKUB is 100 000 in each DKUB-file
40 +
41 +== Format description ==
42 +
43 +Semicolons separate the file.
44 +
45 +The format field is written in the way that numerical values are written as N where ”n” is the maximum number of characters or in certain cases number of characters that must exist. Alphanumerical characters are written as X. The decimal separator on amounts must be comma ”,”. Some records are not obligatory but if they exist can some fields in the record be obligatory. Mandatory records are described with the abbreviation ”Req.” in the type column.
46 +
47 +== Response files ==
48 +
49 +Examples of an extract from a receipt and a error -file:
50 +
51 +[[Receipt and Error -file example>>doc:.Response-files.WebHome]]
52 +
53 += Record description =
54 +
55 +== H - Header record ==
56 +
57 +(% border="1" %)
58 +|**Field name**|**Field no.**|**Format**|**Type**|**Description**
59 +|Record type|1|H|Req.|Header record
60 +|FirmNumber|2|N(5)|Req.|Company number
61 +|FirmName|3|X(40)|Req.|Company name
62 +|Creationdate|4|N(6)|Req.|YYMMDD – Same date as in filename
63 +|Creationtime|5|N(4)|Req.|HHMM – Time when the file was created
64 +
65 +== D - Delete record -Delete criteria ==
66 +
67 +(% border="1" %)
68 +|**Field name**|**Field no.**|**Format**|**Type**|**Description**
69 +|Record type|1|D|Req.|Delete Criteria record
70 +|CustomerNo|2|X|Req.|Customer Number
71 +
72 +== R - Reactivate record – Reactive criteria ==
73 +
74 +(% border="1" %)
75 +|**Field name**|**Field no.**|**Format**|**Type**|**Description**
76 +|Record type|1|R|Req.|Reactive Criteria record
77 +|CustomerNo|2|X|Req.|Customer NumberS -
78 +
79 +== S - Trailer record ==
80 +
81 +(% border="1" %)
82 +|**Field name**|**Field no.**|**Format**|**Type**|**Description**
83 +|Record type|1|S|Req.|Trailer record
84 +|Number of records|2|N(8)|Req.|Total number of records including header and trailer
85 +|Number of delete (D) records|3|N(8)|Req.|Total number of delete records
86 +|Number of reactivate (R) records|4|N(8)|Req.|Total number of reactivate records
87 +
88 += Example =
89 +
90 +H;1234;TestCompany;180226;1244
91 +
92 +D;123456
93 +
94 +R;586595
95 +
96 +S;4;1;1
97 +
98 +
99 +
100 +
DKUB_CustomerDeleteFile_InformationAndRecordDescription.docx
Author
... ... @@ -1,0 +1,1 @@
1 +xwiki:XWiki.ang
Size
... ... @@ -1,0 +1,1 @@
1 +0 bytes
Content
DKUB_CustomerDeleteFile_InformationAndRecordDescription_html_m334f24f4.png
Author
... ... @@ -1,0 +1,1 @@
1 +xwiki:XWiki.ang
Size
... ... @@ -1,0 +1,1 @@
1 +0 bytes
Content