Name convention
DP_<CompanyNumber>_<DateTime>_<SEQNO>[<tag>].DAT
Names Component | Description |
---|---|
CompanyNumber | The company number in PayEx ledger system |
DateTime | Date created in format YYMMDDHHMMSS |
SEQNO | Unbroken serial number sequence. |
tag | Which sub group of configuration this DP setup will be used for |
For example:
Without <tag>: DP_9999_210323124421_1.DAT
With <tag>: DP_9999_210323124421_1[10009999].DAT
The <tag> is used to identify which sub group of configuration this DP setup will be used for.
Each sub group has their own sequence number sequence.
Change log
Version | Date | Description | Created by |
---|---|---|---|
1.0 | 2019-09-20 | Created document | Daniel Olsson |
General information and explanation of records
Destination and price list specification for pre -rated CDR:s. No pricelists in this document.
Character encoding
Windows-1252
Format description
Semi colons separate the file.
The format field is written in the way that numerical values are written as N there ”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 “,”. Certain records are not obligatory but if they exist may certain fields in the record be obligatory. Obligatory records are described with the abbreviation ”obl.” in the type column.
Record description
H - Header record
Field name | Field no | Format | Type | Description |
Type of transaction | 1 | H | Obl. | Header record. |
Text | 2 | X(20) | Obl. | Description text. |
Valid from date | 3 | X(10) | Obl. | YYYY-MM-DD, The date from which the file is valid. |
Example on the records appearance:
H;Valid from date;2000-12-15
Column description record
Field name | Field no | Format | Type | Description |
Destination code | 1 | X(15) | Obl. | Headline destination code column. |
Destination plain text | 2 | X(30) | Obl. | Headline plain text column. |
Type of call | 3 | X(15) | Obl. | Headline type of call column. |
Example on the records appearance:
Destcode;Destination plain text;Type of call
Destprice record
Field name | Field no | Format | Type | Description |
Destination code | 1 | X(15) | Obl. | Headline destination code column |
Destination plain text | 2 | X | Obl. | Headline plain text column, see explanation |
Type of call | 3 | N(3) | Obl. | According to the types of calls that you have received from PayEx. |
Example on the records appearance:
08;Stockholm;15
Number of characters in “Destination plain text”
The text describing the destination might be used differently on the invoice. This causes the value of the length to vary. Maximum length can never exceed 30 characters.
The file isn’t accepted if
The numbers of semi colon separated columns aren’t the same for all rows!
Data contains of any of these characters:
Characters | ASCII | Function |
0 | NUL | |
1 | SOH | |
2 | STX | |
3 | ETX | |
4 | EOT | |
5 | ENQ | |
6 | ACK | |
7 | BEL | |
8 | BS | |
9 | TAB | |
10 | LF | |
11 | VT | |
12 | FF | |
13 | CR | |
14 | SO | |
15 | SI | |
16 | DLE | |
17 | DC1 | |
18 | DC2 | |
19 | DC3 | |
20 | DC4 | |
21 | NAK | |
22 | SYN | |
23 | ETB | |
24 | CAN | |
25 | EM | |
26 | SUB | |
27 | ESC | |
28 | FS | |
29 | GS | |
30 | RS | |
31 | US | |
; | 59 | Semi colon |
| | 124 | Vertical line |
~ | 126 | Tilde |
127 | DEL |
Example
Conditions:
Without commission column.
PayEx doesn’t do the rating. DP-file only used as a reference file to connect usage ID with PayEx predefined usage type.
H;Valid from date;2019-01-01
Destcode;Destination;Type of call
0650;Hudiksvall;15
08;Stockholm;15
45;Denmark;5
47;Norway;5
1850;Florida USA;5
3966982;Vatican state;5