Air tbl

From UG

(Difference between revisions)
Jump to: navigation, search
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,
-
 
+
  `DeliveryComments` varchar(100) DEFAULT NULL,
-
=== HouseBillOfLanding ===
+
  `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,
-
=== FlightOne ===
+
  `FDAStatusDate` date DEFAULT NULL,
-
* ''meaning:''
+
  `DeliveryDateTypeId` int(10) DEFAULT NULL,
-
* ''type/format:'' [[Datatypes#]];
+
  `ExportCustoms` varchar(30) DEFAULT NULL,
-
* ''examples:''
+
  `ExportCustomsId` int(10) DEFAULT NULL,
-
 
+
  `ActualDeliveryDateEnabled` tinyint(1) DEFAULT '0',
-
=== 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 19:46, 3 February 2010


Contents

Related bo wiki

CT bo

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;

= Fields

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',
Personal tools