Name convention
BERR007_<CompanyNumber>_<DateTime>_<SEQNO>[ErrorlogProductfile_<BatchId>].DAT
For example: BERR007_99999_20220415093539_0[ErrorlogProcuctFile_1234567].DAT The file is semicolon-separated. Change log
|
General information and explanation of records
The non-recurring product file process supports selectable logic errors which will be returned in a response file. These selectable errors need to be set-up in cooperation with PayEx
In case of one or more selectable errors, all products for the entire customer within the same product file will be rejected. All rows which passes validation will be accepted and added to unbilled.
All fields in the mentioned report are separated with semicolons ”;”. Sort order is sequence number. The format field is written in the way that numerical values are written as N and alphanumerical characters are written as X. where ”n” is the maximum number of characters/digits or in certain cases number of characters that must exist.
Dot “.” is decimal separator on fields with amount. Some records are not obligatory but if they exist some fields in the record can be obligatory. Obligatory records are described with the abbreviation ” Req.” in the type column.
File name: BERR007_<firmno>_<datetime>_0[ErrorlogProductfile_<processId>].DAT
where <DateTime> (YYYYMMDDHHMMSS) is the time of creation
Example: BERR007_99999_20220415093539_0[ErrorlogProcuctFile_1234567].DAT
Record description
H - Header record
Required record
| Field name | Field no. | Format | Type | Description |
| Record type | 1 | H | Req. | Record type |
| Firm number | 2 | N(5) | Req. | You receive the firm number from PayEx. |
| Firm name | 3 | X(40) | Req. | Your firm name. |
| Process Id | 4 | N(10) | Req. | Process Id from process |
| Created date | 6 | N(6) | Req. | YYMMDD – Same date as in the file name. |
| Created time | 7 | N(4) | Req. | HHMM – Time when the file was created. |
I - Information record
Optional record
| Field name | Field no. | Format | Type | Description |
| Record type | 1 | I | Req. | Information record type |
| Code | 2 | N(15) | Req. | Information code |
| Type | 3 | X(50) | Req. | Category type |
| Description | 4 | X(1000) | Req. | Description of information code |
| Value | 5 | X(300) | Req. | Value |
W - Warning record
Optional record
| Field name | Field no. | Format | Type | Description |
| Record type | 1 | W | Req. | Warning record type |
| Code | 2 | N(15) | Req. | Warning code |
| Line | 3 | N(15) | Corresponding line number in file | |
| Type | 5 | X(50) | Req. | Category type |
| Headline | 5 | X(100) | Req. | Warning headline |
| Description | 6 | X(1000) | Req. | Warning description |
E - Error record
Optional record
| Field name | Field no. | Format | Type | Description |
| Record type | 1 | E | Req. | Error record type |
| Code | 2 | N(15) | Req. | Error code |
| Line | 3 | N(15) | Corresponding line number in file | |
| Type | 5 | X(50) | Req. | Category type |
| Headline | 5 | X(100) | Req. | Error headline |
| Description | 6 | X(1000) | Req. | Error description |
S - Trailer record
Required record
| Field name | Field no | Format | Type | Description |
| Record type | 1 | S | Req. | Record type |
| Total number of records | 2 | N(8) | Req. | Number of records, header record, description record and trailer record included. |
Example
H;99999;Company name;2808359;230502;1358
I;15317;Parameters;Name of processed file;PR01_12345_230109154010_0.DAT
W;190;3;Record;Error: missing customer;Customer [ABC123] not registred in database
W;190;4;Record;Error: missing customer;Customer [ABC123] not registred in database
W;190;5;Record;Error: missing customer;Customer [ABC123] not registred in database
W;190;6;Record;Error: missing customer;Customer [ABC123] not registred in database
W;190;7;Record;Error: missing customer;Customer [ABC123] not registred in database
E;520;;Logic;Error limit exceeded;Logic validation file percent limit 50% is exceeded. Actual [55%].S;9
Result codes
Information codes
| Code | Category type | Description |
| 15317 | Parameters | Name of processed file |
Warning codes
Codes which can be used in the response file as warnings instead of errors
| Code | Category type | Description |
| 190 | Record | Missing customer |
| 460 | Record | Incorrect value on IdNo |
| 480 | Record | Incorrect value on product group |
| 501 | Record | Missing product property in company config |
Error codes
| Code | Category | Description |
| 1001 | Error: Fileformat | Validation error |
| 270 | Error: Fileformat | Invalid date |
| 1240 | Error: Fileformat | Invalid record sequence |
| 1241 | Error: Fileformat | Invalid field sequence |
| 1243 | Error: Fileformat | Error in filename or sequence |
| 100 | Error: Fileformat | Error: invalid fileformat |
| 110 | Error: Fileformat | Error: unknown transactiontype |
| 140 | Error: Fileformat | Error: incorrect length on value |
| 1238 | Error: Fileformat | Duplicate record |
| 1013 | Error: Fileformat | Invalid time |
| 120 | Error: Header | Error: incorrect companynumber |
| 130 | Error: Header | Error: missing value |
| 150 | Error: Header | Error: not numeric value |
| 160 | Error: Header | Error: incorrect number of fields |
| 170 | Error: Header | Error: header missing |
| 300 | Error: Trailer | Error: not numeric value |
| 310 | Error: Trailer | Error: missing value |
| 320 | Error: Trailer | Error: incorrect number of fields |
| 330 | Error: Trailer | Error: trailer missing |
| 340 | Error: Trailer | Error: incorrect no. of entries |
| 370 | Error: Trailer | Error: incorrect no. of Product entries |
| 380 | Error: Trailer | Error: incorrect no. of Customerno.Info entries |
| 390 | Error: Trailer | Error: incorrect no. of SubscriberInfo entries |
| 400 | Error: Trailer | Error: incorrect no. of SubscriberProduct entries |
| 410 | Error: Trailer | Error: incorrect no. of DateProduct entries |
| 420 | Error: Trailer | Error: incorrect no. of DateSubscriberProduct entries |
| 350 | Error: Filename does not comply to standard | Error: missing file |
| 360 | Error: Filename does not comply to standard | Error: filename format |
| 1013 | Error: Logic | CompanyNo Mismatch |
| 520 | Error: Logic | Error limit exceeded: |
| 180 | Error: Record | Error: incorrect length on value |
| 190 | Error: Record | Error: missing customer |
| 200 | Error: Record | Error: missing value |
| 210 | Error: Record | Error: invalid productcode |
| 220 | Error: Record | Error: not numeric value |
| 230 | Error: Record | Error: negative value |
| 240 | Error: Record | Error: not comma separated value |
| 250 | Error: Record | Error: incorrect no. of decimals |
| 260 | Error: Record | Error: wrong no. of characters in value |
| 270 | Error: Record | Error: invalid date |
| 280 | Error: Record | Error: value larger than previous field |
| 290 | Error: Record | Error: incorrect no. of fields |
| 430 | Error: Record | Error: value is zero |
| 440 | Error: Record | Error: value is not integer |
| 450 | Error: Record | Error: Incorrect character |
| 460 | Error: Record | Error: Incorrect value on IdNo. |
| 470 | Error: Record | Error: value is larger than 60k |
| 480 | Error: Record | Error: incorrect value on productId |
| 500 | Error: Record | Error: duplicate of product property |
| 510 | Error: Record | Error: invalid value in product property |
| 501 | Error: Record | Error: missing product property in company config |