SI Acknowledgement Notifications

Initial development has been completed for these notifications. The test service is currently only available on my desktop. This is a pilot windows service, which currently sends notices to customers (the application will send the notice first the forwarder, if no forwarder then the shipper) after receiving an initial MASTER B/L, MASTER SED, or EDI MASTER Image type from MDWS.

The solution has been added to Source Safe as SIAcknowledgementSolution. Here are the sample notifications (Maersk and Safmarine). I went ahead and made the service so it will handle Safmarine bills, even though they haven’t asked for it.

Testing the implementation, as with most windows services is not easy, but I think we can come up with something. Basically, we need to fill the base table, then run the service from my desk.

1. Database – the initial data is generated from the MDWSProcessImageLink stored procedure, inserting data into the SIAcknowledgementBillTable when the ‘Master B/L’ criteria is met.
   
   • Tables

• SIAcknowledgementBillTable – holds initial data from MDWSProcessImageLink
• SIAcknowledgementReportTable – holds records which a Crystal Report notification is processing from
• SIAcknowledgementContactTable – holds the pilot group customer numbers and contact numbers

Stored Procedures

• SIAcknowledgementGetBillNumber – pulls the initial set of data for the application.
• SIAcknowledgementReportSproc – moves the appropriate data into the report tables
• SIAcknowledgementIndex – indexes the data sent in the notification. The data is indexed into the Images, CustomerInteractions, and CustomerInteractionReasons.

File Storage - Files will be stored on the CDTStore drive.

Application
a.Location – Assume we will install this on the SCRBCDTUSWOFCL2 server
b. Running Time – The requirements say as real-time as possible, I’m thinking about putting the timer at 10 or 20 minutes. This may accomplish close enough to real time as necessary for the pilot group.
c.Who to send to – Send notice first to Forwarder, if no forwarder, then shipper
d.Maersk or Safmarine – compares line code to find company