Master
From UG
(Difference between revisions)
| Line 29: | Line 29: | ||
* Company-City // from AddrBook T11 | * Company-City // from AddrBook T11 | ||
* UI: combobox | * UI: combobox | ||
| + | * ShipperId | int(10) | ||
==== Master Shipper Text ==== | ==== Master Shipper Text ==== | ||
| Line 34: | Line 35: | ||
* copy of [[#Master Shipper]] address | * copy of [[#Master Shipper]] address | ||
* UI: textarea | * UI: textarea | ||
| + | * ShipperDescription | varchar(1500) | ||
=== Master Shipper ref === | === Master Shipper ref === | ||
| + | * ShipperRef | varchar(20) | ||
=== Master Consignee === | === Master Consignee === | ||
| Line 42: | Line 45: | ||
* Company-City // from AddrBook T12 | * Company-City // from AddrBook T12 | ||
* UI: combobox | * UI: combobox | ||
| + | * ConsigneeId | int(10) | ||
==== Master Consignee Text ==== | ==== Master Consignee Text ==== | ||
| Line 47: | Line 51: | ||
* copy of [[#Master Consignee]] address | * copy of [[#Master Consignee]] address | ||
* UI: textarea | * UI: textarea | ||
| + | * ConsigneeDescripion | varchar(1500) | ||
=== Master Consignee ref === | === Master Consignee ref === | ||
| + | * ConsigneeRef | varchar(20) | ||
=== Master Notify === | === Master Notify === | ||
| Line 55: | Line 61: | ||
* Company-City // from AddrBook T13 | * Company-City // from AddrBook T13 | ||
* UI: combobox | * UI: combobox | ||
| + | * NotifyId | int(10) | ||
==== Master Notify Text ==== | ==== Master Notify Text ==== | ||
| Line 60: | Line 67: | ||
* copy of [[#Master Notify]] address | * copy of [[#Master Notify]] address | ||
* UI: textarea | * UI: textarea | ||
| + | * NotifyDescription | varchar(1500) | ||
=== Master Origin Trucker === | === Master Origin Trucker === | ||
| + | * OriginTruckerId | int(10) | ||
=== Master Destination Trucker === | === Master Destination Trucker === | ||
| - | + | * DestinationTruckerId | int(10) | |
=== Master Mode of Transport === | === Master Mode of Transport === | ||
| - | + | * TransportModeId | int(10) | |
=== Master Pick-up === | === Master Pick-up === | ||
| Line 74: | Line 83: | ||
* Company-City // from AddrBook T12 | * Company-City // from AddrBook T12 | ||
* UI: combobox | * UI: combobox | ||
| + | * PickUpId | int(10) | ||
==== Master Pick-up Text ==== | ==== Master Pick-up Text ==== | ||
| Line 79: | Line 89: | ||
* copy of [[#Master Pick-up]] address | * copy of [[#Master Pick-up]] address | ||
* UI: textarea | * UI: textarea | ||
| + | * PickUpDescription | varchar(1500) | ||
=== Master Pick-up Comments === | === Master Pick-up Comments === | ||
| - | + | * PickUpComments | varchar(1500) | |
=== Master Delivery Address === | === Master Delivery Address === | ||
| Line 88: | Line 99: | ||
* Company-City // from AddrBook | * Company-City // from AddrBook | ||
* UI: combobox | * UI: combobox | ||
| + | * DeliveryAddressId | int(10) | ||
==== Master Delivery Text ==== | ==== Master Delivery Text ==== | ||
| Line 93: | Line 105: | ||
* copy of [[#Master Delivery Address]] address | * copy of [[#Master Delivery Address]] address | ||
* UI: textarea | * UI: textarea | ||
| + | * DeliveryAddressDescription | varchar(1500) | ||
=== Master Delivery Comments === | === Master Delivery Comments === | ||
| - | + | * DeliveryComments | varchar(1500) | |
=== Master Marks/Numbers === | === Master Marks/Numbers === | ||
| - | + | * MarksNumbers | varchar(1500) | |
=== Master Commodity Description === | === Master Commodity Description === | ||
| - | + | * CommodityDescription | varchar(1500) | |
=== Total Handling Units(readonly) === | === Total Handling Units(readonly) === | ||
| - | + | * | |
=== Total Cubic Meters(readonly) === | === Total Cubic Meters(readonly) === | ||
| Line 114: | Line 127: | ||
=== Hazardous === | === Hazardous === | ||
| + | * | ||
== Details Tab == | == Details Tab == | ||
Revision as of 21:39, 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
- 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
