Ocean tbl

From UG

(Difference between revisions)
Jump to: navigation, search
 
(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

[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

Personal tools