Viewing File

INSERT INTO COMMONE.DBO.STATE_MASTER SELECT * FROM COMMON.DBO.STATE_MASTER WHERE StateName NOT IN (SELECT StateName FROM COMMONE.DBO.STATE_MASTER)
INSERT INTO COMMONE.DBO.CITY_MASTER SELECT * FROM COMMON.DBO.CITY_MASTER WHERE CityName NOT IN (SELECT CityName FROM COMMONE.DBO.CITY_MASTER)
INSERT INTO COMMONE.DBO.GROUP_MASTER SELECT GrpCode, GrpName, GrpAdd1, GrpAdd2, GrpAdd3, GrpCityName, GrpCityPin, GrpPhone, GrpMobile, GrpFax, GrpEmail, GrpResident, GrpContPerson, AgentCode FROM COMMON.DBO.GROUP_MASTER WHERE GrpCode NOT IN (SELECT GrpCode FROM COMMONE.DBO.GROUP_MASTER)
INSERT INTO COMMONE.DBO.AGENT_MASTER SELECT AgentCode, AgentName, AgentAdd1, AgentAdd2, AgentAdd3, AgentCityName, AgentCityPin, AgentPhone, AgentMobile, AgentFax, AgentEmail, AgentResident, AgentPANNo, AgentContPerson, AccType, GSTIN, CompScheme, GSTRegDate FROM COMMON.DBO.AGENT_MASTER WHERE AgentCode NOT IN (SELECT AgentCode FROM COMMONE.DBO.AGENT_MASTER)
INSERT INTO COMMONE.DBO.ACCOUNT_MASTER SELECT AccCode, AccName, AccType, AccAgentCode, AccGroupCode, LEFT(AccAdd1,40), LEFT(AccAdd2,30), LEFT(AccAdd3,30), AccCityName, AccCityPin, AccPhone, AccMobile, AccFax, AccEmail, AccResident, AccGSTNo, AccCSTNo, AccPANNo, AccVATNo, AccContPerson, LEFT(AccRef,35), AccCrLimit, AccCrDays, AccTANNo, AccKSTNo, TDSYesNo, TDSAccount, DiscPerc, RDPerPcs, RDPerMts, JobType, InsPolicyNo, Taxable, GSTIN, CompScheme, GSTCategory, GSTRegDate, AccManager, CityDistanceKM, TransName, BlackListed, UdyamRegNumber, EnterpriseType, EnterpriseActivity FROM COMMON.DBO.ACCOUNT_MASTER WHERE AccCode NOT IN (SELECT AccCode FROM COMMONE.DBO.ACCOUNT_MASTER)
INSERT INTO COMMONE.DBO.ITEM_MASTER SELECT ItemName, ItemQuality, ItemCut, HSNCode, GSTPerc, DescGST, ItemPer FROM T27N001.DBO.FINISHED_ITEM_MASTER WHERE ItemName NOT IN (SELECT ItemName FROM COMMONE.DBO.ITEM_MASTER)
INSERT INTO COMMONE.DBO.SCREEN_ITEM_MASTER SELECT LEFT(ItemName,30), ItemRatePerPcs, ItemRatePerMts, ItemImagePath, HSNCode, GSTPerc FROM COMMON.DBO.SCREEN_ITEM_MASTER WHERE ItemName NOT IN (SELECT ItemName FROM COMMONE.DBO.SCREEN_ITEM_MASTER)

INSERT INTO E27N001.DBO.STATE_MASTER SELECT * FROM T27N001.DBO.STATE_MASTER WHERE StateName NOT IN (SELECT StateName FROM E27N001.DBO.STATE_MASTER)
INSERT INTO E27N001.DBO.CITY_MASTER SELECT * FROM T27N001.DBO.CITY_MASTER WHERE CityName NOT IN (SELECT CityName FROM E27N001.DBO.CITY_MASTER)
INSERT INTO E27N001.DBO.GROUP_MASTER SELECT GrpCode, GrpName, GrpAdd1, GrpAdd2, GrpAdd3, GrpCityName, GrpCityPin, GrpPhone, GrpMobile, GrpFax, GrpEmail, GrpResident, GrpContPerson, AgentCode FROM T27N001.DBO.GROUP_MASTER WHERE GrpCode NOT IN (SELECT GrpCode FROM E27N001.DBO.GROUP_MASTER)
INSERT INTO E27N001.DBO.AGENT_MASTER SELECT AgentCode, AgentName, AgentAdd1, AgentAdd2, AgentAdd3, AgentCityName, AgentCityPin, AgentPhone, AgentMobile, AgentFax, AgentEmail, AgentResident, AgentPANNo, AgentContPerson, AccType, GSTIN, CompScheme, GSTRegDate FROM T27N001.DBO.AGENT_MASTER WHERE AgentCode NOT IN (SELECT AgentCode FROM E27N001.DBO.AGENT_MASTER)
INSERT INTO E27N001.DBO.ACCOUNT_MASTER SELECT AgentCode, AgentName, AgentAdd1, AgentAdd2, AgentAdd3, AgentCityName, AgentCityPin, AgentPhone, AgentMobile, AgentFax, AgentEmail, AgentResident, AgentPANNo, AgentContPerson, AccType, GSTIN, CompScheme, GSTRegDate FROM T27N001.DBO.AGENT_MASTER WHERE AgentCode NOT IN (SELECT AgentCode FROM E27N001.DBO.AGENT_MASTER)
INSERT INTO E27N001.DBO.ACCOUNT_MASTER SELECT AccCode, AccName, AccType, AccAgentCode, AccGroupCode, LEFT(AccAdd1,40), LEFT(AccAdd2,30), LEFT(AccAdd3,30), AccCityName, AccCityPin, AccPhone, AccMobile, AccFax, AccEmail, AccResident, AccGSTNo, AccCSTNo, AccPANNo, AccVATNo, AccContPerson, LEFT(AccRef,35), AccCrLimit, AccCrDays, AccOpenBal, AccOpenBalCrDr, AccSharePerc, AccTANNo, AccKSTNo, TDSYesNo, TDSAccount, DiscPerc, RDPerPcs, RDPerMts, JobType, InsPolicyNo, Taxable, GSTIN, CompScheme, GSTCategory, GSTRegDate, AccManager, CityDistanceKM, TransName, BlackListed, UdyamRegNumber, EnterpriseType, EnterpriseActivity FROM T27N001.DBO.ACCOUNT_MASTER WHERE AccCode NOT IN (SELECT AccCode FROM E27N001.DBO.ACCOUNT_MASTER)
INSERT INTO E27N001.DBO.ITEM_MASTER SELECT ItemName, ItemQuality, ItemOpeningPcs, ItemOpeningMts, ItemCut, HSNCode, GSTPerc, DescGST, ItemPer FROM T27N001.DBO.FINISHED_ITEM_MASTER WHERE ItemName NOT IN (SELECT ItemName FROM E27N001.DBO.ITEM_MASTER)
INSERT INTO E27N001.DBO.SCREEN_ITEM_MASTER SELECT LEFT(ItemName,30), ItemRatePerPcs, ItemRatePerMts, ItemOpeningPcs, ItemOpeningMts, ItemOpeningValue, ItemImagePath, HSNCode, GSTPerc FROM T27N001.DBO.SCREEN_ITEM_MASTER WHERE ItemName NOT IN (SELECT ItemName FROM E27N001.DBO.SCREEN_ITEM_MASTER)

INSERT INTO E27N001.DBO.OPENING_OUTWARD_DETAIL SELECT BillNo, BillDate, VouNo, CustCode, AgentCode, NetAmt, TransName, TransLRNo, TransLRCase, TransLRDate, TransDespStation, UName, BillStatus, GRAmt, ChqAmt, CashAmt, AddLess, GSTSupplyType, GSTAmt, 0 AS TDSAmt, Remark, TaxableAmt, DiscPerc, DiscAmt, Haste, DispFromCityName, DispFromCityPIN, PaymentWithinDays, DispFromAdd1, DispFromAdd2, ManualOrderNo FROM T27N001.DBO.OPENING_BILL_DETAIL WHERE BillNo NOT IN (SELECT BillNo FROM E27N001.DBO.OPENING_OUTWARD_DETAIL)
INSERT INTO E27N001.DBO.OPENING_FINISHED_PURCHASE SELECT SrNo, BillNo, BillDate, ChallanNo, ChallanRecdDate, WeaverCode, WeaverAgentCode, NetAmt, UName, BillStatus, GRAmt, ChqAmt, CashAmt, AddLess, PurType, GSTSupplyType, GSTAmt, RevCharge, Remark, TaxableAmt, DiscPerc, DiscAmt, Haste FROM T27N001.DBO.OPENING_FINISHED_PURCHASE WHERE SrNo NOT IN (SELECT SrNo FROM E27N001.DBO.OPENING_FINISHED_PURCHASE)
INSERT INTO E27N001.DBO.OPENING_GENERAL_PURCHASE SELECT SrNo, SuppCode, BillDate, BillNo, NetAmt, BillStatus, UName, GRAmt, ChqAmt, CashAmt, AddLess, PLAcc, GSTSupplyType, GSTAmt, RevCharge, GSTITC, TDSAmt, Remark, TaxableAmt, DiscPerc, DiscAmt FROM T27N001.DBO.OPENING_GENERAL_PURCHASE WHERE SrNo NOT IN (SELECT SrNo FROM E27N001.DBO.OPENING_GENERAL_PURCHASE)
INSERT INTO E27N001.DBO.OPENING_RECEIVED_FROM_JOB SELECT SrNo, JobCode, BillDate, BillNo, NetAmt, BillStatus, UName, GRAmt, ChqAmt, CashAmt, AddLess, 'JOBCA/C', GSTSupplyType, GSTAmt, RevCharge, TDSAmt, AgentCode, Remark, TaxableAmt, DiscPerc, DiscAmt FROM T27N001.DBO.OPENING_RECEIVED_FROM_JOB WHERE SrNo NOT IN (SELECT SrNo FROM E27N001.DBO.OPENING_RECEIVED_FROM_JOB)


INSERT INTO E27N001.DBO.RECEIVED_BANK_BOOK_DETAIL SELECT BkSrNo, BkAccCode, BkBankAccCode, BkPartyBankName, BkChequeAmt, BkChequeDate, BkRemark, BkClearingSlipNo, BkCurDate, BkCurTime, BkUName, BkClearingDate, BkChequeNo FROM T27N001.DBO.RECEIVED_BANK_BOOK_DETAIL WHERE BkSrNo NOT IN (SELECT BkSrNo FROM E27N001.DBO.RECEIVED_BANK_BOOK_DETAIL)
INSERT INTO E27N001.DBO.RECEIVED_BANK_BOOK_ADDLESS_DETAIL SELECT BkSrNo, BkBillNo, BkDiscPerc, BkDiscPercAmt, BkRateDiff, BkClaimLess, BkBankCommission, BkAddInterestPerc, BkAddInterestPercAmt, BkBillPaidAmt, BkStatus, BkDisBal, BkRDBal, BkGRBal, BkIntBal, 0, 0 FROM T27N001.DBO.RECEIVED_BANK_BOOK_ADDLESS_DETAIL WHERE BkSrNo NOT IN (SELECT BkSrNo FROM E27N001.DBO.RECEIVED_BANK_BOOK_ADDLESS_DETAIL)
INSERT INTO E27N001.DBO.RECEIVED_CASH_BOOK_DETAIL SELECT BkSrNo, BkAccCode, BkCashAccCode, BkCashAmt, BkCashDate, BkRemark, BkCurDate, BkCurTime, BkUName FROM T27N001.DBO.RECEIVED_CASH_BOOK_DETAIL WHERE BkSrNo NOT IN (SELECT BkSrNo FROM E27N001.DBO.RECEIVED_CASH_BOOK_DETAIL)
INSERT INTO E27N001.DBO.RECEIVED_CASH_BOOK_ADDLESS_DETAIL SELECT BkSrNo, BkBillNo, BkDiscPerc, BkDiscPercAmt, BkRateDiff, BkClaimLess, BkBankCommission, BkAddInterestPerc, BkAddInterestPercAmt, BkBillPaidAmt, BkStatus, BkDisBal, BkRDBal, BkGRBal, BkIntBal, 0, 0 FROM T27N001.DBO.RECEIVED_CASH_BOOK_ADDLESS_DETAIL WHERE BkSrNo NOT IN (SELECT BkSrNo FROM E27N001.DBO.RECEIVED_CASH_BOOK_ADDLESS_DETAIL)

INSERT INTO E27N001.DBO.PAYMENT_BANK_BOOK_DETAIL SELECT BkSrNo, BkAccCode, BkBankAccCode, BkChequeAmt, BkChequeDate, BkRemark, BkCurDate, BkCurTime, BkUName, BkClearingDate, BkChequeNo FROM T27N001.DBO.PAYMENT_BANK_BOOK_DETAIL WHERE BkSrNo NOT IN (SELECT BkSrNo FROM E27N001.DBO.PAYMENT_BANK_BOOK_DETAIL)
INSERT INTO E27N001.DBO.PAYMENT_BANK_BOOK_ADDLESS_DETAIL SELECT BkSrNo, BkBillNo, BkDiscPerc, BkDiscPercAmt, BkRateDiff, BkClaimLess, BkBankCommission, BkAddInterestPerc, BkAddInterestPercAmt, BkBillPaidAmt, BkStatus, BkTDSPartyCode FROM T27N001.DBO.PAYMENT_BANK_BOOK_ADDLESS_DETAIL WHERE BkSrNo NOT IN (SELECT BkSrNo FROM E27N001.DBO.PAYMENT_BANK_BOOK_ADDLESS_DETAIL)
INSERT INTO E27N001.DBO.PAYMENT_CASH_BOOK_DETAIL SELECT BkSrNo, BkAccCode, BkCashAccCode, BkCashAmt, BkCashDate, BkRemark, BkCurDate, BkCurTime, BkUName FROM T27N001.DBO.PAYMENT_CASH_BOOK_DETAIL WHERE BkSrNo NOT IN (SELECT BkSrNo FROM E27N001.DBO.PAYMENT_CASH_BOOK_DETAIL)
INSERT INTO E27N001.DBO.PAYMENT_CASH_BOOK_ADDLESS_DETAIL SELECT BkSrNo, BkBillNo, BkDiscPerc, BkDiscPercAmt, BkRateDiff, BkClaimLess, BkBankCommission, BkAddInterestPerc, BkAddInterestPercAmt, BkBillPaidAmt, BkStatus FROM T27N001.DBO.PAYMENT_CASH_BOOK_ADDLESS_DETAIL WHERE BkSrNo NOT IN (SELECT BkSrNo FROM E27N001.DBO.PAYMENT_CASH_BOOK_ADDLESS_DETAIL)

INSERT INTO E27N001.DBO.RECEIVED_RETURN_GOODS_DETAIL SELECT BkSrNo, BkAccCode, BkGRAmt, BkGRDate, BkRemark, BkCurDate, BkCurTime, TransName, TransLRNo, TransLRCase, TransLRDate, TransFromStation, Haste, CreditNoteNo, SaleRtnType, GSTSupplyType, EInvActNo, EInvActDate, EInvIRN, EInvQRCode, EWayNo FROM T27N001.DBO.RECEIVED_RETURN_GOODS_DETAIL WHERE BkSrNo NOT IN (SELECT BkSrNo FROM E27N001.DBO.RECEIVED_RETURN_GOODS_DETAIL)
INSERT INTO E27N001.DBO.RECEIVED_RETURN_GOODS_ADDLESS_DETAIL SELECT BkSrNo, BkBillNo, BkBillGRAmt, BkStatus, BkDescription, ISrNo, AdjGST, AdjGSTPerc FROM T27N001.DBO.RECEIVED_RETURN_GOODS_ADDLESS_DETAIL WHERE BkSrNo NOT IN (SELECT BkSrNo FROM E27N001.DBO.RECEIVED_RETURN_GOODS_ADDLESS_DETAIL)
INSERT INTO E27N001.DBO.RECEIVED_RETURN_GOODS_ITEM_DETAIL SELECT BkSrNo, BkItemName, BkCut, BkPcs, BkMts, BkPer, BkRate, BkBillGRAmt, DesignScreen, ISrNo, PurSrNo, PurISrNo, PurRate, PurAmt, HSNCode, IGSTPerc, IGSTAmt, CGSTPerc, CGSTAmt, SGSTPerc, SGSTAmt, UTGSTPerc, UTGSTAmt, CESSPerc, CESSAmt, ItemDiscPerc, ItemDiscAmt, ItemAddPerc, ItemAddAmt, AddLess1Name, AddLess1Perc, AddLess1Amt, AddLess2Name, AddLess2Perc, AddLess2Amt FROM T27N001.DBO.RECEIVED_RETURN_GOODS_ITEM_DETAIL WHERE BkSrNo NOT IN (SELECT BkSrNo FROM E27N001.DBO.RECEIVED_RETURN_GOODS_ITEM_DETAIL)

INSERT INTO E27N001.DBO.MULTI_JOURNAL_DETAIL SELECT BkSrNo, BkAccCode, BkDrCr, BkCurDate, BkUname, JVType, GSTSupplyType FROM T27N001.DBO.MULTI_JOURNAL_DETAIL WHERE BkSrNo NOT IN (SELECT BkSrNo FROM E27N001.DBO.MULTI_JOURNAL_DETAIL)
INSERT INTO E27N001.DBO.MULTI_JOURNAL_ADDLESS_DETAIL SELECT BkSrNo, BkISrNo, BkDrCrParty, BkBillPaidAmt, BkBillNo, VouNo, JVDate, BkRemark, BkStatus, BkBillNo2, BkStatus2, HSNCode, IGSTPerc, IGSTAmt, CGSTPerc, CGSTAmt, SGSTPerc, SGSTAmt, UTGSTPerc, UTGSTAmt, CESSPerc, CESSAmt, ItemDiscPerc, ItemDiscAmt, ItemAddPerc, ItemAddAmt, GSTITC, ROffAmt, TDSPerc, TDSAmt, TDSAcc, IncomeTaxPerc, IncomeTaxAmt, SurchargePerc, SurchargeAmt, EduCessPerc, EduCessAmt, TDSType, TDSDate, TDSRecPay, PartyNoteNo, EInvActNo, EInvActDate, EInvIRN, EInvQRCode, EWayNo FROM T27N001.DBO.MULTI_JOURNAL_ADDLESS_DETAIL WHERE BkSrNo NOT IN (SELECT BkSrNo FROM E27N001.DBO.MULTI_JOURNAL_ADDLESS_DETAIL)

DELETE FROM COMMONE.DBO.COMPANY_DETAIL WHERE CompCode = 'E27N001' 
INSERT INTO COMMONE.DBO.COMPANY_DETAIL SELECT 'E27N001', CompName, CompOpeningDate, CompClosingDate, CompYear, CompStatus, NextYearCode FROM COMMON.DBO.COMPANY_DETAIL WHERE CompCode = 'T27N001' 
DELETE FROM E27N001.DBO.COMPANY_DETAIL WHERE CompCode = 'E27N001' 
INSERT INTO E27N001.DBO.COMPANY_DETAIL SELECT 'E27N001', CompName, CompAdd1, CompAdd2, CompAdd3, CompCityName, CompCityPin, CompCountry, CompPhone, CompMobile, CompFax, CompEmail, CompResident, CompGSTNo, CompCSTNo, CompPANNo, CompVATNo, CompOpeningDate, CompClosingDate, CompYear, CompCurBase, CompCurUnit, CompCaption1, CompCaption2, CompFirmType, CompSign, BranchAddress, CompTANNo, CompTDSITO, GSTIN, GSPUserName, GSPPassword, GSPUserName2, GSPPassword2, DefaultGSP, UdyamRegNumber, EnterpriseType, EnterpriseActivity, GSPUserName3, GSPPassword3 FROM T27N001.DBO.COMPANY_DETAIL WHERE CompCode = 'T27N001' 


UPDATE E27N001.DBO.ACCOUNT_MASTER SET AccOpenBal = T1.F1, AccOpenBalCrDr = T1.F2 FROM (SELECT AccCode AS F0, AccOpenBal AS F1, AccOpenBalCrDr AS F2 FROM T27N001.DBO.ACCOUNT_MASTER) AS T1 WHERE T1.F0 = AccCode