From empty
To version 3.1
edited by Anders Göthberg
on 2021/04/14 13:31
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,0 +1,1 @@
1 +DP without pricelists
Parent
... ... @@ -1,0 +1,1 @@
1 +Main.Invoicing.billing.technical-reference.Usage.DP file.WebHome
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.XWikiGuest
1 +xwiki:XWiki.ang
Default language
... ... @@ -1,0 +1,1 @@
1 +en
Tags
... ... @@ -1,0 +1,1 @@
1 +px-custom-page-content
Content
... ... @@ -1,0 +1,152 @@
1 += Name convention =
2 +
3 +DP_<CompanyNumber>_<DateTime>_<SEQNO>[<tag>].DAT
4 +
5 +
6 +(% border="1" %)
7 +|=Names Component|=Description
8 +|CompanyNumber|The company number in PayEx ledger system
9 +|DateTime|Date created in format YYMMDDHHMMSS
10 +|SEQNO|Unbroken serial number sequence.
11 +|tag|Which sub group of configuration this DP setup will be used for
12 +
13 +**For example:**
14 +**Without <tag>: DP_9999_210323124421_1.DAT**
15 +**With <tag>: DP_9999_210323124421_1[10009999].DAT**
16 +
17 +The <tag> is used to identify which sub group of configuration this DP setup will be used for.
18 +Each sub group has their own sequence number sequence.
19 +
20 +(% id="HChangelog" %)
21 += Change log =
22 +
23 +(% border="1" %)
24 +|=**Version**|=**Date**|=**Description**|=**Created by**
25 +|1.0|2019-09-20|(((
26 +Created document
27 +)))|Daniel Olsson
28 +
29 +(% id="HGeneralinformationandexplanationofrecords" %)
30 +=
31 +General information and explanation of records =
32 +
33 +Destination and price list specification for pre -rated CDR:s. No pricelists in this document.
34 +
35 +== (% style="color:inherit; font-family:inherit" %)Character encoding(%%) ==
36 +
37 +Windows-1252
38 +
39 +== Format description ==
40 +
41 +Semi colons separate the file.
42 +
43 +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.
44 +
45 += Record description =
46 +
47 +== H - Header record ==
48 +
49 +(% border="1" %)
50 +|**Field name**|**Field no**|**Format**|**Type**|**Description**
51 +|Type of transaction|1|H|Obl.|Header record.
52 +|Text|2|X(20)|Obl.|Description text.
53 +|Valid from date|3|X(10)|Obl.|YYYY-MM-DD, The date from which the file is valid.
54 +
55 +Example on the records appearance:
56 +
57 +H;Valid from date;2000-12-15
58 +
59 +== Column description record ==
60 +
61 +(% border="1" %)
62 +|**Field name**|**Field no**|**Format**|**Type**|**Description**
63 +|Destination code|1|X(15)|Obl.|Headline destination code column.
64 +|Destination plain text|2|X(30)|Obl.|Headline plain text column.
65 +|Type of call|3|X(15)|Obl.|Headline type of call column.
66 +
67 +Example on the records appearance:
68 +
69 +Destcode;Destination plain text;Type of call
70 +
71 +== Destprice record ==
72 +
73 +(% border="1" %)
74 +|**Field name**|**Field no**|**Format**|**Type**|**Description**
75 +|Destination code|1|X(15)|Obl.|Headline destination code column
76 +|Destination plain text|2|X|Obl.|Headline plain text column, see explanation
77 +|Type of call|3|N(3)|Obl.|According to the types of calls that you have received from PayEx.
78 +
79 +Example on the records appearance:
80 +
81 +08;Stockholm;15
82 +
83 +== Number of characters in “Destination plain text” ==
84 +
85 +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.
86 +
87 +== The file isn’t accepted if ==
88 +
89 +The numbers of semi colon separated columns aren’t the same for all rows!
90 +
91 +Data contains of any of these characters:
92 +
93 +(% border="1" %)
94 +|**Tecken**|**ASCII**|**Funktion**
95 +| |0|NUL
96 +| |1|SOH
97 +| |2|STX
98 +| |3|ETX
99 +| |4|EOT
100 +| |5|ENQ
101 +| |6|ACK
102 +| |7|BEL
103 +| |8|BS
104 +| |9|TAB
105 +| |10|LF
106 +| |11|VT
107 +| |12|FF
108 +| |13|CR
109 +| |14|SO
110 +| |15|SI
111 +| |16|DLE
112 +| |17|DC1
113 +| |18|DC2
114 +| |19|DC3
115 +| |20|DC4
116 +| |21|NAK
117 +| |22|SYN
118 +| |23|ETB
119 +| |24|CAN
120 +| |25|EM
121 +| |26|SUB
122 +| |27|ESC
123 +| |28|FS
124 +| |29|GS
125 +| |30|RS
126 +| |31|US
127 +|;|59|Semi colon
128 +|~||124|Vertical line
129 +|~~|126|Tilde
130 +| |127|(((
131 +DEL
132 +)))
133 +
134 +== ==
135 +
136 +== Example ==
137 +
138 +//Conditions~://
139 +//Without commission column.//
140 +//PayEx doesn’t do the rating. DP-file only used as a reference file to connect usage ID with PayEx predefined usage type.//
141 +
142 +H;Valid from date;2019-01-01
143 +Destcode;Destination;Type of call
144 +0650;Hudiksvall;15
145 +08;Stockholm;15
146 +45;Denmark;5
147 +47;Norway;5
148 +1850;Florida USA;5
149 +3966982;Vatican state;5
150 +
151 +
152 +