Main.Invoicing.billing.technical-reference.Usage.DP file.DP pre-rated - DP without pricelists

Page of - last modified by Anders Göthberg on 2024/03/14 15:06

DP without pricelists

Anders Göthberg

2024/03/14 15:06

Table of Contents

Name convention

Change log

General information and explanation of records

Character encoding

Format description

Record description

H - Header record

Column description record

Destprice record

Number of characters in “Destination plain text”

The file isn’t accepted if

Example

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