Ocean tbl

From UG

Revision as of 15:53, 2 February 2010 (edit) Andrei (Talk | contribs) ← Older edit		Current revision as of 19:48, 22 February 2010 (edit) (undo) Alex (Talk | contribs)
(7 intermediate revisions not shown)
Line 1:		Line 1:
	[[Category:Shipment Data Objects]]		[[Category:Shipment Data Objects]]
		+
		+	== Related bo wiki ==
		+	[[CT bo]]
	== MySQL Table Definitions  ==		== MySQL Table Definitions  ==
Line 171:		Line 174:
	</pre>		</pre>
-	== Related Business Object and Its Fields ==	+	== Fields ==
-	This table corresponds to '''Air Shipment''' business object.	+	=== <example> ===
-	See its fields (attributes) below.	+	* ''properties:''
	=== OceanShipmentId ===		=== OceanShipmentId ===
-	* ''meaning:'' PRI key	+
		+	` int(10) NOT NULL AUTO_INCREMENT,
	=== GenericShipmentId ===		=== 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
		+
		+	` int(10) NOT NULL,
	=== Hazardous ===		=== Hazardous ===
-	* ''meaning:'' hazardous indication in [[Commodity Table]]	+	` tinyint(1) NOT NULL DEFAULT '0',
-	* ''type/format:''  [[Datatypes#positive integer]]; exactly 1 digit	+
-	* ''examples:'' 0, 1	+
	=== HazardousNote ===		=== HazardousNote ===
-	* ''meaning:'' hazardous note	+	` varchar(1500) DEFAULT NULL,
-	* ''type/format:'' [[Datatypes#alphanumeric]]; max = 1500 chars	+
-	* ''examples:''	+
	=== Freight ===		=== Freight ===
-	* ''meaning:''	+	` int(1) DEFAULT '0',
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
	=== MoveTypeId ===		=== MoveTypeId ===
-	* ''meaning:''	+	` int(10) DEFAULT NULL,
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
	=== OriginalHouseBill ===		=== OriginalHouseBill ===
-	* ''meaning:''	+	` int(1) DEFAULT '0',
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-	=== SteamshiplineId ===	+	=== SteamshiplineId` int(10) DEFAULT NULL,
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
	=== CoLoaderOceanId ===		=== CoLoaderOceanId ===
-	* ''meaning:''	+	` int(10) DEFAULT NULL,
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
	=== Booking ===		=== Booking ===
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+	` varchar(30) DEFAULT NULL,
-	* ''examples:''	+
	=== MasterBill ===		=== MasterBill ===
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+	` varchar(30) DEFAULT NULL,
-	* ''examples:''	+
	=== AMSSubmissionDate ===		=== AMSSubmissionDate ===
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+	` date DEFAULT NULL,
-	* ''examples:''	+
	=== VesselName ===		=== VesselName ===
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+	` varchar(30) DEFAULT NULL,
-	* ''examples:''	+
	=== Voyage1 ===		=== Voyage1 ===
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+	varchar(30) DEFAULT NULL,
-	* ''examples:''	+
	=== FeederVesselname ===		=== FeederVesselname ===
-	* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];
-	* ''examples:''
-	=== Voyage2 ===	+	` varchar(30) DEFAULT NULL,
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-	=== OriginalTerminalId ===
-	* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];
-	* ''examples:''
-	=== OriginalTerminalETD ===	+	=== Voyage2 ===
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== OriginalTerminalATD ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== PortOfLoadingId ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== PortOfLoadingETD ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== PortOfLoadingATD ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== PortOfTransShipmentId ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== PortOfTransShipmentETA ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== PortOfTransShipmentATA ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-	=== PortOfDischargeId ===	+	` varchar(30) DEFAULT NULL,
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-	=== PortOfDischargeETA ===
-	* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];
-	* ''examples:''
-	=== PortOfDischargeATA ===
-	* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];
-	* ''examples:''
-	=== DestinationalTerminalId ===	+	`OriginalTerminalId` int(10) DEFAULT NULL,
-	* ''meaning:''	+	`OriginalTerminalETD` date DEFAULT NULL,
-	* ''type/format:'' [[Datatypes#]];	+	`OriginalTerminalATD` date DEFAULT NULL,
-	* ''examples:''	+	`PortOfLoadingId` int(10) DEFAULT NULL,
-		+	`PortOfLoadingETD` date DEFAULT NULL,
-	=== DestinationalTerminalETA ===	+	`PortOfLoadingATD` date DEFAULT NULL,
-	* ''meaning:''	+	`PortOfTransShipmentId` int(10) DEFAULT NULL,
-	* ''type/format:'' [[Datatypes#]];	+	`PortOfTransShipmentETA` date DEFAULT NULL,
-	* ''examples:''	+	`PortOfTransShipmentATA` date DEFAULT NULL,
-		+	`PortOfDischargeId` int(10) DEFAULT NULL,
-	=== DestinationalTerminalATA ===	+	`PortOfDischargeETA` date DEFAULT NULL,
-	* ''meaning:''	+	`PortOfDischargeATA` date DEFAULT NULL,
-	* ''type/format:'' [[Datatypes#]];	+	`DestinationalTerminalId` int(10) DEFAULT NULL,
-	* ''examples:''	+	`DestinationalTerminalETA` date DEFAULT NULL,
-		+	`DestinationalTerminalATA` date DEFAULT NULL,
-	=== DestinationReceivingAgentId ===	+	`DestinationReceivingAgentId` int(10) DEFAULT NULL,
-	* ''meaning:''	+	`HouseBillComments` varchar(1500) DEFAULT NULL,
-	* ''type/format:'' [[Datatypes#]];	+	`EnabledArrivalToWH` tinyint(1) DEFAULT '1',
-	* ''examples:''	+	`ArrivalToWarehouseDate` date DEFAULT NULL,
-		+	`ItNumber` varchar(17) DEFAULT NULL,
-	=== HouseBillComments ===	+	`ItDate` date DEFAULT NULL,
-	* ''meaning:''	+	`ItLocation` varchar(20) DEFAULT NULL,
-	* ''type/format:'' [[Datatypes#]];	+	`CustomsBrokerID` int(10) DEFAULT NULL,
-	* ''examples:''	+	`CustomsBrokerDescription` varchar(1500) DEFAULT NULL,
-		+	`DeliveryAddressId` int(10) DEFAULT NULL,
-	=== EnabledArrivalToWH ===	+	`DeliveryAddressDescription` varchar(1500) DEFAULT NULL,
-	* ''meaning:''	+	`DeliveryComments` varchar(1500) DEFAULT NULL,
-	* ''type/format:'' [[Datatypes#]];	+	`LastFreeDay` date DEFAULT NULL,
-	* ''examples:''	+	`CargoLocationId` int(10) DEFAULT NULL,
-		+	`CargoLocationDescription` varchar(1500) DEFAULT NULL,
-	=== ArrivalToWarehouseDate ===	+	`DeliveryTruckerId` int(10) DEFAULT NULL,
-	* ''meaning:''	+	`ImportEstimatedDeliveryDate` date DEFAULT NULL,
-	* ''type/format:'' [[Datatypes#]];	+	`ActualDeliveryDate` date DEFAULT NULL,
-	* ''examples:''	+	`ArrivalNoticeComments` varchar(1500) DEFAULT NULL,
-		+	`OriginalBillLandingRequired` int(1) DEFAULT '0',
-	=== ItNumber ===	+	`PaymentFreightChargesRequired` int(1) DEFAULT '0',
-	* ''meaning:''	+	`CustomsStatusId` int(10) DEFAULT NULL,
-	* ''type/format:'' [[Datatypes#]];	+	`CustomsStatusDate` date DEFAULT NULL,
-	* ''examples:''	+	`FDAStatusId` int(10) DEFAULT NULL,
-		+	`FDAStatusDate` date DEFAULT NULL,
-	=== ItDate ===	+	`HouseBill` varchar(30) DEFAULT NULL,
-	* ''meaning:''	+	`DeliveryDateTypeId` int(10) DEFAULT NULL,
-	* ''type/format:'' [[Datatypes#]];	+	`JaguarDelivery` tinyint(1) DEFAULT '0',
-	* ''examples:''	+	`ExportCustoms` varchar(30) DEFAULT NULL,
-		+	`ActualDeliveryDateEnabled` tinyint(1) DEFAULT '0',
-	=== ItLocation ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== CustomsBrokerID ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== CustomsBrokerDescription ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== DeliveryAddressId ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== DeliveryAddressDescription ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== DeliveryComments ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== LastFreeDay ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== CargoLocationId ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== CargoLocationDescription ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== DeliveryTruckerId ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== ImportEstimatedDeliveryDate ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== ActualDeliveryDate ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== ArrivalNoticeComments ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== OriginalBillLandingRequired ===	+
-	* ''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:''	+
-		+
-	=== HouseBill ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== DeliveryDateTypeId ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-		+
-	=== JaguarDelivery ===	+
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-	=== ExportCustoms ===	+	=== 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 <example> 3.2 OceanShipmentId 3.3 GenericShipmentId 3.4 Hazardous 3.5 HazardousNote 3.6 Freight 3.7 MoveTypeId 3.8 OriginalHouseBill 3.9 CoLoaderOceanId 3.10 Booking 3.11 MasterBill 3.12 AMSSubmissionDate 3.13 VesselName 3.14 Voyage1 3.15 FeederVesselname 3.16 Voyage2 3.17 DeliveryInstructions

[edit] Related bo wiki

CT bo

[edit] MySQL Table Definitions

on 02-Feb-2010

mysql> describe tblOceanShipment;
+-------------------------------+---------------+------+-----+---------+----------------+
| Field                         | Type          | Null | Key | Default | Extra          |
+-------------------------------+---------------+------+-----+---------+----------------+
| OceanShipmentId               | 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       |                |
| MoveTypeId                    | int(10)       | YES  | MUL | NULL    |                |
| OriginalHouseBill             | int(1)        | YES  |     | 0       |                |
| SteamshiplineId               | int(10)       | YES  | MUL | NULL    |                |
| CoLoaderOceanId               | int(10)       | YES  | MUL | NULL    |                |
| Booking                       | varchar(30)   | YES  |     | NULL    |                |
| MasterBill                    | varchar(30)   | YES  |     | NULL    |                |
| AMSSubmissionDate             | date          | YES  |     | NULL    |                |
| VesselName                    | varchar(30)   | YES  |     | NULL    |                |
| Voyage1                       | varchar(30)   | YES  |     | NULL    |                |
| FeederVesselname              | varchar(30)   | YES  |     | NULL    |                |
| Voyage2                       | varchar(30)   | YES  |     | NULL    |                |
| OriginalTerminalId            | int(10)       | YES  | MUL | NULL    |                |
| OriginalTerminalETD           | date          | YES  |     | NULL    |                |
| OriginalTerminalATD           | date          | YES  |     | NULL    |                |
| PortOfLoadingId               | int(10)       | YES  | MUL | NULL    |                |
| PortOfLoadingETD              | date          | YES  |     | NULL    |                |
| PortOfLoadingATD              | date          | YES  |     | NULL    |                |
| PortOfTransShipmentId         | int(10)       | YES  | MUL | NULL    |                |
| PortOfTransShipmentETA        | date          | YES  |     | NULL    |                |
| PortOfTransShipmentATA        | date          | YES  |     | NULL    |                |
| PortOfDischargeId             | int(10)       | YES  | MUL | NULL    |                |
| PortOfDischargeETA            | date          | YES  |     | NULL    |                |
| PortOfDischargeATA            | date          | YES  |     | NULL    |                |
| DestinationalTerminalId       | int(10)       | YES  | MUL | NULL    |                |
| DestinationalTerminalETA      | date          | YES  |     | NULL    |                |
| DestinationalTerminalATA      | date          | YES  |     | NULL    |                |
| DestinationReceivingAgentId   | int(10)       | YES  | MUL | NULL    |                |
| HouseBillComments             | 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    |                |
| DeliveryAddressId             | int(10)       | YES  | MUL | NULL    |                |
| DeliveryAddressDescription    | varchar(1500) | YES  |     | NULL    |                |
| DeliveryComments              | varchar(1500) | YES  |     | NULL    |                |
| LastFreeDay                   | date          | YES  |     | NULL    |                |
| CargoLocationId               | int(10)       | YES  | MUL | NULL    |                |
| CargoLocationDescription      | varchar(1500) | YES  |     | NULL    |                |
| DeliveryTruckerId             | int(10)       | YES  | MUL | NULL    |                |
| ImportEstimatedDeliveryDate   | date          | YES  |     | NULL    |                |
| ActualDeliveryDate            | date          | YES  |     | NULL    |                |
| ArrivalNoticeComments         | varchar(1500) | YES  |     | NULL    |                |
| OriginalBillLandingRequired   | int(1)        | YES  |     | 0       |                |
| 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    |                |
| HouseBill                     | varchar(30)   | YES  |     | NULL    |                |
| DeliveryDateTypeId            | int(10)       | YES  |     | NULL    |                |
| JaguarDelivery                | tinyint(1)    | YES  |     | 0       |                |
| ExportCustoms                 | varchar(30)   | YES  |     | NULL    |                |
| ActualDeliveryDateEnabled     | tinyint(1)    | YES  |     | 0       |                |
+-------------------------------+---------------+------+-----+---------+----------------+
61 rows in set

CREATE TABLE `tbloceanshipment` (
  `OceanShipmentId` 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',
  `MoveTypeId` int(10) DEFAULT NULL,
  `OriginalHouseBill` int(1) DEFAULT '0',
  `SteamshiplineId` int(10) DEFAULT NULL,
  `CoLoaderOceanId` int(10) DEFAULT NULL,
  `Booking` varchar(30) DEFAULT NULL,
  `MasterBill` varchar(30) DEFAULT NULL,
  `AMSSubmissionDate` date DEFAULT NULL,
  `VesselName` varchar(30) DEFAULT NULL,
  `Voyage1` varchar(30) DEFAULT NULL,
  `FeederVesselname` varchar(30) DEFAULT NULL,
  `Voyage2` varchar(30) DEFAULT NULL,
  `OriginalTerminalId` int(10) DEFAULT NULL,
  `OriginalTerminalETD` date DEFAULT NULL,
  `OriginalTerminalATD` date DEFAULT NULL,
  `PortOfLoadingId` int(10) DEFAULT NULL,
  `PortOfLoadingETD` date DEFAULT NULL,
  `PortOfLoadingATD` date DEFAULT NULL,
  `PortOfTransShipmentId` int(10) DEFAULT NULL,
  `PortOfTransShipmentETA` date DEFAULT NULL,
  `PortOfTransShipmentATA` date DEFAULT NULL,
  `PortOfDischargeId` int(10) DEFAULT NULL,
  `PortOfDischargeETA` date DEFAULT NULL,
  `PortOfDischargeATA` date DEFAULT NULL,
  `DestinationalTerminalId` int(10) DEFAULT NULL,
  `DestinationalTerminalETA` date DEFAULT NULL,
  `DestinationalTerminalATA` date DEFAULT NULL,
  `DestinationReceivingAgentId` int(10) DEFAULT NULL,
  `HouseBillComments` 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,
  `DeliveryAddressId` int(10) DEFAULT NULL,
  `DeliveryAddressDescription` varchar(1500) DEFAULT NULL,
  `DeliveryComments` varchar(1500) DEFAULT NULL,
  `LastFreeDay` date DEFAULT NULL,
  `CargoLocationId` int(10) DEFAULT NULL,
  `CargoLocationDescription` varchar(1500) DEFAULT NULL,
  `DeliveryTruckerId` int(10) DEFAULT NULL,
  `ImportEstimatedDeliveryDate` date DEFAULT NULL,
  `ActualDeliveryDate` date DEFAULT NULL,
  `ArrivalNoticeComments` varchar(1500) DEFAULT NULL,
  `OriginalBillLandingRequired` int(1) DEFAULT '0',
  `PaymentFreightChargesRequired` int(1) DEFAULT '0',
  `CustomsStatusId` int(10) DEFAULT NULL,
  `CustomsStatusDate` date DEFAULT NULL,
  `FDAStatusId` int(10) DEFAULT NULL,
  `FDAStatusDate` date DEFAULT NULL,
  `HouseBill` varchar(30) DEFAULT NULL,
  `DeliveryDateTypeId` int(10) DEFAULT NULL,
  `JaguarDelivery` tinyint(1) DEFAULT '0',
  `ExportCustoms` varchar(30) DEFAULT NULL,
  `ActualDeliveryDateEnabled` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`OceanShipmentId`),
  KEY `OceanShipment_GenericShipmentId` (`GenericShipmentId`),
  KEY `OceanShipment_MoveTypeId` (`MoveTypeId`),
  KEY `OceanShipment_SteamshiplineId` (`SteamshiplineId`),
  KEY `OceanShipment_CoLoaderOceanId` (`CoLoaderOceanId`),
  KEY `OceanShipment_OriginalTerminalId` (`OriginalTerminalId`),
  KEY `OceanShipment_PortOfLoadingId` (`PortOfLoadingId`),
  KEY `OceanShipment_PortOfTransShipmentId` (`PortOfTransShipmentId`),
  KEY `OceanShipment_PortOfDischargeId` (`PortOfDischargeId`),
  KEY `OceanShipment_DestinationalTerminalId` (`DestinationalTerminalId`),
  KEY `OceanShipment_DestinationReceivingAgentId` (`DestinationReceivingAgentId`),
  KEY `OceanShipment_CustomsBrokerID` (`CustomsBrokerID`),
  KEY `OceanShipment_DeliveryAddressId` (`DeliveryAddressId`),
  KEY `OceanShipment_CargoLocationId` (`CargoLocationId`),
  KEY `OceanShipment_FDAStatusId` (`FDAStatusId`),
  KEY `OceanShipment_CustomsStatusId` (`CustomsStatusId`),
  KEY `tblOceanShipment_ibfk_27` (`DeliveryTruckerId`),
  CONSTRAINT `tblOceanShipment_ibfk_11` FOREIGN KEY (`MoveTypeId`) REFERENCES `tblmovetype` (`Id`),
  CONSTRAINT `tblOceanShipment_ibfk_12` FOREIGN KEY (`SteamshiplineId`) REFERENCES `tblsteamshipline` (`Id`),
  CONSTRAINT `tblOceanShipment_ibfk_13` FOREIGN KEY (`CoLoaderOceanId`) REFERENCES `tbladdressjaguarvendor` (`Id`),
  CONSTRAINT `tblOceanShipment_ibfk_14` FOREIGN KEY (`OriginalTerminalId`) REFERENCES `tblseaport` (`Id`),
  CONSTRAINT `tblOceanShipment_ibfk_15` FOREIGN KEY (`PortOfLoadingId`) REFERENCES `tblseaport` (`Id`),
  CONSTRAINT `tblOceanShipment_ibfk_16` FOREIGN KEY (`PortOfTransShipmentId`) REFERENCES `tblseaport` (`Id`),
  CONSTRAINT `tblOceanShipment_ibfk_17` FOREIGN KEY (`PortOfDischargeId`) REFERENCES `tblseaport` (`Id`),
  CONSTRAINT `tblOceanShipment_ibfk_18` FOREIGN KEY (`DestinationalTerminalId`) REFERENCES `tblseaport` (`Id`),
  CONSTRAINT `tblOceanShipment_ibfk_19` FOREIGN KEY (`DestinationReceivingAgentId`) REFERENCES `tbladdresstransportation` (`Id`),
  CONSTRAINT `tblOceanShipment_ibfk_20` FOREIGN KEY (`CustomsBrokerID`) REFERENCES `tbladdressjaguarvendor` (`Id`),
  CONSTRAINT `tblOceanShipment_ibfk_21` FOREIGN KEY (`DeliveryAddressId`) REFERENCES `tbladdresstransportation` (`Id`),
  CONSTRAINT `tblOceanShipment_ibfk_22` FOREIGN KEY (`CargoLocationId`) REFERENCES `tbladdressjaguarvendor` (`Id`),
  CONSTRAINT `tblOceanShipment_ibfk_23` FOREIGN KEY (`FDAStatusId`) REFERENCES `tblfdastatus` (`Id`),
  CONSTRAINT `tblOceanShipment_ibfk_24` FOREIGN KEY (`CustomsStatusId`) REFERENCES `tblcustomsstatus` (`Id`),
  CONSTRAINT `tblOceanShipment_ibfk_26` FOREIGN KEY (`GenericShipmentId`) REFERENCES `tblgenericshipment` (`Id`) ON DELETE CASCADE,
  CONSTRAINT `tblOceanShipment_ibfk_27` FOREIGN KEY (`DeliveryTruckerId`) REFERENCES `tbladdressjaguarvendor` (`Id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=433 DEFAULT CHARSET=latin1;

[edit] Fields

[edit] <example>

• properties:

[edit] OceanShipmentId

` int(10) NOT NULL AUTO_INCREMENT,

[edit] GenericShipmentId

` int(10) NOT NULL,

[edit] Hazardous

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

[edit] HazardousNote

` varchar(1500) DEFAULT NULL,

[edit] Freight

` int(1) DEFAULT '0',

[edit] MoveTypeId

` int(10) DEFAULT NULL,

[edit] OriginalHouseBill

` int(1) DEFAULT '0',

=== SteamshiplineId` int(10) DEFAULT NULL,

[edit] CoLoaderOceanId

` int(10) DEFAULT NULL,

[edit] Booking

` varchar(30) DEFAULT NULL,

[edit] MasterBill

` varchar(30) DEFAULT NULL,

[edit] AMSSubmissionDate

` date DEFAULT NULL,

[edit] VesselName

` varchar(30) DEFAULT NULL,

[edit] Voyage1

varchar(30) DEFAULT NULL,

[edit] FeederVesselname

` varchar(30) DEFAULT NULL,

[edit] Voyage2

` varchar(30) DEFAULT NULL,

 `OriginalTerminalId` int(10) DEFAULT NULL,
 `OriginalTerminalETD` date DEFAULT NULL,
 `OriginalTerminalATD` date DEFAULT NULL,
 `PortOfLoadingId` int(10) DEFAULT NULL,
 `PortOfLoadingETD` date DEFAULT NULL,
 `PortOfLoadingATD` date DEFAULT NULL,
 `PortOfTransShipmentId` int(10) DEFAULT NULL,
 `PortOfTransShipmentETA` date DEFAULT NULL,
 `PortOfTransShipmentATA` date DEFAULT NULL,
 `PortOfDischargeId` int(10) DEFAULT NULL,
 `PortOfDischargeETA` date DEFAULT NULL,
 `PortOfDischargeATA` date DEFAULT NULL,
 `DestinationalTerminalId` int(10) DEFAULT NULL,
 `DestinationalTerminalETA` date DEFAULT NULL,
 `DestinationalTerminalATA` date DEFAULT NULL,
 `DestinationReceivingAgentId` int(10) DEFAULT NULL,
 `HouseBillComments` 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,
 `DeliveryAddressId` int(10) DEFAULT NULL,
 `DeliveryAddressDescription` varchar(1500) DEFAULT NULL,
 `DeliveryComments` varchar(1500) DEFAULT NULL,
 `LastFreeDay` date DEFAULT NULL,
 `CargoLocationId` int(10) DEFAULT NULL,
 `CargoLocationDescription` varchar(1500) DEFAULT NULL,
 `DeliveryTruckerId` int(10) DEFAULT NULL,
 `ImportEstimatedDeliveryDate` date DEFAULT NULL,
 `ActualDeliveryDate` date DEFAULT NULL,
 `ArrivalNoticeComments` varchar(1500) DEFAULT NULL,
 `OriginalBillLandingRequired` int(1) DEFAULT '0',
 `PaymentFreightChargesRequired` int(1) DEFAULT '0',
 `CustomsStatusId` int(10) DEFAULT NULL,
 `CustomsStatusDate` date DEFAULT NULL,
 `FDAStatusId` int(10) DEFAULT NULL,
 `FDAStatusDate` date DEFAULT NULL,
 `HouseBill` varchar(30) DEFAULT NULL,
 `DeliveryDateTypeId` int(10) DEFAULT NULL,
 `JaguarDelivery` tinyint(1) DEFAULT '0',
 `ExportCustoms` varchar(30) DEFAULT NULL,
 `ActualDeliveryDateEnabled` tinyint(1) DEFAULT '0',

[edit] DeliveryInstructions

varchar(1500) DEFAULT NULL