Master

From UG

(Difference between revisions)

Jump to: navigation, search

Current revision as of 23:37, 15 November 2013

[edit] Scope

This wiki describes Master Business Object

[edit] Misc

[edit] Master Number

Master record id, counter
Numeric, starts with "M", example: "M98632"
Id | int(10)

[edit] Create Date

Date that Master has been created. Currently not displayed on tabs.
CreateDate | datetime

[edit] Master Mode of Transport

TransportModeId | int(10)
1/2/3
MASTER OCEAN ONLY

[edit] General Tab

Fields on this tab belong to Masters of all 3 modes: Air, Ocean, Trucking.

[edit] Master Shipper

Legal party that will appear on MBL and SI
Company-City // from AddrBook T11
UI: combobox
ShipperId | int(10)
MASTER TRUCKING field

[edit] Master Shipper Text

copy of #Master Shipper address
UI: textarea
ShipperDescription | varchar(1500)
MASTER TRUCKING field

[edit] Master Shipper ref

ShipperRef | varchar(20)
MASTER TRUCKING field

[edit] Master Consignee

Legal party that will appear on MBL and SI
Company-City // from AddrBook T12
UI: combobox
ConsigneeId | int(10)
MASTER TRUCKING field

[edit] Master Consignee Text

copy of #Master Consignee address
UI: textarea
ConsigneeDescripion | varchar(1500)
MASTER TRUCKING field

[edit] Master Consignee ref

ConsigneeRef | varchar(20)

[edit] Master Notify

Legal party
Company-City // from AddrBook T13
UI: combobox
NotifyId | int(10)
MASTER TRUCKING field

[edit] Master Notify Text

copy of #Master Notify address
UI: textarea
NotifyDescription | varchar(1500)
MASTER TRUCKING field

[edit] Master Origin Trucker

OriginTruckerId | int(10)
MASTER TRUCKING field

[edit] Master Destination Trucker

DestinationTruckerId | int(10)
MASTER AIR and OCEAN only

[edit] Master Pick-up

Origin door?
Company-City // from AddrBook T12
UI: combobox
PickUpId | int(10)
MASTER TRUCKING field

[edit] Master Pick-up Text

copy of #Master Pick-up address
UI: textarea
PickUpDescription | varchar(1500)
MASTER TRUCKING field

[edit] Master Pick-up Comments

PickUpComments | varchar(1500)
MASTER TRUCKING field

[edit] Master Delivery Address

Destination door
Company-City // from AddrBook
UI: combobox
DeliveryAddressId | int(10)
MASTER TRUCKING field

[edit] Master Delivery Text

copy of #Master Delivery Address address
UI: textarea
DeliveryAddressDescription | varchar(1500)
MASTER TRUCKING field

[edit] Master Delivery Comments

DeliveryComments | varchar(1500)
MASTER TRUCKING field

[edit] Master Marks/Numbers

MarksNumbers | varchar(1500)
MASTER TRUCKING field

[edit] Master Commodity Description

CommodityDescription | varchar(1500)
MASTER TRUCKING field

[edit] Total Handling Units

calculated
MASTER TRUCKING field

[edit] Total Cubic Meters

calculated
MASTER TRUCKING field

[edit] Total Gross kg

calculated
MASTER TRUCKING field

[edit] Hazardous

calculated
MASTER TRUCKING field

[edit] Details Tab

[edit] Freight Prepaid Collect

radio
| Freight | int(1)

[edit] Move Type/MBL

dropdown
MoveTypeId | int(10)

[edit] Steamshipline

UI: combobox, label: ** 4.Steamshipline:
is a master field
SteamshiplineId | int(10)

[edit] Airline

| AirlineId | int(10)

[edit] Co Loaders

| CoLoaderAirId | int(10)

[edit] Booking Num

id assigned by carrier for Booking Request
entered by operator in non EDI case
assigned automatically in EDI case
label: ** 6.Booking#:
Booking | varchar(30)

[edit] Master Bill Of Lading

MasterBillOfLoading | varchar(30)

[edit] Master Airway Bill

MasterAirwayBill            | varchar(30)     
MasterAirwayBillA           | varchar(3)     
MasterAirwayBillB           | varchar(4)    
MasterAirwayBillC           | varchar(4)

[edit] FedEx carrier ID

CRUD: Master_Details_Tab_(component)#FedEx_carrier_ID
else - see CT#FedEx_carrier_ID

[edit] AMS Submission Date

AMSSubmissionDate | date

[edit] Vessel Name

VesselName | varchar(30)

[edit] Voyage Num

Voyage1 | varchar(30)

[edit] Feeder Vessel Name

FeederVesselname | varchar(30)

[edit] Feeder Vessel Voyage Num

Voyage2 | varchar(30)

[edit] Flight One

Flight1 | varchar(30)

[edit] Flight Two

Flight2 | varchar(30)

[edit] Origin Terminal

[edit] Airport Of Departure

[edit] Origin Terminal Estimated Date

[edit] Airport Of Departure Estimated Date

[edit] Origin Terminal Actual Date

[edit] Airport Of Departure Actual Date

[edit] Port Of Loading

[edit] Port Of Loading Estimated Date

[edit] Port Of Loading Actual Date

[edit] Port Of Trans Shipment

[edit] Trans Shipment Airport

[edit] Port Of Trans Shipment Estimated Date

[edit] Trans Shipment Airport Estimated Date

[edit] Port Of Trans Shipment Actual Date

[edit] Trans Shipment Airport Actual Date

[edit] Port Of Discharge

[edit] Airport Of Destination

[edit] Port Of Discharge Estimated Date

[edit] Airport Of Destination Estimated Date

[edit] Port Of Discharge Actual Date

[edit] Airport Of Destination Actual Date

[edit] Destination Terminal

[edit] Destination Terminal Estimated Date

[edit] Destination Terminal Actual Date

[edit] Destination Receiving Agent

[edit] Cubic Meter

[edit] Total Chargeable Weight

[edit] Master Bill Of Lading Comment

[edit] Master Airway Bill Comment

[edit] Mapping Fields

[edit] DB

mysql> describe tblMasterOcean
    -> ;
+-----------------------------+---------------+------+-----+---------+----------------+
| Field                       | Type          | Null | Key | Default | Extra          |
+-----------------------------+---------------+------+-----+---------+----------------+
| Id                          | int(10)       | NO   | PRI | NULL    | auto_increment |
| MasterTypeCode              | int(10)       | NO   |     | NULL    |                |
| CreateDate                  | datetime      | NO   |     | NULL    |                |
| ShipperId                   | int(10)       | YES  | MUL | NULL    |                |
| ShipperDescription          | varchar(1500) | YES  |     | NULL    |                |
| ConsigneeId                 | int(10)       | YES  | MUL | NULL    |                |
| ConsigneeDescripion         | varchar(1500) | YES  |     | NULL    |                |
| NotifyId                    | int(10)       | YES  | MUL | NULL    |                |
| NotifyDescription           | varchar(1500) | YES  |     | NULL    |                |
| OriginTruckerId             | int(10)       | YES  | MUL | NULL    |                |
| DestinationTruckerId        | int(10)       | YES  | MUL | NULL    |                |
| ShipperRef                  | varchar(20)   | YES  |     | NULL    |                |
| ConsigneeRef                | varchar(20)   | YES  |     | NULL    |                |
| TransportModeId             | int(10)       | YES  | MUL | NULL    |                |
| PickUpId                    | int(10)       | YES  | MUL | NULL    |                |
| PickUpDescription           | varchar(1500) | YES  |     | NULL    |                |
| DeliveryAddressId           | int(10)       | YES  | MUL | NULL    |                |
| DeliveryAddressDescription  | varchar(1500) | YES  |     | NULL    |                |
| MarksNumbers                | varchar(1500) | YES  |     | NULL    |                |
| CommodityDescription        | varchar(1500) | YES  |     | NULL    |                |
| PickUpComments              | varchar(1500) | YES  |     | NULL    |                |
| DeliveryComments            | varchar(1500) | YES  |     | NULL    |                |
| Freight                     | int(1)        | YES  |     | 0       |                |
| MoveTypeId                  | int(10)       | YES  | MUL | NULL    |                |
| SteamshiplineId             | int(10)       | YES  | MUL | NULL    |                |
| CoLoaderOceanId             | int(10)       | YES  | MUL | NULL    |                |
| Booking                     | varchar(30)   | YES  |     | NULL    |                |
| MasterBillOfLoading         | 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    |                |
| PortOfTransShipmentETD      | dat| PortOfTransShipmentETD      | date          | YES  |     | NULL    |                |
| PortOfTransShipmentATD      | date          | YES  |     | NULL    |                |
| PortOfDischargeId           | int(10)       | YES  | MUL | NULL    |                |
| PortOfDischargeETD          | date          | YES  |     | NULL    |                |
| PortOfDischargeATD          | date          | YES  |     | NULL    |                |
| DestinationalTerminalId     | int(10)       | YES  | MUL | NULL    |                |
| DestinationalTerminalETD    | date          | YES  |     | NULL    |                |
| DestinationalTerminalATD    | date          | YES  |     | NULL    |                |
| DestinationReceivingAgentId | int(10)       | YES  | MUL | NULL    |                |
| MasterBillComments          | varchar(1500) | YES  |     | NULL    |                |
| AirlineId                   | int(10)       | YES  | MUL | NULL    |                |
| CoLoaderAirId               | int(10)       | YES  | MUL | NULL    |                |
| MasterAirwayBill            | varchar(30)   | YES  |     | NULL    |                |
| MasterAirwayBillA           | varchar(3)    | YES  |     | NULL    |                |
| MasterAirwayBillB           | varchar(4)    | YES  |     | NULL    |                |
| MasterAirwayBillC           | varchar(4)    | YES  |     | NULL    |                |
| MasterAirwayBillComment     | varchar(1500) | YES  |     | NULL    |                |
| Flight1                     | varchar(30)   | YES  |     | NULL    |                |
| Flight2                     | varchar(30)   | YES  |     | NULL    |                |
| AirportOfDepartureId        | int(10)       | YES  | MUL | NULL    |                |
| AirportOfDepartureETD       | date          | YES  |     | NULL    |                |
| AirportOfDepartureATD       | date          | YES  |     | NULL    |                |
| TransShipmentAirportId      | int(10)       | YES  | MUL | NULL    |                |
| TransShipmentAirportETA     | date          | YES  |     | NULL    |                |
| TransShipmentAirportATA     | date          | YES  |     | NULL    |                |
| AirportOfDestinationId      | int(10)       | YES  | MUL | NULL    |                |
| AirportOfDestinationETA     | date          | YES  |     | NULL    |                |
| AirportOfDestinationATA     | date          | YES  |     | NULL    |                |
| FedexId                     | varchar(50)   | YES  |     | NULL    |                |
| TransmitLog                 | varchar(1500) | YES  |     | NULL    |                |
| UploadedManifest            | bit(1)        | NO   |     | b'0'    |                |
| GeneratedInvoices           | bit(1)        | NO   |     | b'0'    |                |
| SentToTrendsetInvoices      | bit(1)        | NO   |     | b'0'    |                |
+-----------------------------+---------------+------+-----+---------+----------------+
73 rows in set (0.01 sec)


mysql> show create table tblMasterOcean;

| tblMasterOcean | CREATE TABLE `tblMasterOcean` (
  `Id` int(10) NOT NULL AUTO_INCREMENT,
  `MasterTypeCode` int(10) NOT NULL,
  `CreateDate` datetime NOT NULL,
  `ShipperId` int(10) DEFAULT NULL,
  `ShipperDescription` varchar(1500) DEFAULT NULL,
  `ConsigneeId` int(10) DEFAULT NULL,
  `ConsigneeDescripion` varchar(1500) DEFAULT NULL,
  `NotifyId` int(10) DEFAULT NULL,
  `NotifyDescription` varchar(1500) DEFAULT NULL,
  `OriginTruckerId` int(10) DEFAULT NULL,
  `DestinationTruckerId` int(10) DEFAULT NULL,
  `ShipperRef` varchar(20) DEFAULT NULL,
  `ConsigneeRef` varchar(20) DEFAULT NULL,
  `TransportModeId` int(10) DEFAULT NULL,
  `PickUpId` int(10) DEFAULT NULL,
  `PickUpDescription` varchar(1500) DEFAULT NULL,
  `DeliveryAddressId` int(10) DEFAULT NULL,
  `DeliveryAddressDescription` varchar(1500) DEFAULT NULL,
  `MarksNumbers` varchar(1500) DEFAULT NULL,
  `CommodityDescription` varchar(1500) DEFAULT NULL,
  `PickUpComments` varchar(1500) DEFAULT NULL,
  `DeliveryComments` varchar(1500) DEFAULT NULL,
  `Freight` int(1) DEFAULT '0',
  `MoveTypeId` int(10) DEFAULT NULL,
  `SteamshiplineId` int(10) DEFAULT NULL,
  `CoLoaderOceanId` int(10) DEFAULT NULL,
  `Booking` varchar(30) DEFAULT NULL,
  `MasterBillOfLoading` 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,
  `PortOfTransShipmentETD` date DEFAULT NULL,
  `PortOfTransShipmentATD` date DEFAULT NULL,
  `PortOfDischargeId` int(10) DEFAULT NULL,
  `PortOfDischargeETD` date DEFAULT NULL,
  `PortOfDischargeATD` date DEFAULT NULL,
  `DestinationalTerminalId` int(10) DEFAULT NULL,
  `DestinationalTerminalETD` date DEFAULT NULL,
  `DestinationalTerminalATD` date DEFAULT NULL,
  `DestinationReceivingAgentId` int(10) DEFAULT NULL,
  `MasterBillComments` varchar(1500) DEFAULT NULL,
  `AirlineId` int(10) DEFAULT NULL,
  `CoLoaderAirId` int(10) DEFAULT NULL,
  `MasterAirwayBill` varchar(30) DEFAULT NULL,
  `MasterAirwayBillA` varchar(3) DEFAULT NULL,
  `MasterAirwayBillB` varchar(4) DEFAULT NULL,
  `MasterAirwayBillC` varchar(4) DEFAULT NULL,
  `MasterAirwayBillComment` varchar(1500) DEFAULT NULL,
  `Flight1` varchar(30) DEFAULT NULL,
  `Flight2` varchar(30) DEFAULT NULL,
  `AirportOfDepartureId` int(10) DEFAULT NULL,
  `AirportOfDepartureETD` date DEFAULT NULL,
  `AirportOfDepartureATD` date DEFAULT NULL,
  `TransShipmentAirportId` int(10) DEFAULT NULL,
  `TransShipmentAirportETA` date DEFAULT NULL,
  `TransShipmentAirportATA` date DEFAULT NULL,
  `AirportOfDestinationId` int(10) DEFAULT NULL,
  `AirportOfDestinationETA` date DEFAULT NULL,
  `AirportOfDestinationATA` date DEFAULT NULL,
  `FedexId` varchar(50) DEFAULT NULL,
  `TransmitLog` varchar(1500) DEFAULT NULL,
  `UploadedManifest` bit(1) NOT NULL DEFAULT b'0',
  `GeneratedInvoices` bit(1) NOT NULL DEFAULT b'0',
  `SentToTrendsetInvoices` bit(1) NOT NULL DEFAULT b'0',
  PRIMARY KEY (`Id`),
  KEY `ShipperId` (`ShipperId`),
  KEY `ConsigneeId` (`ConsigneeId`),
  KEY `NotifyId` (`NotifyId`),
  KEY `OriginTruckerId` (`OriginTruckerId`),
  KEY `DestinationTruckerId` (`DestinationTruckerId`),
  KEY `PickUpId` (`PickUpId`),
  KEY `DeliveryAddressId` (`DeliveryAddressId`),
  KEY `TransportModeId` (`TransportModeId`),
  KEY `tblMasterOcean_ibfk_9` (`AirlineId`),
  KEY `tblMasterOcean_ibfk_10` (`CoLoaderAirId`),
  KEY `tblMasterOcean_ibfk_11` (`AirportOfDepartureId`),
  KEY `tblMasterOcean_ibfk_12` (`TransShipmentAirportId`),
  KEY `tblMasterOcean_ibfk_13` (`AirportOfDestinationId`),
  KEY `tblMasterOcean_ibfk_14` (`CoLoaderOceanId`),
  KEY `tblMasterOcean_ibfk_15` (`DestinationReceivingAgentId`),
  KEY `tblMasterOcean_ibfk_16` (`MoveTypeId`),
  KEY `tblMasterOcean_ibfk_17` (`SteamshiplineId`),
  KEY `tblMasterOcean_ibfk_18` (`OriginalTerminalId`),
  KEY `tblMasterOcean_ibfk_19` (`PortOfLoadingId`),
  KEY `tblMasterOcean_ibfk_20` (`PortOfTransShipmentId`),
  KEY `tblMasterOcean_ibfk_21` (`PortOfDischargeId`),
  KEY `tblMasterOcean_ibfk_22` (`DestinationalTerminalId`),
  CONSTRAINT `tblMasterOcean_ibfk_1` FOREIGN KEY (`ShipperId`) REFERENCES `tblAddressTransportation` (`Id`),
  CONSTRAINT `tblMasterOcean_ibfk_10` FOREIGN KEY (`CoLoaderAirId`) REFERENCES `tblAddressJaguarVendor` (`Id`),
mysql>

[edit] Link to CRUD

See:

[edit] Misc

[edit] Text from body of Master Ocean Details tab

1) Orange fields (also marked with '**') are Common fields for Indiv CT and Master.

2) Master rules, meaning that If Indiv CT is assigned to Master then corresponding Common fields from Master will replace same fields in CT without warning

3) Also, following assigment of CT to a Master, Common fields become read only. Editable through Master only. Changes through Master to these fields will propagate into corresponding fields for each CT that is a part of this Master

[edit] SOWs

[edit] SOW 1

mantis: 4232

[edit] Container validations and related

1/ Add validations for the session when user sets Actual Departure Date.

Use same logic as for CT profile: CT Editor#SOW_3_Commodity_and_Container_related_validations

2/ If Actual Departure Date is set and user is trying to add container(s) OR add CTs with unassigned container(s) to Master then:

present dialog:

WARNING: 
--------
Actual Departure Date is already set. 
Adding new container(s) OR adding CT with unassigned container(s) will clear this date. 
If you proceed you need to assign at least one commodity to a new container first
and then set this date again. 
[OK] [Cancel]

If user clicks OK then:
- add container(s) OR CTs with containers
- clear Actual Departure Date (in Master - updated per Alex's SIT note)

3/ permanently hide "Contents assigned?:" column against containers in master's "master detail's" tab

@@ Line 4: / Line 4: @@
 This wiki describes Master Business Object
 == Misc ==
@@ Line 12: / Line 11: @@
 * Master record id, counter
 * Numeric, starts with "M", example: "M98632"
+* Id                          | int(10)
 === Create Date ===
-Date that Master has been created. Currently not displayed on tabs.
+* Date that Master has been created. Currently not displayed on tabs.
+* CreateDate                  | datetime
-=== Created On ===
+=== Master Mode of Transport ===
-same as [[#Create Date]]
+* TransportModeId             | int(10)
+* 1/2/3
+* MASTER OCEAN ONLY
 == General Tab ==
+Fields on this tab belong to Masters of all 3 modes: Air, Ocean, Trucking.
 === Master Shipper ===
@@ Line 28: / Line 33: @@
 * Company-City // from AddrBook T11
 * UI: combobox
+* ShipperId                   | int(10)
+* MASTER TRUCKING field
 ==== Master Shipper Text ====
@@ Line 33: / Line 40: @@
 *  copy of [[#Master Shipper]] address
 * UI: textarea
+* ShipperDescription          | varchar(1500)
+* MASTER TRUCKING field
 === Master Shipper ref ===
+*  ShipperRef                  | varchar(20)
+* MASTER TRUCKING field
 === Master Consignee ===
@@ Line 41: / Line 52: @@
 * Company-City // from AddrBook T12
 * UI: combobox
+* ConsigneeId                 | int(10)
+* MASTER TRUCKING field
 ==== Master Consignee Text ====
@@ Line 46: / Line 59: @@
 *  copy of [[#Master Consignee]] address
 * UI: textarea
+* ConsigneeDescripion         | varchar(1500)
+* MASTER TRUCKING field
 === Master Consignee ref ===
+* ConsigneeRef                | varchar(20)
 === Master Notify ===
@@ Line 54: / Line 70: @@
 * Company-City // from AddrBook T13
 * UI: combobox
+* NotifyId                    | int(10)
+* MASTER TRUCKING field
 ==== Master Notify Text ====
@@ Line 59: / Line 77: @@
 *   copy of [[#Master Notify]] address
 * UI: textarea
+* NotifyDescription           | varchar(1500)
+* MASTER TRUCKING field
 === Master Origin Trucker ===
+* OriginTruckerId             | int(10)
+* MASTER TRUCKING field
 === Master Destination Trucker ===
+* DestinationTruckerId        | int(10)
-=== Master Mode of Transport ===
+* MASTER AIR and OCEAN only
 === Master Pick-up ===
@@ Line 73: / Line 94: @@
 * Company-City // from AddrBook T12
 * UI: combobox
+* PickUpId                    | int(10)
+* MASTER TRUCKING field
 ==== Master Pick-up Text ====
@@ Line 78: / Line 101: @@
 *  copy of [[#Master Pick-up]] address
 * UI: textarea
+* PickUpDescription           | varchar(1500)
+* MASTER TRUCKING field
 === Master Pick-up Comments ===
+* PickUpComments              | varchar(1500)
+* MASTER TRUCKING field
 === Master Delivery Address ===
@@ Line 87: / Line 113: @@
 * Company-City // from AddrBook
 * UI: combobox
+* DeliveryAddressId           | int(10)
+* MASTER TRUCKING field
 ==== Master Delivery Text ====
@@ Line 92: / Line 120: @@
 *  copy of [[#Master Delivery Address]] address
 * UI: textarea
+* DeliveryAddressDescription  | varchar(1500)
+* MASTER TRUCKING field
 === Master Delivery Comments ===
+* DeliveryComments            | varchar(1500)
+* MASTER TRUCKING field
 === Master Marks/Numbers ===
+* MarksNumbers                | varchar(1500)
+* MASTER TRUCKING field
 === Master Commodity Description ===
+* CommodityDescription        | varchar(1500)
+* MASTER TRUCKING field
+=== Total Handling Units ===
+* calculated
+* MASTER TRUCKING field
-=== Total Handling Units(readonly) ===
+=== Total Cubic Meters ===
+* calculated
+* MASTER TRUCKING field
-=== Total Cubic Meters(readonly) ===
-=== Total Gross kg(readonly)  ===
+=== Total Gross kg  ===
+* calculated
+* MASTER TRUCKING field
 === Hazardous ===
+* calculated
+* MASTER TRUCKING field
 == Details Tab ==
 === Freight Prepaid Collect ===
+* radio
+* | Freight                     | int(1)
 === Move Type/MBL ===
+* dropdown
+* MoveTypeId                  | int(10)
 === Steamshipline  ===
@@ Line 123: / Line 166: @@
 * UI: combobox, label: ** 4.Steamshipline:
 * is a '''master field'''
+* SteamshiplineId             | int(10)
-=== Airline ===
+=== Airline ===
+* | AirlineId                   | int(10)
 === Co Loaders ===
+* | CoLoaderAirId               | int(10)
 === Booking Num ===
@@ Line 132: / Line 180: @@
 * assigned automatically in EDI case
 * label: ** 6.Booking#:
+* Booking                     | varchar(30)
 === Master Bill Of Lading ===
+* MasterBillOfLoading         | varchar(30)
 === Master Airway Bill ===
+ MasterAirwayBill            | varchar(30)
+ MasterAirwayBillA           | varchar(3)
+ MasterAirwayBillB           | varchar(4)
+ MasterAirwayBillC           | varchar(4)
 === FedEx carrier ID ===
 * ''CRUD:'' [[Master_Details_Tab_(component)#FedEx_carrier_ID]]
 * else - see [[CT#FedEx_carrier_ID]]
 === AMS Submission Date  ===
-=== Vessel Name ===
+* AMSSubmissionDate           | date
-=== Voyage Num  ===
-=== Flight One ===
+=== Vessel Name ===
+* VesselName                  | varchar(30)
+=== Voyage Num  ===
+* Voyage1                     | varchar(30)
 === Feeder Vessel Name ===
+* FeederVesselname            | varchar(30)
 === Feeder Vessel Voyage Num  ===
+* Voyage2                     | varchar(30)
+=== Flight One ===
+* Flight1                     | varchar(30)
 === Flight Two ===
+* Flight2                     | varchar(30)
 === Origin Terminal ===
 === Airport Of Departure ===
@@ Line 262: / Line 334: @@
 +-----------------------------+---------------+------+-----+---------+----------------+
 rows in set (0.01 sec)
+mysql> show create table tblMasterOcean;
+| tblMasterOcean | CREATE TABLE `tblMasterOcean` (
+  `Id` int(10) NOT NULL AUTO_INCREMENT,
+  `MasterTypeCode` int(10) NOT NULL,
+  `CreateDate` datetime NOT NULL,
+  `ShipperId` int(10) DEFAULT NULL,
+  `ShipperDescription` varchar(1500) DEFAULT NULL,
+  `ConsigneeId` int(10) DEFAULT NULL,
+  `ConsigneeDescripion` varchar(1500) DEFAULT NULL,
+  `NotifyId` int(10) DEFAULT NULL,
+  `NotifyDescription` varchar(1500) DEFAULT NULL,
+  `OriginTruckerId` int(10) DEFAULT NULL,
+  `DestinationTruckerId` int(10) DEFAULT NULL,
+  `ShipperRef` varchar(20) DEFAULT NULL,
+  `ConsigneeRef` varchar(20) DEFAULT NULL,
+  `TransportModeId` int(10) DEFAULT NULL,
+  `PickUpId` int(10) DEFAULT NULL,
+  `PickUpDescription` varchar(1500) DEFAULT NULL,
+  `DeliveryAddressId` int(10) DEFAULT NULL,
+  `DeliveryAddressDescription` varchar(1500) DEFAULT NULL,
+  `MarksNumbers` varchar(1500) DEFAULT NULL,
+  `CommodityDescription` varchar(1500) DEFAULT NULL,
+  `PickUpComments` varchar(1500) DEFAULT NULL,
+  `DeliveryComments` varchar(1500) DEFAULT NULL,
+  `Freight` int(1) DEFAULT '0',
+  `MoveTypeId` int(10) DEFAULT NULL,
+  `SteamshiplineId` int(10) DEFAULT NULL,
+  `CoLoaderOceanId` int(10) DEFAULT NULL,
+  `Booking` varchar(30) DEFAULT NULL,
+  `MasterBillOfLoading` 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,
+  `PortOfTransShipmentETD` date DEFAULT NULL,
+  `PortOfTransShipmentATD` date DEFAULT NULL,
+  `PortOfDischargeId` int(10) DEFAULT NULL,
+  `PortOfDischargeETD` date DEFAULT NULL,
+  `PortOfDischargeATD` date DEFAULT NULL,
+  `DestinationalTerminalId` int(10) DEFAULT NULL,
+  `DestinationalTerminalETD` date DEFAULT NULL,
+  `DestinationalTerminalATD` date DEFAULT NULL,
+  `DestinationReceivingAgentId` int(10) DEFAULT NULL,
+  `MasterBillComments` varchar(1500) DEFAULT NULL,
+  `AirlineId` int(10) DEFAULT NULL,
+  `CoLoaderAirId` int(10) DEFAULT NULL,
+  `MasterAirwayBill` varchar(30) DEFAULT NULL,
+  `MasterAirwayBillA` varchar(3) DEFAULT NULL,
+  `MasterAirwayBillB` varchar(4) DEFAULT NULL,
+  `MasterAirwayBillC` varchar(4) DEFAULT NULL,
+  `MasterAirwayBillComment` varchar(1500) DEFAULT NULL,
+  `Flight1` varchar(30) DEFAULT NULL,
+  `Flight2` varchar(30) DEFAULT NULL,
+  `AirportOfDepartureId` int(10) DEFAULT NULL,
+  `AirportOfDepartureETD` date DEFAULT NULL,
+  `AirportOfDepartureATD` date DEFAULT NULL,
+  `TransShipmentAirportId` int(10) DEFAULT NULL,
+  `TransShipmentAirportETA` date DEFAULT NULL,
+  `TransShipmentAirportATA` date DEFAULT NULL,
+  `AirportOfDestinationId` int(10) DEFAULT NULL,
+  `AirportOfDestinationETA` date DEFAULT NULL,
+  `AirportOfDestinationATA` date DEFAULT NULL,
+  `FedexId` varchar(50) DEFAULT NULL,
+  `TransmitLog` varchar(1500) DEFAULT NULL,
+  `UploadedManifest` bit(1) NOT NULL DEFAULT b'0',
+  `GeneratedInvoices` bit(1) NOT NULL DEFAULT b'0',
+  `SentToTrendsetInvoices` bit(1) NOT NULL DEFAULT b'0',
+  PRIMARY KEY (`Id`),
+  KEY `ShipperId` (`ShipperId`),
+  KEY `ConsigneeId` (`ConsigneeId`),
+  KEY `NotifyId` (`NotifyId`),
+  KEY `OriginTruckerId` (`OriginTruckerId`),
+  KEY `DestinationTruckerId` (`DestinationTruckerId`),
+  KEY `PickUpId` (`PickUpId`),
+  KEY `DeliveryAddressId` (`DeliveryAddressId`),
+  KEY `TransportModeId` (`TransportModeId`),
+  KEY `tblMasterOcean_ibfk_9` (`AirlineId`),
+  KEY `tblMasterOcean_ibfk_10` (`CoLoaderAirId`),
+  KEY `tblMasterOcean_ibfk_11` (`AirportOfDepartureId`),
+  KEY `tblMasterOcean_ibfk_12` (`TransShipmentAirportId`),
+  KEY `tblMasterOcean_ibfk_13` (`AirportOfDestinationId`),
+  KEY `tblMasterOcean_ibfk_14` (`CoLoaderOceanId`),
+  KEY `tblMasterOcean_ibfk_15` (`DestinationReceivingAgentId`),
+  KEY `tblMasterOcean_ibfk_16` (`MoveTypeId`),
+  KEY `tblMasterOcean_ibfk_17` (`SteamshiplineId`),
+  KEY `tblMasterOcean_ibfk_18` (`OriginalTerminalId`),
+  KEY `tblMasterOcean_ibfk_19` (`PortOfLoadingId`),
+  KEY `tblMasterOcean_ibfk_20` (`PortOfTransShipmentId`),
+  KEY `tblMasterOcean_ibfk_21` (`PortOfDischargeId`),
+  KEY `tblMasterOcean_ibfk_22` (`DestinationalTerminalId`),
+  CONSTRAINT `tblMasterOcean_ibfk_1` FOREIGN KEY (`ShipperId`) REFERENCES `tblAddressTransportation` (`Id`),
+  CONSTRAINT `tblMasterOcean_ibfk_10` FOREIGN KEY (`CoLoaderAirId`) REFERENCES `tblAddressJaguarVendor` (`Id`),
+mysql>
 </pre>