Air tbl
From UG
mysql> describe tblAirShipment;
+-------------------------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------------------+---------------+------+-----+---------+----------------+
| AirShipmentId | int(10) | NO | PRI | NULL | auto_increment |
| GenericShipmentId | int(10) | NO | MUL | NULL | |
| Hazardous | tinyint(1) | NO | | 0 | |
| HazardousNote | varchar(1500) | YES | | NULL | |
| Freight | int(1) | YES | | 0 | |
| AirlineId | int(10) | YES | MUL | NULL | |
| CoLoaderAirId | int(10) | YES | MUL | NULL | |
| Hawb | varchar(30) | YES | | NULL | |
| MasterBillA | varchar(3) | NO | | | |
| MasterBillB | varchar(4) | NO | | | |
| MasterBillC | varchar(4) | NO | | | |
| HouseBillOfLanding | varchar(30) | YES | | NULL | |
| FlightOne | varchar(30) | YES | | NULL | |
| FlightTwo | varchar(30) | YES | | NULL | |
| AirportOfDepartureId | int(10) | YES | MUL | NULL | |
| AirportOfDepartureETD | date | YES | | NULL | |
| AirportOfDepartureATD | date | YES | | NULL | |
| TransShipmentAirportId | int(10) | YES | MUL | NULL | |
| TransShipmentAirportETA | date | YES | | NULL | |
| TransShipmentAirportATA | date | YES | | NULL | |
| AirportOfDestinationId | int(10) | YES | MUL | NULL | |
| AirportOfDestinationETA | date | YES | | NULL | |
| AirportOfDestinationATA | date | YES | | NULL | |
| DestinationReceivingAgentId | int(10) | YES | MUL | NULL | |
| HouseAirwayBillComments | varchar(1500) | YES | | NULL | |
| EnabledArrivalToWH | tinyint(1) | YES | | 1 | |
| ArrivalToWarehouseDate | date | YES | | NULL | |
| ItNumber | varchar(17) | YES | | NULL | |
| ItDate | date | YES | | NULL | |
| ItLocation | varchar(20) | YES | | NULL | |
| CustomsBrokerId | int(10) | YES | MUL | NULL | |
| CustomsBrokerDescription | varchar(1500) | YES | | NULL | |
| CargoLocationId | int(10) | YES | MUL | NULL | |
| CargoLocationDescription | varchar(1500) | YES | | NULL | |
| LastFreeDay | date | YES | | NULL | |
| ArrivalNoticeComments | varchar(1500) | YES | | NULL | |
| DeliveryAddressId | int(10) | YES | MUL | NULL | |
| DeliveryAddressDescription | varchar(1500) | YES | | NULL | |
| DeliveryTruckerId | int(10) | YES | MUL | NULL | |
| ImportEstimatedDeliveryDate | date | YES | | NULL | |
| ImportActualDeliveryDate | date | YES | | NULL | |
| DeliveryComments | varchar(100) | YES | | NULL | |
| TruckerDeliveryInstructions | varchar(1500) | YES | | NULL | |
| PaymentFreightChargesRequired | int(1) | YES | | 0 | |
| CustomsStatusId | int(10) | YES | MUL | NULL | |
| CustomsStatusDate | date | YES | | NULL | |
| FDAStatusId | int(10) | YES | MUL | NULL | |
| FDAStatusDate | date | YES | | NULL | |
| DeliveryDateTypeId | int(10) | YES | | NULL | |
| ExportCustoms | varchar(30) | YES | | NULL | |
| ActualDeliveryDateEnabled | tinyint(1) | YES | | 0 | |
+-------------------------------+---------------+------+-----+---------+----------------+
51 rows in set
mysql>
