Air tbl

From UG

Revision as of 08:45, 31 January 2010 (edit) Alex (Talk | contribs) m (moved Tbl Air Shipment to Air Shipment (tbl)) ← Older edit		Revision as of 15:38, 2 February 2010 (edit) (undo) Andrei (Talk | contribs) Newer edit →
Line 1:		Line 1:
	[[Category:Shipment Data Objects]]		[[Category:Shipment Data Objects]]
-	<pre>	+	== MySQL Table Definitions  ==
		+	on 02-Feb-2010
		+
		+	<pre>
	mysql> describe tblAirShipment;		mysql> describe tblAirShipment;
	+-------------------------------+---------------+------+-----+---------+----------------+		+-------------------------------+---------------+------+-----+---------+----------------+
Line 57:		Line 60:
	| DeliveryDateTypeId            | int(10)      | YES  |    | NULL    |                |		| DeliveryDateTypeId            | int(10)      | YES  |    | NULL    |                |
	| ExportCustoms                | varchar(30)  | YES  |    | NULL    |                |		| ExportCustoms                | varchar(30)  | YES  |    | NULL    |                |
		+	| ExportCustomsId              | int(10)      | YES  | MUL | NULL    |                |
	| ActualDeliveryDateEnabled    | tinyint(1)    | YES  |    | 0      |                |		| ActualDeliveryDateEnabled    | tinyint(1)    | YES  |    | 0      |                |
	+-------------------------------+---------------+------+-----+---------+----------------+		+-------------------------------+---------------+------+-----+---------+----------------+
-	51 rows in set	+	52 rows in set
-		+
-	mysql>	+
		+	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;
	</pre>		</pre>
		+
		+	== Related Business Object and Its Fields ==
		+
		+	This table corresponds to '''Air Shipment''' business object.
		+
		+	See its fields (attributes) below.
		+
		+	=== AirShipmentId ===
		+	* ''meaning:'' PRI key
		+
		+	=== GenericShipmentId ===
		+	* ''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 ===
		+	* ''meaning:'' hazardous indication in [[Commodity Table]]
		+	* ''type/format:''  [[Datatypes#positive integer]]; exactly 1 digit
		+	* ''examples:'' 0, 1
		+
		+	=== HazardousNote ===
		+	* ''meaning:'' hazardous note
		+	* ''type/format:'' [[Datatypes#alphanumeric]]; max = 1500 chars
		+	* ''examples:''
		+
		+	=== Freight ===
		+	* ''meaning:''
		+	* ''type/format:'' [[Datatypes#]];
		+	* ''examples:''
		+
		+	=== AirlineId ===
		+	* ''meaning:'' key field, see [[tbl Airline#Id]]
		+	* ''type/format:'' [[Datatypes#]];
		+	* ''examples:''
		+
		+	=== CoLoaderAirId ===
		+	* ''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
		+
		+	=== Hawb ===
		+	* ''meaning:''
		+	* ''type/format:'' [[Datatypes#]];
		+	* ''examples:''
		+
		+	=== MasterBillA ===
		+	* ''meaning:''
		+	* ''type/format:'' [[Datatypes#]];
		+	* ''examples:''
		+
		+	=== MasterBillB ===
		+	* ''meaning:''
		+	* ''type/format:'' [[Datatypes#]];
		+	* ''examples:''
		+
		+	=== MasterBillC ===
		+	* ''meaning:''
		+	* ''type/format:'' [[Datatypes#]];
		+	* ''examples:''
		+
		+	=== 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 ===
		+	* ''meaning:''
		+	* ''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 ===
		+	* ''meaning:''
		+	* ''type/format:'' [[Datatypes#]];
		+	* ''examples:''
		+
		+	=== ExportCustomsId ===
		+	* ''meaning:''
		+	* ''type/format:'' [[Datatypes#]];
		+	* ''examples:''
		+
		+	=== ActualDeliveryDateEnabled ===
		+	* ''meaning:''
		+	* ''type/format:'' [[Datatypes#]];
		+	* ''examples:''

---

Revision as of 15:38, 2 February 2010

Contents 1 MySQL Table Definitions 2 Related Business Object and Its Fields 2.1 AirShipmentId 2.2 GenericShipmentId 2.3 Hazardous 2.4 HazardousNote 2.5 Freight 2.6 AirlineId 2.7 CoLoaderAirId 2.8 Hawb 2.9 MasterBillA 2.10 MasterBillB 2.11 MasterBillC 2.12 HouseBillOfLanding 2.13 FlightOne 2.14 FlightTwo 2.15 AirportOfDepartureId 2.16 AirportOfDepartureETD 2.17 AirportOfDepartureATD 2.18 TransShipmentAirportId 2.19 TransShipmentAirportETA 2.20 TransShipmentAirportATA 2.21 AirportOfDestinationId 2.22 AirportOfDestinationETA 2.23 AirportOfDestinationATA 2.24 DestinationReceivingAgentId 2.25 HouseAirwayBillComments 2.26 EnabledArrivalToWH 2.27 ArrivalToWarehouseDate 2.28 ItNumber 2.29 ItDate 2.30 ItLocation 2.31 CustomsBrokerId 2.32 CustomsBrokerDescription 2.33 CargoLocationId 2.34 CargoLocationDescription 2.35 LastFreeDay 2.36 ArrivalNoticeComments 2.37 DeliveryAddressId 2.38 DeliveryAddressDescription 2.39 DeliveryTruckerId 2.40 ImportEstimatedDeliveryDate 2.41 ImportActualDeliveryDate 2.42 DeliveryComments 2.43 TruckerDeliveryInstructions 2.44 PaymentFreightChargesRequired 2.45 CustomsStatusId 2.46 CustomsStatusDate 2.47 FDAStatusId 2.48 FDAStatusDate 2.49 DeliveryDateTypeId 2.50 ExportCustoms 2.51 ExportCustomsId 2.52 ActualDeliveryDateEnabled

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;

Related Business Object and Its Fields

This table corresponds to Air Shipment business object.

See its fields (attributes) below.

AirShipmentId

• meaning: PRI key

GenericShipmentId

• 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

• meaning: hazardous indication in Commodity Table
• type/format: Datatypes#positive integer; exactly 1 digit
• examples: 0, 1

HazardousNote

• meaning: hazardous note
• type/format: Datatypes#alphanumeric; max = 1500 chars
• examples:

Freight

• meaning:
• type/format: Datatypes#;
• examples:

AirlineId

• meaning: key field, see tbl Airline#Id
• type/format: Datatypes#;
• examples:

CoLoaderAirId

• 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

Hawb

• meaning:
• type/format: Datatypes#;
• examples:

MasterBillA

• meaning:
• type/format: Datatypes#;
• examples:

MasterBillB

• meaning:
• type/format: Datatypes#;
• examples:

MasterBillC

• meaning:
• type/format: Datatypes#;
• examples:

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

• meaning:
• 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

• meaning:
• type/format: Datatypes#;
• examples:

ExportCustomsId

• meaning:
• type/format: Datatypes#;
• examples:

ActualDeliveryDateEnabled

• meaning:
• type/format: Datatypes#;
• examples: