Main.Invoicing.billing.technical-reference.Costumer information.Delete-Customer-(DKUB) - Delete Customer (DKUB)

Page of - last modified by ang on 2024/03/14 10:45

Delete Customer (DKUB)

ang

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.

For example: DKUB_1234_20210226124421_1.DAT

Change log

Version	Date	Description	Created by
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

Field name	Field no.	Format	Type	Description
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

Field name	Field no.	Format	Type	Description
Record type	1	D	Req.	Delete Criteria record
CustomerNo	2	X	Req.	Customer Number

R - Reactivate record – Reactive criteria

Field name	Field no.	Format	Type	Description
Record type	1	R	Req.	Reactive Criteria record
CustomerNo	2	X	Req.	Customer NumberS -

S - Trailer record

Field name	Field no.	Format	Type	Description
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