Air tbl

From UG

Revision as of 19:50, 3 February 2010 (edit) Alex (Talk | contribs) m (moved Air Shipment (tbl) to Air tbl) ← Older edit		Revision as of 21:29, 3 February 2010 (edit) (undo) Alex (Talk | contribs) Newer edit →
Line 1:		Line 1:
-	[[Category:Shipment Data Objects]]	+	[[Category:CT Profile]]
	== Related bo wiki ==		== Related bo wiki ==

---

Revision as of 21:29, 3 February 2010

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

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