update ARInvoice set TaxEntityID=null
update APInvoice set TaxEntityID=null
update IV set TaxEntityID=null
update TaxTransAuditDTL set TaxEntityID=null
update GR set TaxEntityID=null
update ARCN set TaxEntityID=null
update QT set TaxEntityID=null
update ARDN set TaxEntityID=null
update PO set TaxEntityID=null
update PI set TaxEntityID=null
update TaxTrans set TaxEntityID=null
update JEDTL set TaxEntityID=null
update Debtor set TaxEntityID = null where tin = update Creditor set TaxEntityID = null
update CB set TaxEntityID=null
update SO set TaxEntityID=null
update XS set TaxEntityID=null
update CN set TaxEntityID=null
update APCN set TaxEntityID = null
update PR set TaxEntityID = null
update XP set TaxEntityID = null
update RQ set TaxEntityID = null
update GT set TaxEntityID = null
UPDATE [dbo].[ConsignmentReturn] SET taxEntityID = NULL;
UPDATE [dbo].[PurchaseConsignment] SET taxEntityID = NULL;
UPDATE [dbo].[PurchaseConsignmentReturn] SET taxEntityID = NULL;
UPDATE [dbo].PaymentMethod SET BankChargeTaxEntityID = NULL;