Ocean tbl

From UG

Revision as of 15:53, 2 February 2010 (edit) Andrei (Talk | contribs) ← Older edit		Revision as of 18:56, 2 February 2010 (edit) (undo) Andrei (Talk | contribs) Newer edit →
Line 181:		Line 181:
	=== GenericShipmentId ===		=== GenericShipmentId ===
-	* ''meaning:'' FRN key, see [[tbl Generic Shipment#Id]]; also visible number of shipment	+	* ''meaning:'' FRN key, see [[tbl Generic Shipment#Id]]; also visible number of shipment
	* ''type/format:''  [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits		* ''type/format:''  [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
	* ''examples:'' 669, 200539		* ''examples:'' 669, 200539
-
	=== Hazardous ===		=== Hazardous ===
Line 198:		Line 197:
	=== Freight ===		=== Freight ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#positive integer]]; exactly 1 digit
-	* ''examples:''	+	* ''examples:'' 0, 1
	=== MoveTypeId ===		=== MoveTypeId ===
-	* ''meaning:''	+	* ''meaning:'' FRN key, see [[tbl Move Type#Id]]
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
	* ''examples:''		* ''examples:''
	=== OriginalHouseBill ===		=== OriginalHouseBill ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#positive integer]]; exactly 1 digit
-	* ''examples:''	+	* ''examples:'' 0, 1
	=== SteamshiplineId ===		=== SteamshiplineId ===
-	* ''meaning:''	+	* ''meaning:'' FRN key, see [[tbl Steamshipline#Id]]
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
	* ''examples:''		* ''examples:''
	=== CoLoaderOceanId ===		=== CoLoaderOceanId ===
-	* ''meaning:''	+	* ''meaning:'' FRN key, see [[tbl Address Jaguar Vendor#Id]]
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
	* ''examples:''		* ''examples:''
Line 233:		Line 232:
	=== AMSSubmissionDate ===		=== AMSSubmissionDate ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#CT2 date]];
-	* ''examples:''	+	* ''examples:'' 02-Feb-2010
	=== VesselName ===		=== VesselName ===
Line 257:		Line 256:
	=== OriginalTerminalId ===		=== OriginalTerminalId ===
-	* ''meaning:''	+	* ''meaning:'' FRN key, see [[tbl Seaport#Id]]
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
	* ''examples:''		* ''examples:''
	=== OriginalTerminalETD ===		=== OriginalTerminalETD ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#CT2 date]];
-	* ''examples:''	+	* ''examples:'' 02-Feb-2010
	=== OriginalTerminalATD ===		=== OriginalTerminalATD ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#CT2 date]];
-	* ''examples:''	+	* ''examples:'' 02-Feb-2010
	=== PortOfLoadingId ===		=== PortOfLoadingId ===
-	* ''meaning:''	+	* ''meaning:'' FRN key, see [[tbl Seaport#Id]]
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
	* ''examples:''		* ''examples:''
	=== PortOfLoadingETD ===		=== PortOfLoadingETD ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#CT2 date]];
-	* ''examples:''	+	* ''examples:'' 02-Feb-2010
	=== PortOfLoadingATD ===		=== PortOfLoadingATD ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#CT2 date]];
-	* ''examples:''	+	* ''examples:'' 02-Feb-2010
	=== PortOfTransShipmentId ===		=== PortOfTransShipmentId ===
-	* ''meaning:''	+	* ''meaning:'' FRN key, see [[tbl Seaport#Id]]
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
	* ''examples:''		* ''examples:''
	=== PortOfTransShipmentETA ===		=== PortOfTransShipmentETA ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#CT2 date]];
-	* ''examples:''	+	* ''examples:'' 02-Feb-2010
	=== PortOfTransShipmentATA ===		=== PortOfTransShipmentATA ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#CT2 date]];
-	* ''examples:''	+	* ''examples:'' 02-Feb-2010
	=== PortOfDischargeId ===		=== PortOfDischargeId ===
-	* ''meaning:''	+	* ''meaning:'' FRN key, see [[tbl Seaport#Id]]
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
	* ''examples:''		* ''examples:''
	=== PortOfDischargeETA ===		=== PortOfDischargeETA ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#CT2 date]];
-	* ''examples:''	+	* ''examples:'' 02-Feb-2010
	=== PortOfDischargeATA ===		=== PortOfDischargeATA ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#CT2 date]];
-	* ''examples:''	+	* ''examples:'' 02-Feb-2010
	=== DestinationalTerminalId ===		=== DestinationalTerminalId ===
-	* ''meaning:''	+	* ''meaning:'' FRN key, see [[tbl Seaport#Id]]
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
	* ''examples:''		* ''examples:''
	=== DestinationalTerminalETA ===		=== DestinationalTerminalETA ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#CT2 date]];
-	* ''examples:''	+	* ''examples:'' 02-Feb-2010
	=== DestinationalTerminalATA ===		=== DestinationalTerminalATA ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#CT2 date]];
-	* ''examples:''	+	* ''examples:'' 02-Feb-2010
	=== DestinationReceivingAgentId ===		=== DestinationReceivingAgentId ===
-	* ''meaning:''	+	* ''meaning:'' FRN key, see [[tbl Address Transportation#Id]]
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
	* ''examples:''		* ''examples:''
	=== HouseBillComments ===		=== HouseBillComments ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#alphanumeric]]; max = 1500 chars
	* ''examples:''		* ''examples:''
Line 367:		Line 366:
	=== CustomsBrokerID ===		=== CustomsBrokerID ===
-	* ''meaning:''	+	* ''meaning:'' FRN key, see [[tbl Address Jaguar Vendor#Id]]
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
	* ''examples:''		* ''examples:''
	=== CustomsBrokerDescription ===		=== CustomsBrokerDescription ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#alphanumeric]]; max = 1500 chars
	* ''examples:''		* ''examples:''
	=== DeliveryAddressId ===		=== DeliveryAddressId ===
-	* ''meaning:''	+	* ''meaning:'' FRN key, see [[tbl Address Transportation#Id]]
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
	* ''examples:''		* ''examples:''
	=== DeliveryAddressDescription ===		=== DeliveryAddressDescription ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#alphanumeric]]; max = 1500 chars
	* ''examples:''		* ''examples:''
	=== DeliveryComments ===		=== DeliveryComments ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#alphanumeric]]; max = 1500 chars
	* ''examples:''		* ''examples:''
	=== LastFreeDay ===		=== LastFreeDay ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#CT2 date]];
-	* ''examples:''	+	* ''examples:'' 02-Feb-2010
	=== CargoLocationId ===		=== CargoLocationId ===
-	* ''meaning:''	+	* ''meaning:'' FRN key, see [[tbl Address Jaguar Vendor#Id]]
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
	* ''examples:''		* ''examples:''
	=== CargoLocationDescription ===		=== CargoLocationDescription ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#alphanumeric]]; max = 1500 chars
	* ''examples:''		* ''examples:''
	=== DeliveryTruckerId ===		=== DeliveryTruckerId ===
-	* ''meaning:''	+	* ''meaning:'' FRN key, see [[tbl Address Jaguar Vendor#Id]]
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
	* ''examples:''		* ''examples:''
	=== ImportEstimatedDeliveryDate ===		=== ImportEstimatedDeliveryDate ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#CT2 date]];
-	* ''examples:''	+	* ''examples:'' 02-Feb-2010
	=== ActualDeliveryDate ===		=== ActualDeliveryDate ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#CT2 date]];
-	* ''examples:''	+	* ''examples:'' 02-Feb-2010
	=== ArrivalNoticeComments ===		=== ArrivalNoticeComments ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#alphanumeric]]; max = 1500 chars
	* ''examples:''		* ''examples:''
Line 443:		Line 442:
	=== CustomsStatusDate ===		=== CustomsStatusDate ===
	* ''meaning:''		* ''meaning:''
-	* ''type/format:'' [[Datatypes#]];	+	* ''type/format:'' [[Datatypes#CT2 date]];
-	* ''examples:''	+	* ''examples:'' 02-Feb-2010
	=== FDAStatusId ===		=== FDAStatusId ===

---

Revision as of 18:56, 2 February 2010

Contents 1 MySQL Table Definitions 2 Related Business Object and Its Fields 2.1 OceanShipmentId 2.2 GenericShipmentId 2.3 Hazardous 2.4 HazardousNote 2.5 Freight 2.6 MoveTypeId 2.7 OriginalHouseBill 2.8 SteamshiplineId 2.9 CoLoaderOceanId 2.10 Booking 2.11 MasterBill 2.12 AMSSubmissionDate 2.13 VesselName 2.14 Voyage1 2.15 FeederVesselname 2.16 Voyage2 2.17 OriginalTerminalId 2.18 OriginalTerminalETD 2.19 OriginalTerminalATD 2.20 PortOfLoadingId 2.21 PortOfLoadingETD 2.22 PortOfLoadingATD 2.23 PortOfTransShipmentId 2.24 PortOfTransShipmentETA 2.25 PortOfTransShipmentATA 2.26 PortOfDischargeId 2.27 PortOfDischargeETA 2.28 PortOfDischargeATA 2.29 DestinationalTerminalId 2.30 DestinationalTerminalETA 2.31 DestinationalTerminalATA 2.32 DestinationReceivingAgentId 2.33 HouseBillComments 2.34 EnabledArrivalToWH 2.35 ArrivalToWarehouseDate 2.36 ItNumber 2.37 ItDate 2.38 ItLocation 2.39 CustomsBrokerID 2.40 CustomsBrokerDescription 2.41 DeliveryAddressId 2.42 DeliveryAddressDescription 2.43 DeliveryComments 2.44 LastFreeDay 2.45 CargoLocationId 2.46 CargoLocationDescription 2.47 DeliveryTruckerId 2.48 ImportEstimatedDeliveryDate 2.49 ActualDeliveryDate 2.50 ArrivalNoticeComments 2.51 OriginalBillLandingRequired 2.52 PaymentFreightChargesRequired 2.53 CustomsStatusId 2.54 CustomsStatusDate 2.55 FDAStatusId 2.56 FDAStatusDate 2.57 HouseBill 2.58 DeliveryDateTypeId 2.59 JaguarDelivery 2.60 ExportCustoms 2.61 ActualDeliveryDateEnabled

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;

Related Business Object and Its Fields

This table corresponds to Air Shipment business object.

See its fields (attributes) below.

OceanShipmentId

• 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#positive integer; exactly 1 digit
• examples: 0, 1

MoveTypeId

• meaning: FRN key, see tbl Move Type#Id
• type/format: Datatypes#positive integer; min = 1 digit; max = 10 digits
• examples:

OriginalHouseBill

• meaning:
• type/format: Datatypes#positive integer; exactly 1 digit
• examples: 0, 1

SteamshiplineId

• meaning: FRN key, see tbl Steamshipline#Id
• type/format: Datatypes#positive integer; min = 1 digit; max = 10 digits
• examples:

CoLoaderOceanId

• meaning: FRN key, see tbl Address Jaguar Vendor#Id
• type/format: Datatypes#positive integer; min = 1 digit; max = 10 digits
• examples:

Booking

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

MasterBill

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

AMSSubmissionDate

• meaning:
• type/format: Datatypes#CT2 date;
• examples: 02-Feb-2010

VesselName

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

Voyage1

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

FeederVesselname

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

Voyage2

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

OriginalTerminalId

• meaning: FRN key, see tbl Seaport#Id
• type/format: Datatypes#positive integer; min = 1 digit; max = 10 digits
• examples:

OriginalTerminalETD

• meaning:
• type/format: Datatypes#CT2 date;
• examples: 02-Feb-2010

OriginalTerminalATD

• meaning:
• type/format: Datatypes#CT2 date;
• examples: 02-Feb-2010

PortOfLoadingId

• meaning: FRN key, see tbl Seaport#Id
• type/format: Datatypes#positive integer; min = 1 digit; max = 10 digits
• examples:

PortOfLoadingETD

• meaning:
• type/format: Datatypes#CT2 date;
• examples: 02-Feb-2010

PortOfLoadingATD

• meaning:
• type/format: Datatypes#CT2 date;
• examples: 02-Feb-2010

PortOfTransShipmentId

• meaning: FRN key, see tbl Seaport#Id
• type/format: Datatypes#positive integer; min = 1 digit; max = 10 digits
• examples:

PortOfTransShipmentETA

• meaning:
• type/format: Datatypes#CT2 date;
• examples: 02-Feb-2010

PortOfTransShipmentATA

• meaning:
• type/format: Datatypes#CT2 date;
• examples: 02-Feb-2010

PortOfDischargeId

• meaning: FRN key, see tbl Seaport#Id
• type/format: Datatypes#positive integer; min = 1 digit; max = 10 digits
• examples:

PortOfDischargeETA

• meaning:
• type/format: Datatypes#CT2 date;
• examples: 02-Feb-2010

PortOfDischargeATA

• meaning:
• type/format: Datatypes#CT2 date;
• examples: 02-Feb-2010

DestinationalTerminalId

• meaning: FRN key, see tbl Seaport#Id
• type/format: Datatypes#positive integer; min = 1 digit; max = 10 digits
• examples:

DestinationalTerminalETA

• meaning:
• type/format: Datatypes#CT2 date;
• examples: 02-Feb-2010

DestinationalTerminalATA

• meaning:
• type/format: Datatypes#CT2 date;
• examples: 02-Feb-2010

DestinationReceivingAgentId

• meaning: FRN key, see tbl Address Transportation#Id
• type/format: Datatypes#positive integer; min = 1 digit; max = 10 digits
• examples:

HouseBillComments

• meaning:
• type/format: Datatypes#alphanumeric; max = 1500 chars
• 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: FRN key, see tbl Address Jaguar Vendor#Id
• type/format: Datatypes#positive integer; min = 1 digit; max = 10 digits
• examples:

CustomsBrokerDescription

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

DeliveryAddressId

• meaning: FRN key, see tbl Address Transportation#Id
• type/format: Datatypes#positive integer; min = 1 digit; max = 10 digits
• examples:

DeliveryAddressDescription

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

DeliveryComments

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

LastFreeDay

• meaning:
• type/format: Datatypes#CT2 date;
• examples: 02-Feb-2010

CargoLocationId

• meaning: FRN key, see tbl Address Jaguar Vendor#Id
• type/format: Datatypes#positive integer; min = 1 digit; max = 10 digits
• examples:

CargoLocationDescription

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

DeliveryTruckerId

• meaning: FRN key, see tbl Address Jaguar Vendor#Id
• type/format: Datatypes#positive integer; min = 1 digit; max = 10 digits
• examples:

ImportEstimatedDeliveryDate

• meaning:
• type/format: Datatypes#CT2 date;
• examples: 02-Feb-2010

ActualDeliveryDate

• meaning:
• type/format: Datatypes#CT2 date;
• examples: 02-Feb-2010

ArrivalNoticeComments

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

OriginalBillLandingRequired

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

PaymentFreightChargesRequired

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

CustomsStatusId

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

CustomsStatusDate

• meaning:
• type/format: Datatypes#CT2 date;
• examples: 02-Feb-2010

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

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

ActualDeliveryDateEnabled

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