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 |
FirmNumber | 2 | N(5) | Req. | Company number |
FirmName | 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