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
on 2021/04/21 14:29
Change comment: There is no comment for this version
Summary
-
Page properties (6 modified, 0 added, 0 removed)
-
Attachments (0 modified, 2 added, 0 removed)
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.XWikiGuest1 +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