 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'FATISLID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'FATISLID'*/ ALTER TABLE FATISL ADD FATISLID int NOT NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'FATID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'FATID'*/ ALTER TABLE FATISL ADD FATID int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'STOKID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'STOKID'*/ ALTER TABLE FATISL ADD STOKID int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'ACIKLAMA' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'ACIKLAMA'*/ ALTER TABLE FATISL ADD ACIKLAMA nvarchar(250) NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'ADET' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'ADET'*/ ALTER TABLE FATISL ADD ADET float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'BFIYAT' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'BFIYAT'*/ ALTER TABLE FATISL ADD BFIYAT float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'SATIRIND' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'SATIRIND'*/ ALTER TABLE FATISL ADD SATIRIND float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'SATIRIND2' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'SATIRIND2'*/ ALTER TABLE FATISL ADD SATIRIND2 float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'BARKOD' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'BARKOD'*/ ALTER TABLE FATISL ADD BARKOD nvarchar(30) NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'KODU' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'KODU'*/ ALTER TABLE FATISL ADD KODU nvarchar(20) NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'SATISTID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'SATISTID'*/ ALTER TABLE FATISL ADD SATISTID int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'FBIRIM' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'FBIRIM'*/ ALTER TABLE FATISL ADD FBIRIM nvarchar(50) NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'FADET' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'FADET'*/ ALTER TABLE FATISL ADD FADET float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'VADE' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'VADE'*/ ALTER TABLE FATISL ADD VADE datetime NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'HESAPID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'HESAPID'*/ ALTER TABLE FATISL ADD HESAPID int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'KDV' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'KDV'*/ ALTER TABLE FATISL ADD KDV float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'SRMMRKID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'SRMMRKID'*/ ALTER TABLE FATISL ADD SRMMRKID int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'GKODU' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'GKODU'*/ ALTER TABLE FATISL ADD GKODU nvarchar(10) NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'IRSCOUNTER' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'IRSCOUNTER'*/ ALTER TABLE FATISL ADD IRSCOUNTER int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'IRSCOUNTERILK' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'IRSCOUNTERILK'*/ ALTER TABLE FATISL ADD IRSCOUNTERILK int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'SATIRINDT' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'SATIRINDT'*/ ALTER TABLE FATISL ADD SATIRINDT float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'DEPT' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'DEPT'*/ ALTER TABLE FATISL ADD DEPT nvarchar(15) NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'GELIRGRUP' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'GELIRGRUP'*/ ALTER TABLE FATISL ADD GELIRGRUP nvarchar(15) NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'FBFIYAT' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'FBFIYAT'*/ ALTER TABLE FATISL ADD FBFIYAT float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'FBTOPLAM' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'FBTOPLAM'*/ ALTER TABLE FATISL ADD FBTOPLAM float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'ARATOPLAM' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'ARATOPLAM'*/ ALTER TABLE FATISL ADD ARATOPLAM float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'TOPLAM' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'TOPLAM'*/ ALTER TABLE FATISL ADD TOPLAM float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'SATINALMAISLID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'SATINALMAISLID'*/ ALTER TABLE FATISL ADD SATINALMAISLID int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'SGRUPLA' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'SGRUPLA'*/ ALTER TABLE FATISL ADD SGRUPLA int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'SATIRINDYZD' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'SATIRINDYZD'*/ ALTER TABLE FATISL ADD SATIRINDYZD float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'IRSISLID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'IRSISLID'*/ ALTER TABLE FATISL ADD IRSISLID int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'TEVORAN' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'TEVORAN'*/ ALTER TABLE FATISL ADD TEVORAN nvarchar(5) NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'SKTARIHI' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'SKTARIHI'*/ ALTER TABLE FATISL ADD SKTARIHI datetime NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'MASMERID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'MASMERID'*/ ALTER TABLE FATISL ADD MASMERID int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'IRSALIYEID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'IRSALIYEID'*/ ALTER TABLE FATISL ADD IRSALIYEID int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'FFARKI' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'FFARKI'*/ ALTER TABLE FATISL ADD FFARKI int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'DOVIZKODU' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'DOVIZKODU'*/ ALTER TABLE FATISL ADD DOVIZKODU nvarchar(5) NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'DFBFIYAT' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'DFBFIYAT'*/ ALTER TABLE FATISL ADD DFBFIYAT float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'DBFIYAT' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'DBFIYAT'*/ ALTER TABLE FATISL ADD DBFIYAT float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'ISLREFID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'ISLREFID'*/ ALTER TABLE FATISL ADD ISLREFID int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'KNO' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'KNO'*/ ALTER TABLE FATISL ADD KNO int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'RGDEPOID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'RGDEPOID'*/ ALTER TABLE FATISL ADD RGDEPOID int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'IRSADET' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'IRSADET'*/ ALTER TABLE FATISL ADD IRSADET float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'KRMKODU' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'KRMKODU'*/ ALTER TABLE FATISL ADD KRMKODU nvarchar(20) NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'KRMTUTAR' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'KRMTUTAR'*/ ALTER TABLE FATISL ADD KRMTUTAR float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'TEMPITSID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'TEMPITSID'*/ ALTER TABLE FATISL ADD TEMPITSID int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'KDVTURU' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'KDVTURU'*/ ALTER TABLE FATISL ADD KDVTURU nvarchar(5) NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'MUHDEMIRBASID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'MUHDEMIRBASID'*/ ALTER TABLE FATISL ADD MUHDEMIRBASID int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'MUHAMORTISMANID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'MUHAMORTISMANID'*/ ALTER TABLE FATISL ADD MUHAMORTISMANID int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'MUHMALIYETID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'MUHMALIYETID'*/ ALTER TABLE FATISL ADD MUHMALIYETID int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'BRKAMORTISMAN_YILI' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'BRKAMORTISMAN_YILI'*/ ALTER TABLE FATISL ADD BRKAMORTISMAN_YILI int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'BRKAMORTISMAN_DONEM' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'BRKAMORTISMAN_DONEM'*/ ALTER TABLE FATISL ADD BRKAMORTISMAN_DONEM int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'GECMIS_BRKAMORT' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'GECMIS_BRKAMORT'*/ ALTER TABLE FATISL ADD GECMIS_BRKAMORT float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'CARI_BRKAMORT' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'CARI_BRKAMORT'*/ ALTER TABLE FATISL ADD CARI_BRKAMORT float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'DONEM_BRKAMORT' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'DONEM_BRKAMORT'*/ ALTER TABLE FATISL ADD DONEM_BRKAMORT float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'BIR_AMORT' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'BIR_AMORT'*/ ALTER TABLE FATISL ADD BIR_AMORT float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'IKI_AMORT' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'IKI_AMORT'*/ ALTER TABLE FATISL ADD IKI_AMORT float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'UC_AMORT' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'UC_AMORT'*/ ALTER TABLE FATISL ADD UC_AMORT float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'DORT_AMORT' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'DORT_AMORT'*/ ALTER TABLE FATISL ADD DORT_AMORT float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'MUHFC' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'MUHFC'*/ ALTER TABLE FATISL ADD MUHFC float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'DOVIZKURU' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'DOVIZKURU'*/ ALTER TABLE FATISL ADD DOVIZKURU float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'ITEMTURUID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'ITEMTURUID'*/ ALTER TABLE FATISL ADD ITEMTURUID int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'INDHESAPID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'INDHESAPID'*/ ALTER TABLE FATISL ADD INDHESAPID int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'BAZPUAN' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'BAZPUAN'*/ ALTER TABLE FATISL ADD BAZPUAN float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'KDVAYRILDI' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'KDVAYRILDI'*/ ALTER TABLE FATISL ADD KDVAYRILDI bit NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'KDVACIKLAMA' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'KDVACIKLAMA'*/ ALTER TABLE FATISL ADD KDVACIKLAMA nvarchar(100) NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'SATIRNO' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'SATIRNO'*/ ALTER TABLE FATISL ADD SATIRNO int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'URETICIKODU' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'URETICIKODU'*/ ALTER TABLE FATISL ADD URETICIKODU nvarchar(150) NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'ALICIKODU' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'ALICIKODU'*/ ALTER TABLE FATISL ADD ALICIKODU nvarchar(150) NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'SATICIKODU' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'SATICIKODU'*/ ALTER TABLE FATISL ADD SATICIKODU nvarchar(150) NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'TEMPIADEFATISLID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'TEMPIADEFATISLID'*/ ALTER TABLE FATISL ADD TEMPIADEFATISLID int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'KDV2' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'KDV2'*/ ALTER TABLE FATISL ADD KDV2 float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'TEVKANUNKODU' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'TEVKANUNKODU'*/ ALTER TABLE FATISL ADD TEVKANUNKODU nvarchar(20) NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'TEVKANUNACIKLAMA' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'TEVKANUNACIKLAMA'*/ ALTER TABLE FATISL ADD TEVKANUNACIKLAMA nvarchar(200) NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'KDVSIZLIKKODU' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'KDVSIZLIKKODU'*/ ALTER TABLE FATISL ADD KDVSIZLIKKODU nvarchar(20) NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'OKCKISIMNO' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'OKCKISIMNO'*/ ALTER TABLE FATISL ADD OKCKISIMNO int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'SILINDI' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'SILINDI'*/ ALTER TABLE FATISL ADD SILINDI int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'ISLEMGRUPID1' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'ISLEMGRUPID1'*/ ALTER TABLE FATISL ADD ISLEMGRUPID1 int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'ISLEMGRUPID2' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'ISLEMGRUPID2'*/ ALTER TABLE FATISL ADD ISLEMGRUPID2 int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'ISLEMGRUPID3' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'ISLEMGRUPID3'*/ ALTER TABLE FATISL ADD ISLEMGRUPID3 int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'OZELKOD1' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'OZELKOD1'*/ ALTER TABLE FATISL ADD OZELKOD1 nvarchar(30) NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'OZELKOD2' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'OZELKOD2'*/ ALTER TABLE FATISL ADD OZELKOD2 nvarchar(30) NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'OZELKOD3' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'OZELKOD3'*/ ALTER TABLE FATISL ADD OZELKOD3 nvarchar(30) NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'PROJEID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'PROJEID'*/ ALTER TABLE FATISL ADD PROJEID int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'BMALIYET' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'BMALIYET'*/ ALTER TABLE FATISL ADD BMALIYET float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'KDVLIFIYAT' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'KDVLIFIYAT'*/ ALTER TABLE FATISL ADD KDVLIFIYAT float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'DTOPLAM' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'DTOPLAM'*/ ALTER TABLE FATISL ADD DTOPLAM float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'DOVIZ' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'DOVIZ'*/ ALTER TABLE FATISL ADD DOVIZ nvarchar(5) NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'KUR' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'KUR'*/ ALTER TABLE FATISL ADD KUR float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'SKKARTID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'SKKARTID'*/ ALTER TABLE FATISL ADD SKKARTID int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'SKDETAYID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'SKDETAYID'*/ ALTER TABLE FATISL ADD SKDETAYID int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'YAZICINO' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'YAZICINO'*/ ALTER TABLE FATISL ADD YAZICINO int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'YAZILDI' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'YAZILDI'*/ ALTER TABLE FATISL ADD YAZILDI int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'SIPYAZILDI' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'SIPYAZILDI'*/ ALTER TABLE FATISL ADD SIPYAZILDI int NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'YEVSATIRSIRANO' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'YEVSATIRSIRANO'*/ ALTER TABLE FATISL ADD YEVSATIRSIRANO float NULL END 
 IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id WHERE SYSCOLUMNS.NAME = 'DEMID' AND SYSOBJECTS.name = 'FATISL')  BEGIN /*PRINT 'DEMID'*/ ALTER TABLE FATISL ADD DEMID int NULL END 