-------RUN IN ALL FIRM

USE E25R001

insert into account_master
SELECT        AccCode, AccName, AccType, AccAgentCode, AccGroupCode, AccAdd1, AccAdd2, AccAdd3, AccCityName, AccCityPin, AccPhone, AccMobile, AccFax, AccEmail, AccResident, AccGSTNo, AccCSTNo, AccPANNo, AccVATNo, 
                         AccContPerson, AccRef, AccCrLimit, AccCrDays, 0, 'Dr', 0, AccTANNo, AccKSTNo, TDSYesNo, TDSAccount, DiscPerc, RDPerPcs, RDPerMts, JobType, InsPolicyNo, Taxable, GSTIN, 
                         CompScheme, GSTCategory, GSTRegDate, AccManager, CityDistanceKM, TransName, BlackListed, UdyamRegNumber, EnterpriseType, EnterpriseActivity
FROM            commone.dbo.ACCOUNT_MASTER where acccode not in (select acccode from account_master)