1、raising standards worldwideNO COPYING WITHOUT BSI PERMISSION EXCEPT AS PERMITTED BY COPYRIGHT LAWBSI Standards PublicationBS EN 15969-2:2011Tanks for transport ofdangerous goods Digitalinterface for the data transferbetween tank vehicle and withstationary facilitiesPart 2: Commercial and logistic da
2、taBS EN 15969-2:2011 BRITISH STANDARDNational forewordThis British Standard is the UK implementation of EN 15969-2:2011.The UK participation in its preparation was entrusted to TechnicalCommittee AUE/18, Tanks for the transport of dangerous goods.A list of organizations represented on this committee
3、 can beobtained on request to its secretary.This publication does not purport to include all the necessaryprovisions of a contract. Users are responsible for its correctapplication. BSI 2011ISBN 978 0 580 69052 5ICS 13.300; 23.020.10; 35.240.60Compliance with a British Standard cannot confer immunit
4、y fromlegal obligations.This British Standard was published under the authority of theStandards Policy and Strategy Committee on 31 October 2011.Amendments issued since publicationDate Text affectedBS EN 15969-2:2011EUROPEAN STANDARD NORME EUROPENNE EUROPISCHE NORM EN 15969-2 September 2011 ICS 35.2
5、40.60 English Version Tanks for transport of dangerous goods - Digital interface for the data transfer between tank vehicle and with stationary facilities -Part 2: Commercial and logistic data Citernes destines au transport de matires dangereuses -Interface numrique pour le transfert de donnes sur d
6、es vhicules citernes et avec des installations fixes - Partie 2 : Donnes commerciales et logistiques Tanks fr die Befrderung gefhrlicher Gter - Digitale Schnittstelle fr den Datenaustausch zwischen Tankfahrzeugen und stationren Einrichtungen - Teil 2: Kommerzielle und logistische Daten This European
7、 Standard was approved by CEN on 18 June 2011. CEN members are bound to comply with the CEN/CENELEC Internal Regulations which stipulate the conditions for giving this European Standard the status of a national standard without any alteration. Up-to-date lists and bibliographical references concerni
8、ng such national standards may be obtained on application to the CEN-CENELEC Management Centre or to any CEN member. This European Standard exists in three official versions (English, French, German). A version in any other language made by translation under the responsibility of a CEN member into i
9、ts own language and notified to the CEN-CENELEC Management Centre has the same status as the official versions. CEN members are the national standards bodies of Austria, Belgium, Bulgaria, Croatia, Cyprus, Czech Republic, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Iceland, Ireland,
10、 Italy, Latvia, Lithuania, Luxembourg, Malta, Netherlands, Norway, Poland, Portugal, Romania, Slovakia, Slovenia, Spain, Sweden, Switzerland and United Kingdom. EUROPEAN COMMITTEE FOR STANDARDIZATION COMIT EUROPEN DE NORMALISATION EUROPISCHES KOMITEE FR NORMUNG Management Centre: Avenue Marnix 17, B
11、-1000 Brussels 2011 CEN All rights of exploitation in any form and by any means reserved worldwide for CEN national Members. Ref. No. EN 15969-2:2011: EBS EN 15969-2:2011EN 15969-2:2011 (E) 2 Contents Page Foreword 3Introduction .41 Scope 62 Normative references 63 Terms and definitions .64 General
12、75 Files .75.1 Format identifiers.75.2 Relations .85.3 File naming conventions 116 Fields of special types . 116.1 Text module reference . 116.2 Geo-Coordinates . 126.3 UTF-8 strings . 127 Price calculation rules 127.1 General . 127.2 Low volume (surcharge) 127.3 Pricing of packed products, containe
13、r, pieces 137.3.1 Article records . 137.3.2 Low volume (surcharge) 137.3.3 Price calculation methods 137.4 Taxes 148 Description of trip management 148.1 Handling of several trips 148.2 Handling of a pseudo-trip with a pool of orders 148.3 Handling of orders 148.4 Handling of products 159 Fields and
14、 records of RC_File . 1510 Multi-Order Data (Subnode RC_FILE) . 4010.1 General . 4010.2 Node RC_File . 4010.3 Information concerning application 4110.3.1 Simple trip plan, using FTL connection . 4110.3.2 Simple Trip Plan, Using FTP and RC_FILE 4210.3.3 Managing static data, using FTL connection . 44
15、10.3.4 Managing static data under FTP . 44BS EN 15969-2:2011EN 15969-2:2011 (E) 3 Foreword This document (EN 15969-2:2011) has been prepared by Technical Committee CEN/TC 296 “Tanks for transport of dangerous goods”, the secretariat of which is held by AFNOR. This European Standard shall be given th
16、e status of a national standard, either by publication of an identical text or by endorsement, at the latest by March 2012, and conflicting national standards shall be withdrawn at the latest by March 2012. Attention is drawn to the possibility that some of the elements of this document may be the s
17、ubject of patent rights. CEN and/or CENELEC shall not be held responsible for identifying any or all such patent rights. This European Standard EN 15969, Tanks for transport of dangerous goods Digital interface for the data transfer between tank vehicle and with stationary vehicles, is divided into
18、the following parts: Part 1 Protocol Specification Control, measurement and event data Part 2 Commercial and logistic data According to the CEN/CENELEC Internal Regulations, the national standards organizations of the following countries are bound to implement this European Standard: Austria, Belgiu
19、m, Bulgaria, Croatia, Cyprus, Czech Republic, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Iceland, Ireland, Italy, Latvia, Lithuania, Luxembourg, Malta, Netherlands, Norway, Poland, Portugal, Romania, Slovakia, Slovenia, Spain, Sweden, Switzerland and the United Kingdom. BS EN 15969
20、-2:2011EN 15969-2:2011 (E) 4 Introduction FTL is an acronym for Fuel Truck Link, the interface between electronic system(s) on board of a tank truck (Tank-Vehicle-Equipment) and any external computer, Part 2 mainly for a host installed in the office and connected via Internet (TCP/IP); for illustrat
21、ion, see Figure 1. This European Standard specifies data format for all interconnecting communication paths for commercial issues. This European Standard offers the user following features: Multiple orders (batch processing); Pricing; Master data (e.g. products, customers, drivers, taxes); Additiona
22、l texts for the printout; Information for the drivers; Trip management; Data for invoicing with surcharge; Data for delivery packaged goods; Handle planned and unplanned deliveries. BS EN 15969-2:2011EN 15969-2:2011 (E) 5 Key direction of communication (client server) a may be either two independent
23、 units or one single unit which incorporates both functions OBC and TVE Figure 1 Communication structure BS EN 15969-2:2011EN 15969-2:2011 (E) 6 1 Scope This European Standard specifies the data structure needed for tour management, scheduling orders of measured and unmeasured products online to the
24、 truck. Processed orders are transferred back to the host in the office at once or later every time the truck is online. It specifies the transfer of commercial and logistic data between transport vehicle equipment, on board computer of the tank vehicle and stationary facilities for all communicatio
25、n channels between these parties. 2 Normative references The following referenced documents are indispensable for the application of this document. For dated references, only the edition cited applies. For undated references, the latest edition of the referenced document (including any amendments) a
26、pplies. EN 14116, Tanks for transport of dangerous goods Digital interface for the product recognition device EN 15969-1:2011, Tanks for transport of dangerous goods Digital interface for the data transfer between tank vehicle and with stationary facilities Part 1: Protocol specification Control, me
27、asurement and event data EN ISO 3166-1; Codes for the representation of names of countries and their subdivisions Part 1: Country codes (ISO 3166-1:2006) ISO 639-1, Codes for the representation of names of languages Part 1: Alpha-2 code ISO 4217, Codes for the representation of currencies and funds
28、ISO/IEC 10646-1, Information technology Universal Multiple-Octet Coded Character Set (UCS) Part 1: Architecture and Basic Multilingual Plane 3 Terms and definitions For the purposes of this document, the terms and definitions given in EN 15969-1:2011 and the following apply. 3.1 dispatcher person wh
29、o planes tour at the host system 3.2 operator (driver) person who operates the truck and the truck management computer 3.3 tour set of at least one Order Record and related records, which describes a collection of stops at different customers and the ordered products, so that the driver knows where
30、to go and what to deliver 3.4 article goods and/or services provided BS EN 15969-2:2011EN 15969-2:2011 (E) 7 4 General This document shall only be used in conjunction with EN 15969-1 and shall not modify or override any of the requirements of EN 15969-1. 5 Files 5.1 Format identifiers According to E
31、N 15969-1. Table 1 Record identifier and file type Record identifier Short description Description of file contents and possible destinations of the file Primary Key Deletion Identifier A Article List of all goods and/or services provided a_art_id a_deleted C Customer Customer database c_cus_id c_de
32、leted FB FTL batch Record type used to mark batch commands inside RC_file; see Table 11. - - BS EN 15969-2:2011EN 15969-2:2011 (E) 8 Table 1 (continued) Record identifier Short description Description of file contents and possible destinations of the file Primary Key Deletion Identifier H Trip A tri
33、p consists of a list of trip stops, which could be stops at customers (typ. unloading) or depots (typ. loading). h_tour_no h_deleted L Location All locations (depots, customers, etc) l_loc_id l_deleted LR Location restriction Restrictions for a location (time windows, vehicle accessibility, permitte
34、d actions) lr_loc_id lr_deleted N Notes Notes that can be specified for any object. n_ref_obj n_obj_id n_seq_no n_deleted O Order Represents a stop in a trip. This could be both a loadstop and an orderstop. per stop, several actions can be performed. These are specified in the p-records of this o-re
35、cord. If field o_ord_id is 0, the order is unplanned o_tour_no o_ord_no o_deleted OR Order restrictions Order restrictions, used for scheduling and routing. or_ord_id or_deleted P Order lines Specifies the goods and services to be delivered at this stop (o-record). p_tour_no p_ord_no p_pos_no p_dele
36、ted R Driver List of all drivers r_drv_id r_deleted S Text-module reference Static texts for any object. provides text module references, to add a variable number of static texts to an object for printout. s_ref_obj s_obj_id s_seq_no s_deleted T Tax Different applicable VAT rates, used for invoice c
37、alculation. t_tax_id t_deleted X Text modules Texts which are repetitively used, may be stored in this database and referred to by a three-digit numeric code in the S-record. x_blk_id x_lang_id x_deleted Y Annotations Optional annotations to any other type, this annotations are used to add manufactu
38、rer specific fields to any record, which trigger an action on the truck and are not only used for printout. It is not allowed to define fields of type y within this standard. y_ann_obj y_obj_id y_ann_key y_deleted 5.2 Relations Figure 2 shows the relations between the different record types and cont
39、ains only the fields relevant for these relations. BS EN 15969-2:2011EN 15969-2:2011 (E) 9 BS EN 15969-2:2011EN 15969-2:2011 (E) 10 BS EN 15969-2:2011EN 15969-2:2011 (E) 11 Key Symbol Meaning Primary key, shall be unique Foreign key, this attribute is referencing/reference Attribute One-to-one relat
40、ionship, both objects shall exist One-to-one relationship, the object on the right side is optional (zero or one) One-to-many relationship, both objects shall exist One-to-many relationship, the object on the right side is optional (zero, one or many) Figure 2 Work data and master data 5.3 File nami
41、ng conventions When files are being transferred using FTP connection, the file(s) shall be named RC_CCYYMMDDhhmmss.FTL. CCYYMMDDhhmmss is the timestamp according to Table 3 of EN 15969-1:2011. If more than one file is transferred, they shall be processed in ascending order of file names. 6 Fields of
42、 special types 6.1 Text module reference Table 2 Text module reference Type Size Explanation R N4.1 Text module reference Text module fields according to Table 2 have the special functionality described below. The text module selection will be done by a key number. Each record of type X can be used
43、as a single line or as a set of lines. To differentiate between single line and set, the pointer has a special structure. The text module reference s_txt_id is defined as a numeric value with the size: 4.1. The text module reference s_txt_id, is defined as a numeric value with the size: 4.1. The lea
44、ding 4 digit number is the key-field of the record of type X (field x_txt_id). The 1 digit number behind the decimal point counts the number of records following the first record, i.e. this number is used to increment the pointer. BS EN 15969-2:2011EN 15969-2:2011 (E) 12 EXAMPLE Value Explanation99.
45、0 Only record no. 99 is printed. 99.2 Record no. 99, 100, 101 are printed. 6.2 Geo-Coordinates Geo-coordinate fields shall be according to Table 3. Table 3 Geo-coordinate field Type Size Explanation G N4.6 Longitude and latitude values shall be in degrees and decimal fractions of degree: negative va
46、lue of longitude is west of Greenwich; positive value is east of Greenwich; positive value of latitude is north of equator; negative value is south of equator. Examples for longitude GPS: +007.512500 = 7,512500 E = 7 30 45“ E = 7 0,750 E 7. 5125 = 7,512500 E = 7 30 45“ E -007. 512500 = 7,512500 W =
47、7 30 45“ W Examples for latitude GPS: +07.512500 = 7,512500 N = 7 30 45“ N 6.3 UTF-8 strings UTF-8 strings according to Table 4. Table 4 UTF-8 string field Type Explanation Ux Text with maximum length of x printable characters coded in UTF-8 according to ISO/IEC 10646-1. At most, x-times four bytes
48、are required for storage. 7 Price calculation rules 7.1 General All prices shall be net prices. 7.2 Low volume (surcharge) In the event of the actual delivered volume being less than the planned delivered volume, negative price discounts (surcharges) may be applied. BS EN 15969-2:2011EN 15969-2:2011
49、 (E) 13 These fields are used to calculate the applicable surcharges. Two surcharge levels are allowed, depending on the difference between the actual delivered volume and the planned delivered volume. For example, if this difference is between “p_low_vol1“ and “p_low_vol2“ then surcharge “p_sur_vol1“ shall be used, and if between “p_low_vol2“ and “p_low
