Master
From UG
(→General Tab) |
(→Details Tab) |
||
Line 149: | Line 149: | ||
== Details Tab == | == Details Tab == | ||
- | === Freight Prepaid Collect === | + | === Freight Prepaid Collect === |
+ | |||
+ | * radio | ||
+ | * | Freight | int(1) | ||
+ | |||
=== Move Type/MBL === | === Move Type/MBL === | ||
+ | * dropdown | ||
+ | * MoveTypeId | int(10) | ||
=== Steamshipline === | === Steamshipline === | ||
Line 156: | Line 162: | ||
* UI: combobox, label: ** 4.Steamshipline: | * UI: combobox, label: ** 4.Steamshipline: | ||
* is a '''master field''' | * is a '''master field''' | ||
- | + | * SteamshiplineId | int(10) | |
- | === Airline === | + | |
+ | === Airline === | ||
+ | * | AirlineId | int(10) | ||
+ | |||
=== Co Loaders === | === Co Loaders === | ||
+ | * | CoLoaderAirId | int(10) | ||
+ | |||
=== Booking Num === | === Booking Num === | ||
Line 165: | Line 176: | ||
* assigned automatically in EDI case | * assigned automatically in EDI case | ||
* label: ** 6.Booking#: | * label: ** 6.Booking#: | ||
+ | * Booking | varchar(30) | ||
=== Master Bill Of Lading === | === Master Bill Of Lading === | ||
+ | |||
+ | * MasterBillOfLoading | varchar(30) | ||
+ | |||
=== Master Airway Bill === | === Master Airway Bill === | ||
+ | |||
+ | MasterAirwayBill | varchar(30) | ||
+ | MasterAirwayBillA | varchar(3) | ||
+ | MasterAirwayBillB | varchar(4) | ||
+ | MasterAirwayBillC | varchar(4) | ||
+ | |||
=== FedEx carrier ID === | === FedEx carrier ID === | ||
* ''CRUD:'' [[Master_Details_Tab_(component)#FedEx_carrier_ID]] | * ''CRUD:'' [[Master_Details_Tab_(component)#FedEx_carrier_ID]] | ||
* else - see [[CT#FedEx_carrier_ID]] | * else - see [[CT#FedEx_carrier_ID]] | ||
- | === AMS Submission Date === | + | === AMS Submission Date === |
- | === Vessel Name === | + | * AMSSubmissionDate | date |
- | === Voyage Num === | + | |
- | + | === 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 === | === Airport Of Departure === |
Revision as of 23:10, 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)
- 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
- 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