Master
From UG
(Difference between revisions)
(→Booking Num) |
|||
| Line 4: | Line 4: | ||
This wiki describes Master Business Object | This wiki describes Master Business Object | ||
| - | |||
== Misc == | == Misc == | ||
| Line 16: | Line 15: | ||
Date that Master has been created. Currently not displayed on tabs. | Date that Master has been created. Currently not displayed on tabs. | ||
| + | |||
| + | DB: CreateDate | ||
=== Created On === | === Created On === | ||
Revision as of 21:27, 15 November 2013
Scope
This wiki describes Master Business Object
Misc
Master Number
- Master record id, counter
- Numeric, starts with "M", example: "M98632"
Create Date
Date that Master has been created. Currently not displayed on tabs.
DB: CreateDate
Created On
same as #Create Date
General Tab
Master Shipper
- Legal party that will appear on MBL and SI
- Company-City // from AddrBook T11
- UI: combobox
Master Shipper Text
- copy of #Master Shipper address
- UI: textarea
Master Shipper ref
Master Consignee
- Legal party that will appear on MBL and SI
- Company-City // from AddrBook T12
- UI: combobox
Master Consignee Text
- copy of #Master Consignee address
- UI: textarea
Master Consignee ref
Master Notify
- Legal party
- Company-City // from AddrBook T13
- UI: combobox
Master Notify Text
- copy of #Master Notify address
- UI: textarea
Master Origin Trucker
Master Destination Trucker
Master Mode of Transport
Master Pick-up
- Origin door?
- Company-City // from AddrBook T12
- UI: combobox
Master Pick-up Text
- copy of #Master Pick-up address
- UI: textarea
Master Pick-up Comments
Master Delivery Address
- Destination door
- Company-City // from AddrBook
- UI: combobox
Master Delivery Text
- copy of #Master Delivery Address address
- UI: textarea
Master Delivery Comments
Master Marks/Numbers
Master Commodity Description
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
