Ocean tbl

From UG

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#;
• examples:

MoveTypeId

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

OriginalHouseBill

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

SteamshiplineId

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

CoLoaderOceanId

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

Booking

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

MasterBill

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

AMSSubmissionDate

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

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:
• type/format: Datatypes#;
• examples:

OriginalTerminalETD

• 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

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

PortOfDischargeETA

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

PortOfDischargeATA

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

DestinationalTerminalId

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

DestinationalTerminalETA

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

DestinationalTerminalATA

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

DestinationReceivingAgentId

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

HouseBillComments

• 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:

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

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

ActualDeliveryDateEnabled

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