EN 15969-2:2017

2003-01.Slovenski inštitut za standardizacijo. Razmnoževanje celote ali delov tega standarda ni dovoljeno.Tanks für die Beförderung gefährlicher Güter - Digitale Schnittstelle für den Datenaustausch zwischen Tankfahrzeugen und stationären Einrichtungen - Teil 2: Kommerzielle und logistische DatenCiternes destinées au transport de matières dangereuses - Interface numérique pour le transfert de données entre des véhicules-citernes et des installations fixes - Partie 2: Données commerciales et logistiquesTanks for transport of dangerous goods - Digital interface for the data transfer between tank vehicle and with stationary facilities - Part 2: Commercial and logistic data35.240.60Uporabniške rešitve IT v prometuIT applications in transport23.020.20Posode in vsebniki, montirani na vozilaVessels and containers mounted on vehicles13.300Varstvo pred nevarnimi izdelkiProtection against dangerous goodsICS:Ta slovenski standard je istoveten z:EN 15969-2:2017SIST EN 15969-2:2018en,fr,de01-maj-2018SIST EN 15969-2:2018SLOVENSKI
STANDARDSIST EN 15969-2:20111DGRPHãþD

EUROPEAN STANDARD NORME EUROPÉENNE EUROPÄISCHE NORM
EN 15969-2
December
t r s y ICS
u wä t v rä x r Supersedes EN
s w { x {æ tã t r s sEnglish Version
Tanks for transport of dangerous goods æ Digital interface for the data transfer between tank vehicle and with stationary facilities æ Part
tã Commercial and logistic dataCiternes destinées au transport de matières dangereuses æ Interface numérique pour le transfert de données entre des véhiculesæciternes et des installations fixes æ Partie
tã Données commerciales et logistiques
Tanks für die Beförderung gefährlicher Güter æ Digitale Schnittstelle für den Datenaustausch zwischen Tankfahrzeugen und stationären Einrichtungen æ Teil
tã Kommerzielle und logistische Daten This European Standard was approved by CEN on
s w October
t r s yä
egulations 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 concerning such national standards may be obtained on application to the CENæCENELEC Management Centre or to any CEN memberä
translation under the responsibility of a CEN member into its 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á Former Yugoslav Republic of Macedoniaá Franceá Germanyá Greeceá Hungaryá Icelandá Irelandá Italyá Latviaá Lithuaniaá Luxembourgá Maltaá Netherlandsá Norwayá Polandá Portugalá Romaniaá Serbiaá Slovakiaá Sloveniaá Spainá Swedená Switzerlandá Turkey and United Kingdomä
EUROPEAN COMMITTEE FOR STANDARDIZATION COMITÉ EUROPÉEN DE NORMALISATION EUROPÄISCHES KOMITEE FÜR NORMUNG
CEN-CENELEC Management Centre:
Avenue Marnix 17,
B-1000 Brussels
t r s y CEN All rights of exploitation in any form and by any means reserved worldwide for CEN national Membersä Refä Noä EN
s w { x {æ tã t r s y ESIST EN 15969-2:2018

Key \
a may be either two independent units or one single unit which incorporates both functions OBC and TVE Figure 1 — Communication structure SIST EN 15969-2:2018

Key Symbol Meaning PK Primary key FK Foreign key R Reference
One-to-one relationship, 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 4.3 File naming conventions When files are being transferred using FTP connection, the file(s) shall be named RC_CCYYMMDDhhmmss.FTL. CCYYMMDDhhmmss is the timestamp according to EN 15969-1:2017, Table 3. If more than one file is transferred, they shall be processed in ascending order of file names. SIST EN 15969-2:2018

Value Explanation 99.0 Only record no. 99 is printed. 99.2 Record no. 99, 100, 101 are printed. 5.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 value 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
=
y ¹
u r"
v wó E
= 7° 0,750’ E
7. 5125 = 7,512500° E
=
y ¹
u r"
v wó E
« r r yä 512500 = 7,512500° W =
y ¹
u r"
v wò W Examples for latitude GPS:
+07.512500 = 7,512500° N
±
y ¹
u r"
v wó N 5.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:2014. At most, x-times four bytes are required for storage. SIST EN 15969-2:2018

Surcharge =
6.3 Pricing of packed products, container, pieces 6.3.1 Article records Packed goods can also be delivered, packed goods have no a_met_prod, a_met_prod is the reference to the metered product on the truck. 6.3.2 Low volume (surcharge) For this type of product there are also quantity limits available. The conditions are the same as for liquid products. 6.3.3 Price calculation methods — by piece ('a_prc_code' = 0) If a_pck_cnt = 0 the driver inputs the number of pieces, which is stored in p_del_qty. If a_pck_cnt > 0, the driver inputs the number of packings, the quantity is calculated by a multiplication of the number of packings and a_pck_cnt is stored in the data field p_del_qty. The price will be the unit price p_unit_prc. The a_prc_fac shall be taken into consideration. The text for unit of measure is given in a_unit_txt, e.g. can. Price-Formula: price =
— by quantity ('a_prc_code' = 1) If a_case_cnt > 0, a special calculation shall be made to get the delivered quantity 'p_del_qty'. The text for unit of measure is given in 'p_unit_msr'. If a_case_cnt = 0, the driver inputs the quantity directly. Formula: SIST EN 15969-2:2018

® a 4pck 4cnt price =
— by fixed price ('a_prc_code' = 2) A price calculation is not needed because this price is negotiated. No quantity input is necessary, the delivered quantity is the preset quantity, text for unit of measure is given in 'p_unit_msr'. Formula: price = p_unit_prc 6.4 Taxes Taxes are defined in the 'Tax Records' and will be referenced by the ordered products and thereby ordered article (a_tax_id). If tax id is zero, this product is tax free. The tax records contain an expiration date that defines the start of a new tax value that is also defined in this record. Formula: tax =
If expiration date is reached: tax =
7 Description of tour management 7.1 Handling of several tours Any number of orders of record type O, combined in tours of record type H, can be transferred to the truck. Each order record may be followed by 0 to n product records of type P. The operator selects one of the pre-planned tours at the truck. This tour record is duplicated into the return data, filled with the actual data and saved. The internal tour number h_tour_no in the return data starts at 1 and is incremented by 1 at every tour. The internal tour number in the return data are not related with the internal tour number in the planned data. In the office, the correlation of the planned data to the return data are shown in field h_tour_id. If field h_tour_id is empty, it is an unplanned tour. If a planned tour is selected repetitively, field h_tour_id in the return data contains the original information. The field h_tour_id is unique in the planned data, but it may not be unique in the return data. 7.2 Handling of a pseudo-tour with a pool of orders It is also possible to work with only one (pseudo-) tour with a pool of orders. The office deletes executed orders and adds new orders or modifies existing orders of this pool, but always within this tour. This tour is a pseudo-tour and always contains the orders for the next few hours. There is no need to select a tour at the truck. This option is configurable at the truck. Within the return data, the tour data contains the completed orders in chronological sequence, e.g. by day, or by shift, after a driver change. 7.3 Handling of orders Within a tour 0 to n orders exist. The operator chooses one of the given orders at the truck, this order record is duplicated into the return data and will be filled with the actual processed data and saved. The SIST EN 15969-2:2018

for pricing — A05 a_ovr_pck N4 — — Number of items in overpack e.g. 20 cans per box (only for information, not used for any calculation) A06 a_tare_wgh N5.2 — T Empty weight of packing (in kg) — A07 a_unit_txt U6 X T Abbreviation of unit of measure (SI units shall be used when applicable) e.g. 'L', kg', m3', 'pieces' A08 a_unit_msr N1 X T Unit of measure See #L1007 of EN 15969–1:2017 A09 a_pck_txt U30 — T Packing name e.g. “Pieces2”, “Drum”,… A10 a_prc_fac N4 — T Unit price factor This factor will typically be 1, 10, 100 or 1000 A11 a_prc_code N1 — T Price code This code indicates how to handle 'a_unit_prc' within SIST EN 15969-2:2018

X T Metered product code
0 - all unmetered products 1 to 99 — metered products (met_prod) according to EN 14116 A15 a_add_id C16 — T Product code of additive that shall be injected links to #A01. A16 a_add_ppm N5 — T Ratio in ppm Ratio concerning #A14; may be used to set on board injection system A17 a_sup_id C16 — T code of supplementary product that might be added links to #A01. The article referenced may be added when this article is delivered. e.g. deposit, ADR surcharge, see #A18 A18 a_sup_cat B — T Category of supplementary product If an supplementary product is specified in #A17 this field specifies whether it is: 0 – mandatory 1 – optional A19 a_art_cat N1 — T Category of product 0 – available product 1 – common product (frequently used) 2 – fixed charge incurred (common supplementary product) A20 a_fp_cl C2 — T Flashpoint classes A1: flashpoint < 21 °C SIST EN 15969-2:2018

· 21 °C, < 55 °C A3: flashpoint
· 55 °C A21 a_crny_sym C3 — T Currency symbol according to ISO 4217, e.g. EUR, GBP, DKK, SEK, … A22 a_dens_15c N4.1 — HT Density at 15°C kg m3 A23 a_prt_grs B — T Print gross quantity 0 – not print gross quantity, only net quantity 1 - print both, gross and net quantity In accordance with national regulations A24 a_pid_grd N3 X — PID - Grade according to EN 14116, 0 non oil products A25 a_p_compc N5 X — Company code Unique oil company code according to EN 14116 0 not specified > 0 specific company code A26 a_p_prodc N10 X — Product code Company specific unique product code according to EN 14116. 0 not specified > 0 specific product code A27 a_lead_r N3 — T Lead rate mg/l A28 a_sulphur N4 — T Sulphur content Unit PPM A29 a_lubr N4 — T Lubricant agent Unit PPM A30 a_freez N4 — T Anti-freezing agent Unit PPM A31 a_dye_c N1 — T Dye code Dyed product d = 0: unknown – don’t care d = 1: undyed product d = 2: dyed product, red SIST EN 15969-2:2018
...