Name convention
BERR030_<CompanyNumber>_<DateTime>_<SEQNO>[ErrorlogInvoiceOrdering_<BatchId>].DAT
For example: BERR030_99999_20221128093539_0[ErrorlogInvoiceOrdering_1234567].DAT The file is semicolon-separated. Change log
|
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 | 5 | N(6) | Req. | YYMMDD – Same date as in the file name. |
| Created time | 6 | 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 |
| Description | 3 | X(1000) | Req. | Description of information code |
| Value | 4 | X(300) | Req. | Value |
E - Error record
Optional record
| Field name | Field no. | Format | Type | Description |
| Record type | 1 | E | Error record type | |
| Code | 2 | N(15) | Req. | Error code |
| Line | 3 | N(15) | Corresponding line number in file | |
| Customer number | 4 | X(15) | Customer number | |
| Type | 5 | X(50) | Req. | Error type (format/logic) |
| Description | 6 | X(1000) | Req. | Error description |
W - Warning record
Optional record
| Field name | Field no. | Format | Type | Description |
| Record type | 1 | W | Warning record type | |
| Code | 2 | N(15) | Req. | Warning code |
| Line | 3 | N(15) | Corresponding line number in file | |
| Customer number | 4 | X(15) | Customer number | |
| Type | 5 | X(50) | Req. | Warning type (format/logic) |
| Description | 6 | X(1000) | Req. | Warning 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;12345;Company AB;234567;221101;0958
I;15313;Parameters;Name of processed file: FB01_12345_221101095800_444.DAT
E;1241;3;Fileformat;Invalid field sequence;Incorrect number of fields in B-record: Expected maximum [5], supplied [12]
W;15232;4;cust001;Missing customer;Q-Error: missing customer [Customerumber] not registred in database
W;15314;7;cust003;Logic;Missing configuration , recurring product cannot be used for actuall document code [DS_IS_STD] on customer [cust003], product code [123]
W;15314;8;cust004;Logic;Missing configuration , productgroup [150] cannot be used for actuall document code [DS_IS_STD] on customer [cust004], subscriber [12346], product code [FP3]
S;7
Logic
This error report is based on errors detected in PayEx billing system Invoice order file process.
Result codes
Information codes
| Code | Category | Description |
| 15317 | Parameters | File name |
Error/Warning codes( depends on company rules )
| Code | Category | Description |
| 561 | Parameters | Ignore Q-errors? |
| 1001 | Fileformat | Incorrect format |
| 1238 | Fileformat | Duplicate records |
| 1240 | Fileformat | Incorrect record order |
| 1241 | Fileformat | Mandatory filed is missing |
| 1243 | Fileformat | Incorrect filname or sequence number |
| 14611 | Fileformat | Invalid date |
| 14613 | Fileformat | Incorrect testinvoice |
| 14614 | Fileformat | Incorrect market textcode |
| 14615 | Fileformat | Incorrect layout |
| 14619 | Fileformat | Incorrect enclosure |
| 14620 | Fileformat | Max no. of enclosures exceeded |
| 14621 | Fileformat | Duplicate enclosure |
| 14622 | Fileformat | Incorrect metadata selection |
| 15000 | Fileformat | Incorrect number of fields in row |
| 15001 | Fileformat | Unknown transactiontype |
| 15002 | Header | Incorrect companynumber |
| 15003 | Header | Max nr of characters in companyname exceeded |
| 15004 | Fileformat | Incorrect filename format |
| 15006 | Logic | Duplicate customer |
| 15007 | Header | Duplicate headers |
| 15008 | Trailer | Duplicate trailers |
| 15009 | Logic | Unknown ordertype |
| 15010 | Header | Missing date |
| 15011 | Header | Invalid date |
| 15012 | Header | Incorrect number of digits in timefield |
| 15013 | Trailer | Calculation missmatch |
| 15014 | Fileformat | Transactiontype missing |
| 15015 | Fileformat | No header preceding datatransaction(s) |
| 15016 | Fileformat | Trailer preceding datatransaction(s) |
| 15017 | Fileformat | Missing date |
| 15018 | Fileformat | Invalid date |
| 15020 | Fileformat | Nr of characters in field exceeds max allowed |
| 15232 | Logic | Missing customer |
| 15233 | Logic | Not exported |
| 15314 | Logic | Missing configuration |
| 15315 | Logic | Max errors allowed reached |
| 15316 | Logic | Invalid property |