Cargo element

Tag	Description	Remarks	Datatype
Unitamount	Number of units		FLOAT
Unit_id	Unit id	Matchmode =1	VARCHAR(50)
Article_id		Not necessary for normal transport-booking	VARCHAR(20)
Articlenumber		Not necessary for normal transport-booking	VARCHAR(50)
Product_id	Product	Matchmode = 1	VARCHAR(50)
Productdespriction	Free product description		VARCHAR(50)
ADR class	ADR class	Matchmode = 1	INT
Hazardousmaterial_id	Hazardous material, table with UN numbers	Matchmode = 1	VARCHAR(20)
Weight	Weight of the shipment		FLOAT
Loadingmeters	Loadingmeterss of the shipment		FLOAT
Volume	Volume of the shipment		FLOAT
Pallet places	Number of pallet places		FLOAT
Containers	Number of containers ( roco, flower CC)		FLOAT
Shelves	Shelves		SMALLINT
Extensions	Extensions		SMALLINT
Colli	Number of colli on 1 unit		FLOAT
Qty1	User defined field		FLOAT
Qty2	User defined field		FLOAT
Qty3	USer defined field		FLOAT
Qty4	User defined field		FLOAT
Length	Length		FLOAT
Width	Width		FLOAT
Height	Heigth		FLOAT
Min temperature	Minimum transport temprature		FLOAT
Max temperature	Maximum transport tempature		FLOAT
Temperature setpoint	Setpoint temprature onloading		FLOAT
Cargovalue	Value of the cargo		MONEY
Document numbers	Document numbers		VARCHAR(200)
External customer id	Id of the customer in other system		VARCHAR(20)
External shipment	Id of shipment in other system		VARCHAR(20)
Barcode	Barcode		VARCHAR(20)
Cmr number	CMR number/freight letter nr		VARCHAR(50)
Incoterm_id			VARCHAR(50)
Gmpclass_id			VARCHAR(50)

Cargo extra info about ADR goods.

To add simple ADR info, the following elements can be used:Choosing the code (like UN1730 or NA1270), the rest of the fields will be filled in automatically. Because we store that info under the code in our table.

<hazardousmaterial><code/>

<class/>

<packagegroup/>

<symbols/>

<labelcodes/>

<tunnelcode/>

<specialprovisions/>

</hazardousmaterial>