EDI 300

From UG

Revision as of 06:34, 8 November 2013 (edit) Alex (Talk | contribs) (→Service Mode (move type)) ← Older edit		Current revision as of 15:10, 15 November 2013 (edit) (undo) Alex (Talk | contribs) (→CY Cutoff Date)
(151 intermediate revisions not shown)
Line 2:		Line 2:
	== Intro ==		== Intro ==
		+
		+	=== 300 ===
	EDI 300 is a '''Booking Request''' message.		EDI 300 is a '''Booking Request''' message.
Line 9:		Line 11:
	The shipper or forwarder can use this transaction set to reserve cargo space.		The shipper or forwarder can use this transaction set to reserve cargo space.
-	Types of 300 message:	+	=== 301 ===
-	* '''Initial Booking'''	+	EDI 301 is a '''Booking Confirmation''' message.
-	* '''Booking Update''' - Booking amendment, initiated by the customer. You can only send amendments on confirmed, conditionally accepted or pending bookings. For rejected bookings a new initial booking needs to be sent	+	This is '''incoming''' message sent by Carrier to Jaguar.
-		+
-	* '''Booking Cancellation''' -  initiated by the customer. You can	+
-	only send cancellations on confirmed, conditionally accepted or pend	+
-	ing bookings.	+
		+	This message is used to confirm/reject/update the Booking Request.
	=== Message Flow ===		=== Message Flow ===
-	Below covers most scenarious except updates from carriers.	+	Below is a typical flow. See also [[#Actions]].
	[[File:300 and 301 exchange.png|700px]]		[[File:300 and 301 exchange.png|700px]]
		+	=== Limitations ===
		+
		+	We impose this limitation:
		+
		+	At any moment in time there could be only one Booking Request/Update 300
		+	and related Booking Response 301
		+
		+	Theoretically we could send multiple alternative booking requests to:
		+
		+	* different steamshiplines (to maximize chance of any booking)
		+	* same steamshipline (say different dates)
		+
		+	but we are not going to support this now.
	== Business Process ==		== Business Process ==
-	=== Regular BP ===	+	Below is defined for New Booking.
		+
		+	=== Actual Master BP ===
		+
		+	When Master contains '''actual''' data.
-	* 1/ Combine CTs into GRP and then into Master (currently not all operators are doing this at the moment of booking)	+	* 1/ Combine CTs into GRPs and then into Master (currently not all operators are doing this at the moment of booking)
	* 2/		* 2/
-	** Enter all required information such as containers, etc.	+	** Enter all missing booking related information (if any)
-	** Pass all [[#Validations]].	+	** Pass all validations.
-	* 3/ Browse [[#Sailing Schedule]] to identify appropriate Vessel / Voyage (example: VANCOUVER EXPRESS / 029W)	+	* 3/ Send booking request from [[#EDI tab]]. Most data will come from Master fields.
-	* 4/ Enter Vessel / Voyage	+	=== Estimated Master BP ===
-	* 5/ Send booking request by pressing a button in '''Master Context Menu'''. See [[#Master UI 1]].	+	When Master contains '''estimated''' data.
-	=== Blind BP ===	+	* 1/ create empty master from Master template
		+	* 2/ steps 2,3 from [[#Actual Master BP]]
		+	** some data will be estimated and some of it entered on EDI template (example: weight per container)
-	skip 3,4 in Regular BP	+	'''Note''': User will wrap CTs inside the master with one or more groups later on (before [[EDI 301]] is transmitted)
-	=== Phone BP ===	+	== EDI tab ==
-	At step 3 if there are no space then make a phone call. Then if space provided then complete it over the phone or proceed to 4,5 in Regular BP.	+	This tab is active only if:
-	=== Empty Master BP ===	+	[[Master#Steamshipline]] in given Master is on the list of
		+	active carriers in OS Admin (see [[OS#Steamshiplines]])
		+	'''AND'''
		+	[[Master#Master Mode of Transport]] = Full Container Load (AW) OR
		+	Full Container Load (MLB)
-	* 1/ create empty master from Master template	+	NOTE:
-	* 2/ Change / add booking related fields	+	-----
-	* 3/ follow steps 3,4,5 from Regular BP	+	When Master MOT is set as FCL (AW or MLB) then CT/GRP could have MOT set as:
		+	FCL (AW) or
		+	FCL(MLB) or
		+	Client Consol
-	== Validations ==	+	See mock up below.
-	EDI transmission assumes strict validations.	+	[[File:EDI tab.JPG|700 px]]
-	All required fields mast be marked as "required". See [[#Master UI 1]].	+	=== Booking Request and Confirmation ===
-	On "Transmit" system should:	+	'''Columns''':
-	* validate all fields and present user with all required fields. See [[#Required fields]]	+
-	* validate that all contents are assigned to containers in all CTs under Master	+
-	== Sailing Schedule ==	+	* '''ANSI# ''' - 300 or 301 or 997
-	User needs access to this info in many cases before they make a booking.	+	* '''Message type''' - Booking or Confirmation or Acknowledgement
-	Tech Note	+	* '''Date''' - date/time of update
-	---------	+
-	User accesses this through:	+	* '''Event''' - see [[#Events]]
-	.	+
-	option A) A different free URL (example: https://www.e-usiship.com/party/sailingschedule/ss_expresslink.jsf?ANONYMOUS_BEHAVIOR=BUILD_UP&domainName=PARTY_DOMAIN&ENTRY_TYPE=USI&ENTRY=MCC&PREFER_LANGUAGE=en-US)	+	* '''By''' - Jag user name (First Name + Last Name) or CT2 or Carrier
-	A1) on separate browser tab OR	+
-	A2) embedded into CT2 page	+	* '''View Message''' - Link to human readable copy of a saved message
-	.	+
-	option B) CT2 module that connects through Web Service or alike(not free, example: CargoSmart's Sailing Schedule feature)	+	* '''XML''' - XML version of a message
		+
		+
		+	'''Rows''':
		+
		+	Each row corresponds to one update by operator or CT2 system or VAN/Carrier.
		+
		+	'''Actions''':
		+
		+	* '''create''' - see [[#300 Create]]
		+	* '''update''' - see [[#300 Update]]
		+	* '''cancel''' - see [[#300 Cancel]]
		+
		+	=== Shipping Instructions ===
		+
		+	See [[EDI 304]]
		+
		+	=== Status Updates ===
		+
		+	See [[EDI 315]]
		+
		+	=== Events ===
		+
		+	Each '''event''' relates to 300 message and leads to a new '''status''' with the same name.
		+
		+	'''300''':
		+	* '''created''' (new) - 300 was initiated by Jag user, XML created by CT2 and waiting scheduled time to be transmitted to VAN/Carrier
		+	* '''transmitted''' - 300 was posted into VAN/Carriers FTP folder, waiting to be read
		+	* '''updated''' - Jag user initiates updates to existing 300
		+	* '''cancelled''' - Jag user cancels existing 300
		+
		+	'''997''':
		+	* '''acknowledged''' - 300 has no errors (corresponds to 997 accepted) // set by VAN or carrier
		+	* '''error''' - significant errors found in 300 (syntax, structure, validations, etc)(corresponds to 997 rejected) // set by VAN or carrier
		+
		+	'''301''':
		+	* '''conditionally accepted''' - (300 was set as conditionally accepted by carrier)
		+	* '''pending''' - (300 was set as pending by carrier)
		+	* '''rejected''' (300 was rejected by carrier)
		+	* '''confirmed''' (300 was confirmed by carrier)
		+	* '''updated''' (300 was updated by carrier)
		+	* '''canceled''' (300 was canceled by carrier)
		+
		+	=== Message 300 ===
		+
		+	==== Actions ====
		+
		+	See actions available for each state:
		+
		+	[[File:Transition diagramm for 300 301.jpg| 700px]]
		+
		+	General Rule
		+	------------
		+	You can only send cancellations on confirmed,
		+	conditionally accepted or pending bookings.
		+
		+	==== 300 Create ====
		+
		+	Template to create new 300 request.
		+
		+	See [[#300 Message Form]]
		+
		+	Action Type displayed as Create.
		+
		+	==== 300 Update ====
		+
		+	Template to update 300 request.
		+
		+	Action Type displayed as Update.
		+
		+	See [[#300 Message Form]]
		+
		+	NOTE:
		+	-----
		+	System is not pulling data from last saved state of 300.
		+	System pulls from Master/other entities as if it is a new 300.
		+
		+	==== 300 Cancel ====
		+
		+	Present Confirmation pop-up:
		+
		+	Are you sure you want to cancel this Booking?
		+	[OK]  [Cancel]
		+
		+	On '''OK''':
		+	* schedule cancellation message
		+	* send e-mail to user who submitted with details of submission
		+
		+	On '''Cancel''' return user to Master Editor.
		+
		+	==== 300 Message Form ====
		+
		+	Opens in pop-up.
		+
		+	Fields are defined in [[OOCL 300#300 Data Elements]].
		+
		+	All fields are read-only and are pulled from Master entity or other entities.
		+
		+	See mock up below.
		+
		+	[[File:300 template new general.JPG]]
		+
		+	==== Actions and Validations ====
		+
		+	If all required fields are present then show these buttons:
		+
		+	* '''Submit''' - submit message
		+	* '''Cancel''' - return to Est Tab
		+
		+	If not all required fields are present then indicate what fields needs to be filed in and show this button:
		+
		+	* '''OK''' - return to Est Tab
		+
		+	==== Reefer ====
		+
		+	If Cargo Nature = Reefer then "Reefer info section will be added".
		+
		+	TBD
		+
		+	==== 300 Message View ====
		+
		+	Is a read only version of [[#300 Message Form]] - without any action buttons.
		+
		+	=== Message 301 ===
		+
		+	Once message is received appropriate fields in CT2 will be updated - see [[OOCL 300#301 Data Elements]].
		+
		+	==== 301 Message View ====
		+
		+	Is a read only version of 301 Message sent by carriers.
-	[[File:Sailing schedule.JPG]]	+	Opens in pop-up.
-	== Transmit button ==	+	Fields are defined in [[OOCL 300#301 Data Elements]].
-	* Add Booking Request button to initiate 300 message.	+	System will compare value of each field as received and as stored in Master and display appropriate field status for a user:
-	* Button is active only if:	+	* confirmed
-	** [[Master#Steamshipline]] on the list of active carriers in [[OS#Admin]] AND	+	* new
-	** MOT = FCL or Client Consol	+	* changed
-	* On Press Message will be sent and confirmation pop-up will be shown.	+	See mock up below.
-	[[File:Transmit Booking request.JPG |700px]]	+	[[File:301 example.JPG|500px]]
	== Reporting and Notifications ==		== Reporting and Notifications ==
Line 99:		Line 251:
	=== Master Comments Tab ===		=== Master Comments Tab ===
-	Post all events/updates related to all messages here:	+	Suggest not to duplicate here since we have log on EDI tab.
-	* Add record every time message was sent or received	+
-	* Record content of the message, operator who initiated.	+
	=== Email Notifications ===		=== Email Notifications ===
-	997?	+	Email all [[#Events]] to [[EDI 300#Export Operator]].
	==== Email Template ====		==== Email Template ====
Line 114:		Line 264:
	'''Sent''': <date>		'''Sent''': <date>
	'''To''': <user name>		'''To''': <user name>
-	'''Subject''': Rejected: <protocol number><message type><related master numbers>	+	'''Subject''': Rejected: <protocol number> <Event> <By> for <master number>
	Dear <user name>,		Dear <user name>,
-	The following transmission was rejected:	+	Status has changed for <master number>:
-	<protocol number><message type><related master numbers>	+	<protocol number> was <Event>
		+
		+	Updated by: <By>
	This is automated message generated by Cybertrax 2 System.		This is automated message generated by Cybertrax 2 System.
Line 126:		Line 278:
	</pre>		</pre>
-	* <protocol number>: 300, 301, etc	+	<Event> and <By> as defined in [[#Booking Request and Confirmation]].
-	* <protocol name>: Booking Request, etc	+
-	* <related master numbers>: Master numbers related to thi transmission. Example: M1234, M12414	+
	=== Reports ===		=== Reports ===
-	==== 997 Reporting ====	+	==== Updated List Masters Report ====
-	Optional for 300 (since we have 301 as a response).	+	At the core we need a report that lists Masters in the system.
-	Required for 304.	+	Increment existing List Masters report to enable operator to look at EDI activity for desired group of Masters singled out by applying certain filters such as Steamshipline and Export Operator.
-	Dashboard similar to 997 dashboard in [[SI EDI]] (Data2Log).	+	Add these filters to List Masters:
-	Provides counter of Rejected messages.	+	* [[MOT]]
		+	* [[Master#Steamshipline]]
		+	* [[EDI 300#Created On Date]]
		+	* [[EDI 300#Export Operator]]
-	Must be based off of [[#List Masters]].	+	Add these output fields:
-	=== Log ===	+	* EDI Status
		+	** map to[[EDI 300#Events]]
-	Log all related events:	+	See mock up below.
-	* when Process started	+	[[File:List Masters.JPG | 700px]]
-	* when Process ended	+
-	* 300 sent	+
-	* 301 received	+
-	* 304 sent	+
-	* 315 received	+
-	* any 997 received	+
-	Additional info to include into log event description:	+	==== Rejected Booking Dashboard ====
-	* related list of Master numbers	+
-	* status for incoming messages (such as accepted/rejected)	+
-	== Required Fields ==	+	More details TBD once concept is approved.
-	* '''Traffic Mode'''	+	Based on [[#List Masters Report]]
-	** FCL: constant ''"FCL/FCL"''	+
-	=== Rate/Reference Information ===	+	Level 1.
-	* [[#Contract Number]]	+	[[File:Rejected booking dashboard.JPG | 700px]]
-	=== Parties ===	+	Level 2.
-	* '''Shipper'''	+	[[File:List Masters BC status rejected.JPG | 700px]]
-	** [[Master#Master_Shipper]]	+
-	* '''Forwarder'''	+	==== Impending Events Dashboard ====
-	** [[Offices]] based on users login	+
-	* '''Consignee'''	+	* Impending cargo cut off report/dashboard.
-	** [[Master#Master_Consignee]]	+	* Impending documents cut off report/dashboard
-	=== Cargo ===	+	See mock up below.
-	* '''Outbound Traffic Mode'''	+	More details TBD once concept is approved.
-	** constant ''FCL: Full Container Load'' for FCL/FCL	+
-	* '''Inbound Traffic Mode'''	+	[[File:Impending db.JPG | 700px]]
-	** constant ''FCL: Full Container Load'' for FCL/FCL	+
-	* '''Cargo Nature'''	+	=== Log ===
-	** ''General / Reefer / Dangerous''	+
-	* '''Cargo Descriptions'''	+	Log all [[#Events]].
-	** [[#Commodity]]	+
-	=== Routing ===	+	== Misc ==
-	* '''Origin City'''	+	=== Move type ===
-	** for cy/* moves: [[Master#Origin_Terminal]]	+
-	** for door/* moves: [[Master#Master_Pick-up]]	+
-	* '''Destination City'''	+	Need to change [[Master#Move Type/MBL]] list in Admin:
-	** for */cy moves: [[Master#Destination_Terminal]]	+
-	** for */cy moves: [[Master#Master_Delivery_Address]]	+
-	* '''Vessel Name'''	+	* archive "port to port" item
-	** [[Master#Vessel_Name]]	+	* will have 4 items:
		+	** "door to port" rename into "door to cy"
		+	** "port to door" rename into "cy to door"
		+	** "door to door" leave as is
		+	** "cy/cy" rename into "cy to cy"
-	* '''Voyage Number'''	+	NOTE:
-	** [[Master#Voyage_Num]]	+	-----
		+	Alex: I feel we need to remove this from Admin and hard code
		+	as we say did with MOT.
		+	Marc: make this area very secure instead.
		+	Kostya: TBD
-	=== Container ===	+	=== Jaguar Offices ===
-	For each size type:	+	Tech Note
		+	----------
		+	There is a problem.
		+	Office addr is stored in one field tblOffice.Address
		+	Need to re-factor DB table to add separate fields that hold Zip, City, etc
		+	and trigger to support existing field. Or other solution.
-	* '''Quantity'''	+	=== Changes to Carriers Admin ===
-	** calculate from Master containers table	+
-	* '''Size Type'''	+	==== Contract Number ====
-	** see [[#Container Type ISO Code]]	+
-	* '''Cargo Weight'''	+	Contract number for contract between Jaguar and Steamshipline.
-	** see [[OS#Add Weight per container]]	+
-	* '''Cargo Weight Unit''' (kg / lb)	+	UI: Add to Admin > Carriers > Steamshiplines
-	** see [[OS#Add Weight per container]]	+
-	=== Trucking and Haulage ===	+	* OOCL
		+	** Format: AN, 8 chars
		+	** example: MT136710
-	* '''Door Pickup'''
-	** options:  all 4 combinations of '''cy''' and '''door'''
-	** map to [[Master#Move_Type.2FMBL | Move Type/MBL ]] ''(Master Details tab. 2)''
-	*** cy = port
-	? do we need to add Appointment interface or always use "To be Advised"?	+	=== Changes to Container Size Type Admin ===
-	* '''Empty Container Pickup Request'''	+	==== Container Size Type ISO Code ====
-	** O	+
-	** do we need this?	+
-	=== Special Requirements ===	+	In Admin > Transportation > Container Size/Type
-	* '''Export Declaration'''	+	* add field "ISO code", same format/validation as D2L codes
-	** see [[#Export Declaration]]	+	* add Long Description field (100 char string)
-	* '''Special Stowage'''	+	NOTE:
-	** see [[#Special Stowage]]	+	D2L codes are based on ISO but not identical.
		+	For example, open top type.
		+	In ISO it is tagged as "UT" or U0, U1 or .... or U5.
		+	In D2L classification it is "OT"
		+	References:
		+	ISO: http://en.wikipedia.org/wiki/ISO_6346
		+	D2L: [[File:Container_Codes.xls]]
		+	[[SI_EDI#SOW_18_Fix_Container_info]]
-	* '''Document Upload'''	+	==== Reefer Indicator ====
-	** O	+
-	** no need?	+
-	=== Booking Remarks ===	+	Add "Reefer Indicator" attribute to container types. Values: "Y" or "No"
-	* [[#Booking Remarks]]	+	=== Changes to Master Container Table ===
-	** OOCL Example: If an item is over one ton, enter the Gross Weight per package	+
-	== Old fields ==	+	==== Container Weight ====
-	=== Estimated Departure Date ===	+	For every container table add columns/fields:
-	* '''map''':	+	* '''weight'''
-	:* [[Master#Origin_Terminal_Estimated_Date | Origin Terminal Estimated Date]] if "Origin Terminal Estimated Date" is NOT EMPTY	+	* '''unit'''
-	:* [[Master#Port_Of_Loading_Estimated_Date | Port Of Loading Estimated Date]] if "Origin Terminal Estimated Date" is EMPTY	+
-	* '''required''': Y	+
-	* '''EDI''':	+
-	* '''Notes''': might be labeled something else, ready to ship date, or cargo delivery date, for example	+
-	=== Hazardous Information ===	+	Also add selector to choose one of the following:
-	* '''map''': [[Master#Hazardous | Hazardous]] ''(Master General tab. 18)''	+	* '''actual weight'''
-	* '''required''': Y	+	** calculated weight based on commodity assignments to containers
-	* '''EDI''':	+	** weight field will be read-only
-	* '''Notes''': if any	+
-	=== Maybe: Estimated Arrival Date ===	+	* '''estimated weight'''
		+	** in this case system will offer place to enter estimated weight required for EDI 300
		+	** this is for the case when no actual is available yet
		+	** store this into DB
-	* '''map''':	+	* '''auto-populate max'''
-	:* [[Master#Destination_Terminal_Estimated_Date | Destination Terminal Estimated Date]] if "Destination Terminal Estimated Date" is NOT EMPTY	+	** in this case system will populate max weight for this type size of container
-	:* [[Master#Port_Of_Discharge_Estimated_Date | Port Of Discharge Estimated Date]] if "Destination Terminal Estimated Date" is EMPTY	+	** weight field will be read-only
-	* '''required''': Y	+	** default value
-	* '''EDI''':	+
-	* '''Notes''':	+
-	=== Freight Prepaid / Freight Collect ===	+	[[File:Container table.JPG| 700px]]
-	* '''map''': [[Master#Freight_Prepaid_Collect | Freight Prepaid Collect]] ''(Master Details tab. 1)''	+	==== Container Weight Unit ====
-	* '''required''': Y	+
-	* '''EDI''':	+
-	* '''Notes''':	+
-	=== Gross Weight ===	+	Options:
-	* '''map''': [[Master#Total_Gross_kg.28readonly.29 | Total Gross KG(readonly)]] ''(Master General tab. 17)''	+	* kg
-	* '''required''': Y	+	* lb
-	* '''EDI''':	+
-	* '''Notes''':	+
-	== New Fields ==	+	==== Reefer Info ====
-	=== Export Declaration ===	+	If at least one contained is reefer - see [[#Reefer Indicator]] - then present additional form.
-	* options:	+	Fields below are not per container - they are per container table / per Master.
-	** Filing Electronically (Canada, China, and United States)	+
-	** Submitting Forms (Canada, China, and United States)	+
-	** No Export Declaration	+
-	=== Special Stowage ===	+	===== Generator Set =====
-	* options:	+	One value from the list.
-	** Stow below Deck	+
-	** Stow on Deck	+
-	** No Special Stowage	+
-	=== Booking Remarks ===	+	Options: Not Required, Clip On, Underslung
-	* required: N (used in some cases)	+	UI: single select
-	* AN // size TBD	+
-	* UI: textarea	+
-	=== RF Temperature ===	+	===== RF Temperature =====
-	* '''RF Temperature''' // Format: 9999.99 // Temperature Requirement for RF containers.	+	* UI: textbox;
-	** UI: add to container profile; textfield; default = TBD	+	* cannot be greater than 25 degrees Celsius or 77 degrees Fahrenheit and cannot be less than -30 degrees Celsius or -22 degrees Fahrenheit.
-	* '''RF Temperature Unit''' //  C (Celsius) or F(Farenheit) // Unit of measurement	+	===== RF Temperature Unit =====
-	** UI: add to container profile; dropdown ; default = TBD;	+
-	Above needs to be presented/validated only for RF type of containers - use [[#Reefer Indicator]] to distinguish.	+	* options: C (Celsius) or F(Farenheit) // Unit of measurement
		+	* UI: dropdown ; default = F;
-	Editable in container table in M only or in CT as well when CTs are under Master.	+	===== Ventilation =====
-	==== Reefer Indicator ====	+	* Numerical
		+	* min/max = 1/3 digits
-	Add "Reefer Indicator" attribute to container types. Values: "Y" or "No"	+	===== Ventilation Unit =====
		+	* options: Cubic Feet per minute, Cubic meter per hour, Degrees // Unit of measurement
		+	* UI: dropdown ; default = F;
-	=== Contract Number ===	+	===== Sensitive Cargo =====
-	Contract number for contract between Jaguar and Steamshipline.	+	* options: Not Sensitive, Blood Plazma, Ice Cream, USDA Requirement
		+	* UI: dropdown ; default = F;
-	UI: Add to Admin > Carriers > Steamshiplines	+	===== CO2 =====
-	* OOCL	+	* Percentage of this gas.
-	** Format: AN, 8 chars	+	* numeric, 0 < x < 100
-	** example: MT136710	+
-	=== AMS SCAC Code ===	+	===== O2 =====
-	* '''AMS SCAC Code''' -  SCAC/ACI Code. For USA trade, this is a code with normally 4 digits for AMS filing, we need this code to submit AMS filing and Jaguar is registered. Our AMS SCAC code is '''JAFR'''.	+	* Percentage of this gas.
		+	* numeric, 0 < x < 100
-	=== Container Size Type ISO Code ===	+	===== Container Atmosphere =====
-	* '''map''': see below	+	One value from the list.
-	* '''required''': Y	+
-	* '''EDI''':	+
-	* '''Notes''': cover all containers in the loop	+
		+	Options:
		+	* AFAM,
		+	* CA,
		+	* MA,
		+	* Magnum,
		+	* No Preference
-	Related to http://wiki.jaguarfreight.com/wiki/SI_EDI#SOW_18_Fix_Container_info	+	UI: single select
-	In Admin > Transportation > Container Size/Type	+	=== New Master Controls for 300 ===
-	* add field "ISO code", same format/validation	+	==== Hazardous ====
-	* add Long Description field (100 char string)	+
-	NOTE:	+	[[Master#Hazardous]] is calculated from CTs that belong to Master.
-	D2L codes are based on ISO but not identical.	+
-	For example, open top type.	+
-	In ISO it is tagged as "UT" or U0, U1 or .... or U5.	+
-	In D2L classification it is "OT"	+
-	References:	+
-	ISO: http://en.wikipedia.org/wiki/ISO_6346	+
-	D2L: http://wiki.jaguarfreight.com/wiki/File:Container_Codes.xls	+
-	=== Est GW ===	+	In there are no CTs in Master it would be set to No.
-	* "Est GW" checkbox	+	We need to add option to set estimated hazardous:
-	** NOTE: "Use Estimated Weight for Booking Request instead of actual?"	+	* checkbox "use estimated"
-	** above master container table	+	** when use estimated is activated then show two options Y/N
-	=== Add Weight per container ===	+	==== Special Stowage ====
-	* add extra column "GW" to cont table	+	Add new Master field.
-	** with dropdown with '''unit''' (kg/lb) in the header of column	+
-	* if Est GW is checked then show show textfield in each line (float, format same as GW in commod table) else show calculated read only from CTs	+	Possible values:
-	** if CTs have mixed kg/lb then recalculate in '''unit''' above table	+
-	== Misc ==	+	* Stow below Deck
		+	* Stow on Deck
		+	* No Special Stowage
		+
		+	UI: radio group
		+
		+	Add to Master details bottom right - see mock up below.
		+
		+	==== Booking Remarks ====
		+
		+	* AN // size 1000 chars
		+	* UI: textarea
		+
		+	UI: Master Det tab, See mock up below.
		+
		+	[[File:Special stowage.JPG|700px]]
		+
		+	=== New fields for 301 ===
		+
		+	==== CY Cutoff Date ====
		+
		+	* // Date+Time // Last possible date cargo may be delivered to CY
		+	* Editable
		+	* M Det Tab, bottom right
		+
		+	=== New Master Fields for reporting ===
		+
		+	==== Created On Date ====
		+
		+	* date Master was created
		+	* similar to this field that we have for CT
		+	* UI: read only
		+	* DB: name it CreatedOnDate
		+
		+	==== Export Operator ====
		+
		+	* Operator who is responsible for this record on Export side
		+	* default to user who created Master
		+	* UI: [[Users Selector]]
		+	* DB: name it ExportOperatorUserId
	=== Grouping inside Master ===		=== Grouping inside Master ===
Line 394:		Line 557:
	Add ability to group/ungroup selected CTs inside the Master.		Add ability to group/ungroup selected CTs inside the Master.
-	=== Extend Master Templates ===	+	=== Extended Master Templates ===
	Following additional fields must be copied at the moment of creating a template from Master Clone.		Following additional fields must be copied at the moment of creating a template from Master Clone.
	Add column / filter of user who created them.		Add column / filter of user who created them.
		+
		+	TBD: ask opers/team leads if they cross share
		+	or there is a benefit of cross sharing
		+
		+	=== Make Address Text fields read only ===
		+
		+	Make the following fields read-only on Masters profile:
		+
		+	[[Master#Master Shipper Text]]
		+	[[Master#Master Consignee Text]]
		+	[[Master#Master Notify Text]]
		+	[[Master#Master Pick-up Text]]
		+	[[Master#Master Delivery Text]]
		+
		+	=== Tags for required fields ===
		+
		+	EDI transmission assumes strict validations.
		+
		+	All required fields mast be marked as colored "*" (say orange).
		+
		+	Add note (in orange): "* Required fields for Booking Confirmation"
	== EDI Vendor Implementations ==		== EDI Vendor Implementations ==
	* CargoSmart: [[CSmart 300]]		* CargoSmart: [[CSmart 300]]
		+
		+	== Wiki source files ==
		+
		+	[[File:BR+SI+designs Nov13a.xls]]

---

Current revision as of 15:10, 15 November 2013

Contents 1 Intro 1.1 300 1.2 301 1.3 Message Flow 1.4 Limitations 2 Business Process 2.1 Actual Master BP 2.2 Estimated Master BP 3 EDI tab 3.1 Booking Request and Confirmation 3.2 Shipping Instructions 3.3 Status Updates 3.4 Events 3.5 Message 300 3.5.1 Actions 3.5.2 300 Create 3.5.3 300 Update 3.5.4 300 Cancel 3.5.5 300 Message Form 3.5.6 Actions and Validations 3.5.7 Reefer 3.5.8 300 Message View 3.6 Message 301 3.6.1 301 Message View 4 Reporting and Notifications 4.1 Master Comments Tab 4.2 Email Notifications 4.2.1 Email Template 4.3 Reports 4.3.1 Updated List Masters Report 4.3.2 Rejected Booking Dashboard 4.3.3 Impending Events Dashboard 4.4 Log 5 Misc 5.1 Move type 5.2 Jaguar Offices 5.3 Changes to Carriers Admin 5.3.1 Contract Number 5.4 Changes to Container Size Type Admin 5.4.1 Container Size Type ISO Code 5.4.2 Reefer Indicator 5.5 Changes to Master Container Table 5.5.1 Container Weight 5.5.2 Container Weight Unit 5.5.3 Reefer Info 5.5.3.1 Generator Set 5.5.3.2 RF Temperature 5.5.3.3 RF Temperature Unit 5.5.3.4 Ventilation 5.5.3.5 Ventilation Unit 5.5.3.6 Sensitive Cargo 5.5.3.7 CO2 5.5.3.8 O2 5.5.3.9 Container Atmosphere 5.6 New Master Controls for 300 5.6.1 Hazardous 5.6.2 Special Stowage 5.6.3 Booking Remarks 5.7 New fields for 301 5.7.1 CY Cutoff Date 5.8 New Master Fields for reporting 5.8.1 Created On Date 5.8.2 Export Operator 5.9 Grouping inside Master 5.10 Extended Master Templates 5.11 Make Address Text fields read only 5.12 Tags for required fields 6 EDI Vendor Implementations 7 Wiki source files

[edit] Intro

[edit] 300

EDI 300 is a Booking Request message.

It is an outgoing Message: Jaguar sends info to Carrier.

The shipper or forwarder can use this transaction set to reserve cargo space.

[edit] 301

EDI 301 is a Booking Confirmation message.

This is incoming message sent by Carrier to Jaguar.

This message is used to confirm/reject/update the Booking Request.

[edit] Message Flow

Below is a typical flow. See also #Actions.

[edit] Limitations

We impose this limitation:

At any moment in time there could be only one Booking Request/Update 300 
and related Booking Response 301

Theoretically we could send multiple alternative booking requests to:

• different steamshiplines (to maximize chance of any booking)
• same steamshipline (say different dates)

but we are not going to support this now.

[edit] Business Process

Below is defined for New Booking.

[edit] Actual Master BP

When Master contains actual data.

• 1/ Combine CTs into GRPs and then into Master (currently not all operators are doing this at the moment of booking)

• 2/
  • Enter all missing booking related information (if any)
  • Pass all validations.

• 3/ Send booking request from #EDI tab. Most data will come from Master fields.

[edit] Estimated Master BP

When Master contains estimated data.

• 1/ create empty master from Master template
• 2/ steps 2,3 from #Actual Master BP
  • some data will be estimated and some of it entered on EDI template (example: weight per container)

Note: User will wrap CTs inside the master with one or more groups later on (before EDI 301 is transmitted)

[edit] EDI tab

This tab is active only if:

Master#Steamshipline in given Master is on the list of 
active carriers in OS Admin (see OS#Steamshiplines) 
AND
Master#Master Mode of Transport = Full Container Load (AW) OR
                                      Full Container Load (MLB) 

NOTE:
-----
When Master MOT is set as FCL (AW or MLB) then CT/GRP could have MOT set as:
FCL (AW) or
FCL(MLB) or
Client Consol 

See mock up below.

[edit] Booking Request and Confirmation

Columns:

• ANSI# - 300 or 301 or 997

• Message type - Booking or Confirmation or Acknowledgement

• Date - date/time of update

• Event - see #Events

• By - Jag user name (First Name + Last Name) or CT2 or Carrier

• View Message - Link to human readable copy of a saved message

• XML - XML version of a message

Rows:

Each row corresponds to one update by operator or CT2 system or VAN/Carrier.

Actions:

• create - see #300 Create
• update - see #300 Update
• cancel - see #300 Cancel

[edit] Shipping Instructions

See EDI 304

[edit] Status Updates

See EDI 315

[edit] Events

Each event relates to 300 message and leads to a new status with the same name.

300:

• created (new) - 300 was initiated by Jag user, XML created by CT2 and waiting scheduled time to be transmitted to VAN/Carrier
• transmitted - 300 was posted into VAN/Carriers FTP folder, waiting to be read
• updated - Jag user initiates updates to existing 300
• cancelled - Jag user cancels existing 300

997:

• acknowledged - 300 has no errors (corresponds to 997 accepted) // set by VAN or carrier
• error - significant errors found in 300 (syntax, structure, validations, etc)(corresponds to 997 rejected) // set by VAN or carrier

301:

• conditionally accepted - (300 was set as conditionally accepted by carrier)
• pending - (300 was set as pending by carrier)
• rejected (300 was rejected by carrier)
• confirmed (300 was confirmed by carrier)
• updated (300 was updated by carrier)
• canceled (300 was canceled by carrier)

[edit] Message 300

[edit] Actions

See actions available for each state:

General Rule
------------
You can only send cancellations on confirmed, 
conditionally accepted or pending bookings. 

[edit] 300 Create

Template to create new 300 request.

See #300 Message Form

Action Type displayed as Create.

[edit] 300 Update

Template to update 300 request.

Action Type displayed as Update.

See #300 Message Form

NOTE:
-----
System is not pulling data from last saved state of 300.
System pulls from Master/other entities as if it is a new 300.

[edit] 300 Cancel

Present Confirmation pop-up:

Are you sure you want to cancel this Booking?
[OK]  [Cancel]

On OK:

• schedule cancellation message
• send e-mail to user who submitted with details of submission

On Cancel return user to Master Editor.

[edit] 300 Message Form

Opens in pop-up.

Fields are defined in OOCL 300#300 Data Elements.

All fields are read-only and are pulled from Master entity or other entities.

See mock up below.

[edit] Actions and Validations

If all required fields are present then show these buttons:

• Submit - submit message
• Cancel - return to Est Tab

If not all required fields are present then indicate what fields needs to be filed in and show this button:

• OK - return to Est Tab

[edit] Reefer

If Cargo Nature = Reefer then "Reefer info section will be added".

TBD

[edit] 300 Message View

Is a read only version of #300 Message Form - without any action buttons.

[edit] Message 301

Once message is received appropriate fields in CT2 will be updated - see OOCL 300#301 Data Elements.

[edit] 301 Message View

Is a read only version of 301 Message sent by carriers.

Opens in pop-up.

Fields are defined in OOCL 300#301 Data Elements.

System will compare value of each field as received and as stored in Master and display appropriate field status for a user:

• confirmed
• new
• changed

See mock up below.

[edit] Reporting and Notifications

[edit] Master Comments Tab

Suggest not to duplicate here since we have log on EDI tab.

[edit] Email Notifications

Email all #Events to EDI 300#Export Operator.

[edit] Email Template

'''From''': cybertrax@jaguarfreight.com [cybertrax@jaguarfreight.com]
'''Sent''': <date>
'''To''': <user name>
'''Subject''': Rejected: <protocol number> <Event> <By> for <master number>

Dear <user name>,

Status has changed for <master number>:

<protocol number> was <Event> 

Updated by: <By>

This is automated message generated by Cybertrax 2 System.

<Event> and <By> as defined in #Booking Request and Confirmation.

[edit] Reports

[edit] Updated List Masters Report

At the core we need a report that lists Masters in the system.

Increment existing List Masters report to enable operator to look at EDI activity for desired group of Masters singled out by applying certain filters such as Steamshipline and Export Operator.

Add these filters to List Masters:

• MOT
• Master#Steamshipline
• EDI 300#Created On Date
• EDI 300#Export Operator

Add these output fields:

• EDI Status
  • map toEDI 300#Events

See mock up below.

[edit] Rejected Booking Dashboard

More details TBD once concept is approved.

Based on #List Masters Report

Level 1.

Level 2.

[edit] Impending Events Dashboard

• Impending cargo cut off report/dashboard.
• Impending documents cut off report/dashboard

See mock up below.

More details TBD once concept is approved.

[edit] Log

Log all #Events.

[edit] Misc

[edit] Move type

Need to change Master#Move Type/MBL list in Admin:

• archive "port to port" item
• will have 4 items:
  • "door to port" rename into "door to cy"
  • "port to door" rename into "cy to door"
  • "door to door" leave as is
  • "cy/cy" rename into "cy to cy"

NOTE:
-----
Alex: I feel we need to remove this from Admin and hard code 
as we say did with MOT.
Marc: make this area very secure instead.
Kostya: TBD

[edit] Jaguar Offices

Tech Note
----------
There is a problem.
Office addr is stored in one field tblOffice.Address
Need to re-factor DB table to add separate fields that hold Zip, City, etc
and trigger to support existing field. Or other solution. 

[edit] Changes to Carriers Admin

[edit] Contract Number

Contract number for contract between Jaguar and Steamshipline.

UI: Add to Admin > Carriers > Steamshiplines

• OOCL
  • Format: AN, 8 chars
  • example: MT136710

[edit] Changes to Container Size Type Admin

[edit] Container Size Type ISO Code

In Admin > Transportation > Container Size/Type

• add field "ISO code", same format/validation as D2L codes
• add Long Description field (100 char string)

NOTE:
D2L codes are based on ISO but not identical.
For example, open top type.
In ISO it is tagged as "UT" or U0, U1 or .... or U5.
In D2L classification it is "OT"
References:
ISO: http://en.wikipedia.org/wiki/ISO_6346
D2L: File:Container Codes.xls
SI_EDI#SOW_18_Fix_Container_info

[edit] Reefer Indicator

Add "Reefer Indicator" attribute to container types. Values: "Y" or "No"

[edit] Changes to Master Container Table

[edit] Container Weight

For every container table add columns/fields:

• weight
• unit

Also add selector to choose one of the following:

• actual weight
  • calculated weight based on commodity assignments to containers
  • weight field will be read-only

• estimated weight
  • in this case system will offer place to enter estimated weight required for EDI 300
  • this is for the case when no actual is available yet
  • store this into DB

• auto-populate max
  • in this case system will populate max weight for this type size of container
  • weight field will be read-only
  • default value

[edit] Container Weight Unit

Options:

• kg
• lb

[edit] Reefer Info

If at least one contained is reefer - see #Reefer Indicator - then present additional form.

Fields below are not per container - they are per container table / per Master.

[edit] Generator Set

One value from the list.

Options: Not Required, Clip On, Underslung

UI: single select

[edit] RF Temperature

• UI: textbox;
• cannot be greater than 25 degrees Celsius or 77 degrees Fahrenheit and cannot be less than -30 degrees Celsius or -22 degrees Fahrenheit.

[edit] RF Temperature Unit

• options: C (Celsius) or F(Farenheit) // Unit of measurement
• UI: dropdown ; default = F;

[edit] Ventilation

• Numerical
• min/max = 1/3 digits

[edit] Ventilation Unit

• options: Cubic Feet per minute, Cubic meter per hour, Degrees // Unit of measurement
• UI: dropdown ; default = F;

[edit] Sensitive Cargo

• options: Not Sensitive, Blood Plazma, Ice Cream, USDA Requirement
• UI: dropdown ; default = F;

[edit] CO2

• Percentage of this gas.
• numeric, 0 < x < 100

[edit] O2

• Percentage of this gas.
• numeric, 0 < x < 100

[edit] Container Atmosphere

One value from the list.

Options:

• AFAM,
• CA,
• MA,
• Magnum,
• No Preference

UI: single select

[edit] New Master Controls for 300

[edit] Hazardous

Master#Hazardous is calculated from CTs that belong to Master.

In there are no CTs in Master it would be set to No.

We need to add option to set estimated hazardous:

• checkbox "use estimated"
  • when use estimated is activated then show two options Y/N

[edit] Special Stowage

Add new Master field.

Possible values:

• Stow below Deck
• Stow on Deck
• No Special Stowage

UI: radio group

Add to Master details bottom right - see mock up below.

[edit] Booking Remarks

• AN // size 1000 chars
• UI: textarea

UI: Master Det tab, See mock up below.

[edit] New fields for 301

[edit] CY Cutoff Date

• // Date+Time // Last possible date cargo may be delivered to CY
• Editable
• M Det Tab, bottom right

[edit] New Master Fields for reporting

[edit] Created On Date

• date Master was created
• similar to this field that we have for CT
• UI: read only
• DB: name it CreatedOnDate

[edit] Export Operator

• Operator who is responsible for this record on Export side
• default to user who created Master
• UI: Users Selector
• DB: name it ExportOperatorUserId

[edit] Grouping inside Master

Add ability to group/ungroup selected CTs inside the Master.

[edit] Extended Master Templates

Following additional fields must be copied at the moment of creating a template from Master Clone.

Add column / filter of user who created them.

TBD: ask opers/team leads if they cross share 
     or there is a benefit of cross sharing

[edit] Make Address Text fields read only

Make the following fields read-only on Masters profile:

Master#Master Shipper Text
Master#Master Consignee Text
Master#Master Notify Text
Master#Master Pick-up Text
Master#Master Delivery Text

[edit] Tags for required fields

EDI transmission assumes strict validations.

All required fields mast be marked as colored "*" (say orange).

Add note (in orange): "* Required fields for Booking Confirmation"

[edit] EDI Vendor Implementations

• CargoSmart: CSmart 300

[edit] Wiki source files

File:BR+SI+designs Nov13a.xls