UPDATE VS4TAPVoucher Set TAPVCancelStatus=0 WHERE TAPVCancelStatus is null
GO
UPDATE VS4TAPInvoice Set TIAPCancelStatus=0 WHERE TIAPCancelStatus is null
GO
UPDATE VS4TAPCreditNote Set TPCNCancelStatus=0 WHERE TPCNCancelStatus is null
GO
UPDATE VS4TAPDebitNote Set TDENCancelStatus=0 WHERE TDENCancelStatus is null
GO
UPDATE VS4TAPBill Set TPBiCancelStatus=0 WHERE TPBiCancelStatus is null
GO
UPDATE VS4TPO Set TPODCancelStatus=0 WHERE TPODCancelStatus is null
GO
UPDATE VS4TPS Set TPSDCancelStatus=0 WHERE TPSDCancelStatus is null
GO
UPDATE VS4TARVoucher Set TRVHCancelStatus=0 WHERE TRVHCancelStatus is null
GO
UPDATE VS4TARInvoice Set TIvoCancelStatus=0 WHERE TIvoCancelStatus is null
GO
UPDATE VS4TARCreditNote Set TRCNCancelStatus=0 WHERE TRCNCancelStatus is null
GO
UPDATE VS4TARDebitNote Set TDBNCancelStatus=0 WHERE TDBNCancelStatus is null
GO
UPDATE VS4TARBill Set TBilCancelStatus=0 WHERE TBilCancelStatus is null
GO
UPDATE VS4TARReceipt Set TAIHCancelStatus=0 WHERE TAIHCancelStatus is null
GO
UPDATE VS4TSO Set TSODCancelStatus=0 WHERE TSODCancelStatus is null
GO
UPDATE VS4TQuotation Set TQuoCancelStatus=0 WHERE TQuoCancelStatus is null
GO
UPDATE VS4TJob Set TJobCancelStatus=0 WHERE TJobCancelStatus is null
GO
UPDATE VS4TJobProduction Set TJPdCancelStatus=0 WHERE TJPdCancelStatus is null
GO
UPDATE VS4TInventory Set TInvCancelStatus=0 WHERE TInvCancelStatus is null
GO