Record description

Records

H - Header

Field nameField no.FormatTypeDescription
Transaction type1HReqHeader record
Firm number2N(5)ReqThe firm number you receive from PayEx
Firm name3X(40)ReqYour firm name
Created date4N(6)ReqYYMMDD – the same date as in the filename.
Created time5N(4)ReqHHMM – the time of creation.

Example on the records appearance.

H;1234;Firm;180919;1220

M - Metadata record

Field nameFiled no.FormatTypeDescription
Transaction type1MReqMetadata record
Type of billing2N(2)Req0 = ordinary invoicing (default). 1 – n = test invoicing. Support for test invoicing and the different codes to be used are set up in cooperation with PayEx.
Reserved3  Reserved for future use

Example on the records appearance

M;0;

P - Product record

Field nameField no.FormatTypeDescription
Transaction type1P Product record.
Customer number2X(15)ReqCustomer number
Product text3X(73)ReqProduct text, see Definitions and terms
Quantity4N(5)ReqNumber of products
Unit5N(7),N(2-6)ReqPrice for each product, VAT excluded, can have 2 to 6 decimals.
VAT rate6N(7),N(2)ReqVAT rate
Product_group_Id7N(5)ReqAccording to agreement with PayEx.
Identification_No8N(10) Id used to group statistics. Required when service Revenue Accounting is active, maximum value 231
Product_Id9N(10) Id for the product, maximum value 231

Example on the records appearance.

P;12345;Football1;5;23,50;25,00;2;;

P;12345;Football2;5;23,50;25,00;2;1;12365487

K - Customer number Information record

**Is not used without agreement

Field nameField no.FormatTypeDescription
Transaction type1K Product record.
Customer number2X(15)ReqCustomer number
Product text3XReqProduct text, see Definitions and terms
Product_group_Id4N(5)ReqAccording to agreement with PayEx.*
Group_No5N(3) Is empty if nothing else is agreed.

Example on the records appearance:

K;000087;Installation: the Villa;9;

*Product_group_id is set according to agreement for CustnoInformation record.

I - A -number Information record

**Is not used without agreement

Field nameField noFormatTypeDescription
Transaction type1I Product record.
Customer number2X(15)ReqCustomer number
A-number3X(34)ReqA-number
Product text4XReqProduct text, see Definitions and terms
Product_group_Id5N(5)ReqAccording to agreement with PayEx.*
Group_No6N(3) Is left blank if nothing else is agreed.

Example on the records appearance:

I;000087;0702402377;Installation: The house;9;

* Product_group_id is set according to agreement for A -no Information record.

A - A -number product record

Field nameField noFormatTypeDescription
Transaction type1A Product record.
Customer number2X(15)ReqCustomer no.
A-number3X(34)ReqA-Number
Product text4XReqProduct text, see Definitions and terms
Quantity5N(5)ReqNumber of products
Unit6N(7),N(2-6)ReqPrice for each product, VAT excluded, can have 2 to 6 decimals.
VAT rate7N(7),N(2)ReqVAT rate
Product_group_Id8N(5)ReqAccording to agreement with PayEx.
Identification_No9N(10) Id used to group statistics. Required when service Revenue Accounting is active, maximum value 231
Product_Id10N(10) Id for the product, maximum value 231

Example on the records appearance:

A;12345;4788743;Installation fee1;5;150,00;25,00;1;2;

A;12345;4788743;Installation fee3;5;150,00;25,00;1;2;123456

Q - Date product record

**Is not used without agreement

Field nameField noFormatTypeDescription
Transaction type1Q Product record.
Customer number2X(15)ReqCustomer number
Product text3XReqProduct text, see Definitions and terms
Quantity4N(5)ReqNumber of products
Unit5N(7),N(2-6)ReqPrice for each product, VAT excluded, can have 2 to 6 decimals.
VAT rate6N(7),N(2)ReqVAT rate
Product_group_Id7N(5)ReqAccording to agreement with PayEx.
From-date8N(8)ReqYYYYMMDD – Date from when the product is active
To-date9N(8)ReqYYYYMMDD – Date from when the product no longer is active
Identification_No10N(10) Id used to group statistics. Required when service Revenue Accounting is active, maximum value 231
Product_Id11N(10) Id for the product, maximum value 231
Product property 112N(1) Property for product (0-9) ex. for grouping on invoice layout
Product property 213N(1) Property for product (0-9)
Product property 314N(1) Property for product (0-9)

Note! When service Revenue Accounting is active, the dates must be within revenue month. It is only allowed to use from- and to-date within a calendar month. Use of “Product property” field is set up in agreement with PayEx

Example on the records appearance:

Q;12345;Football1;5;23,50;25,00;2;20180101;20181001;1;;;;

Q;12345;Football2;5;23,50;25,00;2;20180101;20181001;1;1234567;1;2;8

B - Date A -number product record

**Is not used without agreement

Field nameField noFormatTypeDescription
Transaction type1B Product record.
Customer number2X(15)ReqCustomer number
A-Number3X(34)ReqA-Number
Product text4XReqProduct text, see Definitions and terms
Quantity5N(5)ReqNumber of products
Unit6N(7),N(2-6)ReqPrice for each product, VAT excluded, can have 2 to 6 decimals.
VAT rate7N(7),N(2)ReqVAT rate
Product_group_Id8N(5)ReqAccording to agreement with PayEx.
From-date9N(8)ReqYYYYMMDD – Date from when the product is active
To-date10N(8)ReqYYYYMMDD – Date from when the product no longer is active
Identification_No11N(10) Id used to group statistics. Required when service Revenue Accounting is active, maximum value 231
Product_Id12N(10) Id for the product, maximum value 231
Product property 113N(1) Property for product (0-9) ex. for grouping on invoice layout
Product property 214N(1) Property for product (0-9)
Product property 315N(1) Property for product (0-9)

Note! When service Revenue Accounting is active, the dates must be within revenue month. It is only allowed to use from- and to-date within a calendar month. Use of “Product property” field is set up in agreement with PayEx

Example on the records appearance:

B;12345;4788743;Installationfee1;5;150,00;25,00;1;20180101;20181001;2;;;;

B;12345;4788743;Installationfee2;5;150,00;25,00;1;20180101;20181001;2;123456;1;2;8

S - Trailer record

Field nameField noFormatTypeDescription
Transaction type1SReqTrailer record.
Number of records.2N(8)ReqNumber of records, main record and end record included.

Example on the records appearance:

S;10

Example on appearance

H;99999;TestFirm;180919;1002

M;0;

P;sp000012;Dressing gown; 3;350,00;25,00;3;;

P;sp000012;Mug; 3;50,00;25,00;3;;134567

P;sp000302;Dressing gown; 1;350,00;25,00;3;214;

I;000087;0702402377;Installation: House;9;

I;000087;0702402377;Calculated year consumption: 24795 kWh;9;

I;000087;0702402377;Calculated meter reading: 000731: 28671;9;

A;000087;0702402377;Electricity june;992;0,129;25,00;6;147;

A;000087;0702402377;Energy tax june;992;0,162;25,00;6;;123456

Q;12345Football;5;23,50;25,00;2;20180101;20181001;1;1;2;8

B;12345;4788743;Installfee;5;150,00;25,00;1;20180101;20181001;212;125478;1;2;8

S;12

Definitions and terms

Header record and Trailer record exists only once. Records of the type P, A, I, Q, K and B can exist a multiply of times for a single customer number. The maximum length of the product text is depending on which type of invoice layout is used, and is therefore agreed with PayEx.

There are also some limitations regarding which characters can be used in the product text. See below “Characters that can not be used in product text field”.

Characters that not can be used in product text field.

CharacterASCIIFunction
 0NUL
 1SOH
 2STX
 3ETX
 4EOT
 5ENQ
 6ACK
 7BEL
 8BS
 9TAB
 10LF
 11VT
 12FF
 13CR
 14SO
 15SI
 16DLE
 17DC1
 18DC2
 19DC3
 20DC4
 21NAK
 22SYN
 23ETB
 24CAN
 25EM
 26SUB
 27ESC
 28FS
 29GS
 30RS
 31US
;59Semicolon
|124Vertical line
~126Tilde
 127DEL
150Simple dash

Characters that not can be used in A-number field.

CharacterASCIIFunction
 0NUL
 1SOH
 2STX
 3ETX
 4EOT
 5ENQ
 6ACK
 7BEL
 8BS
 9TAB
 10LF
 11VT
 12FF
 13CR
 14SO
 15SI
 16DLE
 17DC1
 18DC2
 19DC3
 20DC4
 21NAK
 22SYN
 23ETB
 24CAN
 25EM
 26SUB
 27ESC
 28FS
 29GS
 30RS
 31US
 32Space
$36Dollarsign
*42Asterisk
;59Semicolon
<60Less then
^94Caret
`96Acute accent
|124Vertical line
~126Tilde
 127DEL
150Simple dash
¤164General currency symbol

 

Created by David Persson on 2021/01/29 09:26