INSERT INTO T202425.DBO.PURCHASE_DETAIL SELECT RIGHT(VouNo,6) AS VouNo, VouCurDate, VouSuppCode, VouCustCode, VouCustSubAgentCode, REPLACE(SuppBillNo,'#',''), SuppBillDate, SuppDueDays, VouGrossAmt, VouNetAmt, CompCode, Uname, CustBillForwarding, VouStatus, OrderForm, FirmCode, right(VouNo,6), PackChrg, SuppDisc, SuppRDPerMts, SuppRDPerPcs, SweetLess, Marka, 0 AS BillReceived, 0 AS CForm, GSTPerc, CGSTPerc, CGSTAmt, SGSTPerc, SGSTAmt, IGSTPerc, IGSTAmt, CESSPerc, CESSAmt, AddPerc, LessPerc, SweetLessPerc, BrokPerc, BrokAmt, AddAmt2, TDSPerc, TDSAmt, TCSPerc, TCSAmt FROM T202526.dbo.OPENING_PURCHASE_DETAIL
INSERT INTO T202425.DBO.PURCHASE_TRANSPORT_DETAIL SELECT RIGHT(VouNo,6) AS VouNo, TransName, TransLRNo, TransLRCase, TransLRDate, TransDespStation, CompCode FROM T202526.dbo.OPENING_PURCHASE_TRANSPORT_DETAIL
INSERT INTO T202425.DBO.PURCHASE_ADDLESS_DETAIL SELECT RIGHT(VouNo,6) AS VouNo, VatAddPerc, VatAddAmt, AddAmt, LessAmt, VouRemark, EntryNo, CompCode, Dhara, Days, PackPerPcs, BankComm, CourierCharge, DharaAmt, PackingPerPcsAmt, BankCommAmt, DharaRD, DharaRDAmt, DiscPerc, DiscAmt FROM T202526.dbo.OPENING_PURCHASE_ADDLESS_DETAIL
INSERT INTO T202425.DBO.PURCHASE_ITEM_DETAIL SELECT RIGHT(VouNo,6) AS VouNo, ItemName, ItemPcs, ItemCut, ItemMts, ItemPer, ItemRate, ItemAmount, CompCode, OrdNo, OrdISrNo, ItemGroupName, ItemFold, ItemFMts, ISrNo, Bale, HSNCode, IGSTPerc, IGSTAmt, CGSTPerc, CGSTAmt, SGSTPerc, SGSTAmt, UTGSTPerc, UTGSTAmt, CESSPerc, CESSAmt, ItemDiscPerc, ItemDiscAmt, ItemAddPerc, ItemAddAmt, PackCharge, TransCharge, AddLess1Name, AddLess1Perc, AddLess1Amt, AddLess2Name, AddLess2Perc, AddLess2Amt FROM T202526.dbo.OPENING_PURCHASE_ITEM_DETAIL
INSERT INTO T202425.DBO.PURCHASE_IMAGES_DETAIL SELECT RIGHT(VouNo,6) AS VouNo, FirmCode, ImgPath FROM T202526.dbo.OPENING_PURCHASE_IMAGES_DETAIL

INSERT INTO T202425.DBO.RECEIVED_DETAIL SELECT RIGHT(RecSrNo,6), RecCustCode, RecCashCheque, RecAmt, RecDate, RecChequeNo, RecBankName, RecSuppCode, RecRemark, RecGRReceived, RecFirmCode, right(RecFirmSrNo,6), CompCode, RecCurDate, RecCurTime, RecUName, RecBrokerPerc, RecBrokerAmt, PackChrg, right(CompSrNo,6), RecExcess, EntNo, BrokLessPerc, BrokLessAmt, NeftRtgs, GSTPerc, CommOn, CommBy FROM T202526.dbo.RECEIVED_DETAIL WHERE (LEN(RecSrNo) = 10)
INSERT INTO T202425.DBO.RECEIVED_PAYMENT_DETAIL SELECT RIGHT(RecSrNo,6), RecISrNo, RecCashCheque, RecChequeNo, RecDate, RecBankName, RecAmt, CompCode FROM T202526.dbo.RECEIVED_PAYMENT_DETAIL WHERE (LEN(RecSrNo) = 10)
INSERT INTO T202425.DBO.RECEIVED_ADDLESS_DETAIL SELECT RIGHT(RecSrNo,6), REPLACE(RecBillNo,'#',''), GRLess, RateDiff, ClaimLess, DiscPerc, DiscAmt, BankComm, PackTrans, OtherLess, AddIntPerc, AddIntAmt, OtherAdd, PaidAmt, Status, CompCode FROM T202526.dbo.RECEIVED_ADDLESS_DETAIL WHERE (LEN(RecSrNo) = 10)
INSERT INTO T202425.DBO.RECEIVED_IMAGES_DETAIL SELECT RIGHT(RecSrNo,6), RecFirmCode, ImgPath FROM T202526.dbo.RECEIVED_IMAGES_DETAIL WHERE (LEN(RecSrNo) = 10)

DELETE FROM T202526.dbo.OPENING_PURCHASE_DETAIL
DELETE FROM T202526.dbo.OPENING_PURCHASE_TRANSPORT_DETAIL
DELETE FROM T202526.dbo.OPENING_PURCHASE_ADDLESS_DETAIL
DELETE FROM T202526.dbo.OPENING_PURCHASE_ITEM_DETAIL
DELETE FROM T202526.dbo.OPENING_PURCHASE_IMAGES_DETAIL

DELETE FROM T202526.dbo.RECEIVED_DETAIL WHERE (LEN(RecSrNo) = 10)
DELETE FROM T202526.dbo.RECEIVED_PAYMENT_DETAIL WHERE (LEN(RecSrNo) = 10)
DELETE FROM T202526.dbo.RECEIVED_ADDLESS_DETAIL WHERE (LEN(RecSrNo) = 10)
DELETE FROM T202526.dbo.RECEIVED_IMAGES_DETAIL WHERE (LEN(RecSrNo) = 10)