-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Dec 04, 2021 at 11:33 AM
-- Server version: 10.3.32-MariaDB
-- PHP Version: 7.3.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `portalbd_asycuda`
--

-- --------------------------------------------------------

--
-- Table structure for table `package_code`
--

CREATE TABLE `package_code` (
  `code` varchar(3) DEFAULT NULL,
  `description` varchar(58) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `package_code`
--

INSERT INTO `package_code` (`code`, `description`) VALUES
('1A', 'Drum, steel '),
('1B', 'Drum, aluminium '),
('1D', 'Drum, plywood '),
('1G', 'Drum, fibre '),
('1W', 'Drum, wooden '),
('2C', 'Barrel, wooden '),
('3A', 'Jerrican, steel '),
('3H', 'Jerrican, plastic '),
('4A', 'Box, steel '),
('4B', 'Box, aluminium '),
('4C', 'Box, natural wood '),
('4D', 'Box, plywood '),
('4F', 'Box, reconstituted wood '),
('4G', 'Box, fibreboard '),
('4H', 'Box, plastic '),
('5H', 'Bag, woven plastic '),
('5L', 'Bag, textile'),
('5M', 'Bag, paper'),
('6H', 'Comp. pkg, plastic recept. '),
('6P', 'Comp. pkg, glass recept. '),
('AA', 'Int. bulk cont., rigid plastic '),
('AB', 'recept., fibre '),
('AC', 'recept., paper '),
('AD', 'recept., wooden '),
('AE', 'Aerosol'),
('AF', 'Pallet, modular, collars 80cms * 60cms '),
('AG', 'Pallet, shrinkwrapped'),
('AH', 'Pallet, 100cms * 110cms '),
('AI', 'Clamshell '),
('AJ', 'Cone'),
('AM', 'Ampoule, non-protected '),
('AP', 'Ampoule, protected '),
('AT', 'Atomizer'),
('AV', 'Capsule '),
('BA', 'Barrel '),
('BB', 'Bobbin '),
('BC', 'Bottlecrate / bottlerack '),
('BD', 'Board '),
('BE', 'Bundle '),
('BF', 'Balloon, non-protected '),
('BG', 'Bag '),
('BH', 'Bunch '),
('BI', 'Bin '),
('BJ', 'Bucket '),
('BK', 'Basket '),
('BL', 'Bale, compressed '),
('BM', 'Basin '),
('BN', 'Bale, non-compressed '),
('BO', 'Bottle, non-protected, cylindrical '),
('BP', 'Balloon, protected '),
('BQ', 'Bottle, protected cylindrical '),
('BR', 'Bar '),
('BS', 'Bottle, non-protected, bulbous '),
('BT', 'Bolt '),
('BU', 'Butt '),
('BV', 'Bottle, protected bulbous '),
('BW', 'Box, for liquids'),
('BX', 'Box '),
('BY', 'Board, in bundle/bunch/truss '),
('BZ', 'Bars, in bundle/bunch/truss '),
('CA', 'Can, rectangular '),
('CB', 'Crate, beer '),
('CC', 'Churn '),
('CD', 'Can, with handle and spout '),
('CE', 'Creel '),
('CF', 'Coffer '),
('CG', 'Cage '),
('CH', 'Chest '),
('CI', 'Canister '),
('CJ', 'Coffin'),
('CK', 'Cask '),
('CL', 'Coil '),
('CM', 'Card '),
('CN', 'cont., not otherwise specified '),
('CO', 'Carboy, non-protected '),
('CP', 'Carboy, protected '),
('CQ', 'Cartridge'),
('CR', 'Crate'),
('CS', 'Case'),
('CT', 'Carton '),
('CU', 'Cup '),
('CV', 'Cover'),
('CW', 'Cage, roll'),
('CX', 'Can, cylindrical '),
('CY', 'Cylinder '),
('CZ', 'Canvas '),
('DA', 'Crate, multiple layer, plastic '),
('DB', 'Crate, multiple layer, wooden '),
('DC', 'Crate, multiple layer, cardboard '),
('DG', 'Cage, Commonwealth Handling Equipment Pool (CHEP) '),
('DI', 'Drum, iron '),
('DJ', 'Demijohn, non-protected '),
('DK', 'Crate, bulk, cardboard '),
('DL', 'Crate, bulk, plastic '),
('DM', 'Crate, bulk, wooden '),
('DN', 'Dispenser'),
('DP', 'Demijohn, protected '),
('DR', 'Drum '),
('DS', 'Tray, one layer no cover, plastic '),
('DT', 'Tray, one layer no cover, wooden '),
('DU', 'Tray, one layer no cover, polystyrene'),
('DV', 'Tray, one layer no cover, cardboard '),
('DW', 'Tray, two layers no cover, plastic tray '),
('DX', 'Tray, two layers no cover, wooden '),
('DY', 'Tray, two layers no cover, cardboard '),
('EC', 'Bag, plastic'),
('ED', 'Case, with pallet base '),
('EE', 'Case, with pallet base, wooden '),
('EF', 'Case, with pallet base, cardboard '),
('EG', 'Case, with pallet base, plastic '),
('EH', 'Case, with pallet base, metal '),
('EI', 'Case, isothermic '),
('EN', 'Envelope '),
('FC', 'Crate, fruit '),
('FD', 'Crate, framed '),
('FI', 'Firkin '),
('FL', 'Flask '),
('FO', 'Footlocker '),
('FP', 'Filmpack '),
('FR', 'Frame '),
('FT', 'Foodtainer '),
('FX', 'Bag, flexible cont.'),
('GB', 'Bottle, gas '),
('GI', 'Girder '),
('GR', 'recept., glass '),
('GZ', 'Girders, in bundle/bunch/truss '),
('HA ', 'Basket, with handle, plastic '),
('HB', 'Basket, with handle, wooden '),
('HC', 'Basket, with handle, cardboard '),
('HG', 'Hogshead '),
('HR', 'Hamper '),
('IA', 'Package, display, wooden '),
('IB', 'Package, display, cardboard '),
('IC', 'Package, display, plastic '),
('ID', 'Package, display, metal '),
('IE', 'Package, show '),
('IF', 'Package, flow '),
('IG', 'Package, paper wrapped '),
('IH', 'Drum, plastic '),
('IK', 'Package, cardboard, with bottle grip-holes '),
('IN', 'Ingot '),
('IZ', 'Ingots, in bundle/bunch/truss '),
('JC', 'Jerrican, rectangular '),
('JG', 'Jug '),
('JR', 'Jar '),
('JT', 'Jutebag '),
('JY', 'Jerrican, cylindrical '),
('KG', 'Keg '),
('LG', 'Log '),
('LT', 'Lot '),
('LV', 'Liftvan '),
('LZ', 'Logs, in bundle/bunch/truss '),
('MB', 'Bag, multiply'),
('MC', 'Crate, milk'),
('MR', 'recept., metal '),
('MS', 'Sack, multi-wall'),
('MT', 'Mat '),
('MW', 'recept., plastic wrapped'),
('MX', 'Matchbox '),
('NA', 'Not available'),
('NE', 'Unpacked or unpackaged '),
('NF', 'Unpacked or unpackaged, single unit '),
('NG', 'Unpacked or unpackaged, multiple units '),
('NS', 'Nest'),
('NT', 'Net'),
('NU', 'Net, tube, plastic'),
('NV', 'Net, tube, textile '),
('PA', 'Packet '),
('PB', 'Pallet, box '),
('PC', 'Parcel '),
('PD', 'Pallet, modular, collars 80cms * 100cms'),
('PE', 'Pallet, modular, collars 80cms * 120cms '),
('PF', 'Pen'),
('PG', 'Plate '),
('PH', 'Pitcher '),
('PI', 'Pipe'),
('PJ', 'Punnet'),
('PK', 'Package '),
('PL', 'Pail '),
('PN', 'Plank '),
('PO', 'Pouch '),
('PR', 'recept., plastic '),
('PT', 'Pot '),
('PU', 'Tray '),
('PV', 'Pipes, in bundle/bunch/truss '),
('PX', 'Pallet '),
('PY', 'Plates, in bundle/bunch/truss '),
('PZ', 'Planks, in bundle/bunch/truss '),
('QA', 'Drum, steel, non-removable head '),
('QB', 'Drum, steel, removable head '),
('QC', 'Drum, aluminium, non-removable head '),
('QD', 'Drum, aluminium, removable head '),
('QF', 'Drum, plastic, non-removable head '),
('QG', 'Drum, plastic, removable head '),
('QH', 'Barrel, wooden, bung type '),
('QJ', 'Barrel, wooden, removable head '),
('QK', 'Jerrican, steel, non-removable head '),
('QL', 'Jerrican, steel, removable head '),
('QM', 'Jerrican, plastic, non-removable head '),
('QN', 'Jerrican, plastic, removable head '),
('QP', 'Box, wooden, natural wood, ordinary '),
('QQ', 'Box, wooden, natural wood, with sift proof walls '),
('QR', 'Box, plastic, expanded '),
('QS', 'Box, plastic, solid '),
('RD', 'Rod'),
('RG', 'Ring '),
('RJ', 'Rack, clothing hanger'),
('RK', 'Rack'),
('RL', 'Reel '),
('RO', 'Roll '),
('RT', 'Rednet '),
('RZ', 'Rods, in bundle/bunch/truss '),
('SA', 'Sack '),
('SB', 'Slab'),
('SC', 'Crate, shallow '),
('SD', 'Spindle '),
('SE', 'Sea-chest '),
('SH', 'Sachet '),
('SI', 'Skid '),
('SK', 'Case, skeleton '),
('SL', 'Slipsheet '),
('SM', 'Sheetmetal '),
('SO', 'Spool'),
('SP', 'Sheet, plastic wrapping '),
('SS', 'Case, steel '),
('ST', 'Sheet '),
('SU', 'Suitcase '),
('SV', 'Envelope, steel '),
('SW', 'Shrinkwrapped '),
('SX', 'X Set '),
('SY', 'Sleeve'),
('SZ', 'Sheets, in bundle/bunch/truss '),
('TB', 'Tub '),
('TC', 'Tea-chest '),
('TD', 'Tube, collapsible '),
('TI', 'Tierce '),
('TK', 'Tank, rectangular '),
('TL', 'Tub, with lid '),
('TN', 'Tin '),
('TO ', 'Tun '),
('TR', 'Trunk '),
('TS', 'Truss '),
('TU', 'Tube '),
('TV', 'Tube, with nozzle '),
('TY', 'Tank, cylindrical '),
('TZ', 'Tubes, in bundle/bunch/truss '),
('UC', 'Uncaged '),
('VA', 'Vat '),
('VG', 'Bulk, gas (at 1031 mbar and 15'),
('VI', 'Vial '),
('VK', 'Vanpack '),
('VL', 'Bulk, liquid '),
('VO', 'Bulk, solid, large particles ('),
('VP', 'Vacuum-packed '),
('VQ', 'Bulk, liquefied gas (at abnormal temperature/pressure) '),
('VR', 'Bulk, solid, granular particles ('),
('VY', 'Bulk, solid, fine particles ('),
('WA', 'Int. bulk cont.'),
('WB', 'Wickerbottle'),
('WC', 'Int. bulk cont., steel'),
('WD', 'Int. bulk cont., aluminium '),
('WF', 'Int. bulk cont., metal'),
('WG', 'Int. bulk cont., steel, pressurised > 10 kpa '),
('WH', 'Int. bulk cont., aluminium, pressurised > 10 kpa '),
('WJ', 'Int. bulk cont., metal, pressure 10 kpa '),
('WK ', 'Int. bulk cont., steel, liquid '),
('WL', 'Int. bulk cont., aluminium, liquid '),
('WM', 'Int. bulk cont., metal, liquid'),
('WN', 'Int. bulk cont., woven plastic, without coat/liner '),
('WP', 'Int. bulk cont., woven plastic, coated '),
('WQ', 'Int. bulk cont., woven plastic, with liner '),
('WR', 'Int. bulk cont., woven plastic, coated and liner '),
('WS', 'Int. bulk cont., plastic film '),
('WT', 'Int. bulk cont., textile with out coat/liner '),
('WU', 'Int. bulk cont., natural wood, with inner liner'),
('WV', 'Int. bulk cont., textile, coated '),
('WW', 'Int. bulk cont., textile, with liner'),
('WX', 'Int. bulk cont., textile, coated and liner '),
('WY', 'Int. bulk cont., plywood, with inner liner '),
('WZ', 'Int. bulk cont., reconstituted wood, with inner liner'),
('XA', 'Bag, woven plastic, without inner coat/liner '),
('XB', 'Bag, woven plastic, sift proof '),
('XC', 'Bag, woven plastic, water resistant '),
('XD', 'Bag, plastics film '),
('XF', 'Bag, textile, without inner coat/liner '),
('XG', 'Bag, textile, sift proof '),
('XH', 'Bag, textile, water resistant '),
('XJ', 'Bag, paper, multi-wall '),
('XK', 'Bag, paper, multi-wall, water resistant '),
('YA', 'Comp. pkg, plastic recept. in steel drum '),
('YB', 'Comp. pkg, plastic recept. in steel crate box '),
('YC', 'Comp. pkg, plastic recept. in aluminium drum '),
('YD', 'Comp. pkg, plastic recept. in aluminium crate '),
('YF', 'Comp. pkg, plastic recept. in wooden box '),
('YG', 'Comp. pkg, plastic recept. in plywood drum '),
('YH', 'Comp. pkg, plastic recept. in plywood box '),
('YJ', 'Comp. pkg, plastic recept. in fibre drum '),
('YK', 'Comp. pkg, plastic recept. in fibreboard box '),
('YL', 'Comp. pkg, plastic recept. in plastic drum '),
('YM', 'Comp. pkg, plastic recept. in solid plastic box '),
('YN', 'Comp. pkg, glass recept. in steel drum '),
('YP', 'Comp. pkg, glass recept. in steel crate box '),
('YQ', 'Comp. pkg, glass recept. in aluminium drum '),
('YR', 'Comp. pkg, glass recept. in aluminium crate '),
('YS', 'Comp. pkg, glass recept. in wooden box '),
('YT', 'Comp. pkg, glass recept. in plywood drum '),
('YV', 'Comp. pkg, glass recept. in wickerwork hamper '),
('YW', 'Comp. pkg, glass recept. in fibre drum '),
('YX', 'Comp. pkg, glass recept. in fibreboard box '),
('YY', 'Comp. pkg, glass recept. in expand. plastic pack'),
('YZ', 'Comp. pkg, glass recept. in solid plastic pack '),
('ZA', 'Int. bulk cont., paper, multi-wall '),
('ZB', 'Bag, large'),
('ZC', 'Int. bulk cont., paper, multi-wall, water resistant '),
('ZD', 'Int. bulk cont., rigid plastic, with str. eqpt, solids '),
('ZF', 'Int. bulk cont., rigid plastic, freestanding, solids '),
('ZH', 'Int. bulk cont., rigid plastic, freestanding, pressurised '),
('ZJ', 'Int. bulk cont., rigid plastic, with str. eqpt., liquids '),
('ZK', 'Int. bulk cont., rigid plastic, freestanding, liquids '),
('ZL', 'Int. bulk cont., Comp., rigid plastic, solids '),
('ZM', 'Int. bulk cont., Comp., flexible plastic, solids '),
('ZN', 'Int. bulk cont., Comp., rigid plastic, pressurised '),
('ZP', 'Int. bulk cont., Comp., flexible plastic, pressurised '),
('ZQ', 'Int. bulk cont., Comp., rigid plastic, liquids '),
('ZR', 'Int. bulk cont., Comp., flexible plastic, liquids '),
('ZT', 'Int. bulk cont., fibreboard '),
('ZU', 'Int. bulk cont., flexible'),
('ZV', 'Int. bulk cont., metal, other than steel '),
('ZW', 'Int. bulk cont., natural wood'),
('ZY', 'Int. bulk cont., reconstituted wood');
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
