CREATE TABLE `a_awbexport` (
	`ID` INT(11) NOT NULL AUTO_INCREMENT,
	`aUserIns` INT(11) NOT NULL,
	`aDataIns` DATETIME NOT NULL DEFAULT NOW(),
	`aAction` INT(11) NOT NULL,
	`oID` INT(11) NOT NULL,
	`sid` VARCHAR(40) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`AWB` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`Data` DATETIME NULL DEFAULT NULL,
	`Dest` VARCHAR(200) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`vol_flag` INT(11) NOT NULL,
	`ncolli` INT(11) NOT NULL,
	`NrPackages` INT(11) NOT NULL,
	`TotPackages` INT(11) NOT NULL,
	`GrossWeight` DECIMAL(10,2) NULL DEFAULT NULL,
	`GrossWeightUM` VARCHAR(5) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`NetWeight` DECIMAL(10,2) NULL DEFAULT NULL,
	`NetWeightUM` VARCHAR(5) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`WeighingID` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`HPackage` DECIMAL(10,2) NULL DEFAULT NULL,
	`WPackage` DECIMAL(10,2) NULL DEFAULT NULL,
	`LPackage` DECIMAL(10,2) NULL DEFAULT '0.00',
	`Inbound` DECIMAL(10,2) NULL DEFAULT '0.00',
	`RealVolume` DECIMAL(10,2) NULL DEFAULT '0.00',
	`InboundVolumeSurface` DECIMAL(10,2) NULL DEFAULT '0.00',
	`RealVolumeSurface` DECIMAL(10,2) NULL DEFAULT '0.00',
	`Vettore` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`Destinazione` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`Stato` INT(11) NULL DEFAULT NULL,
	`Flags` INT(11) NULL DEFAULT NULL,
	`StandBy` INT(11) NULL DEFAULT NULL,
	`Congruita` INT(11) NULL DEFAULT NULL,
	`UserIns` INT(11) NULL DEFAULT NULL,
	`DataIns` DATETIME NULL DEFAULT NULL,
	`UserMod` INT(11) NULL DEFAULT NULL,
	`DataMod` DATETIME NULL DEFAULT NULL,
	`PalletID` INT(11) NULL DEFAULT NULL,
	`PalletHeight` INT(11) NULL DEFAULT NULL,
	`PalletWeight` INT(11) NULL DEFAULT NULL,
	`PalletDescr` VARCHAR(200) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`PalletCode` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`pallet_op` INT(11) NULL DEFAULT NULL,
	`VolumeFlag` VARCHAR(1) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`MeasureFlag` VARCHAR(1) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`cancellato` INT(11) NULL DEFAULT NULL,
	`ibx1` DOUBLE(22,0) NULL DEFAULT NULL,
	`iby1` DOUBLE(22,0) NULL DEFAULT NULL,
	`ibz1` DOUBLE(22,0) NULL DEFAULT NULL,
	`ibx2` DOUBLE(22,0) NULL DEFAULT NULL,
	`iby2` DOUBLE(22,0) NULL DEFAULT NULL,
	`ibz2` DOUBLE(22,0) NULL DEFAULT NULL,
	`ibx3` DOUBLE(22,0) NULL DEFAULT NULL,
	`iby3` DOUBLE(22,0) NULL DEFAULT NULL,
	`ibz3` DOUBLE(22,0) NULL DEFAULT NULL,
	`ibx4` DOUBLE(22,0) NULL DEFAULT NULL,
	`iby4` DOUBLE(22,0) NULL DEFAULT NULL,
	`ibz4` DOUBLE(22,0) NULL DEFAULT NULL,
	`ibx5` DOUBLE(22,0) NULL DEFAULT NULL,
	`iby5` DOUBLE(22,0) NULL DEFAULT NULL,
	`ibz5` DOUBLE(22,0) NULL DEFAULT NULL,
	`ibx6` DOUBLE(22,0) NULL DEFAULT NULL,
	`iby6` DOUBLE(22,0) NULL DEFAULT NULL,
	`ibz6` DOUBLE(22,0) NULL DEFAULT NULL,
	`ibx7` DOUBLE(22,0) NULL DEFAULT NULL,
	`iby7` DOUBLE(22,0) NULL DEFAULT NULL,
	`ibz7` DOUBLE(22,0) NULL DEFAULT NULL,
	`ibx8` DOUBLE(22,0) NULL DEFAULT NULL,
	`iby8` DOUBLE(22,0) NULL DEFAULT NULL,
	`ibz8` DOUBLE(22,0) NULL DEFAULT NULL,
	`obj_code` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	PRIMARY KEY (`ID`) USING BTREE,
	INDEX `idx_aUserIns` (`aUserIns`) USING BTREE,
	INDEX `idx_aDataIns` (`aDataIns`) USING BTREE,
	INDEX `idx_aAction` (`aAction`) USING BTREE,
	INDEX `idx_oID` (`oID`) USING BTREE,
	INDEX `idx_DataIns` (`DataIns`) USING BTREE,
	INDEX `idx_DataMod` (`DataMod`) USING BTREE,
	INDEX `idx_Data` (`Data`) USING BTREE,
	INDEX `idx_AWB` (`AWB`) USING BTREE,
	INDEX `idx_idxSid` (`sid`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
