Master

From UG

(Difference between revisions)
Jump to: navigation, search
(DB)
(General Tab)
Line 28: Line 28:
* UI: combobox
* UI: combobox
* ShipperId                  | int(10)
* ShipperId                  | int(10)
 +
* MASTER TRUCKING field
==== Master Shipper Text ====
==== Master Shipper Text ====
Line 34: Line 35:
* UI: textarea
* UI: textarea
* ShipperDescription          | varchar(1500)
* ShipperDescription          | varchar(1500)
 +
* MASTER TRUCKING field
=== Master Shipper ref ===
=== Master Shipper ref ===
*  ShipperRef                  | varchar(20)  
*  ShipperRef                  | varchar(20)  
 +
* MASTER TRUCKING field
=== Master Consignee ===
=== Master Consignee ===
Line 44: Line 47:
* UI: combobox
* UI: combobox
* ConsigneeId                | int(10)   
* ConsigneeId                | int(10)   
 +
* MASTER TRUCKING field
==== Master Consignee Text ====
==== Master Consignee Text ====
Line 50: Line 54:
* UI: textarea
* UI: textarea
* ConsigneeDescripion        | varchar(1500)
* ConsigneeDescripion        | varchar(1500)
 +
* MASTER TRUCKING field
=== Master Consignee ref ===
=== Master Consignee ref ===
Line 60: Line 65:
* UI: combobox
* UI: combobox
* NotifyId                    | int(10)   
* NotifyId                    | int(10)   
 +
* MASTER TRUCKING field
==== Master Notify Text ====
==== Master Notify Text ====
Line 66: Line 72:
* UI: textarea
* UI: textarea
* NotifyDescription          | varchar(1500)
* NotifyDescription          | varchar(1500)
 +
* MASTER TRUCKING field
=== Master Origin Trucker ===
=== Master Origin Trucker ===
* OriginTruckerId            | int(10)  
* OriginTruckerId            | int(10)  
 +
* MASTER TRUCKING field
=== Master Destination Trucker ===
=== Master Destination Trucker ===
Line 75: Line 83:
=== Master Mode of Transport ===
=== Master Mode of Transport ===
* TransportModeId            | int(10)  
* TransportModeId            | int(10)  
 +
* 1/2/3
=== Master Pick-up ===
=== Master Pick-up ===
Line 82: Line 91:
* UI: combobox
* UI: combobox
* PickUpId                    | int(10)   
* PickUpId                    | int(10)   
 +
* MASTER TRUCKING field
==== Master Pick-up Text ====
==== Master Pick-up Text ====
Line 88: Line 98:
* UI: textarea
* UI: textarea
* PickUpDescription          | varchar(1500)
* PickUpDescription          | varchar(1500)
 +
* MASTER TRUCKING field
=== Master Pick-up Comments ===
=== Master Pick-up Comments ===
* PickUpComments              | varchar(1500)  
* PickUpComments              | varchar(1500)  
 +
* MASTER TRUCKING field
=== Master Delivery Address ===
=== Master Delivery Address ===
Line 98: Line 110:
* UI: combobox
* UI: combobox
* DeliveryAddressId          | int(10)   
* DeliveryAddressId          | int(10)   
 +
* MASTER TRUCKING field
==== Master Delivery Text ====
==== Master Delivery Text ====
Line 104: Line 117:
* UI: textarea
* UI: textarea
* DeliveryAddressDescription  | varchar(1500)
* DeliveryAddressDescription  | varchar(1500)
 +
* MASTER TRUCKING field
=== Master Delivery Comments ===
=== Master Delivery Comments ===
* DeliveryComments            | varchar(1500)  
* DeliveryComments            | varchar(1500)  
 +
* MASTER TRUCKING field
=== Master Marks/Numbers ===
=== Master Marks/Numbers ===
* MarksNumbers                | varchar(1500)
* MarksNumbers                | varchar(1500)
 +
* MASTER TRUCKING field
=== Master Commodity Description ===
=== Master Commodity Description ===
* CommodityDescription        | varchar(1500)
* CommodityDescription        | varchar(1500)
 +
* MASTER TRUCKING field
-
=== Total Handling Units(readonly) ===
+
=== Total Handling Units ===
-
*  
+
* calculated
 +
* MASTER TRUCKING field
-
=== Total Cubic Meters(readonly) ===
+
=== Total Cubic Meters ===
-
 
+
* calculated
-
 
+
* MASTER TRUCKING field
-
 
+
-
=== Total Gross kg(readonly)  ===
+
 +
=== Total Gross kg  ===
 +
* calculated
 +
* MASTER TRUCKING field
=== Hazardous ===
=== Hazardous ===
-
*  
+
* calculated
 +
* MASTER TRUCKING field
== Details Tab ==
== Details Tab ==

Revision as of 22:02, 15 November 2013


Contents

Scope

This wiki describes Master Business Object

Misc

Master Number

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

Create Date

  • Date that Master has been created. Currently not displayed on tabs.
  • CreateDate | datetime
  • MASTER TRUCKING field

General Tab

Master Shipper

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

Master Shipper Text

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

Master Shipper ref

  • ShipperRef | varchar(20)
  • MASTER TRUCKING field

Master Consignee

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

Master Consignee Text

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

Master Consignee ref

  • ConsigneeRef | varchar(20)

Master Notify

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

Master Notify Text

  • 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

  • TransportModeId | int(10)
  • 1/2/3

Master Pick-up

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

Master Pick-up Text

  • 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

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

Master Delivery Text

  • 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 Cubic Meters

  • calculated
  • MASTER TRUCKING field

Total Gross kg

  • calculated
  • MASTER TRUCKING field

Hazardous

  • calculated
  • MASTER TRUCKING field

Details Tab

Freight Prepaid Collect

Move Type/MBL

Steamshipline

  • UI: combobox, label: ** 4.Steamshipline:
  • is a master field

Airline

Co Loaders

Booking Num

  • id assigned by carrier for Booking Request
  • entered by operator in non EDI case
  • assigned automatically in EDI case
  • label: ** 6.Booking#:

Master Bill Of Lading

Master Airway Bill

FedEx carrier ID

AMS Submission Date

Vessel Name

Voyage Num

Flight One

Feeder Vessel Name

Feeder Vessel Voyage Num

Flight Two

Origin Terminal

Airport Of Departure

Origin Terminal Estimated Date

Airport Of Departure Estimated Date

Origin Terminal Actual Date

Airport Of Departure Actual Date

Port Of Loading

Port Of Loading Estimated Date

Port Of Loading Actual Date

Port Of Trans Shipment

Trans Shipment Airport

Port Of Trans Shipment Estimated Date

Trans Shipment Airport Estimated Date

Port Of Trans Shipment Actual Date

Trans Shipment Airport Actual Date

Port Of Discharge

Airport Of Destination

Port Of Discharge Estimated Date

Airport Of Destination Estimated Date

Port Of Discharge Actual Date

Airport Of Destination Actual Date

Destination Terminal

Destination Terminal Estimated Date

Destination Terminal Actual Date

Destination Receiving Agent

Cubic Meter

Total Chargeable Weight

Master Bill Of Lading Comment

Master Airway Bill Comment

Mapping Fields

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> 

Link to CRUD

See:

Misc

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

SOWs

SOW 1

mantis: 4232

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

Personal tools