Air tbl
From UG
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: