Master
From UG
(Difference between revisions)
(→Details Tab) |
|||
| Line 12: | Line 12: | ||
* Numeric, starts with "M", example: "M98632" | * Numeric, starts with "M", example: "M98632" | ||
* Id | int(10) | * Id | int(10) | ||
| - | |||
=== Create Date === | === Create Date === | ||
| Line 18: | Line 17: | ||
* Date that Master has been created. Currently not displayed on tabs. | * Date that Master has been created. Currently not displayed on tabs. | ||
* CreateDate | datetime | * CreateDate | datetime | ||
| - | * MASTER | + | |
| + | === Master Mode of Transport === | ||
| + | |||
| + | * TransportModeId | int(10) | ||
| + | * 1/2/3 | ||
| + | * MASTER OCEAN ONLY | ||
== General Tab == | == General Tab == | ||
| + | |||
| + | Fields on this tab belong to Masters of all 3 modes: Air, Ocean, Trucking. | ||
=== Master Shipper === | === Master Shipper === | ||
| Line 80: | Line 86: | ||
=== Master Destination Trucker === | === Master Destination Trucker === | ||
* DestinationTruckerId | int(10) | * DestinationTruckerId | int(10) | ||
| - | |||
| - | |||
| - | |||
| - | |||
=== Master Pick-up === | === Master Pick-up === | ||
Revision as of 23:34, 15 November 2013
Scope
This wiki describes Master Business Object
Misc
Master Number
- 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.
- CreateDate | datetime
Master Mode of Transport
- 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
- 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 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
- radio
- | Freight | int(1)
Move Type/MBL
- dropdown
- MoveTypeId | int(10)
Steamshipline
- UI: combobox, label: ** 4.Steamshipline:
- is a master field
- SteamshiplineId | int(10)
Airline
- | AirlineId | int(10)
Co Loaders
- | CoLoaderAirId | int(10)
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)
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
- 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
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
