Main.Invoicing.billing.technical-reference.Costumer information.Delete-Customer-(DKUB) - Delete Customer (DKUB) 
Page of - last modified by Anders Göthberg on 2024/03/14 10:45 
Delete Customer (DKUB) 

Anders Göthberg

2024/03/14 10:45
Table of Contents
Name convention
Change log
General information and explanation of records
Limitation
Format description
Response files
Record description
H - Header record
D - Delete record -Delete criteria
R - Reactivate record – Reactive criteria
S - Trailer record
Example

Name convention
DKUB_<CompanyNumber>_<DateTime>_<SEQNO>.DAT
Names Component | Description
CompanyNumber | The company number in PayEx ledger system
DateTime | Date created in format YYMMDDHHMMSS
SEQNO | Unbroken serial number sequence.

Change log
1.0 | 2021-03-05 | Created document | Jakob Flodman

General information and explanation of records
The input file (DKUB) specifies which customers should be set to inactive and marked for removal in the billing system (D-record).
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.
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.
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
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.
Limitation
Max number of records for DKUB is 100 000 in each DKUB-file
Format description
Semicolons separate the file.
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.
Response files
Examples of an extract from a receipt and a error -file:
Receipt and Error -file example
Record description
H - Header record
Record type | 1 | H | Req. | Header record
CompanyNumber | 2 | N(5) | Req. | Company number
CompanyName | 3 | X(40) | Req. | Company name
Creationdate | 4 | N(6) | Req. | YYMMDD – Same date as in filename
Creationtime | 5 | N(4) | Req. | HHMM – Time when the file was created
D - Delete record -Delete criteria
Record type | 1 | D | Req. | Delete Criteria record
CustomerNo | 2 | X | Req. | Customer Number
R - Reactivate record – Reactive criteria
Record type | 1 | R | Req. | Reactive Criteria record
CustomerNo | 2 | X | Req. | Customer NumberS -
S - Trailer record
Record type | 1 | S | Req. | Trailer record
Number of records | 2 | N(8) | Req. | Total number of records including header and trailer
Number of delete (D) records | 3 | N(8) | Req. | Total number of delete records
Number of reactivate (R) records | 4 | N(8) | Req. | Total number of reactivate records
Example
H;1234;TestCompany;180226;1244
D;123456
R;586595
S;4;1;1