Wiki source code of DP without pricelists
Last modified by Anders Göthberg on 2024/03/14 15:06
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 | |**Characters**|**ASCII**|**Function** |
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 |