USE COMMON
ALTER TABLE ACCOUNT_MASTER ALTER COLUMN AccAdd21 Varchar(100)
ALTER TABLE ACCOUNT_MASTER ALTER COLUMN AccAdd22 Varchar(100)
ALTER TABLE ACCOUNT_MASTER ALTER COLUMN AccAdd23 Varchar(100)



------RUN IN ALL FIRM FOR ACCOUNT NOT FOUND IN OUTSTANDING OR BILLING REGISTER
USE T24P001

INSERT INTO COMMON.DBO.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, AccTANNo, AccKSTNo, TDSYesNo, TDSAccount, JobType, DiscPerc, RDPerPcs, RDPerMts, InsPolicyNo, Dhara, DharaDays, TransName, AccAdd21, AccAdd22, AccAdd23, 
                         AccCityName2, AccCityPin2, BlackListed, BankDetail, ExcessRate, SeriesName, CommPerc, TDSLimit, BankName, AccountNo, IFSCCode, Branch, LessDays, PackPerPcs, BankCommPerc, BankCommLessPerc, PackPerMts, 
                         PostageCharge, Taxable, GSTIN, CompScheme, GSTCategory, ECommGSTIN, GSTRegDate, AccManager, CityDistanceKM, SMAccCode, TCSApplicable, TCSCollectFrom
FROM            ACCOUNT_MASTER WHERE AccCode NOT IN (SELECT AccCode FROM COMMON.DBO.ACCOUNT_MASTER)