Delete Duplicate Query

For Speednet
use pospcc
UPDATE  DeliveryReturns
SET     RemarkCode='1'

For Postman
USE POSTMAN
UPDATE      RegDeliveryMaster
SET             DeliveryOrDespatchDate =TransDate
UPDATE       RegDeliveryReturns
SET              Action ='0',ReasonCode='1'

USE POSTMAN
UPDATE      ParDeliveryMaster
SET             DeliveryOrDespatchDate =TransDate
UPDATE       ParDeliveryReturns
SET              Action ='0',ReasonCode='1'

USE POSTMAN
UPDATE      MoDeliveryMaster
SET             DeliveryOrDespatchDate =TransDate
UPDATE       MoDeliveryReturns
SET              Action ='0',ReasonCode='1'
-------------------------------------------------------------------
For Speednet
use pospcc
UPDATE  DeliveryMaster
SET          DeliveryOrDespatchDate=Transdate
WHERE   (DeliveryOrDespatchDate IS NULL)
 
For Postman
USE POSTMAN
UPDATE      RegDeliveryMaster
SET             DeliveryOrDespatchDate =TransDate
UPDATE       RegDeliveryReturns
SET              [Action] ='0',REASONSCODE='1'

Speednet 3.1.2 update dated 15.12.11 and MNPO Update

Speednet 3.1.2 update dated 15.12.11 and MNPO Update is uploaded in the following link.


http://www.sendspace.com/file/k192h6

TCP IP for All Communication modules

TCP IP for All Communication modules is attached herewith.

Latest MNOP Data Updation as on 13/10/2011 for POS and SpeedNet

MNOP Script: Latest MNOP Data Updation as on 13/10/2011 for POS and SpeedNet.

For details please refer to Release of Revised MNOPScript.doc file kept along with Script File.

It is decided to keep both POS and SpeedNet MNOP Updation Script at a single point download. This script has to be used at all the offices using POS and SpeedNet.

Based on the latest Sorting Extract / Orders received from the Directorate, the Revised MNOP Script is released and the details of the releases are as follows.

This script will contain the entire Hub Master data as per the requirement /modifications - including all the previous revisions. This document shows only the latest revisions.

Link to Download