Changes for page DP without pricelists
Last modified by Anders Göthberg on 2024/03/14 15:06
From empty
To version 3.1
edited by Anders Göthberg
on 2021/04/14 13:31
on 2021/04/14 13:31
Change comment: There is no comment for this version
Summary
-
Page properties (6 modified, 0 added, 0 removed)
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.XWikiGuest1 +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 +