Ocean tbl

From UG

Revision as of 18:56, 2 February 2010 (edit) Andrei (Talk | contribs) ← Older edit		Revision as of 19:13, 3 February 2010 (edit) (undo) Alex (Talk | contribs) Newer edit →
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 1 Related bo wiki 2 MySQL Table Definitions 3 Related Business Object and Its Fields 3.1 OceanShipmentId 3.2 GenericShipmentId 3.3 Hazardous 3.4 HazardousNote 3.5 Freight 3.6 MoveTypeId 3.7 OriginalHouseBill 3.8 SteamshiplineId 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 OriginalTerminalId 3.18 OriginalTerminalETD 3.19 OriginalTerminalATD 3.20 PortOfLoadingId 3.21 PortOfLoadingETD 3.22 PortOfLoadingATD 3.23 PortOfTransShipmentId 3.24 PortOfTransShipmentETA 3.25 PortOfTransShipmentATA 3.26 PortOfDischargeId 3.27 PortOfDischargeETA 3.28 PortOfDischargeATA 3.29 DestinationalTerminalId 3.30 DestinationalTerminalETA 3.31 DestinationalTerminalATA 3.32 DestinationReceivingAgentId 3.33 HouseBillComments 3.34 EnabledArrivalToWH 3.35 ArrivalToWarehouseDate 3.36 ItNumber 3.37 ItDate 3.38 ItLocation 3.39 CustomsBrokerID 3.40 CustomsBrokerDescription 3.41 DeliveryAddressId 3.42 DeliveryAddressDescription 3.43 DeliveryComments 3.44 LastFreeDay 3.45 CargoLocationId 3.46 CargoLocationDescription 3.47 DeliveryTruckerId 3.48 ImportEstimatedDeliveryDate 3.49 ActualDeliveryDate 3.50 ArrivalNoticeComments 3.51 OriginalBillLandingRequired 3.52 PaymentFreightChargesRequired 3.53 CustomsStatusId 3.54 CustomsStatusDate 3.55 FDAStatusId 3.56 FDAStatusDate 3.57 HouseBill 3.58 DeliveryDateTypeId 3.59 JaguarDelivery 3.60 ExportCustoms 3.61 ActualDeliveryDateEnabled

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

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