Air tbl

From UG

Revision as of 19:13, 3 February 2010 (edit) Alex (Talk | contribs) ← Older edit		Current revision as of 19:48, 22 February 2010 (edit) (undo) Alex (Talk | contribs)
(7 intermediate revisions not shown)
Line 153:		Line 153:
	</pre>		</pre>
-	== Related Business Object and Its Fields ==	+	==   Fields ==
-	This table corresponds to '''Air Shipment''' business object.	+	===  AirShipmentId  ===
-	See its fields (attributes) below.	+	` int(10) NOT NULL AUTO_INCREMENT,
-	=== AirShipmentId ===	+	=== GenericShipmentId ===
-	* ''meaning:'' PRI key	+
-	=== GenericShipmentId ===	+	` int(10) NOT NULL,
-	* ''meaning:''  FRN key, see [[tbl Generic Shipment#Id]]; also visible number of shipment	+
-	* ''type/format:''  [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits	+
-	* ''examples:'' 669, 200539	+
-	=== Hazardous ===	+	=== Hazardous ===
-	* ''meaning:'' hazardous indication in [[Commodity Table]]	+
-	* ''type/format:''  [[Datatypes#positive integer]]; exactly 1 digit	+
-	* ''examples:'' 0, 1	+
-	=== HazardousNote ===	+	` tinyint(1) NOT NULL DEFAULT '0',
-	* ''meaning:'' hazardous note	+	`HazardousNote` varchar(1500) DEFAULT NULL,
-	* ''type/format:'' [[Datatypes#alphanumeric]]; max = 1500 chars	+	`Freight` int(1) DEFAULT '0',
-	* ''examples:''	+	`AirlineId` int(10) DEFAULT NULL,
-		+	`CoLoaderAirId` int(10) DEFAULT NULL,
-	=== Freight ===	+	`Hawb` varchar(30) DEFAULT NULL,
-	* ''meaning:''	+	`MasterBillA` varchar(3) NOT NULL DEFAULT '',
-	* ''type/format:'' [[Datatypes#]];	+	`MasterBillB` varchar(4) NOT NULL DEFAULT '',
-	* ''examples:''	+	`MasterBillC` varchar(4) NOT NULL DEFAULT '',
-		+	`HouseBillOfLanding` varchar(30) DEFAULT NULL,
-	=== AirlineId ===	+	`FlightOne` varchar(30) DEFAULT NULL,
-	* ''meaning:'' key field, see [[tbl Airline#Id]]	+	`FlightTwo` varchar(30) DEFAULT NULL,
-	* ''type/format:'' [[Datatypes#]];	+	`AirportOfDepartureId` int(10) DEFAULT NULL,
-	* ''examples:''	+	`AirportOfDepartureETD` date DEFAULT NULL,
-		+	`AirportOfDepartureATD` date DEFAULT NULL,
-	=== CoLoaderAirId ===	+	`TransShipmentAirportId` int(10) DEFAULT NULL,
-	* ''meaning:''  FRN key, see [[tbl Generic Shipment#Id]]; also visible number of shipment	+	`TransShipmentAirportETA` date DEFAULT NULL,
-	* ''type/format:''  [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits	+	`TransShipmentAirportATA` date DEFAULT NULL,
-	* ''examples:'' 669, 200539	+	`AirportOfDestinationId` int(10) DEFAULT NULL,
-		+	`AirportOfDestinationETA` date DEFAULT NULL,
-	=== Hawb ===	+	`AirportOfDestinationATA` date DEFAULT NULL,
-	* ''meaning:''	+	`DestinationReceivingAgentId` int(10) DEFAULT NULL,
-	* ''type/format:'' [[Datatypes#]];	+	`HouseAirwayBillComments` varchar(1500) DEFAULT NULL,
-	* ''examples:''	+	`EnabledArrivalToWH` tinyint(1) DEFAULT '1',
-		+	`ArrivalToWarehouseDate` date DEFAULT NULL,
-	=== MasterBillA ===	+	`ItNumber` varchar(17) DEFAULT NULL,
-	* ''meaning:''	+	`ItDate` date DEFAULT NULL,
-	* ''type/format:'' [[Datatypes#]];	+	`ItLocation` varchar(20) DEFAULT NULL,
-	* ''examples:''	+	`CustomsBrokerId` int(10) DEFAULT NULL,
-		+	`CustomsBrokerDescription` varchar(1500) DEFAULT NULL,
-	=== MasterBillB ===	+	`CargoLocationId` int(10) DEFAULT NULL,
-	* ''meaning:''	+	`CargoLocationDescription` varchar(1500) DEFAULT NULL,
-	* ''type/format:'' [[Datatypes#]];	+	`LastFreeDay` date DEFAULT NULL,
-	* ''examples:''	+	`ArrivalNoticeComments` varchar(1500) DEFAULT NULL,
-		+	`DeliveryAddressId` int(10) DEFAULT NULL,
-	=== MasterBillC ===	+	`DeliveryAddressDescription` varchar(1500) DEFAULT NULL,
-	* ''meaning:''	+	`DeliveryTruckerId` int(10) DEFAULT NULL,
-	* ''type/format:'' [[Datatypes#]];	+	`ImportEstimatedDeliveryDate` date DEFAULT NULL,
-	* ''examples:''	+	`ImportActualDeliveryDate` date DEFAULT NULL,
-		+
-	=== HouseBillOfLanding ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== FlightOne ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== FlightTwo ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== AirportOfDepartureId ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== AirportOfDepartureETD ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== AirportOfDepartureATD ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== TransShipmentAirportId ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== TransShipmentAirportETA ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== TransShipmentAirportATA ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== AirportOfDestinationId ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== AirportOfDestinationETA ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== AirportOfDestinationATA ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== DestinationReceivingAgentId ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== HouseAirwayBillComments ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== EnabledArrivalToWH ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== ArrivalToWarehouseDate ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== ItNumber ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== ItDate ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== ItLocation ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== CustomsBrokerId ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== CustomsBrokerDescription ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== CargoLocationId ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== CargoLocationDescription ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== LastFreeDay ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== ArrivalNoticeComments ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== DeliveryAddressId ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== DeliveryAddressDescription ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== DeliveryTruckerId ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== ImportEstimatedDeliveryDate ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== ImportActualDeliveryDate ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
	=== DeliveryComments ===		=== DeliveryComments ===
-	* ''meaning:''	+	` varchar(100) DEFAULT NULL,
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== TruckerDeliveryInstructions ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== PaymentFreightChargesRequired ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== CustomsStatusId ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== CustomsStatusDate ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== FDAStatusId ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== FDAStatusDate ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-	=== DeliveryDateTypeId ===
-	* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];
-	* ''examples:''
-	=== ExportCustoms ===	+	`TruckerDeliveryInstructions` varchar(1500) DEFAULT NULL,
-	* ''meaning:''	+	`PaymentFreightChargesRequired` int(1) DEFAULT '0',
-	* ''type/format:'' [[Datatypes#]];	+	`CustomsStatusId` int(10) DEFAULT NULL,
-	* ''examples:''	+	`CustomsStatusDate` date DEFAULT NULL,
		+	`FDAStatusId` int(10) DEFAULT NULL,
		+	`FDAStatusDate` date DEFAULT NULL,
		+	`DeliveryDateTypeId` int(10) DEFAULT NULL,
		+	`ExportCustoms` varchar(30) DEFAULT NULL,
		+	`ExportCustomsId` int(10) DEFAULT NULL,
		+	`ActualDeliveryDateEnabled` tinyint(1) DEFAULT '0',
-	=== ExportCustomsId ===	+	=== DeliveryInstructions ===
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-	=== ActualDeliveryDateEnabled ===	+	varchar(1500) DEFAULT NULL
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+

---

Current revision as of 19:48, 22 February 2010

Contents 1 Related bo wiki 2 MySQL Table Definitions 3 Fields 3.1 AirShipmentId 3.2 GenericShipmentId 3.3 Hazardous 3.4 DeliveryComments 3.5 DeliveryInstructions

[edit] Related bo wiki

CT bo

[edit] MySQL Table Definitions

on 02-Feb-2010

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    |                |
| ExportCustomsId               | int(10)       | YES  | MUL | NULL    |                |
| ActualDeliveryDateEnabled     | tinyint(1)    | YES  |     | 0       |                |
+-------------------------------+---------------+------+-----+---------+----------------+
52 rows in set

CREATE TABLE `tblairshipment` (
  `AirShipmentId` int(10) NOT NULL AUTO_INCREMENT,
  `GenericShipmentId` int(10) NOT NULL,
  `Hazardous` tinyint(1) NOT NULL DEFAULT '0',
  `HazardousNote` varchar(1500) DEFAULT NULL,
  `Freight` int(1) DEFAULT '0',
  `AirlineId` int(10) DEFAULT NULL,
  `CoLoaderAirId` int(10) DEFAULT NULL,
  `Hawb` varchar(30) DEFAULT NULL,
  `MasterBillA` varchar(3) NOT NULL DEFAULT '',
  `MasterBillB` varchar(4) NOT NULL DEFAULT '',
  `MasterBillC` varchar(4) NOT NULL DEFAULT '',
  `HouseBillOfLanding` varchar(30) DEFAULT NULL,
  `FlightOne` varchar(30) DEFAULT NULL,
  `FlightTwo` varchar(30) DEFAULT NULL,
  `AirportOfDepartureId` int(10) DEFAULT NULL,
  `AirportOfDepartureETD` date DEFAULT NULL,
  `AirportOfDepartureATD` date DEFAULT NULL,
  `TransShipmentAirportId` int(10) DEFAULT NULL,
  `TransShipmentAirportETA` date DEFAULT NULL,
  `TransShipmentAirportATA` date DEFAULT NULL,
  `AirportOfDestinationId` int(10) DEFAULT NULL,
  `AirportOfDestinationETA` date DEFAULT NULL,
  `AirportOfDestinationATA` date DEFAULT NULL,
  `DestinationReceivingAgentId` int(10) DEFAULT NULL,
  `HouseAirwayBillComments` varchar(1500) DEFAULT NULL,
  `EnabledArrivalToWH` tinyint(1) DEFAULT '1',
  `ArrivalToWarehouseDate` date DEFAULT NULL,
  `ItNumber` varchar(17) DEFAULT NULL,
  `ItDate` date DEFAULT NULL,
  `ItLocation` varchar(20) DEFAULT NULL,
  `CustomsBrokerId` int(10) DEFAULT NULL,
  `CustomsBrokerDescription` varchar(1500) DEFAULT NULL,
  `CargoLocationId` int(10) DEFAULT NULL,
  `CargoLocationDescription` varchar(1500) DEFAULT NULL,
  `LastFreeDay` date DEFAULT NULL,
  `ArrivalNoticeComments` varchar(1500) DEFAULT NULL,
  `DeliveryAddressId` int(10) DEFAULT NULL,
  `DeliveryAddressDescription` varchar(1500) DEFAULT NULL,
  `DeliveryTruckerId` int(10) DEFAULT NULL,
  `ImportEstimatedDeliveryDate` date DEFAULT NULL,
  `ImportActualDeliveryDate` date DEFAULT NULL,
  `DeliveryComments` varchar(100) DEFAULT NULL,
  `TruckerDeliveryInstructions` varchar(1500) DEFAULT NULL,
  `PaymentFreightChargesRequired` int(1) DEFAULT '0',
  `CustomsStatusId` int(10) DEFAULT NULL,
  `CustomsStatusDate` date DEFAULT NULL,
  `FDAStatusId` int(10) DEFAULT NULL,
  `FDAStatusDate` date DEFAULT NULL,
  `DeliveryDateTypeId` int(10) DEFAULT NULL,
  `ExportCustoms` varchar(30) DEFAULT NULL,
  `ExportCustomsId` int(10) DEFAULT NULL,
  `ActualDeliveryDateEnabled` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`AirShipmentId`),
  KEY `OceanShipment_GenericShipmentId` (`GenericShipmentId`),
  KEY `AirShipment_AirlineId` (`AirlineId`),
  KEY `AirShipment_CoLoaderAirId` (`CoLoaderAirId`),
  KEY `AirShipment_AirportOfDepartureId` (`AirportOfDepartureId`),
  KEY `AirShipment_TransShipmentAirportId` (`TransShipmentAirportId`),
  KEY `AirShipment_AirportOfDestinationId` (`AirportOfDestinationId`),
  KEY `AirShipment_DestinationReceivingAgentId` (`DestinationReceivingAgentId`),
  KEY `AirShipment_CustomsBrokerId` (`CustomsBrokerId`),
  KEY `AirShipment_CargoLocationId` (`CargoLocationId`),
  KEY `AirShipment_DeliveryAddressId` (`DeliveryAddressId`),
  KEY `AirShipment_DeliveryTruckerId` (`DeliveryTruckerId`),
  KEY `AirShipment_CustomsStatusId` (`CustomsStatusId`),
  KEY `AirShipment_FDAStatusId` (`FDAStatusId`),
  KEY `tblAirShipment_ibfk_14` (`ExportCustomsId`),
  CONSTRAINT `tblAirShipment_ibfk_1` FOREIGN KEY (`GenericShipmentId`) REFERENCES `tblgenericshipment` (`Id`) ON DELETE CASCADE,
  CONSTRAINT `tblAirShipment_ibfk_10` FOREIGN KEY (`DeliveryAddressId`) REFERENCES `tbladdresstransportation` (`Id`),
  CONSTRAINT `tblAirShipment_ibfk_11` FOREIGN KEY (`DeliveryTruckerId`) REFERENCES `tbladdressjaguarvendor` (`Id`),
  CONSTRAINT `tblAirShipment_ibfk_12` FOREIGN KEY (`CustomsStatusId`) REFERENCES `tblcustomsstatus` (`Id`),
  CONSTRAINT `tblAirShipment_ibfk_13` FOREIGN KEY (`FDAStatusId`) REFERENCES `tblfdastatus` (`Id`),
  CONSTRAINT `tblAirShipment_ibfk_14` FOREIGN KEY (`ExportCustomsId`) REFERENCES `tblexportcustoms` (`Id`),
  CONSTRAINT `tblAirShipment_ibfk_2` FOREIGN KEY (`AirlineId`) REFERENCES `tblairline` (`Id`),
  CONSTRAINT `tblAirShipment_ibfk_3` FOREIGN KEY (`CoLoaderAirId`) REFERENCES `tbladdressjaguarvendor` (`Id`),
  CONSTRAINT `tblAirShipment_ibfk_4` FOREIGN KEY (`AirportOfDepartureId`) REFERENCES `tblairport` (`Id`),
  CONSTRAINT `tblAirShipment_ibfk_5` FOREIGN KEY (`TransShipmentAirportId`) REFERENCES `tblairport` (`Id`),
  CONSTRAINT `tblAirShipment_ibfk_6` FOREIGN KEY (`AirportOfDestinationId`) REFERENCES `tblairport` (`Id`),
  CONSTRAINT `tblAirShipment_ibfk_7` FOREIGN KEY (`DestinationReceivingAgentId`) REFERENCES `tbladdresstransportation` (`Id`),
  CONSTRAINT `tblAirShipment_ibfk_8` FOREIGN KEY (`CustomsBrokerId`) REFERENCES `tbladdressjaguarvendor` (`Id`),
  CONSTRAINT `tblAirShipment_ibfk_9` FOREIGN KEY (`CargoLocationId`) REFERENCES `tbladdresstransportation` (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=312 DEFAULT CHARSET=latin1;

[edit] Fields

[edit] AirShipmentId

` int(10) NOT NULL AUTO_INCREMENT,

[edit] GenericShipmentId

` int(10) NOT NULL,

[edit] Hazardous

` tinyint(1) NOT NULL DEFAULT '0',

 `HazardousNote` varchar(1500) DEFAULT NULL,
 `Freight` int(1) DEFAULT '0',
 `AirlineId` int(10) DEFAULT NULL,
 `CoLoaderAirId` int(10) DEFAULT NULL,
 `Hawb` varchar(30) DEFAULT NULL,
 `MasterBillA` varchar(3) NOT NULL DEFAULT ,
 `MasterBillB` varchar(4) NOT NULL DEFAULT ,
 `MasterBillC` varchar(4) NOT NULL DEFAULT ,
 `HouseBillOfLanding` varchar(30) DEFAULT NULL,
 `FlightOne` varchar(30) DEFAULT NULL,
 `FlightTwo` varchar(30) DEFAULT NULL,
 `AirportOfDepartureId` int(10) DEFAULT NULL,
 `AirportOfDepartureETD` date DEFAULT NULL,
 `AirportOfDepartureATD` date DEFAULT NULL,
 `TransShipmentAirportId` int(10) DEFAULT NULL,
 `TransShipmentAirportETA` date DEFAULT NULL,
 `TransShipmentAirportATA` date DEFAULT NULL,
 `AirportOfDestinationId` int(10) DEFAULT NULL,
 `AirportOfDestinationETA` date DEFAULT NULL,
 `AirportOfDestinationATA` date DEFAULT NULL,
 `DestinationReceivingAgentId` int(10) DEFAULT NULL,
 `HouseAirwayBillComments` varchar(1500) DEFAULT NULL,
 `EnabledArrivalToWH` tinyint(1) DEFAULT '1',
 `ArrivalToWarehouseDate` date DEFAULT NULL,
 `ItNumber` varchar(17) DEFAULT NULL,
 `ItDate` date DEFAULT NULL,
 `ItLocation` varchar(20) DEFAULT NULL,
 `CustomsBrokerId` int(10) DEFAULT NULL,
 `CustomsBrokerDescription` varchar(1500) DEFAULT NULL,
 `CargoLocationId` int(10) DEFAULT NULL,
 `CargoLocationDescription` varchar(1500) DEFAULT NULL,
 `LastFreeDay` date DEFAULT NULL,
 `ArrivalNoticeComments` varchar(1500) DEFAULT NULL,
 `DeliveryAddressId` int(10) DEFAULT NULL,
 `DeliveryAddressDescription` varchar(1500) DEFAULT NULL,
 `DeliveryTruckerId` int(10) DEFAULT NULL,
 `ImportEstimatedDeliveryDate` date DEFAULT NULL,
 `ImportActualDeliveryDate` date DEFAULT NULL,

[edit] DeliveryComments

` varchar(100) DEFAULT NULL,

 `TruckerDeliveryInstructions` varchar(1500) DEFAULT NULL,
 `PaymentFreightChargesRequired` int(1) DEFAULT '0',
 `CustomsStatusId` int(10) DEFAULT NULL,
 `CustomsStatusDate` date DEFAULT NULL,
 `FDAStatusId` int(10) DEFAULT NULL,
 `FDAStatusDate` date DEFAULT NULL,
 `DeliveryDateTypeId` int(10) DEFAULT NULL,
 `ExportCustoms` varchar(30) DEFAULT NULL,
 `ExportCustomsId` int(10) DEFAULT NULL,
 `ActualDeliveryDateEnabled` tinyint(1) DEFAULT '0',

[edit] DeliveryInstructions

varchar(1500) DEFAULT NULL