Name convention
RETC01_<CompanyNumber>_<DateTime>_<SEQNO>].DAT
| Name | Description |
| CompanyNumber | The company number in PayEx ledger system |
| DateTime | Date created in format YYYYMMDDHHMMSS |
| SEQNO | Unbroken serial number sequence |
Examples of report file:
RETC01_9999_181216124421_1.DAT
Change log
| Version | Date | Description | Created by |
|---|---|---|---|
| 1.0 | 2018-12-14 | Created document | Tomas Kristoffersson |
General information and explanation of records
The RETC01 file can be used to delete unbilled one time fees (ETC) on customer level or subscription level from the PayEx Billingsystem. It is also possible to remove fees connected to a certain product group for each customer.
Limitation
Max number for delete is 6 million one time fees based on each RETC01-file.
File format
The file is semicolon separated and starts with a header record and ends with a trailer record.
The format field is written so that numerical values are written as N and alphanumerical values are written as X. ”n” represents the maximum number of numbers/characters or in some instances the required number pf numbers/characters. Decimal separator is represented by a dot ”.”. Some of the s are not required, but are they present other field will also be required. Required field as marked with a ”Req.” in the Type column
Header record ”H and Trailer record ”T” must be present in the file.
Record description
H - Header record
| Field name | Field no. | Format | Type | Description |
| Record type | 1 | H | Req. | Header record |
| CompanyNumber | 2 | N(4) | Req. | The company number you receive from PayEx |
| CompanyName | 3 | X(40) | Req. | Your company name |
| Created date | 4 | N(6) | Req. | YYMMDD – Same date as in filename |
| Created time | 5 | N(4) | Req. | HHMM – Time when the file was created |
U - Delete record
| Field name | Field no. | Format | Type | Description |
| Record type | 1 | U | Req. | Delete Criteria record |
| CustomerNo | 2 | X | Req. | Customer Number |
| SubscriberNo | 3 | X | Subscriber Number | |
| ProductGroup | 4 | N | Product group |
T - Trailer record
| Field name | Field no. | Format | Type | Description |
| Record type | 1 | T | Req. | Trailer record |
| Number of records | 2 | N(8) | Req. | Total number of records inclusive header and trailer record. |
Example:
H;9999;TestCompany;181216;1200
U;K10;0498202000;
U;K12;0765432100;3
U;K12;;22
U;K13;;
T;6