Master
From UG
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 Shipper Text
- copy of #Master Shipper address
- UI: textarea
- ShipperDescription | varchar(1500)
Master Shipper ref
- ShipperRef | varchar(20)
Master Consignee
- Legal party that will appear on MBL and SI
- Company-City // from AddrBook T12
- UI: combobox
- ConsigneeId | int(10)
Master Consignee Text
- copy of #Master Consignee address
- UI: textarea
- ConsigneeDescripion | varchar(1500)
Master Consignee ref
- ConsigneeRef | varchar(20)
Master Notify
- Legal party
- Company-City // from AddrBook T13
- UI: combobox
- NotifyId | int(10)
Master Notify Text
- copy of #Master Notify address
- UI: textarea
- NotifyDescription | varchar(1500)
Master Origin Trucker
- OriginTruckerId | int(10)
Master Destination Trucker
- DestinationTruckerId | int(10)
Master Mode of Transport
- TransportModeId | int(10)
Master Pick-up
- Origin door?
- Company-City // from AddrBook T12
- UI: combobox
- PickUpId | int(10)
Master Pick-up Text
- copy of #Master Pick-up address
- UI: textarea
- PickUpDescription | varchar(1500)
Master Pick-up Comments
- PickUpComments | varchar(1500)
Master Delivery Address
- Destination door
- Company-City // from AddrBook
- UI: combobox
- DeliveryAddressId | int(10)
Master Delivery Text
- copy of #Master Delivery Address address
- UI: textarea
- DeliveryAddressDescription | varchar(1500)
Master Delivery Comments
- DeliveryComments | varchar(1500)
Master Marks/Numbers
- MarksNumbers | varchar(1500)
Master Commodity Description
- CommodityDescription | varchar(1500)
Total Handling Units(readonly)
Total Cubic Meters(readonly)
Total Gross kg(readonly)
Hazardous
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
- CRUD: Master_Details_Tab_(component)#FedEx_carrier_ID
- else - see CT#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)
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
