To honor the request to register emission data related to the carriers, I added some fields to tcmcs080, being:
Table : tcmcs080 Carriers/LSP
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Field Multi I.Hidden I.Hidden I.Hidden Data Type Domain List Initial value (name) Calc Acti Avai Origin
Lang Overview Details MMT
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+
cned [1] CO2 NEDC in grams Combi No No No Yes Numeric tcmcs.dble No Yes Yes Manual
cwlt [1] CO2 WLTP in grams Combi No No No No Numeric tcmcs.dble No Yes Yes Manual
eurn [1] European emission standard No No No No String tcmcs.str10 No Yes Yes Manual
fins [1] Financial Status No No No No List tccdf_lstfis fis Financial Status To Be Defined No Yes Yes Manual
+List constants +
|leasing 3 Leasing |
|owner 1 Owner |
|renting 2 Renting |
|sold 10 Sold |
|tbd 99 To Be Defined |
+---------------------------------------------+
fuel [1] Fuel No No No No List tccdf_lstfut fut Fuel (Power Source) yet unknown/undefined No Yes Yes Manual
+List constants +
|b 8 Biofuel |
|c 9 CNG (Compressed Natural Gas) |
|d 1 Diesel |
|e 4 Electrical |
|g 6 Gas |
|h 3 Hybrid |
|l 7 LPG (Liquefied Petroleum Gas) |
|p 2 Petrol (Gasoline) |
|s 5 Synthetic Fuel |
|y 99 yet unknown/undefined |
+---------------------------------------------+
nedc [1] CO2 NEDC in grams No No No No Numeric tcmcs.dble No Yes Yes Manual
tcex [1] Expiry Date TC No No No No Date tcdate No Yes Yes Manual
vety [1] Vehicle Type No No No No List tccdf_lstvty vty Vehicle Type To Be Defined No Yes Yes Manual
+List constants +
|m1 1 M1: Car, Minibus, Camper |
|m2 2 M2: Touringcar |
|m3 3 M3: Trolleybus |
|n1 4 N1: Delivery Van (<3500 kg) |
|n2 5 N2: Truck (>3500 kg, <12000 kg|
|n3 6 N3: Truck (>12000 kg, <16000 k|
|tbd 99 To Be Defined |
+---------------------------------------------+
vinr [1] Vehicle Information Number No No No No String tcmcs.str25 No Yes Yes Manual
wltp [1] CO2 WLTP in grams No No No No Numeric tcmcs.dble No Yes Yes ManualAnd these fields are added to the RDD:F
:NAME:tcmcs080.cdf_cned
:DOMA:tcmcs.dble
:CDF:1
F
:NAME:tcmcs080.cdf_cwlt
:DOMA:tcmcs.dble
:CDF:1
F
:NAME:tcmcs080.cdf_eurn
:DOMA:tcmcs.str10
:CDF:1
F
:NAME:tcmcs080.cdf_fins
:DEFA:099
:FILL:1
:DOMA:tccdf_lstfis
:CDF:1
F
:NAME:tcmcs080.cdf_fuel
:DEFA:099
:FILL:1
:DOMA:tccdf_lstfut
:CDF:1
F
:NAME:tcmcs080.cdf_nedc
:DOMA:tcmcs.dble
:CDF:1
F
:NAME:tcmcs080.cdf_tcex
:DOMA:tcdate
:CDF:1
F
:NAME:tcmcs080.cdf_vety
:DEFA:099
:FILL:1
:DOMA:tccdf_lstvty
:CDF:1
F
:NAME:tcmcs080.cdf_vinr
:DOMA:tcmcs.str25
:CDF:1
F
:NAME:tcmcs080.cdf_wltp
:DOMA:tcmcs.dble
:CDF:1
In the session however, the field sequence does not make sense: the fields keep appearing in this (alphabetical) order, personalisations are not stored.
Is renaming the fields like so the only way to force them in the right order?avin Vehicle Information Number
bvty Vehicle Type
cfue Fuel
deur European emission standard
ened CO2 NEDC in grams
fned CO2 NEDC in grams Combi
gwlt CO2 WLTP in grams
hwlt CO2 WLTP in grams Combi
ifin Financial Status
jtcx Expiry Date TC