Master

From UG

(Difference between revisions)
Jump to: navigation, search
(Created page with 'Category:Master profile == Scope == This wiki describes Master Business Object == General Fields == === Create Date === Date that Master has been created. Currently not…')
(→Master Destination Trucker)
 
(40 intermediate revisions not shown)
Line 5: Line 5:
This wiki describes Master Business Object
This wiki describes Master Business Object
 +
== Misc ==
-
== General Fields ==
+
=== Master Number ===
 +
 
 +
* Master record id, counter
 +
* Numeric, starts with "M", example: "M98632"
 +
* Id                          | int(10) 
=== Create Date ===
=== 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 ===
=== Master Shipper ===
-
* ''Meaning:'' [[TBD]]
+
* Legal party that will appear on MBL and SI
-
* ''Format/type:'' [[TBD]]
+
* Company-City // from AddrBook T11
-
* ''Examples:'' [[TBD]]
+
* UI: combobox
-
* ''MOT:'' All
+
* ShipperId                  | int(10)
-
* ''DB:'' [[TBD]]
+
* MASTER TRUCKING field
-
* ''CRUD:'' [[Master General#Master Shipper]]
+
 
 +
==== Master Shipper Text ====
 +
 
 +
* copy of [[#Master Shipper]] address
 +
* UI: textarea
 +
* ShipperDescription          | varchar(1500)
 +
* MASTER TRUCKING field
=== Master Shipper ref ===
=== Master Shipper ref ===
 +
*  ShipperRef                  | varchar(20)
 +
* MASTER TRUCKING field
=== Master Consignee ===
=== 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 ===
=== Master Consignee ref ===
 +
* ConsigneeRef                | varchar(20)
=== Master Notify ===
=== 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 ===
=== Master Origin Trucker ===
 +
* OriginTruckerId            | int(10)
 +
* MASTER TRUCKING field
=== Master Destination Trucker ===
=== Master Destination Trucker ===
-
=== Master Mode of Transport ===
+
* DestinationTruckerId        | int(10)
 +
* MASTER AIR and OCEAN only
=== Master Pick-up ===
=== 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 ===
=== Master Pick-up Comments ===
 +
* PickUpComments              | varchar(1500)
 +
* MASTER TRUCKING field
=== Master Delivery Address ===
=== 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 ===
=== Master Delivery Comments ===
 +
* DeliveryComments            | varchar(1500)
 +
* MASTER TRUCKING field
=== Master Marks/Numbers ===
=== Master Marks/Numbers ===
 +
* MarksNumbers                | varchar(1500)
 +
* MASTER TRUCKING field
=== Master Commodity Description ===
=== Master Commodity Description ===
 +
* 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
-
* ''Meaning:'' [[TBD]]
+
== Details Tab ==
-
* ''Format/type:'' [[TBD]]
+
-
* ''Examples:'' [[TBD]]
+
-
* ''MOT:'' [[TBD]]
+
-
* ''DB:'' [[TBD]]
+
-
* ''CRUD:'' [[TBD]]
+
 +
=== Freight Prepaid Collect === 
-
== Details Fields '''(need to edit)''' ==
+
* radio
-
 
+
* | Freight                    | int(1)  
-
=== Freight Prepaid Collect === 
+
=== Move Type/MBL === 
=== Move Type/MBL === 
 +
* dropdown
 +
* MoveTypeId                  | int(10)
-
=== Original House Bill Yes No ===
+
=== Steamshipline ===  
-
=== Steamshipline  === 
+
 
-
=== Airline ===
+
* UI: combobox, label: ** 4.Steamshipline:
 +
* is a '''master field'''
 +
* SteamshiplineId            | int(10)  
 +
 
 +
=== Airline ===
 +
* | AirlineId                  | int(10) 
 +
=== Co Loaders === 
=== Co Loaders === 
-
=== Booking Num ===
+
* | CoLoaderAirId              | int(10) 
-
=== HAWB === 
+
 
-
=== MBL === 
+
=== Booking Num ===
-
=== MAWB ===
+
 
-
=== HBL ===
+
* id assigned by carrier for Booking Request
-
=== AMS Submission Date  ===
+
* entered by operator in non EDI case
-
=== Vessel Name === 
+
* assigned automatically in EDI case
-
=== Voyage Num  ===
+
* label: ** 6.Booking#:
-
=== Flight One === 
+
* 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  ===
 +
* AMSSubmissionDate          | date
 +
 +
=== Vessel Name ===  
 +
* VesselName                  | varchar(30)
 +
 
 +
=== Voyage Num  ===
 +
* Voyage1                    | varchar(30)
 +
 
=== Feeder Vessel Name === 
=== Feeder Vessel Name === 
 +
* FeederVesselname            | varchar(30)
 +
=== Feeder Vessel Voyage Num  === 
=== Feeder Vessel Voyage Num  === 
 +
* Voyage2                    | varchar(30)
 +
 +
=== Flight One === 
 +
* Flight1                    | varchar(30)
 +
=== Flight Two === 
=== Flight Two === 
 +
* Flight2                    | varchar(30)
 +
=== Origin Terminal === 
=== Origin Terminal === 
 +
=== Airport Of Departure === 
=== Origin Terminal Estimated Date === 
=== Origin Terminal Estimated Date === 
 +
=== Airport Of Departure Estimated Date === 
=== Origin Terminal Actual Date  === 
=== Origin Terminal Actual Date  === 
 +
=== Airport Of Departure Actual Date  === 
=== Port Of Loading  === 
=== Port Of Loading  === 
-
=== Airport Of Departure === 
 
=== Port Of Loading Estimated Date  === 
=== Port Of Loading Estimated Date  === 
-
=== Airport Of Departure Estimated Date === 
 
=== Port Of Loading Actual Date  ===   
=== Port Of Loading Actual Date  ===   
-
=== Airport Of Departure Actual Date  ===
+
=== Port Of Trans Shipment ===
-
=== Trans Shipment === 
+
=== Trans Shipment Airport === 
-
=== Trans Shipment Estimated Date === 
+
=== Port Of Trans Shipment Estimated Date === 
-
=== Trans Shipment Actual Date  === 
+
=== Trans Shipment Airport Estimated Date === 
 +
=== Port Of Trans Shipment Actual Date  === 
 +
=== Trans Shipment Airport Actual Date  === 
=== Port Of Discharge  ===   
=== Port Of Discharge  ===   
=== Airport Of Destination === 
=== Airport Of Destination === 
Line 109: Line 242:
=== Destination Terminal Estimated Date === 
=== Destination Terminal Estimated Date === 
=== Destination Terminal Actual Date  === 
=== Destination Terminal Actual Date  === 
-
=== Destination Receiving Agent combobox === 
+
=== Destination Receiving Agent === 
-
=== Cubic Meter textbox ===
+
=== Cubic Meter ===
-
=== Chargeable Weight textbox ===
+
=== Total Chargeable Weight ===
-
=== HBL Comment === 
+
=== Master Bill Of Lading Comment === 
-
=== HAWB Comment ===
+
=== Master Airway Bill Comment ===
-
=== Export Customs Information ===
+
-
 
+
== Mapping Fields ==
== Mapping Fields ==
 +
 +
== DB ==
 +
 +
<pre>
 +
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>
 +
 +
</pre>
== Link to CRUD ==
== Link to CRUD ==
Line 127: Line 448:
* [[Master Details]]
* [[Master Details]]
* [[Master Mapping]]
* [[Master Mapping]]
 +
 +
== 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

Current revision as of 23:37, 15 November 2013


Contents

[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

[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

Retrieved from "https://wiki.jaguarfreight.com/Master"
Personal tools