2013-03-28-5994.200-Spec-DSSCO FTP Process (New Carrier 'Speed' integration). #DSSCOSSISServices

SPECIFICATIONS

5994.200-Spec-DSSCO FTP Process (Freight Forwarder 'Speed' integration).

Purpose

To integrate a new Freight Forwarder (Speed) to existing Automated FTP Process.

Admin Info

Purpose	To integrate a new Freight Forwarder (Speed) to existing Automated FTP Process.
Requested By	Babu Lankipalli
Spec Created By	Sandeep J
Spec Created Date	03/28/2013
Spec QA by	Satish K
Document Status	Completed

References

Functional Requirement

To integrate "Speed" new freight forwarder in the current Auto FTP Process.

Details of Speed Freight Forwarder provided by Babu Lankipalli:

Speed:
FTP: web4.speedgs.com
username: newera
pwd:@sgsFTP4PO

Shipping Instruction number and Shipping Instructions of Speed:

61 Speed Standard Ocean
62 Speed Air

Solution Summary

1) Speed freight forwarder details need to be stored in the Database.
2) Create a batch file for Speed ftp details for FTPing the Speed PO files.
3) Create a Export/Backup folders for speed in the FTP location to drop files and take backup of files.

Test Plan

Test Case ID	Test Case Name	Tested Environment	Steps	Expected Results
DSSCO_TC_FTP_001	Verify a PO having Speed data in OpenPO and Openpos_prev tables .	Dev	1.Take PO(4600003060) and verify the data in OPenPO and Openpos_prev tables.	PO(4600003060) Number data should be preset in both OPenPO and Openpos_prev tables.
DSSCO_TC_FTP_002	Verify exfacdate falls between current date + 30 days in OpenPOs table.	Dev	1. Change the exfacdate in openpos table for the selected PO (4600003060). 2. Run the FTP job.	1.Exfacdate should be changed for selected PO in Openpos table. 2. PO file should be created for selected PO Number (4600003060) in Speed Folder.

Solution Details

1) Speed freight forwarder details to be inserted into DSSCO DB.
2) .bat file (batch file) similar to APL, MIQ, MOHK and FTN will be created with Speed FTP details to FTP Speed PO files.