Inland Arrival Notices: Latest LFD Improvement

I promoted changes this morning to the Inland Arrival and Aged Cargo Notification process which should improve the accuracy of the LFD calculation imbedded in these notices. Apparently, the process was sending out the incorrect LFD’s of previous moves, and was a significant area of improvement from the Maersk and Safmarine Import users.

NAMDAPDEV, developed a function called fnPRIDE_GetCurrentLFD which should retrieve demurrage’s latest LFD for any Bill/Container/Location combination.

This function was added to two database objects: ACGetReportDataSet and ACShipmentDataView which fill the necessary fields on these notices.

Export No Activity 1.1

1. The most significant adjustment is adding Safmarine to the notification list.
   a. All Safmarine branding is included on the notices
   b. Service 26G will not be reported on per Safmarine request since this service has only break bulk shipments
2. Columns added to the notification which will visualize how many containers were booked versus how many containers are active.
3. Containers which are empty will not be counted toward active container total.
   a. This will significantly increase the number of containers reported on.
   b. Stored procedure NoActivityNotificationSproc adjusted
4. New File Server CDTStore will be implemented for all file storage.
   a. All database references to these type of documents will be updated to show new file references (Image and CustomerInteraction tables).
   b. All previous files have been moved from SCRBSQLUSWOF002 to the new file server
   c. Application will write directly to the new file server. There is a virtual path on SCRBSQLUSWOF002 to point to the new folder.
   i. This will enable a consistent URL of nambolt.apmoller.net to be used.

QChat Express Enhancements

Created Enhancements for QChat limited. Expressed the method to sell the application as a relationship builder tool between supervisors and CSRs.

1. Application Name
2. Survey Button Name
3. CA ID, I think??
4. Comments error
5. Rename Category Questions
6. New Question text and question classes
7. Also fixed the calculations

Import Customer Advisory SL Integrity

Created improptu advisory for the SL Integrity 337/0718 due to an onboard fire. 591 notices were sent on 1844 bills.

Delete Duplicate Records Without Temp Table

Good query to have in tool bag, plus don't need temporary table for large deletes.

delete bad_rows
from StrategicAccountsCRC bad_rows with(nolock)
inner join
(
select CustomerNumber, AccountType, CustomerType,
ResponsibleCRC, Customer, MIN(AutoNumber) as min_id
from
StrategicAccountsCRC with(nolock)
group by CustomerNumber, AccountType,
CustomerType, ResponsibleCRC, Customer
having count(*) > 1) good_rows
on Bad_Rows.CustomerNumber = good_rows.CustomerNumber
and
Bad_Rows.AccountType = good_rows.AccountType
and Bad_Rows.CustomerType =
good_rows.CustomerType
and Bad_Rows.ResponsibleCRC =
good_rows.ResponsibleCRC
and Bad_Rows.Customer = good_rows.Customer
and
bad_rows.AutoNumber <> good_rows.min_id