Ocean tbl

From UG

(Difference between revisions)
Jump to: navigation, search
Line 1: Line 1:
[[Category:Shipment Data Objects]]
[[Category:Shipment Data Objects]]
 +
 +
== Related bo wiki ==
 +
[[CT bo]]
== MySQL Table Definitions  ==
== MySQL Table Definitions  ==

Revision as of 19:13, 3 February 2010


Contents

Related bo wiki

CT bo

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

Hazardous

HazardousNote

Freight

MoveTypeId

OriginalHouseBill

SteamshiplineId

CoLoaderOceanId

Booking

MasterBill

AMSSubmissionDate

VesselName

Voyage1

FeederVesselname

Voyage2

OriginalTerminalId

OriginalTerminalETD

OriginalTerminalATD

PortOfLoadingId

PortOfLoadingETD

PortOfLoadingATD

PortOfTransShipmentId

PortOfTransShipmentETA

PortOfTransShipmentATA

PortOfDischargeId

PortOfDischargeETA

PortOfDischargeATA

DestinationalTerminalId

DestinationalTerminalETA

DestinationalTerminalATA

DestinationReceivingAgentId

HouseBillComments

EnabledArrivalToWH

ArrivalToWarehouseDate

ItNumber

ItDate

ItLocation

CustomsBrokerID

CustomsBrokerDescription

DeliveryAddressId

DeliveryAddressDescription

DeliveryComments

LastFreeDay

CargoLocationId

CargoLocationDescription

DeliveryTruckerId

ImportEstimatedDeliveryDate

ActualDeliveryDate

ArrivalNoticeComments

OriginalBillLandingRequired

PaymentFreightChargesRequired

CustomsStatusId

CustomsStatusDate

FDAStatusId

FDAStatusDate

HouseBill

DeliveryDateTypeId

JaguarDelivery

ExportCustoms

ActualDeliveryDateEnabled

Personal tools