CREATE TABLE [dbo].[Tb_Adres](
	[AdrId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[AdrModul] [smallint] NULL,
	[AdrTip] [smallint] NULL,
	[AdrUnvan] [nvarchar](100) NULL,
	[AdrAdres] [nvarchar](100) NULL,
	[AdrSemt] [nvarchar](20) NULL,
	[AdrIlce] [nvarchar](20) NULL,
	[AdrIl] [nvarchar](20) NULL,
	[AdrUlke] [nvarchar](20) NULL,
	[AdrIlceId] [decimal](18, 0) NULL,
	[AdrIlId] [decimal](18, 0) NULL,
	[AdrUlkeId] [decimal](18, 0) NULL,
	[AdrPostaKodu] [nvarchar](10) NULL,
	[AdrKartId] [decimal](18, 0) NULL,
 CONSTRAINT [PK_Tb_Adres] PRIMARY KEY CLUSTERED 
(
	[AdrId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Ajanda](
	[AjdId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[AjdTarih] [date] NULL,
	[AjdTur] [tinyint] NULL,
	[AjdNot] [nvarchar](500) NULL,
	[AjdKapandi] [tinyint] NULL,
	[AjdKullKodu] [nvarchar](20) NULL,
	[AjdKime] [nvarchar](20) NULL,
 CONSTRAINT [PK_Tb_Ajanda] PRIMARY KEY CLUSTERED 
(
	[AjdId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_BankaFis](
	[BnFId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[BnFTur] [tinyint] NULL,
	[BnFTarih] [date] NULL,
	[BnFSaat] [nvarchar](5) NULL,
	[BnFEvrakNo] [nvarchar](20) NULL,
	[BnFFisNo] [nvarchar](20) NULL,
	[BnFHesapId] [decimal](18, 0) NULL,
	[BnFsMerkId] [decimal](18, 0) NULL,
	[BnFPersId] [decimal](18, 0) NULL,
	[BnFAciklama] [nvarchar](200) NULL,
	[BnFOzelKod1] [nvarchar](20) NULL,
	[BnFOzelKod2] [nvarchar](20) NULL,
	[BnFOzelKod3] [nvarchar](20) NULL,
	[BnFKayKullanici] [nvarchar](20) NULL,
	[BnFKayitTarihi] [date] NULL,
	[BnFKayitSaati] [time](5) NULL,
	[BnFDuzKullanici] [nvarchar](20) NULL,
	[BnFDuzeltTarihi] [date] NULL,
	[BnFDuzeltSaat] [time](5) NULL,
	[BnFMagazaKodu] [nvarchar](20) NULL,
 CONSTRAINT [PK_TbBankFis] PRIMARY KEY CLUSTERED 
(
	[BnFId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_BankaHareket](
	[BnHId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[BnHFisId] [decimal](18, 0) NULL,
	[BnHTur] [tinyint] NULL,
	[BnHTarih] [date] NULL,
	[BnHSaat] [nvarchar](5) NULL,
	[BnHEvrakNo] [nvarchar](20) NULL,
	[BnHHesapId] [decimal](18, 0) NULL,
	[BnHTipi] [tinyint] NULL,
	[BnHKarsiHsId] [decimal](18, 0) NULL,
	[BnHTutar] [money] NULL,
	[BnHFaiz] [money] NULL,
	[BnHDovizTip] [nvarchar](5) NULL,
	[BnHDoviz] [nvarchar](4) NULL,
	[BnHDovizTutar] [money] NULL,
	[BnHKur] [money] NULL,
	[BnHMsMerkId] [decimal](18, 0) NULL,
	[BnHPersId] [decimal](18, 0) NULL,
	[BnHAciklama] [nvarchar](200) NULL,
	[BnHOzelKod1] [nvarchar](20) NULL,
	[BnHOzelKod2] [nvarchar](20) NULL,
	[BnHOzelKod3] [nvarchar](20) NULL,
	[BnHKayKullanici] [nvarchar](20) NULL,
	[BnHKayitTarihi] [date] NULL,
	[BnHKayitSaati] [time](5) NULL,
	[BnHDuzKullanici] [nvarchar](20) NULL,
	[BnHDuzeltTarihi] [date] NULL,
	[BnHDuzeltSaat] [time](5) NULL,
	[BnHMagazaKodu] [nvarchar](20) NULL,
	[BnHKdvOrn] [money] NULL,
	[BnHKomisyon] [money] NULL,
 CONSTRAINT [PK_TbBankaHareket] PRIMARY KEY CLUSTERED 
(
	[BnHId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Barkod](
	[BarId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[BarStokId] [decimal](18, 0) NULL,
	[BarBarkod] [nvarchar](50) NULL,
	[BarTipi] [tinyint] NULL,
	[BarBirim] [tinyint] NULL,
	[BarMiktar] [money] NULL,
	[BarFiyat] [money] NULL,
	[BarDoviz] [nvarchar](4) NULL,
 CONSTRAINT [PK_Tb_Barkod] PRIMARY KEY CLUSTERED 
(
	[BarId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_CariBank](
	[CrBId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[CrBSubeId] [decimal](18, 0) NULL,
	[CrBBankaId] [decimal](18, 0) NULL,
	[CrBHesapNo] [nvarchar](20) NULL,
	[CrBIbanNo] [nvarchar](30) NULL,
	[CrBCariId] [decimal](18, 0) NULL,
 CONSTRAINT [PK_Tb_CariBank] PRIMARY KEY CLUSTERED 
(
	[CrBId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_CariFis](
	[CrFId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[CrFTur] [tinyint] NULL,
	[CrFTarih] [date] NULL,
	[CrFSaat] [nvarchar](5) NULL,
	[CrFEvrakNo] [nvarchar](20) NULL,
	[CrFFisNo] [nvarchar](20) NULL,
	[CrFCariId] [decimal](18, 0) NULL,
	[CrFsMerkId] [decimal](18, 0) NULL,
	[CrFPersId] [decimal](18, 0) NULL,
	[CrFAciklama] [nvarchar](200) NULL,
	[CrFOzelKod1] [nvarchar](20) NULL,
	[CrFOzelKod2] [nvarchar](20) NULL,
	[CrFOzelKod3] [nvarchar](20) NULL,
	[CrFKayKullanici] [nvarchar](20) NULL,
	[CrFKayitTarihi] [date] NULL,
	[CrFKayitSaati] [time](5) NULL,
	[CrFDuzKullanici] [nvarchar](20) NULL,
	[CrFDuzeltTarihi] [date] NULL,
	[CrFDuzeltSaat] [time](5) NULL,
	[CrFMagazaKodu] [nvarchar](20) NULL,
 CONSTRAINT [PK_TbCariFis] PRIMARY KEY CLUSTERED 
(
	[CrFId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_CariHareket](
	[CrHId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[CrHFisId] [decimal](18, 0) NULL,
	[CrHTur] [tinyint] NULL,
	[CrHTarih] [date] NULL,
	[CrHSaat] [nvarchar](5) NULL,
	[CrhEvrakNo] [nvarchar](20) NULL,
	[CrHCariId] [decimal](18, 0) NULL,
	[CrHTipi] [tinyint] NULL,
	[CrHBrAl] [tinyint] NULL,
	[CrHKarsiHsId] [decimal](18, 0) NULL,
	[CrHTutar] [money] NULL,
	[CrHFaiz] [money] NULL,
	[CrHDovizTip] [nvarchar](5) NULL,
	[CrHDoviz] [nvarchar](4) NULL,
	[CrHDovizTutar] [money] NULL,
	[CrHKur] [money] NULL,
	[CrHMsMerkId] [decimal](18, 0) NULL,
	[CrHPersId] [decimal](18, 0) NULL,
	[CrHAciklama] [nvarchar](200) NULL,
	[CrHOzelKod1] [nvarchar](20) NULL,
	[CrHOzelKod2] [nvarchar](20) NULL,
	[CrHOzelKod3] [nvarchar](20) NULL,
	[CrHKayKullanici] [nvarchar](20) NULL,
	[CrHKayitTarihi] [date] NULL,
	[CrHKayitSaati] [time](5) NULL,
	[CrHDuzKullanici] [nvarchar](20) NULL,
	[CrHDuzeltTarihi] [date] NULL,
	[CrHDuzeltSaat] [time](5) NULL,
	[CrHMagazaKodu] [nvarchar](20) NULL,
	[CrHTaksit] [money] NULL,
	[CrHEntgTipi] [tinyint] NULL,
	[CrHEntgId] [decimal](18, 0) NULL,
	[CrHEkPosId] [decimal](18, 0) NULL,
 CONSTRAINT [PK_TbCariHareket] PRIMARY KEY CLUSTERED 
(
	[CrHId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_CariKart](
	[CarId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[CarKod] [nvarchar](30) NULL,
	[CarUnvan] [nvarchar](100) NULL,
	[CarKartTur] [tinyint] NULL,
	[CarAd] [nvarchar](30) NULL,
	[CarSoyAd] [nvarchar](50) NULL,
	[CarTelf1] [nvarchar](20) NULL,
	[CarTelf2] [nvarchar](20) NULL,
	[CarTelf3] [nvarchar](20) NULL,
	[CarTelf4] [nvarchar](20) NULL,
	[CarTelf5] [nvarchar](20) NULL,
	[CarOzelKod1] [nvarchar](20) NULL,
	[CarOzelKod2] [nvarchar](20) NULL,
	[CarOzelKod3] [nvarchar](20) NULL,
	[CarOzelKod4] [nvarchar](20) NULL,
	[CarOzelKod5] [nvarchar](20) NULL,
	[CarKrediLimit] [money] NULL,
	[CarRiskLimit] [money] NULL,
	[CarOdeGun] [smallint] NULL,
	[CarAnaIsk] [money] NULL,
	[CarVerDaire] [nvarchar](20) NULL,
	[CarVerNo] [nvarchar](20) NULL,
	[CarAnaGrup] [nvarchar](5) NULL,
	[CarMail] [nvarchar](50) NULL,
	[CarKartNo] [nvarchar](20) NULL,
	[CarAnaAdres] [nvarchar](100) NULL,
	[CarAnaSemt] [nvarchar](20) NULL,
	[CarAnaIlce] [nvarchar](20) NULL,
	[CarAnaIl] [nvarchar](20) NULL,
	[CarAnaUlke] [nvarchar](20) NULL,
	[CarAnaPosta] [nvarchar](10) NULL,
	[CarAciklama] [nvarchar](1000) NULL,
	[CarUyari] [nvarchar](200) NULL,
	[CarResim] [nvarchar](200) NULL,
	[CarResim1] [nvarchar](200) NULL,
	[CarSekId] [decimal](18, 0) NULL,
	[CarSorId] [decimal](18, 0) NULL,
	[CarWebAdr] [nvarchar](200) NULL,
	[CarAltGrup] [nvarchar](5) NULL,
	[CarIsk1] [money] NULL,
	[CarIsk2] [money] NULL,
	[CarSipUst] [money] NULL,
	[CarSipAlt] [money] NULL,
	[CarDoviz] [nvarchar](4) NULL,
	[CarDovizTip] [nvarchar](5) NULL,
	[CarOdGun] [tinyint] NULL,
	[CarOdTur] [tinyint] NULL,
	[CarYazisma] [tinyint] NULL,
	[CarFatura] [tinyint] NULL,
	[CarSevk] [tinyint] NULL,
	[CarVdFrGec] [money] NULL,
	[CarVdFrErk] [money] NULL,
	[CarTanimlar] [nvarchar](30) NULL,
	[CarKartTipi] [nvarchar](30) NULL,
	[CarAciklama1] [nvarchar](50) NULL,
	[CarAciklama2] [nvarchar](50) NULL,
	[CarAciklama3] [nvarchar](50) NULL,
	[CarEkTutar1] [money] NULL,
	[CarEkTutar2] [money] NULL,
	[CarEkTutar3] [money] NULL,
	[CarEkOran1] [money] NULL,
	[CarEkOran2] [money] NULL,
	[CarEkOran3] [money] NULL,
	[CarKayKullanici] [nvarchar](20) NULL,
	[CarKayitTarihi] [date] NULL,
	[CarKayitSaati] [time](5) NULL,
	[CarDuzKullanici] [nvarchar](20) NULL,
	[CarDuzeltTarihi] [date] NULL,
	[CarDuzeltSaati] [time](5) NULL,
	[CarMagazaKodu] [nvarchar](50) NULL,
	[CarCinsiyet] [tinyint] NULL,
	[CarDogumYer] [nvarchar](20) NULL,
	[CarMedeniHal] [tinyint] NULL,
	[CarDogumTarih] [date] NULL,
	[CarEvlilikTarih] [date] NULL,
	[CarEsAd] [nvarchar](20) NULL,
	[CarCocukSayi] [tinyint] NULL,
	[CarAnaAd] [nvarchar](20) NULL,
	[CarBabaAd] [nvarchar](20) NULL,
	[CarAnneKzSoyad] [nvarchar](20) NULL,
	[CarOturEv] [tinyint] NULL,
	[CarAylikKira] [money] NULL,
	[CarOturmaYil] [tinyint] NULL,
	[CarHaneKisi] [tinyint] NULL,
	[CarAskerlik] [tinyint] NULL,
	[CarOgrenim] [tinyint] NULL,
	[CarDin] [tinyint] NULL,
	[CarKan] [tinyint] NULL,
	[CarTcKimlikNo] [nvarchar](20) NULL,
	[CarKimlikNo] [nvarchar](20) NULL,
	[CarKimIl] [nvarchar](20) NULL,
	[CarKimIlce] [nvarchar](20) NULL,
	[CarKimKoy] [nvarchar](20) NULL,
	[CarKimVerYer] [nvarchar](20) NULL,
	[CarKimVerNed] [nvarchar](20) NULL,
	[CarKimTarih] [date] NULL,
	[CarCiltNo] [nvarchar](5) NULL,
	[CarSiraNo] [nvarchar](5) NULL,
	[CarAileNo] [nvarchar](5) NULL,
	[CarUyruk] [tinyint] NULL,
	[CarUyrukUlke] [nvarchar](20) NULL,
	[CarIsyeriAd] [nvarchar](30) NULL,
	[CarGorev] [nvarchar](20) NULL,
	[CarSskNo] [nvarchar](20) NULL,
	[CarEmekliNo] [nvarchar](20) NULL,
	[CarEhliyetTip] [nvarchar](2) NULL,
	[CarEhliyetNo] [nvarchar](20) NULL,
	[CarEhliyetTarih] [date] NULL,
	[CarPasaportNo] [nvarchar](20) NULL,
	[CarMeslek] [nvarchar](20) NULL,
	[CarIlceId] [decimal](18, 0) NULL,
	[CarIlId] [decimal](18, 0) NULL,
	[CarUlkeId] [decimal](18, 0) NULL,
	[CarDevirBorc] [money] NULL,
	[CarDevirAlacak] [money] NULL,
	[CarNakitBorc] [money] NULL,
	[CarNakitAlacak] [money] NULL,
	[CarCekBorc] [money] NULL,
	[CarCekAlacak] [money] NULL,
	[CarSenetBorc] [money] NULL,
	[CarSenetAlacak] [money] NULL,
	[CarKKartBorc] [money] NULL,
	[CarKKartAlacak] [money] NULL,
	[CarFaturaBorc] [money] NULL,
	[CarFaturaAlacak] [money] NULL,
	[CarFaizBorc] [money] NULL,
	[CarFaiz] [money] NULL,
	[CarTeminatBorc] [money] NULL,
	[CarTeminatAlacak] [money] NULL,
	[CarOdKartBorc] [money] NULL,
	[CarOdKartAlacak] [money] NULL,
	[CarBakiye] [money] NULL,
	[CarSatisBorc] [money] NULL,
	[CarRiskToplm] [money] NULL,
	[CarEftSnTip] [tinyint] NULL,
	[CarEftGnTip] [tinyint] NULL,
	[CarEftTipi] [tinyint] NULL,
	[CarEftPsKt] [nvarchar](50) NULL,
	[CarEirTipi] [tinyint] NULL,
	[CarEiRPsKt] [nvarchar](50) NULL,
 CONSTRAINT [PK_Tb_CariKart] PRIMARY KEY CLUSTERED 
(
	[CarId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_CkSnFis](
	[CsFId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[CsFTur] [tinyint] NULL,
	[CsFFisTuru] [tinyint] NULL,
	[CsFTarih] [date] NULL,
	[CsFSaat] [nvarchar](5) NULL,
	[CsFEvrakNo] [nvarchar](20) NULL,
	[CsFFisNo] [nvarchar](20) NULL,
	[CsFsMerkId] [decimal](18, 0) NULL,
	[CsFPersId] [decimal](18, 0) NULL,
	[CsFAciklama] [nvarchar](200) NULL,
	[CsFOzelKod1] [nvarchar](20) NULL,
	[CsFOzelKod2] [nvarchar](20) NULL,
	[CsFOzelKod3] [nvarchar](20) NULL,
	[CsFKayKullanici] [nvarchar](20) NULL,
	[CsFKayitTarihi] [date] NULL,
	[CsFKayitSaati] [time](5) NULL,
	[CsFDuzKullanici] [nvarchar](20) NULL,
	[CsFDuzeltTarihi] [date] NULL,
	[CsFDuzeltSaat] [time](5) NULL,
	[CsFMagazaKodu] [nvarchar](20) NULL,
 CONSTRAINT [PK_TbCkSnFis] PRIMARY KEY CLUSTERED 
(
	[CsFId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_CkSnHareket](
	[CsHId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[CsHFisId] [decimal](18, 0) NULL,
	[CsHTur] [tinyint] NULL,
	[CsHFisTuru] [tinyint] NULL,
	[CsHTarih] [date] NULL,
	[CsHSaat] [nvarchar](5) NULL,
	[CsHEvrakNo] [nvarchar](20) NULL,
	[CsHEvrakId] [decimal](18, 0) NULL,
	[CsHTipi] [tinyint] NULL,
	[CsHKarsiHsId] [decimal](18, 0) NULL,
	[CsHTutar] [money] NULL,
	[CsHDovizTip] [nvarchar](5) NULL,
	[CsHDoviz] [nvarchar](4) NULL,
	[CsHDovizTutar] [money] NULL,
	[CsHKur] [money] NULL,
	[CsHMsMerkId] [decimal](18, 0) NULL,
	[CsHPersId] [decimal](18, 0) NULL,
	[CsHAciklama] [nvarchar](200) NULL,
	[CsHOzelKod1] [nvarchar](20) NULL,
	[CsHOzelKod2] [nvarchar](20) NULL,
	[CsHOzelKod3] [nvarchar](20) NULL,
	[CsHKayKullanici] [nvarchar](20) NULL,
	[CsHKayitTarihi] [date] NULL,
	[CsHKayitSaati] [time](5) NULL,
	[CsHDuzKullanici] [nvarchar](20) NULL,
	[CsHDuzeltTarihi] [date] NULL,
	[CsHDuzeltSaat] [time](5) NULL,
	[CsHMagazaKodu] [nvarchar](20) NULL,
 CONSTRAINT [PK_TbCkSnHareket] PRIMARY KEY CLUSTERED 
(
	[CsHId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_CkSnKart](
	[CksId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[CksPortfoyNo] [nvarchar](30) NULL,
	[CksTutar] [money] NULL,
	[CksDoviz] [nvarchar](4) NULL,
	[CksDovizTip] [nvarchar](5) NULL,
	[CksTanzimTarih] [date] NULL,
	[CksVadeTarih] [date] NULL,
	[CksErOdeOran] [money] NULL,
	[CksGcOdeOran] [money] NULL,
	[CksYetkMahk] [nvarchar](20) NULL,
	[CksKesideYeri] [nvarchar](20) NULL,
	[CksDurum] [tinyint] NULL,
	[CksNo] [nvarchar](30) NULL,
	[CksCariId] [decimal](18, 0) NULL,
	[CksTuru] [tinyint] NULL,
	[CksDuzenleyen] [nvarchar](40) NULL,
	[CksDuzTipi] [tinyint] NULL,
	[CksDuzenId] [decimal](18, 0) NULL,
	[CksKefilId] [decimal](18, 0) NULL,
	[CksKefilAdSoy] [nvarchar](40) NULL,
	[CksKefilTipi] [tinyint] NULL,
	[CksKefVrDa] [nvarchar](20) NULL,
	[CksKefVrNo] [nvarchar](20) NULL,
	[CksKefAdres] [nvarchar](100) NULL,
	[CksKefTCNo] [nvarchar](20) NULL,
	[CksPulAdet] [tinyint] NULL,
	[CksPulTutar] [money] NULL,
	[CksOzelKod1] [nvarchar](20) NULL,
	[CksOzelKod2] [nvarchar](20) NULL,
	[CksOzelKod3] [nvarchar](20) NULL,
	[CksOzelKod4] [nvarchar](20) NULL,
	[CksOzelKod5] [nvarchar](20) NULL,
	[CksAciklama] [nvarchar](1000) NULL,
	[CksUyari] [nvarchar](200) NULL,
	[CksKartTuru] [tinyint] NULL,
	[CksHesapId] [decimal](18, 0) NULL,
	[CksSubeId] [decimal](18, 0) NULL,
	[CksSubeAd] [nvarchar](30) NULL,
	[CksBankaId] [decimal](18, 0) NULL,
	[CksBankaTip] [tinyint] NULL,
	[CksHesapNo] [nvarchar](20) NULL,
	[CksIbanNo] [nvarchar](30) NULL,
	[CksKayKullanici] [nvarchar](20) NULL,
	[CksKayitTarihi] [date] NULL,
	[CksKayitSaati] [time](5) NULL,
	[CksDuzKullanici] [nvarchar](20) NULL,
	[CksDuzeltTarihi] [date] NULL,
	[CksDuzeltSaati] [time](5) NULL,
	[CksMagazaKodu] [nvarchar](50) NULL,
	[CksCiroId] [decimal](18, 0) NULL,
	[CksCiroTp] [tinyint] NULL,
	[CksDurumTx] [nvarchar](10) NULL,
	[CksDurum0] [tinyint] NULL,
	[CksDurum1] [tinyint] NULL,
	[CksDurum2] [tinyint] NULL,
	[CksDurum3] [tinyint] NULL,
	[CksDurum4] [tinyint] NULL,
	[CksDurum5] [tinyint] NULL,
	[CksDurum6] [tinyint] NULL,
	[CksDurum7] [tinyint] NULL,
	[CksDurum8] [tinyint] NULL,
	[CksDurum9] [tinyint] NULL,
	[CksModul] [tinyint] NULL,
 CONSTRAINT [PK_Tb_CkSnKart] PRIMARY KEY CLUSTERED 
(
	[CksId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Depo](
	[DepId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[DepKod] [nvarchar](10) NULL,
	[DepAd] [nvarchar](30) NULL,
	[DepYetkili] [nvarchar](30) NULL,
	[DepTelefon] [nvarchar](20) NULL,
	[DepAdres] [nvarchar](100) NULL,
	[DepDurum] [tinyint] NULL,
 CONSTRAINT [PK_Tb_Depo] PRIMARY KEY CLUSTERED 
(
	[DepId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_eft_eIrsaliye](
	[EiRId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[EiRIrsId] [decimal](18, 0) NULL,
	[EiRTypeCode] [tinyint] NULL,
	[EiRTrackNo] [int] NULL,
	[EiRTasiNot] [nvarchar](50) NULL,
	[EiRTasiTur] [tinyint] NULL,
	[EiRTasiTip] [tinyint] NULL,
	[EirTsSofAd1] [nvarchar](20) NULL,
	[EirTsSofAd2] [nvarchar](20) NULL,
	[EiRTsSofAd3] [nvarchar](20) NULL,
	[EiRTsSofSy1] [nvarchar](20) NULL,
	[EirTsSofSy2] [nvarchar](20) NULL,
	[EirTsSofSy3] [nvarchar](20) NULL,
	[EiRTsAracKd] [nvarchar](20) NULL,
	[EiRTsAracAd] [nvarchar](20) NULL,
	[EirTsFirmAd] [nvarchar](50) NULL,
	[EiRTsFirmVn] [nvarchar](20) NULL,
	[EiRTsSofTc1] [nvarchar](20) NULL,
	[EiRTsSofTc2] [nvarchar](20) NULL,
	[EiRTsSofTc3] [nvarchar](20) NULL,
	[EiRSenaryo] [tinyint] NULL CONSTRAINT [DF_Tb_eft_eIrsaliye_EiRSenaryo]  DEFAULT ((0)),
	[EiRFizTsTr] [date] NULL,
	[EiRFzTsSa] [nvarchar](5) NULL,
	[EiRGonTip] [tinyint] NULL,
	[EirtUrlAd] [nvarchar](200) NULL,
	[EirSisNo] [nvarchar](20) NULL,
	[EirtIrsNo] [nvarchar](20) NULL,
	[EiRReqId] [int] NULL,
	[EiRCevTp] [tinyint] NULL,
	[EirIrsTipi] [tinyint] NULL,
	[EiRMatTar] [date] NULL,
	[EirMatNo] [nvarchar](20) NULL,
 CONSTRAINT [PK_eft_eIrsaliye] PRIMARY KEY CLUSTERED 
(
	[EiRId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_EkPosKart](
	[EkpId] [decimal](18, 0) NOT NULL,
	[EkpAd] [nvarchar](20) NULL,
	[EkpHesapId] [decimal](18, 0) NULL,
	[EkpGecTip] [tinyint] NULL,
	[EkpKomHesTip] [tinyint] NULL,
	[EkpIslemEkGun] [tinyint] NULL,
	[EkpTaksitEkGun] [tinyint] NULL,
	[EkpVadeGunP] [tinyint] NULL,
	[EkpTakSay] [tinyint] NULL,
	[EkpSabGun1] [tinyint] NULL,
	[EkpSabGun2] [tinyint] NULL,
	[EkpSabGun3] [tinyint] NULL,
	[EkpSabGun4] [tinyint] NULL,
	[EkpGun1] [tinyint] NULL,
	[EkpGun2] [tinyint] NULL,
	[EkpGun3] [tinyint] NULL,
	[EkpGun4] [tinyint] NULL,
	[EkpTatilT] [tinyint] NULL,
	[EkpTatilC] [tinyint] NULL,
	[EkpTatilP] [tinyint] NULL,
	[EkpSatisT] [tinyint] NULL,
	[EkpSatisC] [tinyint] NULL,
	[EkpSatisP] [tinyint] NULL,
	[EkpVadeT] [tinyint] NULL,
	[EkpVadeC] [tinyint] NULL,
	[EkpVadeP] [tinyint] NULL,
	[EkpKayKullanici] [nvarchar](20) NULL,
	[EkpKayitTarihi] [date] NULL,
	[EkpKayitSaati] [time](5) NULL,
	[EkpDuzKullanici] [nvarchar](20) NULL,
	[EkpDuzeltTarihi] [date] NULL,
	[EkpDuzeltSaati] [time](5) NULL,
	[EkpMagazaKodu] [nvarchar](50) NULL,
	[EkpTkOr01] [money] NULL,
	[EkpTkOr02] [money] NULL,
	[EkpTkOr03] [money] NULL,
	[EkpTkOr04] [money] NULL,
	[EkpTkOr05] [money] NULL,
	[EkpTkOr06] [money] NULL,
	[EkpTkOr07] [money] NULL,
	[EkpTkOr08] [money] NULL,
	[EkpTkOr09] [money] NULL,
	[EkpTkOr10] [money] NULL,
	[EkpTkOr11] [money] NULL,
	[EkpTkOr12] [money] NULL,
	[EkpTkOr13] [money] NULL,
	[EkpTkOr14] [money] NULL,
	[EkpTkOr15] [money] NULL,
	[EkpTkOr16] [money] NULL,
	[EkpTkOr17] [money] NULL,
	[EkpTkOr18] [money] NULL,
	[EkpTkOr19] [money] NULL,
	[EkpTkOr20] [money] NULL,
	[EkpTkOr21] [money] NULL,
	[EkpTkOr22] [money] NULL,
	[EkpTkOr23] [money] NULL,
	[EkpTkOr24] [money] NULL,
	[EkpVerUcr] [money] NULL,
	[EkpVerBas] [date] NULL,
	[EkpVerGun] [smallint] NULL,
	[EkpFormul1] [nvarchar](30) NULL,
	[EkpFormul2] [nvarchar](30) NULL,
	[EkpFormul3] [nvarchar](30) NULL,
	[EkpFormul4] [nvarchar](30) NULL,
	[EkpIlkFor1] [nvarchar](30) NULL,
	[EkpIlkFor2] [nvarchar](30) NULL,
	[EkpIlkFor3] [nvarchar](30) NULL,
	[EkpIlkFor4] [nvarchar](30) NULL,
	[EkpSabitPosUc] [money] NULL,
 CONSTRAINT [PK_Tb_EkPosKart] PRIMARY KEY CLUSTERED 
(
	[EkpId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_FatKalem](
	[FtKId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[FtKFisId] [decimal](18, 0) NULL,
	[FtKTarih] [date] NULL,
	[FtKSaat] [nvarchar](5) NULL,
	[FtKTipi] [tinyint] NULL,
	[FtKKdvTipi] [tinyint] NULL,
	[FtKOtvTipi] [tinyint] NULL,
	[FtKSatirTipi] [tinyint] NULL,
	[FtKStokId] [decimal](18, 0) NULL,
	[FtKBirim] [nvarchar](10) NULL,
	[FtKMiktar] [money] NULL,
	[FtKFiyat] [money] NULL,
	[FtKDoviz] [nvarchar](4) NULL,
	[FtKDovizTipi] [nvarchar](5) NULL,
	[FtKDovizFiyat] [money] NULL,
	[FtKKur] [money] NULL,
	[FtKTutar] [money] NULL,
	[FtKDepoId] [decimal](18, 0) NULL,
	[FtKPartiId] [decimal](18, 0) NULL,
	[FtKBirimMiktar] [money] NULL,
	[FtKBirimFiyat] [money] NULL,
	[FtKMalyFiyat] [money] NULL,
	[FtKMalyTutar] [money] NULL,
	[FtKKdvOran] [money] NULL,
	[FtKOtvOran] [money] NULL,
	[FtKIskOrn1] [money] NULL,
	[FtKIskOrn2] [money] NULL,
	[FtKIskOrn3] [money] NULL,
	[FtKIskOrn4] [money] NULL,
	[FtKIskOrn5] [money] NULL,
	[FtKIskTut1] [money] NULL,
	[FtKIskTut2] [money] NULL,
	[FtKIskTut3] [money] NULL,
	[FtKIskTut4] [money] NULL,
	[FtKIskTut5] [money] NULL,
	[FtKKaynak] [tinyint] NULL,
	[FtKKaynakId] [decimal](18, 0) NULL,
	[FtKAciklama] [nvarchar](200) NULL,
	[FtKTeslim] [tinyint] NULL,
	[FtKTeslimMiktar] [money] NULL,
	[FtKOtvTutar] [money] NULL,
	[FtKKdvTutar] [money] NULL,
	[FtKOtvMatrah] [money] NULL,
	[FtKKdvMatrah] [money] NULL,
 CONSTRAINT [PK_Tb_FatKalem] PRIMARY KEY CLUSTERED 
(
	[FtKId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Fatura](
	[FatId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[FatTur] [tinyint] NULL,
	[FatTarih] [date] NULL,
	[FatSaat] [nvarchar](5) NULL,
	[FatVade] [date] NULL,
	[FatNo] [nvarchar](20) NULL,
	[FatCariId] [decimal](18, 0) NULL,
	[FatPersId] [decimal](18, 0) NULL,
	[FatKdvTip] [tinyint] NULL,
	[FatMsMerkId] [decimal](18, 0) NULL,
	[FatOtvTip] [tinyint] NULL,
	[FatTip] [tinyint] NULL,
	[FatOzelKod1] [nvarchar](20) NULL,
	[FatOzelKod2] [nvarchar](20) NULL,
	[FatOzelKod3] [nvarchar](20) NULL,
	[FatAciklama] [nvarchar](500) NULL,
	[FatAdresTip] [tinyint] NULL,
	[FatIskTutar1] [money] NULL,
	[FatIskTutar2] [money] NULL,
	[FatIskTutar3] [money] NULL,
	[FatIskTutar4] [money] NULL,
	[FatIskTutar5] [money] NULL,
	[FatIskOran1] [money] NULL,
	[FatIskOran2] [money] NULL,
	[FatIskOran3] [money] NULL,
	[FatIskOran4] [money] NULL,
	[FatIskOran5] [money] NULL,
	[FatIskDvTip1] [nvarchar](5) NULL,
	[FatIskDvTip2] [nvarchar](5) NULL,
	[FatIskDvTip3] [nvarchar](5) NULL,
	[FatIskDvTip4] [nvarchar](5) NULL,
	[FatIskDvTip5] [nvarchar](5) NULL,
	[FatIskDov1] [nvarchar](5) NULL,
	[FatIskDov2] [nvarchar](5) NULL,
	[FatIskDov3] [nvarchar](5) NULL,
	[FatIskDov4] [nvarchar](5) NULL,
	[FatIskDov5] [nvarchar](5) NULL,
	[FatIskDvTut1] [money] NULL,
	[FatIskDvTut2] [money] NULL,
	[FatIskDvTut3] [money] NULL,
	[FatIskDvTut4] [money] NULL,
	[FatIskDvTut5] [money] NULL,
	[FatIskKur1] [money] NULL,
	[FatIskKur2] [money] NULL,
	[FatIskKur3] [money] NULL,
	[FatIskKur4] [money] NULL,
	[FatIskKur5] [money] NULL,
	[FatMasTutar1] [money] NULL,
	[FatMasTutar2] [money] NULL,
	[FatMasTutar3] [money] NULL,
	[FatMasTutar4] [money] NULL,
	[FatMasTutar5] [money] NULL,
	[FatMasOran1] [money] NULL,
	[FatMasOran2] [money] NULL,
	[FatMasOran3] [money] NULL,
	[FatMasOran4] [money] NULL,
	[FatMasOran5] [money] NULL,
	[FatMasDvTip1] [nvarchar](5) NULL,
	[FatMasDvTip2] [nvarchar](5) NULL,
	[FatMasDvTip3] [nvarchar](5) NULL,
	[FatMasDvTip4] [nvarchar](5) NULL,
	[FatMasDvTip5] [nvarchar](5) NULL,
	[FatMasDov1] [nvarchar](5) NULL,
	[FatMasDov2] [nvarchar](5) NULL,
	[FatMasDov3] [nvarchar](5) NULL,
	[FatMasDov4] [nvarchar](5) NULL,
	[FatMasDov5] [nvarchar](5) NULL,
	[FatMasDvTut1] [money] NULL,
	[FatMasDvTut2] [money] NULL,
	[FatMasDvTut3] [money] NULL,
	[FatMasDvTut4] [money] NULL,
	[FatMasDvTut5] [money] NULL,
	[FatMasKur1] [money] NULL,
	[FatMasKur2] [money] NULL,
	[FatMasKur3] [money] NULL,
	[FatMasKur4] [money] NULL,
	[FatMasKur5] [money] NULL,
	[FatKdvAlIn1] [money] NULL,
	[FatKdvAlIn2] [money] NULL,
	[FatKdvAlEk1] [money] NULL,
	[FatKdvAlEk2] [money] NULL,
	[FatTevkOran] [money] NULL,
	[FatMalToplam] [money] NULL,
	[FatKalIsk] [money] NULL,
	[FatGenIsk] [money] NULL,
	[FatTopIsk] [money] NULL,
	[FatTopMas] [money] NULL,
	[FatAraTop] [money] NULL,
	[FatOtvTop] [money] NULL,
	[FatKdvMat] [money] NULL,
	[FatKdvTut] [money] NULL,
	[FatBrtTop] [money] NULL,
	[FatKdvAIn] [money] NULL,
	[FatKdvAEk] [money] NULL,
	[FatGenTop] [money] NULL,
	[FatVerTop] [money] NULL,
	[FatTevTut] [money] NULL,
	[FatOdnVer] [money] NULL,
	[FatKayKullanici] [nvarchar](20) NULL,
	[FatKayTarihi] [date] NULL,
	[FatKaySaati] [time](5) NULL,
	[FatDuzKullanici] [nvarchar](20) NULL,
	[FatDuzeltTarihi] [date] NULL,
	[FatDuzeltSaat] [time](5) NULL,
	[FatMagazaKodu] [nvarchar](20) NULL,
	[FatKaynak] [tinyint] NULL,
	[FatTesTarih] [date] NULL,
	[FatTesSaat1] [nvarchar](5) NULL,
	[FatTesSaat2] [nvarchar](5) NULL,
	[FatTesAlan] [nvarchar](50) NULL,
	[FatTesPersId] [decimal](18, 0) NULL,
	[FatTesAdrTip] [tinyint] NULL,
	[FatTesYeri] [tinyint] NULL,
	[FatTesNot] [nvarchar](100) NULL,
	[FatYazdirildi] [tinyint] NULL,
	[FatKdvOran] [money] NULL,
	[FatOtvMat] [money] NULL,
	[FatDepoId] [decimal](18, 0) NULL,
	[FatEftReqId] [int] NULL,
	[FatEftSisNo] [nvarchar](20) NULL,
	[FatEftUrlAd] [nvarchar](200) NULL,
	[FatEfteTipi] [tinyint] NULL,
	[FatEftGonTp] [tinyint] NULL,
	[FatEftTrcNo] [int] NULL,
	[FatEkVerTut] [money] NULL,
	[FatEftFatNo] [nvarchar](20) NULL,
	[FatEftCevTp] [tinyint] NULL,
	[FatEftTvNo] [nvarchar](5) NULL,
	[FatEftSenTp] [tinyint] NULL,
	[FatAdresId] [decimal](18, 0) NULL,
 CONSTRAINT [PK_Tb_Fatura] PRIMARY KEY CLUSTERED 
(
	[FatId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_FaturaTahsil](
	[FtOId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[FtOFaturaId] [decimal](18, 0) NULL,
	[FtOTahsilId] [decimal](18, 0) NULL,
	[FtOTutar] [money] NULL,
	[FtOTarih] [date] NULL,
	[FtOCariId] [decimal](18, 0) NULL,
	[FtOTipi] [tinyint] NULL,
 CONSTRAINT [PK_Tb_FaturaTahsil] PRIMARY KEY CLUSTERED 
(
	[FtOId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_FirmaKrKart](
	[FkkId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[FkkKod] [nvarchar](30) NULL,
	[FkkAd] [nvarchar](100) NULL,
	[FkkKartNo] [nvarchar](20) NULL,
	[FkkKesTarih] [date] NULL,
	[FkkOdeTarih] [date] NULL,
	[FkkOzelKod1] [nvarchar](20) NULL,
	[FkkOzelKod2] [nvarchar](20) NULL,
	[FkkOzelKod3] [nvarchar](20) NULL,
	[FkkOzelKod4] [nvarchar](20) NULL,
	[FkkOzelKod5] [nvarchar](20) NULL,
	[FkkAnaGrup] [nvarchar](5) NULL,
	[FkkAciklama] [nvarchar](1000) NULL,
	[FkkUyari] [nvarchar](200) NULL,
	[FkkBankaId] [decimal](18, 0) NULL,
	[FkkSorumId] [decimal](18, 0) NULL,
	[FkkAltGrup] [nvarchar](5) NULL,
	[FkkDurum] [tinyint] NULL,
	[FkkAciklama1] [nvarchar](50) NULL,
	[FkkAciklama2] [nvarchar](50) NULL,
	[FkkAciklama3] [nvarchar](50) NULL,
	[FkkEkTutar1] [money] NULL,
	[FkkEkTutar2] [money] NULL,
	[FkkEkTutar3] [money] NULL,
	[FkkEkOran1] [money] NULL,
	[FkkEkOran2] [money] NULL,
	[FkkEkOran3] [money] NULL,
	[FkkKayKullanici] [nvarchar](20) NULL,
	[FkkKayitTarihi] [date] NULL,
	[FkkKayitSaati] [time](5) NULL,
	[FkkDuzKullanici] [nvarchar](20) NULL,
	[FkkDuzeltTarihi] [date] NULL,
	[FkkDuzeltSaati] [time](5) NULL,
	[FkkMagazaKodu] [nvarchar](50) NULL,
	[FkkDevirHarcanan] [money] NULL,
	[FkkDevirOdenen] [money] NULL,
	[FkkHarcanan] [money] NULL,
	[FkkOdenen] [money] NULL,
	[FkkFaiz] [money] NULL,
	[FkkBakiye] [money] NULL,
 CONSTRAINT [PK_Tb_FirmaKrKart] PRIMARY KEY CLUSTERED 
(
	[FkkId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Fiyat](
	[FiyId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[FiyStokId] [decimal](18, 0) NULL,
	[FiyAd] [nvarchar](50) NULL,
	[FiyFiyat] [money] NULL,
	[FiyKur] [nvarchar](4) NULL,
	[FiyTipi] [tinyint] NULL,
	[FiyDovTip] [nvarchar](5) NULL,
 CONSTRAINT [PK_Tb_Fiyat] PRIMARY KEY CLUSTERED 
(
	[FiyId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Hammadde](
	[HamId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[HamKod] [nvarchar](10) NULL,
	[HamAd] [nvarchar](50) NULL,
 CONSTRAINT [PK_Tb_Hammadde] PRIMARY KEY CLUSTERED 
(
	[HamId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_HesapKart](
	[HesId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[HesKod] [nvarchar](30) NULL,
	[HesAd] [nvarchar](100) NULL,
	[HesHesapNo] [nvarchar](20) NULL,
	[HesIban] [nvarchar](30) NULL,
	[HesDoviz] [nvarchar](4) NULL,
	[HesDovizTip] [nvarchar](5) NULL,
	[HesMinBakiye] [money] NULL,
	[HesMaxBakiye] [money] NULL,
	[HesOzelKod1] [nvarchar](20) NULL,
	[HesOzelKod2] [nvarchar](20) NULL,
	[HesOzelKod3] [nvarchar](20) NULL,
	[HesOzelKod4] [nvarchar](20) NULL,
	[HesOzelKod5] [nvarchar](20) NULL,
	[HesAnaGrup] [nvarchar](5) NULL,
	[HesAciklama] [nvarchar](1000) NULL,
	[HesUyari] [nvarchar](200) NULL,
	[HesSubeId] [decimal](18, 0) NULL,
	[HesSorumId] [decimal](18, 0) NULL,
	[HesAltGrup] [nvarchar](5) NULL,
	[HesTanimlar] [nvarchar](30) NULL,
	[HesKartTipi] [nvarchar](20) NULL,
	[HesHavUcret] [tinyint] NULL,
	[HesEftUcret] [tinyint] NULL,
	[HesHavOrT] [money] NULL,
	[HesEftOrT] [money] NULL,
	[HesHavId] [decimal](18, 0) NULL,
	[HesEftId] [decimal](18, 0) NULL,
	[HesKarneNo] [tinyint] NULL,
	[HesKrNoOnTk] [nvarchar](5) NULL,
	[HesKrNoKdBy] [tinyint] NULL,
	[HesAciklama1] [nvarchar](50) NULL,
	[HesAciklama2] [nvarchar](50) NULL,
	[HesAciklama3] [nvarchar](50) NULL,
	[HesEkTutar1] [money] NULL,
	[HesEkTutar2] [money] NULL,
	[HesEkTutar3] [money] NULL,
	[HesEkOran1] [money] NULL,
	[HesEkOran2] [money] NULL,
	[HesEkOran3] [money] NULL,
	[HesGecTip] [tinyint] NULL,
	[HesKomHesTip] [tinyint] NULL,
	[HesIslemEkGun] [tinyint] NULL,
	[HesTaksitEkGun] [tinyint] NULL,
	[HesVadeGunP] [tinyint] NULL,
	[HesTakSay] [tinyint] NULL,
	[HesSabGun1] [tinyint] NULL,
	[HesSabGun2] [tinyint] NULL,
	[HesSabGun3] [tinyint] NULL,
	[HesSabGun4] [tinyint] NULL,
	[HesGun1] [tinyint] NULL,
	[HesGun2] [tinyint] NULL,
	[HesGun3] [tinyint] NULL,
	[HesGun4] [tinyint] NULL,
	[HesTatilT] [tinyint] NULL,
	[HesTatilC] [tinyint] NULL,
	[HesTatilP] [tinyint] NULL,
	[HesSatisT] [tinyint] NULL,
	[HesSatisC] [tinyint] NULL,
	[HesSatisP] [tinyint] NULL,
	[HesVadeT] [tinyint] NULL,
	[HesVadeC] [tinyint] NULL,
	[HesVadeP] [tinyint] NULL,
	[HesKayKullanici] [nvarchar](20) NULL,
	[HesKayitTarihi] [date] NULL,
	[HesKayitSaati] [time](5) NULL,
	[HesDuzKullanici] [nvarchar](20) NULL,
	[HesDuzeltTarihi] [date] NULL,
	[HesDuzeltSaati] [time](5) NULL,
	[HesMagazaKodu] [nvarchar](50) NULL,
	[HesTkOr01] [money] NULL,
	[HesTkOr02] [money] NULL,
	[HesTkOr03] [money] NULL,
	[HesTkOr04] [money] NULL,
	[HesTkOr05] [money] NULL,
	[HesTkOr06] [money] NULL,
	[HesTkOr07] [money] NULL,
	[HesTkOr08] [money] NULL,
	[HesTkOr09] [money] NULL,
	[HesTkOr10] [money] NULL,
	[HesTkOr11] [money] NULL,
	[HesTkOr12] [money] NULL,
	[HesTkOr13] [money] NULL,
	[HesTkOr14] [money] NULL,
	[HesTkOr15] [money] NULL,
	[HesTkOr16] [money] NULL,
	[HesTkOr17] [money] NULL,
	[HesTkOr18] [money] NULL,
	[HesTkOr19] [money] NULL,
	[HesTkOr20] [money] NULL,
	[HesTkOr21] [money] NULL,
	[HesTkOr22] [money] NULL,
	[HesTkOr23] [money] NULL,
	[HesTkOr24] [money] NULL,
	[HesVerUcr] [money] NULL,
	[HesVerBas] [date] NULL,
	[HesVerGun] [smallint] NULL,
	[HesFormul1] [nvarchar](30) NULL,
	[HesFormul2] [nvarchar](30) NULL,
	[HesFormul3] [nvarchar](30) NULL,
	[HesFormul4] [nvarchar](30) NULL,
	[HesIlkFor1] [nvarchar](30) NULL,
	[HesIlkFor2] [nvarchar](30) NULL,
	[HesIlkFor3] [nvarchar](30) NULL,
	[HesIlkFor4] [nvarchar](30) NULL,
	[HesSabitPosUc] [money] NULL,
	[HesMxHavUcr] [money] NULL,
	[HesMnHavUcr] [money] NULL,
	[HesMxEftUcr] [money] NULL,
	[HesMnEftUcr] [money] NULL,
	[HesDevirYatan] [money] NULL,
	[HesDevirCekilen] [money] NULL,
	[HesYatan] [money] NULL,
	[HesCekilen] [money] NULL,
	[HesBakiye] [money] NULL,
	[HesPosYatacak] [money] NULL,
	[HesBorcCeki] [money] NULL,
	[HesPosAd] [nvarchar](20) NULL,
 CONSTRAINT [PK_Tb_HesapKart] PRIMARY KEY CLUSTERED 
(
	[HesId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_HesGecme](
	[HsgId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[HsgTarih] [date] NULL,
	[HsgTutar] [money] NULL,
	[HsgPosId] [decimal](18, 0) NULL,
	[HsgCariId] [decimal](18, 0) NULL,
	[HsgSatisId] [decimal](18, 0) NULL,
	[HsgGcTarih] [date] NULL,
	[HsgGcKull] [nvarchar](20) NULL,
	[HsgGcSaat] [nvarchar](5) NULL,
	[HsgGecti] [tinyint] NULL,
	[HsgMagaza] [nvarchar](20) NULL,
	[HsgGecId] [decimal](18, 0) NULL,
	[HsgGcTutar] [money] NULL,
	[HsGCrHId] [decimal](18, 0) NULL,
	[HsgModul] [tinyint] NULL,
	[HsGEkPosId] [decimal](18, 0) NULL,
 CONSTRAINT [PK_Tb_HesGecme] PRIMARY KEY CLUSTERED 
(
	[HsgId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_HizmetKart](
	[HizId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[HizKod] [nvarchar](30) NULL,
	[HizCins] [nvarchar](100) NULL,
	[HizKisaCins] [nvarchar](50) NULL,
	[HizAnaDoviz] [nvarchar](4) NULL,
	[HizAnaDovTip] [nvarchar](5) NULL,
	[HizAnaBirim] [nvarchar](10) NULL,
	[HizFiyat1] [money] NULL,
	[HizFiyat2] [money] NULL,
	[HizFiyat3] [money] NULL,
	[HizFiyat4] [money] NULL,
	[HizFiyat5] [money] NULL,
	[HizDoviz1] [nvarchar](4) NULL,
	[HizDoviz2] [nvarchar](4) NULL,
	[HizDoviz3] [nvarchar](4) NULL,
	[HizDoviz4] [nvarchar](4) NULL,
	[HizDoviz5] [nvarchar](4) NULL,
	[HizDovTip1] [nvarchar](5) NULL,
	[HizDovTip2] [nvarchar](5) NULL,
	[HizDovTip3] [nvarchar](5) NULL,
	[HizDovTip4] [nvarchar](5) NULL,
	[HizDovTip5] [nvarchar](5) NULL,
	[HizOzelKod1] [nvarchar](20) NULL,
	[HizOzelKod2] [nvarchar](20) NULL,
	[HizOzelKod3] [nvarchar](20) NULL,
	[HizOzelKod4] [nvarchar](20) NULL,
	[HizOzelKod5] [nvarchar](20) NULL,
	[HizAnaKdv] [money] NULL,
	[HizAnaIskonto] [money] NULL,
	[HizAnaGrup] [nvarchar](5) NULL,
	[HizBarkodTipi] [tinyint] NULL,
	[HizBarkod] [nvarchar](50) NULL,
	[HizAciklama] [nvarchar](1000) NULL,
	[HizUyari] [nvarchar](200) NULL,
	[HizToptanKdv] [money] NULL,
	[HizPerakKdv] [money] NULL,
	[HizTopAlisIsk] [money] NULL,
	[HizPerAlisIsk] [money] NULL,
	[HizTopSatisIsk] [money] NULL,
	[HizPerSatisIsk] [money] NULL,
	[HizOtvTipi] [tinyint] NULL,
	[HizOtvOranTutar] [money] NULL,
	[HizTevkifatOrani] [money] NULL,
	[HizTanimlar] [nvarchar](50) NULL,
	[HizUrunTipi] [nvarchar](50) NULL,
	[HizTopAlisFiyTip] [tinyint] NULL,
	[HizTopSatisFiyTip] [tinyint] NULL,
	[HizPerAlisFiyTip] [tinyint] NULL,
	[HizPerSatisFiyTip] [tinyint] NULL,
	[HizAltGrup] [nvarchar](5) NULL,
	[HizAciklama1] [nvarchar](50) NULL,
	[HizAciklama2] [nvarchar](50) NULL,
	[HizAciklama3] [nvarchar](50) NULL,
	[HizEkTutar1] [money] NULL,
	[HizEkTutar2] [money] NULL,
	[HizEkTutar3] [money] NULL,
	[HizEkOran1] [money] NULL,
	[HizEkOran2] [money] NULL,
	[HizEkOran3] [money] NULL,
	[HizKayKullanici] [nvarchar](20) NULL,
	[HizKayitTarihi] [date] NULL,
	[HizKayitSaati] [time](5) NULL,
	[HizDuzKullanici] [nvarchar](20) NULL,
	[HizDuzeltTarihi] [date] NULL,
	[HizDuzeltSaat] [time](5) NULL,
	[HizMagazaKodu] [nvarchar](20) NULL,
	[HizBakiye] [money] NULL,
	[HizDevirGir] [money] NULL,
	[HizDevirCik] [money] NULL,
	[HizHizmetGiren] [money] NULL,
	[HizHizmetCikan] [money] NULL,
	[HizUretGiren] [money] NULL,
	[HizUretCikan] [money] NULL,
	[HizSonAlisTarih] [date] NULL,
	[HizSonSatisTarih] [date] NULL,
	[HizOrtAlisMik] [money] NULL,
	[HizOrtAlisTut] [money] NULL,
	[HizOrtSatMik] [money] NULL,
	[HizOrtSatTut] [money] NULL,
	[HizSonAlis] [money] NULL,
	[HizSonSatis] [money] NULL,
	[HizKdvId] [decimal](18, 0) NULL,
	[HizTopKdvId] [decimal](18, 0) NULL,
	[HizPerKdvId] [decimal](18, 0) NULL,
	[HizTevkId] [decimal](18, 0) NULL,
	[HizOtvTip] [nvarchar](5) NULL,
 CONSTRAINT [PK_Tb_HizmetKart] PRIMARY KEY CLUSTERED 
(
	[HizId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_IptalFatura](
	[IfId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[IfTarih] [date] NULL,
	[IfSaat] [nvarchar](5) NULL,
	[IfNo] [nvarchar](20) NULL,
	[IfTur] [tinyint] NULL,
	[IfUnvan] [nvarchar](100) NULL,
	[IfMalTop] [money] NULL,
	[IfIskTop] [money] NULL,
	[IfVerTop] [money] NULL,
	[IfGenTop] [money] NULL,
	[IfIptTar] [date] NULL,
	[IfIptSaat] [time](5) NULL,
	[IfKullan] [nvarchar](20) NULL,
	[IfMagaza] [nvarchar](20) NULL,
	[IfEftTip] [int] NULL,
 CONSTRAINT [PK_Tb_RaporRnFr] PRIMARY KEY CLUSTERED 
(
	[IfId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Irsaliye](
	[IrsId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[IrsTur] [tinyint] NULL,
	[IrsTarih] [date] NULL,
	[IrsSaat] [nvarchar](5) NULL,
	[IrsNo] [nvarchar](20) NULL,
	[IrsCariId] [decimal](18, 0) NULL,
	[IrsPersId] [decimal](18, 0) NULL,
	[IrsKdvTip] [tinyint] NULL,
	[IrsMsMerkId] [decimal](18, 0) NULL,
	[IrsOtvTip] [tinyint] NULL,
	[IrsOzelKod1] [nvarchar](20) NULL,
	[IrsOzelKod2] [nvarchar](20) NULL,
	[IrsOzelKod3] [nvarchar](20) NULL,
	[IrsAciklama] [nvarchar](200) NULL,
	[IrsAdresTip] [tinyint] NULL,
	[IrsIskTutar1] [money] NULL,
	[IrsIskTutar2] [money] NULL,
	[IrsIskTutar3] [money] NULL,
	[IrsIskTutar4] [money] NULL,
	[IrsIskTutar5] [money] NULL,
	[IrsIskOran1] [money] NULL,
	[IrsIskOran2] [money] NULL,
	[IrsIskOran3] [money] NULL,
	[IrsIskOran4] [money] NULL,
	[IrsIskOran5] [money] NULL,
	[IrsIskDvTip1] [nvarchar](5) NULL,
	[IrsIskDvTip2] [nvarchar](5) NULL,
	[IrsIskDvTip3] [nvarchar](5) NULL,
	[IrsIskDvTip4] [nvarchar](5) NULL,
	[IrsIskDvTip5] [nvarchar](5) NULL,
	[IrsIskDov1] [nvarchar](5) NULL,
	[IrsIskDov2] [nvarchar](5) NULL,
	[IrsIskDov3] [nvarchar](5) NULL,
	[IrsIskDov4] [nvarchar](5) NULL,
	[IrsIskDov5] [nvarchar](5) NULL,
	[IrsIskDvTut1] [money] NULL,
	[IrsIskDvTut2] [money] NULL,
	[IrsIskDvTut3] [money] NULL,
	[IrsIskDvTut4] [money] NULL,
	[IrsIskDvTut5] [money] NULL,
	[IrsIskKur1] [money] NULL,
	[IrsIskKur2] [money] NULL,
	[IrsIskKur3] [money] NULL,
	[IrsIskKur4] [money] NULL,
	[IrsIskKur5] [money] NULL,
	[IrsMasTutar1] [money] NULL,
	[IrsMasTutar2] [money] NULL,
	[IrsMasTutar3] [money] NULL,
	[IrsMasTutar4] [money] NULL,
	[IrsMasTutar5] [money] NULL,
	[IrsMasOran1] [money] NULL,
	[IrsMasOran2] [money] NULL,
	[IrsMasOran3] [money] NULL,
	[IrsMasOran4] [money] NULL,
	[IrsMasOran5] [money] NULL,
	[IrsMasDvTip1] [nvarchar](5) NULL,
	[IrsMasDvTip2] [nvarchar](5) NULL,
	[IrsMasDvTip3] [nvarchar](5) NULL,
	[IrsMasDvTip4] [nvarchar](5) NULL,
	[IrsMasDvTip5] [nvarchar](5) NULL,
	[IrsMasDov1] [nvarchar](5) NULL,
	[IrsMasDov2] [nvarchar](5) NULL,
	[IrsMasDov3] [nvarchar](5) NULL,
	[IrsMasDov4] [nvarchar](5) NULL,
	[IrsMasDov5] [nvarchar](5) NULL,
	[IrsMasDvTut1] [money] NULL,
	[IrsMasDvTut2] [money] NULL,
	[IrsMasDvTut3] [money] NULL,
	[IrsMasDvTut4] [money] NULL,
	[IrsMasDvTut5] [money] NULL,
	[IrsMasKur1] [money] NULL,
	[IrsMasKur2] [money] NULL,
	[IrsMasKur3] [money] NULL,
	[IrsMasKur4] [money] NULL,
	[IrsMasKur5] [money] NULL,
	[IrsKdvAlIn1] [money] NULL,
	[IrsKdvAlIn2] [money] NULL,
	[IrsKdvAlEk1] [money] NULL,
	[IrsKdvAlEk2] [money] NULL,
	[IrsTevkOran] [money] NULL,
	[IrsKdvOran] [money] NULL,
	[IrsMalToplam] [money] NULL,
	[IrsKalIsk] [money] NULL,
	[IrsGenIsk] [money] NULL,
	[IrsTopIsk] [money] NULL,
	[IrsTopMas] [money] NULL,
	[IrsAraTop] [money] NULL,
	[IrsOtvTop] [money] NULL,
	[IrsKdvMat] [money] NULL,
	[IrsKdvTut] [money] NULL,
	[IrsBrtTop] [money] NULL,
	[IrsKdvAIn] [money] NULL,
	[IrsKdvAEk] [money] NULL,
	[IrsGenTop] [money] NULL,
	[IrsVerTop] [money] NULL,
	[IrsTevTut] [money] NULL,
	[IrsOdnVer] [money] NULL,
	[IrsKayKullanici] [nvarchar](20) NULL,
	[IrsKayTarihi] [date] NULL,
	[IrsKaySaati] [time](5) NULL,
	[IrsDuzKullanici] [nvarchar](20) NULL,
	[IrsDuzeltTarihi] [date] NULL,
	[IrsDuzeltSaat] [time](5) NULL,
	[IrsMagazaKodu] [nvarchar](20) NULL,
	[IrsKaynak] [tinyint] NULL,
	[IrsFaturaId] [decimal](18, 0) NULL,
	[IrsTesTarih] [date] NULL,
	[IrsTesSaat1] [nvarchar](5) NULL,
	[IrsTesSaat2] [nvarchar](5) NULL,
	[IrsTesAlan] [nvarchar](50) NULL,
	[IrsTesPersId] [decimal](18, 0) NULL,
	[IrsTesAdrTip] [tinyint] NULL,
	[IrsTesYeri] [tinyint] NULL,
	[IrsTesNot] [nvarchar](100) NULL,
	[IrsYazdirildi] [tinyint] NULL,
	[IrsDepoId] [decimal](18, 0) NULL,
	[IrsEkVerTut] [money] NULL,
	[IrsAdresId] [decimal](18, 0) NULL,
	[IrseIrTipi] [tinyint] NULL,
 CONSTRAINT [PK_Tb_Irsaliye] PRIMARY KEY CLUSTERED 
(
	[IrsId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_IrsKalem](
	[IrKId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[IrKFisId] [decimal](18, 0) NULL,
	[IrKTarih] [date] NULL,
	[IrKSaat] [nvarchar](5) NULL,
	[IrKStokId] [decimal](18, 0) NULL,
	[IrKTipi] [tinyint] NULL,
	[IrKKdvTipi] [tinyint] NULL,
	[IrKOtvTipi] [tinyint] NULL,
	[IrKBirim] [nvarchar](10) NULL,
	[IrKMiktar] [money] NULL,
	[IrKFiyat] [money] NULL,
	[IrKDoviz] [nvarchar](4) NULL,
	[IrKDovizTipi] [nvarchar](5) NULL,
	[IrKDovizFiyat] [money] NULL,
	[IrKKur] [money] NULL,
	[IrKTutar] [money] NULL,
	[IrKDepoId] [decimal](18, 0) NULL,
	[IrKPartiId] [decimal](18, 0) NULL,
	[IrKBirimMiktar] [money] NULL,
	[IrKBirimFiyat] [money] NULL,
	[IrKMalyFiyat] [money] NULL,
	[IrKMalyTutar] [money] NULL,
	[IrKKdvOran] [money] NULL,
	[IrKOtvOran] [money] NULL,
	[IrKIskOrn1] [money] NULL,
	[IrKIskOrn2] [money] NULL,
	[IrKIskOrn3] [money] NULL,
	[IrKIskOrn4] [money] NULL,
	[IrKIskOrn5] [money] NULL,
	[IrKIskTut1] [money] NULL,
	[IrKIskTut2] [money] NULL,
	[IrKIskTut3] [money] NULL,
	[IrKIskTut4] [money] NULL,
	[IrkIskTut5] [money] NULL,
	[IrKKaynak] [tinyint] NULL,
	[IrKAciklama] [nvarchar](200) NULL,
	[IrKKaynakId] [decimal](18, 0) NULL,
	[IrKOtvTutar] [money] NULL,
	[IrKFtMiktar] [money] NULL,
	[IrKRedMiktar] [money] NULL,
	[IrKFazMiktar] [money] NULL,
	[IrKEksMiktar] [money] NULL,
	[IrKRedSebep] [nvarchar](100) NULL,
 CONSTRAINT [PK_Tb_IrsKalem] PRIMARY KEY CLUSTERED 
(
	[IrKId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_KasaFis](
	[KsFId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[KsFTur] [tinyint] NULL,
	[KsFTarih] [date] NULL,
	[KsFSaat] [nvarchar](5) NULL,
	[KsFEvrakNo] [nvarchar](20) NULL,
	[KsFFisNo] [nvarchar](20) NULL,
	[KsFKasaId] [decimal](18, 0) NULL,
	[KsFsMerkId] [decimal](18, 0) NULL,
	[KsFPersId] [decimal](18, 0) NULL,
	[KsFAciklama] [nvarchar](200) NULL,
	[KsFOzelKod1] [nvarchar](20) NULL,
	[KsFOzelKod2] [nvarchar](20) NULL,
	[KsFOzelKod3] [nvarchar](20) NULL,
	[KsFKayKullanici] [nvarchar](20) NULL,
	[KsFKayitTarihi] [date] NULL,
	[KsFKayitSaati] [time](5) NULL,
	[KsFDuzKullanici] [nvarchar](20) NULL,
	[KsFDuzeltTarihi] [date] NULL,
	[KsFDuzeltSaat] [time](5) NULL,
	[KsFMagazaKodu] [nvarchar](20) NULL,
 CONSTRAINT [PK_TbKasaFis] PRIMARY KEY CLUSTERED 
(
	[KsFId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_KasaHareket](
	[KsHId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[KsHFisId] [decimal](18, 0) NULL,
	[KsHTur] [tinyint] NULL,
	[KsHTarih] [date] NULL,
	[KsHSaat] [nvarchar](5) NULL,
	[KsHEvrakNo] [nvarchar](20) NULL,
	[KsHKasaId] [decimal](18, 0) NULL,
	[KsHTipi] [tinyint] NULL,
	[KsHKarsiHsId] [decimal](18, 0) NULL,
	[KsHTutar] [money] NULL,
	[KsHFaiz] [money] NULL,
	[KsHDovizTip] [nvarchar](5) NULL,
	[KsHDoviz] [nvarchar](4) NULL,
	[KsHDovizTutar] [money] NULL,
	[KsHKur] [money] NULL,
	[KsHMsMerkId] [decimal](18, 0) NULL,
	[KsHPersId] [decimal](18, 0) NULL,
	[KsHAciklama] [nvarchar](200) NULL,
	[KsHOzelKod1] [nvarchar](20) NULL,
	[KsHOzelKod2] [nvarchar](20) NULL,
	[KsHOzelKod3] [nvarchar](20) NULL,
	[KsHKayKullanici] [nvarchar](20) NULL,
	[KsHKayitTarihi] [date] NULL,
	[KsHKayitSaati] [time](5) NULL,
	[KsHDuzKullanici] [nvarchar](20) NULL,
	[KsHDuzeltTarihi] [date] NULL,
	[KsHDuzeltSaat] [time](5) NULL,
	[KsHMagazaKodu] [nvarchar](20) NULL,
	[KsHKdvOrn] [money] NULL,
 CONSTRAINT [PK_TbKasaHareket] PRIMARY KEY CLUSTERED 
(
	[KsHId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_KasaKart](
	[KasId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[KasKod] [nvarchar](30) NULL,
	[KasAd] [nvarchar](100) NULL,
	[KasOzelKod1] [nvarchar](20) NULL,
	[KasOzelKod2] [nvarchar](20) NULL,
	[KasOzelKod3] [nvarchar](20) NULL,
	[KasOzelKod4] [nvarchar](20) NULL,
	[KasOzelKod5] [nvarchar](20) NULL,
	[KasMinBakiye] [money] NULL,
	[KasMaxBakiye] [money] NULL,
	[KasAnaGrup] [nvarchar](5) NULL,
	[KasAciklama] [nvarchar](1000) NULL,
	[KasUyari] [nvarchar](200) NULL,
	[KasSorId1] [decimal](18, 0) NULL,
	[KasSorId2] [decimal](18, 0) NULL,
	[KasAltGrup] [nvarchar](5) NULL,
	[KasDoviz] [nvarchar](4) NULL,
	[KasDovizTip] [nvarchar](5) NULL,
	[KasTanimlar] [nvarchar](30) NULL,
	[KasAciklama1] [nvarchar](50) NULL,
	[KasAciklama2] [nvarchar](50) NULL,
	[KasAciklama3] [nvarchar](50) NULL,
	[KasEkTutar1] [money] NULL,
	[KasEkTutar2] [money] NULL,
	[KasEkTutar3] [money] NULL,
	[KasEkOran1] [money] NULL,
	[KasEkOran2] [money] NULL,
	[KasEkOran3] [money] NULL,
	[KasKayKullanici] [nvarchar](20) NULL,
	[KasKayitTarihi] [date] NULL,
	[KasKayitSaati] [time](5) NULL,
	[KasDuzKullanici] [nvarchar](20) NULL,
	[KasDuzeltTarihi] [date] NULL,
	[KasDuzeltSaati] [time](5) NULL,
	[KasMagazaKodu] [nvarchar](50) NULL,
	[KasDevirGelir] [money] NULL,
	[KasDevirGider] [money] NULL,
	[KasGelir] [money] NULL,
	[KasGider] [money] NULL,
	[KasBakiye] [money] NULL,
	[KasDovGelir] [money] NULL,
	[KasDovGider] [money] NULL,
	[KasDovBakiye] [money] NULL,
	[KasDovDevirGelir] [money] NULL,
	[KasDovDevirGider] [money] NULL,
 CONSTRAINT [PK_Tb_KasaKart] PRIMARY KEY CLUSTERED 
(
	[KasId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Kategori](
	[KatId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[KatKod] [nvarchar](10) NULL,
	[KatAd] [nvarchar](50) NULL,
 CONSTRAINT [PK_Tb_Kategori] PRIMARY KEY CLUSTERED 
(
	[KatId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Kefil](
	[KefId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[KefKod] [nvarchar](10) NULL,
	[KefAd] [nvarchar](30) NULL,
	[KefYetkili] [nvarchar](30) NULL,
	[KefTelefon] [nvarchar](20) NULL,
	[KefTelefon1] [nvarchar](20) NULL,
	[KefAdres] [nvarchar](100) NULL,
	[KefTcKimNo] [nvarchar](20) NULL,
	[KefVrDa] [nvarchar](20) NULL,
	[KefVrNo] [nvarchar](20) NULL,
	[KefTip] [tinyint] NULL,
 CONSTRAINT [PK_Tb_Kefil] PRIMARY KEY CLUSTERED 
(
	[KefId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Koleksiyon](
	[KolId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[KolKod] [nvarchar](10) NULL,
	[KolAd] [nvarchar](50) NULL,
 CONSTRAINT [PK_Tb_Koleksiyon] PRIMARY KEY CLUSTERED 
(
	[KolId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Kredi](
	[KreId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[KreKod] [nvarchar](30) NULL,
	[KreTarih] [date] NULL,
	[KreSaat] [nvarchar](5) NULL,
	[KreDurum] [tinyint] NULL,
	[KreAd] [nvarchar](100) NULL,
	[KreDoviz] [nvarchar](4) NULL,
	[KreDovizTip] [nvarchar](5) NULL,
	[KreTutar] [money] NULL,
	[KreFaiz] [money] NULL,
	[KreKkdf] [money] NULL,
	[KreTeminat] [tinyint] NULL,
	[KreTuru] [tinyint] NULL,
	[KreMasraf] [money] NULL,
	[KreTaksitAdet] [tinyint] NULL,
	[KreBsmv] [money] NULL,
	[KreSozlesmeNo] [nvarchar](20) NULL,
	[KreVadeBasl] [date] NULL,
	[KreVadeGun] [tinyint] NULL,
	[KreOdeme] [money] NULL,
	[KreTkEkle] [tinyint] NULL,
	[KreErOdeOran] [money] NULL,
	[KreSorumId] [decimal](18, 0) NULL,
	[KreGcOdeOran] [money] NULL,
	[KreSubeId] [decimal](18, 0) NULL,
	[KreOzelKod1] [nvarchar](20) NULL,
	[KreOzelKod2] [nvarchar](20) NULL,
	[KreOzelKod3] [nvarchar](20) NULL,
	[KreOzelKod4] [nvarchar](20) NULL,
	[KreOzelKod5] [nvarchar](20) NULL,
	[KreAciklama] [nvarchar](1000) NULL,
	[KreUyari] [nvarchar](200) NULL,
	[KreKayKullanici] [nvarchar](20) NULL,
	[KreKayitTarihi] [date] NULL,
	[KreKayitSaati] [time](5) NULL,
	[KreDuzKullanici] [nvarchar](20) NULL,
	[KreDuzeltTarihi] [date] NULL,
	[KreDuzeltSaati] [time](5) NULL,
	[KreMagazaKodu] [nvarchar](50) NULL,
	[KreCekilen] [money] NULL,
	[KreYatan] [money] NULL,
	[KreFaizTutar] [money] NULL,
 CONSTRAINT [PK_Tb_Kredi] PRIMARY KEY CLUSTERED 
(
	[KreId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Log](
	[LogId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[Tarih] [smalldatetime] NULL,
	[KullaniciKodu] [nvarchar](10) NULL,
	[Islem] [smallint] NULL,
	[DetayAciklama] [nvarchar](500) NULL,
	[KayitReferans] [decimal](18, 0) NULL,
	[Saat] [nvarchar](5) NULL,
 CONSTRAINT [PK_Tb_Log] PRIMARY KEY CLUSTERED 
(
	[LogId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Marka](
	[MarId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[MarKod] [nvarchar](10) NULL,
	[MarAd] [nvarchar](50) NULL,
 CONSTRAINT [PK_Tb_Marka] PRIMARY KEY CLUSTERED 
(
	[MarId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_MasrafKart](
	[MasId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[MasKod] [nvarchar](30) NULL,
	[MasAd] [nvarchar](100) NULL,
	[MasOzelKod1] [nvarchar](20) NULL,
	[MasOzelKod2] [nvarchar](20) NULL,
	[MasOzelKod3] [nvarchar](20) NULL,
	[MasOzelKod4] [nvarchar](20) NULL,
	[MasOzelKod5] [nvarchar](20) NULL,
	[MasAnaGrup] [nvarchar](5) NULL,
	[MasAciklama] [nvarchar](1000) NULL,
	[MasUyari] [nvarchar](200) NULL,
	[MasPerId] [decimal](18, 0) NULL,
	[MasAltGrup] [nvarchar](5) NULL,
	[MasDurum] [tinyint] NULL,
	[MasPersBg] [tinyint] NULL,
	[MasSorId] [decimal](18, 0) NULL,
	[MasAlacak] [tinyint] NULL,
	[MasAlTutar] [money] NULL,
	[MasKsGider] [money] NULL,
	[MasBnGider] [money] NULL,
	[MasAciklama1] [nvarchar](50) NULL,
	[MasAciklama2] [nvarchar](50) NULL,
	[MasAciklama3] [nvarchar](50) NULL,
	[MasEkTutar1] [money] NULL,
	[MasEkTutar2] [money] NULL,
	[MasEkTutar3] [money] NULL,
	[MasEkOran1] [money] NULL,
	[MasEkOran2] [money] NULL,
	[MasEkOran3] [money] NULL,
	[MasKayKullanici] [nvarchar](20) NULL,
	[MasKayitTarihi] [date] NULL,
	[MasKayitSaati] [time](5) NULL,
	[MasDuzKullanici] [nvarchar](20) NULL,
	[MasDuzeltTarihi] [date] NULL,
	[MasDuzeltSaati] [time](5) NULL,
	[MasMagazaKodu] [nvarchar](50) NULL,
	[MasDevirGelir] [money] NULL,
	[MasDevirGider] [money] NULL,
	[MasKasaGelir] [money] NULL,
	[MasKasaGider] [money] NULL,
	[MasBankaGelir] [money] NULL,
	[MasBankaGider] [money] NULL,
	[MasBakiye] [money] NULL,
	[MasKdvOrn] [money] NULL,
	[MasKdvId] [decimal](18, 0) NULL,
 CONSTRAINT [PK_Tb_MasrafKart] PRIMARY KEY CLUSTERED 
(
	[MasId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_MasrafMerk](
	[MmzId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[MmzKod] [nvarchar](30) NULL,
	[MmzAd] [nvarchar](100) NULL,
	[MmzOzelKod1] [nvarchar](20) NULL,
	[MmzOzelKod2] [nvarchar](20) NULL,
	[MmzOzelKod3] [nvarchar](20) NULL,
	[MmzOzelKod4] [nvarchar](20) NULL,
	[MmzOzelKod5] [nvarchar](20) NULL,
	[MmzAnaGrup] [nvarchar](5) NULL,
	[MmzAciklama] [nvarchar](1000) NULL,
	[MmzUyari] [nvarchar](200) NULL,
	[MmzSorId] [decimal](18, 0) NULL,
	[MmzAltGrup] [nvarchar](5) NULL,
	[MmzButGelir] [money] NULL,
	[MmzButGider] [money] NULL,
	[MmzDurum] [tinyint] NULL,
	[MmzAciklama1] [nvarchar](50) NULL,
	[MmzAciklama2] [nvarchar](50) NULL,
	[MmzAciklama3] [nvarchar](50) NULL,
	[MmzEkTutar1] [money] NULL,
	[MmzEkTutar2] [money] NULL,
	[MmzEkTutar3] [money] NULL,
	[MmzEkOran1] [money] NULL,
	[MmzEkOran2] [money] NULL,
	[MmzEkOran3] [money] NULL,
	[MmzKayKullanici] [nvarchar](20) NULL,
	[MmzKayitTarihi] [date] NULL,
	[MmzKayitSaati] [time](5) NULL,
	[MmzDuzKullanici] [nvarchar](20) NULL,
	[MmzDuzeltTarihi] [date] NULL,
	[MmzDuzeltSaati] [time](5) NULL,
	[MmzMagazaKodu] [nvarchar](50) NULL,
	[MmzDevirGelir] [money] NULL,
	[MmzDevirGider] [money] NULL,
	[MmzGelir] [money] NULL,
	[MmzGider] [money] NULL,
	[MmzBakiye] [money] NULL,
 CONSTRAINT [PK_Tb_MasrafMerk] PRIMARY KEY CLUSTERED 
(
	[MmzId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Model](
	[ModId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[ModKod] [nvarchar](10) NULL,
	[ModAd] [nvarchar](50) NULL,
 CONSTRAINT [PK_Tb_Model] PRIMARY KEY CLUSTERED 
(
	[ModId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Muadil](
	[MdlId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[MdlBaslikId] [decimal](18, 0) NULL,
	[MdlStokId] [decimal](18, 0) NULL,
	[MdlKalStkId] [decimal](18, 0) NULL,
 CONSTRAINT [PK_Tb_Muadil] PRIMARY KEY CLUSTERED 
(
	[MdlId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_OdemeKart](
	[OdKId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[OdKKod] [nvarchar](30) NULL,
	[OdKAd] [nvarchar](100) NULL,
	[OdKOzelKod1] [nvarchar](20) NULL,
	[OdKOzelKod2] [nvarchar](20) NULL,
	[OdKOzelKod3] [nvarchar](20) NULL,
	[OdKOzelKod4] [nvarchar](20) NULL,
	[OdKOzelKod5] [nvarchar](20) NULL,
	[OdKAnaGrup] [nvarchar](5) NULL,
	[OdKAciklama] [nvarchar](1000) NULL,
	[OdKUyari] [nvarchar](200) NULL,
	[OdKCariId] [decimal](18, 0) NULL,
	[OdKAltGrup] [nvarchar](5) NULL,
	[OdKKomOran] [money] NULL,
	[OdKDurum] [tinyint] NULL,
	[OdKSorId] [decimal](18, 0) NULL,
	[OdKAciklama1] [nvarchar](50) NULL,
	[OdKAciklama2] [nvarchar](50) NULL,
	[OdKAciklama3] [nvarchar](50) NULL,
	[OdKEkTutar1] [money] NULL,
	[OdKEkTutar2] [money] NULL,
	[OdKEkTutar3] [money] NULL,
	[OdKEkOran1] [money] NULL,
	[OdKEkOran2] [money] NULL,
	[OdKEkOran3] [money] NULL,
	[OdKKayKullanici] [nvarchar](20) NULL,
	[OdKKayitTarihi] [date] NULL,
	[OdKKayitSaati] [time](5) NULL,
	[OdKDuzKullanici] [nvarchar](20) NULL,
	[OdKDuzeltTarihi] [date] NULL,
	[OdKDuzeltSaati] [time](5) NULL,
	[OdKMagazaKodu] [nvarchar](50) NULL,
	[OdkDevirSatis] [money] NULL,
	[OdkDevirAlinan] [money] NULL,
	[OdkSatis] [money] NULL,
	[OdkAlinan] [money] NULL,
	[OdkBakiye] [money] NULL,
 CONSTRAINT [PK_Tb_OdemeKart] PRIMARY KEY CLUSTERED 
(
	[OdKId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_PartiKart](
	[PrtId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[PrtKod] [nvarchar](30) NULL,
	[PrtAd] [nvarchar](100) NULL,
	[PrtStokId] [decimal](18, 0) NULL,
	[PrtAciklama] [nvarchar](1000) NULL,
	[PrtUyari] [nvarchar](200) NULL,
	[PrtOzelKod1] [nvarchar](20) NULL,
	[PrtOzelKod2] [nvarchar](20) NULL,
	[PrtOzelKod3] [nvarchar](20) NULL,
	[PrtOzelKod4] [nvarchar](20) NULL,
	[PrtBaslTarih] [date] NULL,
	[PrtBitsTarih] [date] NULL,
	[PrtEn] [money] NULL,
	[PrtBoy] [money] NULL,
	[PrtYukseklik] [money] NULL,
	[PrtAgirlik] [money] NULL,
	[PrtAnaGrup] [nvarchar](5) NULL,
	[PrtAltGrup] [nvarchar](5) NULL,
	[PrtRenId] [decimal](18, 0) NULL,
	[PrtBeden] [nvarchar](10) NULL,
	[PrtKayKullanici] [nvarchar](20) NULL,
	[PrtKayitTarihi] [date] NULL,
	[PrtKayitSaati] [time](5) NULL,
	[PrtDuzKullanici] [nvarchar](20) NULL,
	[PrtDuzeltTarihi] [date] NULL,
	[PrtDuzeltSaat] [time](5) NULL,
	[PrtMagazaKodu] [nvarchar](20) NULL,
	[PrtAciklama1] [nvarchar](50) NULL,
	[PrtAciklama2] [nvarchar](50) NULL,
	[PrtAciklama3] [nvarchar](50) NULL,
	[PrtEkTutar1] [money] NULL,
	[PrtEkTutar2] [money] NULL,
	[PrtEkTutar3] [money] NULL,
	[PrtEkOran1] [money] NULL,
	[PrtEkOran2] [money] NULL,
	[PrtEkOran3] [money] NULL,
	[PrtOzelKod5] [nvarchar](200) NULL,
 CONSTRAINT [PK_Tb_PartiKart] PRIMARY KEY CLUSTERED 
(
	[PrtId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Personel](
	[PerId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[PerKod] [nvarchar](20) NULL,
	[PerAd] [nvarchar](20) NULL,
	[PerSoyad] [nvarchar](30) NULL,
	[PerGirisTarih] [date] NULL,
	[PerCikisTarih] [date] NULL,
	[PerEvTelefon] [nvarchar](20) NULL,
	[PerCepTelefon] [nvarchar](20) NULL,
	[PerTCKimlikNo] [nvarchar](20) NULL,
	[PerGorevi] [nvarchar](20) NULL,
	[PerSgkNo] [nvarchar](20) NULL,
	[PerMaasKasa] [money] NULL,
	[PerMaasBank] [money] NULL,
	[PerAdres] [nvarchar](100) NULL,
	[PerResim] [nvarchar](100) NULL,
	[PerDurum] [tinyint] NULL,
 CONSTRAINT [PK_Tb_Personel] PRIMARY KEY CLUSTERED 
(
	[PerId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Reyon](
	[ReyId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[ReyKod] [nvarchar](10) NULL,
	[ReyAd] [nvarchar](50) NULL,
 CONSTRAINT [PK_Tb_Reyon] PRIMARY KEY CLUSTERED 
(
	[ReyId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_RnBdHareket](
	[RnbId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[RnbStokId] [decimal](18, 0) NULL,
	[RnbRenkId] [decimal](18, 0) NULL,
	[RnbBeden] [nvarchar](10) NULL,
	[RnbTipi] [tinyint] NULL,
	[RnbTarih] [date] NULL,
	[RnbSaat] [nvarchar](5) NULL,
	[RnbMiktar] [money] NULL,
	[RnbSatirId] [decimal](18, 0) NULL,
	[RnbBaslikId] [decimal](18, 0) NULL,
	[RnbEvrakNo] [nvarchar](20) NULL,
	[RnbMagaza] [nvarchar](20) NULL,
	[RnbKullanici] [nvarchar](20) NULL,
	[RnbDepoId] [decimal](18, 0) NULL,
	[RnbGirDepoId] [decimal](18, 0) NULL,
	[RnbModul] [tinyint] NULL,
	[RnbPartiId] [decimal](18, 0) NULL,
	[RnbDepoAr] [tinyint] NULL,
	[RnbKaynak] [tinyint] NULL,
 CONSTRAINT [PK_Tb_RnBdHareket] PRIMARY KEY CLUSTERED 
(
	[RnbId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Satis](
	[SatId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[SatTur] [tinyint] NULL,
	[SatTarih] [date] NULL,
	[SatSaat] [nvarchar](5) NULL,
	[SatNo] [nvarchar](20) NULL,
	[SatCariId] [decimal](18, 0) NULL,
	[SatPersId] [decimal](18, 0) NULL,
	[SatKdvTip] [tinyint] NULL,
	[SatMsMerkId] [decimal](18, 0) NULL,
	[SatOtvTip] [tinyint] NULL,
	[SatOzelKod1] [nvarchar](20) NULL,
	[SatOzelKod2] [nvarchar](20) NULL,
	[SatOzelKod3] [nvarchar](20) NULL,
	[SatAciklama] [nvarchar](200) NULL,
	[SatAdresTip] [tinyint] NULL,
	[SatIskTutar1] [money] NULL,
	[SatIskTutar2] [money] NULL,
	[SatIskTutar3] [money] NULL,
	[SatIskTutar4] [money] NULL,
	[SatIskTutar5] [money] NULL,
	[SatIskOran1] [money] NULL,
	[SatIskOran2] [money] NULL,
	[SatIskOran3] [money] NULL,
	[SatIskOran4] [money] NULL,
	[SatIskOran5] [money] NULL,
	[SatIskDvTip1] [nvarchar](5) NULL,
	[SatIskDvTip2] [nvarchar](5) NULL,
	[SatIskDvTip3] [nvarchar](5) NULL,
	[SatIskDvTip4] [nvarchar](5) NULL,
	[SatIskDvTip5] [nvarchar](5) NULL,
	[SatIskDov1] [nvarchar](5) NULL,
	[SatIskDov2] [nvarchar](5) NULL,
	[SatIskDov3] [nvarchar](5) NULL,
	[SatIskDov4] [nvarchar](5) NULL,
	[SatIskDov5] [nvarchar](5) NULL,
	[SatIskDvTut1] [money] NULL,
	[SatIskDvTut2] [money] NULL,
	[SatIskDvTut3] [money] NULL,
	[SatIskDvTut4] [money] NULL,
	[SatIskDvTut5] [money] NULL,
	[SatIskKur1] [money] NULL,
	[SatIskKur2] [money] NULL,
	[SatIskKur3] [money] NULL,
	[SatIskKur4] [money] NULL,
	[SatIskKur5] [money] NULL,
	[SatMasTutar1] [money] NULL,
	[SatMasTutar2] [money] NULL,
	[SatMasTutar3] [money] NULL,
	[SatMasTutar4] [money] NULL,
	[SatMasTutar5] [money] NULL,
	[SatMasOran1] [money] NULL,
	[SatMasOran2] [money] NULL,
	[SatMasOran3] [money] NULL,
	[SatMasOran4] [money] NULL,
	[SatMasOran5] [money] NULL,
	[SatMasDvTip1] [nvarchar](5) NULL,
	[SatMasDvTip2] [nvarchar](5) NULL,
	[SatMasDvTip3] [nvarchar](5) NULL,
	[SatMasDvTip4] [nvarchar](5) NULL,
	[SatMasDvTip5] [nvarchar](5) NULL,
	[SatMasDov1] [nvarchar](5) NULL,
	[SatMasDov2] [nvarchar](5) NULL,
	[SatMasDov3] [nvarchar](5) NULL,
	[SatMasDov4] [nvarchar](5) NULL,
	[SatMasDov5] [nvarchar](5) NULL,
	[SatMasDvTut1] [money] NULL,
	[SatMasDvTut2] [money] NULL,
	[SatMasDvTut3] [money] NULL,
	[SatMasDvTut4] [money] NULL,
	[SatMasDvTut5] [money] NULL,
	[SatMasKur1] [money] NULL,
	[SatMasKur2] [money] NULL,
	[SatMasKur3] [money] NULL,
	[SatMasKur4] [money] NULL,
	[SatMasKur5] [money] NULL,
	[SatKdvAlIn1] [money] NULL,
	[SatKdvAlIn2] [money] NULL,
	[SatKdvAlEk1] [money] NULL,
	[SatKdvAlEk2] [money] NULL,
	[SatTevkOran] [money] NULL,
	[SatKdvOran] [money] NULL,
	[SatMalToplam] [money] NULL,
	[SatKalIsk] [money] NULL,
	[SatGenIsk] [money] NULL,
	[SatTopIsk] [money] NULL,
	[SatTopMas] [money] NULL,
	[SatAraTop] [money] NULL,
	[SatOtvTop] [money] NULL,
	[SatKdvMat] [money] NULL,
	[SatKdvTut] [money] NULL,
	[SatBrtTop] [money] NULL,
	[SatKdvAIn] [money] NULL,
	[SatKdvAEk] [money] NULL,
	[SatGenTop] [money] NULL,
	[SatVerTop] [money] NULL,
	[SatTevTut] [money] NULL,
	[SatOdnVer] [money] NULL,
	[SatKefilId1] [decimal](18, 0) NULL,
	[SatKefilId2] [decimal](18, 0) NULL,
	[SatKefilId3] [decimal](18, 0) NULL,
	[SatKefilId4] [decimal](18, 0) NULL,
	[SatKefilTip] [tinyint] NULL,
	[SatKayKullanici] [nvarchar](20) NULL,
	[SatKayTarihi] [date] NULL,
	[SatKaySaati] [time](5) NULL,
	[SatDuzKullanici] [nvarchar](20) NULL,
	[SatDuzeltTarihi] [date] NULL,
	[SatDuzeltSaat] [time](5) NULL,
	[SatMagazaKodu] [nvarchar](20) NULL,
	[SatTesTarih] [date] NULL,
	[SatTesSaat1] [nvarchar](5) NULL,
	[SatTesSaat2] [nvarchar](5) NULL,
	[SatTesAlan] [nvarchar](50) NULL,
	[SatTesPersId] [decimal](18, 0) NULL,
	[SatTesAdrTip] [tinyint] NULL,
	[SatTesYeri] [tinyint] NULL,
	[SatTesNot] [nvarchar](100) NULL,
	[SatVade] [date] NULL,
	[SatOtvMat] [money] NULL,
	[SatDepoId] [decimal](18, 0) NULL,
	[SatEkVerTut] [money] NULL,
 CONSTRAINT [PK_Tb_Satis] PRIMARY KEY CLUSTERED 
(
	[SatId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_SatKalem](
	[SKlId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[SKlFisId] [decimal](18, 0) NULL,
	[SKlTarih] [date] NULL,
	[SKlSaat] [nvarchar](5) NULL,
	[SKlTipi] [tinyint] NULL,
	[SKlKdvTipi] [tinyint] NULL,
	[SKlOtvTipi] [tinyint] NULL,
	[SKlSatirTipi] [tinyint] NULL,
	[SKlStokId] [decimal](18, 0) NULL,
	[SKlBirim] [nvarchar](10) NULL,
	[SKlMiktar] [money] NULL,
	[SKlFiyat] [money] NULL,
	[SKlDoviz] [nvarchar](4) NULL,
	[SKlDovizTipi] [nvarchar](5) NULL,
	[SKlDovizFiyat] [money] NULL,
	[SKlKur] [money] NULL,
	[SKlTutar] [money] NULL,
	[SKlDepoId] [decimal](18, 0) NULL,
	[SKlPartiId] [decimal](18, 0) NULL,
	[SKlBirimMiktar] [money] NULL,
	[SKlBirimFiyat] [money] NULL,
	[SKlMalyFiyat] [money] NULL,
	[SKlMalyTutar] [money] NULL,
	[SKlKdvOran] [money] NULL,
	[SKlOtvOran] [money] NULL,
	[SKlIskOrn1] [money] NULL,
	[SKlIskOrn2] [money] NULL,
	[SKlIskOrn3] [money] NULL,
	[SKlIskOrn4] [money] NULL,
	[SKlIskOrn5] [money] NULL,
	[SKlIskTut1] [money] NULL,
	[SKlIskTut2] [money] NULL,
	[SKlIskTut3] [money] NULL,
	[SKlIskTut4] [money] NULL,
	[SKlIskTut5] [money] NULL,
	[SKlTesTar1] [date] NULL,
	[SKlTesTar2] [date] NULL,
	[SKlTeslim] [tinyint] NULL,
	[SKlAciklama] [nvarchar](200) NULL,
	[SKlTeslimMiktar] [money] NULL,
	[SKlOtvTutar] [money] NULL,
	[SKlOtvMatrah] [money] NULL,
	[SKlKdvTutar] [money] NULL,
	[SKlKdvMatrah] [money] NULL,
	[SKlFatura] [tinyint] NULL CONSTRAINT [DF_Tb_SatKalem_SklFatura]  DEFAULT ((0)),
 CONSTRAINT [PK_Tb_SatKalem] PRIMARY KEY CLUSTERED 
(
	[SKlId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_SepetKart](
	[SepId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[SepBaslikId] [decimal](18, 0) NULL,
	[SepStokId] [decimal](18, 0) NULL,
	[SepBirim] [nvarchar](10) NULL,
	[SepMiktar] [money] NULL,
	[SepFiyat] [money] NULL,
	[SepDoviz] [nvarchar](4) NULL,
	[SepDovizTip] [nvarchar](5) NULL,
	[SepDovizFiyat] [money] NULL,
	[SepDepoId] [decimal](18, 0) NULL,
	[SepRenkBeden] [nvarchar](50) NULL,
	[SepAciklama] [nvarchar](200) NULL,
	[SepAnaStokId] [decimal](18, 0) NULL,
	[SepPartiId] [decimal](18, 0) NULL,
 CONSTRAINT [PK_Tb_SepetKart] PRIMARY KEY CLUSTERED 
(
	[SepId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_SeriNo](
	[SrnId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[SrnTipi] [tinyint] NULL,
	[SrnSeriNo] [nvarchar](50) NULL,
	[SrnSeriNo1] [nvarchar](50) NULL,
	[SrnSatirId] [decimal](18, 0) NULL,
	[SrnStokId] [decimal](18, 0) NULL,
	[SrnTarih] [date] NULL,
	[SrnBaslikId] [decimal](18, 0) NULL,
	[SrnEvrakNo] [nvarchar](20) NULL,
	[SrnMagaza] [nvarchar](20) NULL,
	[SrnKullanici] [nvarchar](20) NULL,
	[SrnSaat] [nvarchar](5) NULL,
	[SrnDepoId] [decimal](18, 0) NULL,
	[SrnGirDepoId] [decimal](18, 0) NULL,
	[SrnPartiId] [decimal](18, 0) NULL,
	[SrnSatirTip] [tinyint] NULL,
	[SrnModul] [tinyint] NULL,
	[SrnCariId] [decimal](18, 0) NULL,
	[SrnKaynak] [tinyint] NULL,
 CONSTRAINT [PK_Tb_SeriNo] PRIMARY KEY CLUSTERED 
(
	[SrnId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Sezon](
	[SezId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[SezKod] [nvarchar](10) NULL,
	[SezAd] [nvarchar](50) NULL,
 CONSTRAINT [PK_Tb_Sezon] PRIMARY KEY CLUSTERED 
(
	[SezId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Siparis](
	[SipId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[SipTur] [tinyint] NULL,
	[SipTarih] [date] NULL,
	[SipSaat] [nvarchar](5) NULL,
	[SipNo] [nvarchar](20) NULL,
	[SipCariId] [decimal](18, 0) NULL,
	[SipPersId] [decimal](18, 0) NULL,
	[SipKdvTip] [tinyint] NULL,
	[SipMsMerkId] [decimal](18, 0) NULL,
	[SipOtvTip] [tinyint] NULL,
	[SipTip] [tinyint] NULL,
	[SipOzelKod1] [nvarchar](20) NULL,
	[SipOzelKod2] [nvarchar](20) NULL,
	[SipOzelKod3] [nvarchar](20) NULL,
	[SipAciklama] [nvarchar](200) NULL,
	[SipAdresTip] [tinyint] NULL,
	[SipIskTutar1] [money] NULL,
	[SipIskTutar2] [money] NULL,
	[SipIskTutar3] [money] NULL,
	[SipIskTutar4] [money] NULL,
	[SipIskTutar5] [money] NULL,
	[SipIskOran1] [money] NULL,
	[SipIskOran2] [money] NULL,
	[SipIskOran3] [money] NULL,
	[SipIskOran4] [money] NULL,
	[SipIskOran5] [money] NULL,
	[SipIskDvTip1] [nvarchar](5) NULL,
	[SipIskDvTip2] [nvarchar](5) NULL,
	[SipIskDvTip3] [nvarchar](5) NULL,
	[SipIskDvTip4] [nvarchar](5) NULL,
	[SipIskDvTip5] [nvarchar](5) NULL,
	[SipIskDov1] [nvarchar](5) NULL,
	[SipIskDov2] [nvarchar](5) NULL,
	[SipIskDov3] [nvarchar](5) NULL,
	[SipIskDov4] [nvarchar](5) NULL,
	[SipIskDov5] [nvarchar](5) NULL,
	[SipIskDvTut1] [money] NULL,
	[SipIskDvTut2] [money] NULL,
	[SipIskDvTut3] [money] NULL,
	[SipIskDvTut4] [money] NULL,
	[SipIskDvTut5] [money] NULL,
	[SipIskKur1] [money] NULL,
	[SipIskKur2] [money] NULL,
	[SipIskKur3] [money] NULL,
	[SipIskKur4] [money] NULL,
	[SipIskKur5] [money] NULL,
	[SipMasTutar1] [money] NULL,
	[SipMasTutar2] [money] NULL,
	[SipMasTutar3] [money] NULL,
	[SipMasTutar4] [money] NULL,
	[SipMasTutar5] [money] NULL,
	[SipMasOran1] [money] NULL,
	[SipMasOran2] [money] NULL,
	[SipMasOran3] [money] NULL,
	[SipMasOran4] [money] NULL,
	[SipMasOran5] [money] NULL,
	[SipMasDvTip1] [nvarchar](5) NULL,
	[SipMasDvTip2] [nvarchar](5) NULL,
	[SipMasDvTip3] [nvarchar](5) NULL,
	[SipMasDvTip4] [nvarchar](5) NULL,
	[SipMasDvTip5] [nvarchar](5) NULL,
	[SipMasDov1] [nvarchar](5) NULL,
	[SipMasDov2] [nvarchar](5) NULL,
	[SipMasDov3] [nvarchar](5) NULL,
	[SipMasDov4] [nvarchar](5) NULL,
	[SipMasDov5] [nvarchar](5) NULL,
	[SipMasDvTut1] [money] NULL,
	[SipMasDvTut2] [money] NULL,
	[SipMasDvTut3] [money] NULL,
	[SipMasDvTut4] [money] NULL,
	[SipMasDvTut5] [money] NULL,
	[SipMasKur1] [money] NULL,
	[SipMasKur2] [money] NULL,
	[SipMasKur3] [money] NULL,
	[SipMasKur4] [money] NULL,
	[SipMasKur5] [money] NULL,
	[SipKdvAlIn1] [money] NULL,
	[SipKdvAlIn2] [money] NULL,
	[SipKdvAlEk1] [money] NULL,
	[SipKdvAlEk2] [money] NULL,
	[SipTevkOran] [money] NULL,
	[SipKdvOran] [money] NULL,
	[SipMalToplam] [money] NULL,
	[SipKalIsk] [money] NULL,
	[SipGenIsk] [money] NULL,
	[SipTopIsk] [money] NULL,
	[SipTopMas] [money] NULL,
	[SipAraTop] [money] NULL,
	[SipOtvTop] [money] NULL,
	[SipKdvMat] [money] NULL,
	[SipKdvTut] [money] NULL,
	[SipBrtTop] [money] NULL,
	[SipKdvAIn] [money] NULL,
	[SipKdvAEk] [money] NULL,
	[SipGenTop] [money] NULL,
	[SipVerTop] [money] NULL,
	[SipTevTut] [money] NULL,
	[SipOdnVer] [money] NULL,
	[SipKayKullanici] [nvarchar](20) NULL,
	[SipKayTarihi] [date] NULL,
	[SipKaySaati] [time](5) NULL,
	[SipDuzKullanici] [nvarchar](20) NULL,
	[SipDuzeltTarihi] [date] NULL,
	[SipDuzeltSaat] [time](5) NULL,
	[SipMagazaKodu] [nvarchar](20) NULL,
	[SipYazdirildi] [tinyint] NULL,
	[SipDepoId] [decimal](18, 0) NULL,
	[SipEkVerTut] [money] NULL,
	[SipKaynak] [tinyint] NULL,
 CONSTRAINT [PK_Tb_Siparis] PRIMARY KEY CLUSTERED 
(
	[SipId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_SipKalem](
	[SpKId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[SpKFisId] [decimal](18, 0) NULL,
	[SpKTarih] [date] NULL,
	[SpKSaat] [nvarchar](5) NULL,
	[SpKTipi] [tinyint] NULL,
	[SpKKdvTipi] [tinyint] NULL,
	[SpKOtvTipi] [tinyint] NULL,
	[SpKStokId] [decimal](18, 0) NULL,
	[SpKBirim] [nvarchar](10) NULL,
	[SpKMiktar] [money] NULL,
	[SpKFiyat] [money] NULL,
	[SpKDoviz] [nvarchar](4) NULL,
	[SpKDovizTipi] [nvarchar](5) NULL,
	[SpKDovizFiyat] [money] NULL,
	[SpKKur] [money] NULL,
	[SpKTutar] [money] NULL,
	[SpKBirimMiktar] [money] NULL,
	[SpKBirimFiyat] [money] NULL,
	[SpKMalyFiyat] [money] NULL,
	[SpKMalyTutar] [money] NULL,
	[SpKKdvOran] [money] NULL,
	[SpKOtvOran] [money] NULL,
	[SpKIskOrn1] [money] NULL,
	[SpKIskOrn2] [money] NULL,
	[SpKIskOrn3] [money] NULL,
	[SpKIskOrn4] [money] NULL,
	[SpKIskOrn5] [money] NULL,
	[SpKIskTut1] [money] NULL,
	[SpKIskTut2] [money] NULL,
	[SpKIskTut3] [money] NULL,
	[SpKIskTut4] [money] NULL,
	[SpKIskTut5] [money] NULL,
	[SpKTesTar1] [date] NULL,
	[SpKTesTar2] [date] NULL,
	[SpKTeslim] [tinyint] NULL,
	[SpKTeslimMiktar] [money] NULL,
	[SpKAciklama] [nvarchar](200) NULL,
	[SpKOtvTutar] [money] NULL,
	[SpKDepoId] [decimal](18, 0) NULL,
	[SpKKaynak] [tinyint] NULL,
	[SpKKaynakId] [decimal](18, 0) NULL,
 CONSTRAINT [PK_Tb_SipKalem] PRIMARY KEY CLUSTERED 
(
	[SpKId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_StkHarBaslik](
	[ShbId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[ShbFisTur] [tinyint] NULL,
	[ShbTarih] [date] NULL,
	[ShbSaat] [nvarchar](5) NULL,
	[ShbFisNo] [nvarchar](20) NULL,
	[ShbEvrakNo] [nvarchar](20) NULL,
	[ShbPersId] [decimal](18, 0) NULL,
	[ShbOzKod1] [nvarchar](20) NULL,
	[ShbOzKod2] [nvarchar](20) NULL,
	[ShbOzKod3] [nvarchar](20) NULL,
	[ShbKdvTipi] [tinyint] NULL,
	[ShbAciklama] [nvarchar](200) NULL,
	[ShbKayKullanici] [nvarchar](20) NULL,
	[ShbKayitTarihi] [date] NULL,
	[ShbKayitSaati] [time](5) NULL,
	[ShbDuzKullanici] [nvarchar](20) NULL,
	[ShbDuzeltTarihi] [date] NULL,
	[ShbDuzeltSaat] [time](5) NULL,
	[ShbMagazaKodu] [nvarchar](20) NULL,
	[ShbCariId] [decimal](18, 0) NULL,
	[ShbTopTutar] [money] NULL,
 CONSTRAINT [PK_Tb_StkHarBaslik] PRIMARY KEY CLUSTERED 
(
	[ShbId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_StkHarKalem](
	[ShkId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[ShkBaslikId] [decimal](18, 0) NULL,
	[ShkTipi] [tinyint] NULL,
	[ShkBaslikTipi] [tinyint] NULL,
	[ShkTarih] [date] NULL,
	[ShkSaat] [nvarchar](5) NULL,
	[ShkKdvTipi] [tinyint] NULL,
	[ShkStokId] [decimal](18, 0) NULL,
	[ShkBirim] [nvarchar](10) NULL,
	[ShkMiktar] [money] NULL,
	[ShkFiyat] [money] NULL,
	[ShkTutar] [money] NULL,
	[ShkDoviz] [nvarchar](4) NULL,
	[ShkDovizTip] [nvarchar](5) NULL,
	[ShkDovizFiyat] [money] NULL,
	[ShkKur] [money] NULL,
	[ShkDepoId] [decimal](18, 0) NULL,
	[ShkGirenDepoId] [decimal](18, 0) NULL,
	[ShkPartiId] [decimal](18, 0) NULL,
	[ShkBirimMiktar] [money] NULL,
	[ShkBirimFiyat] [money] NULL,
	[ShkMalyFiyat] [money] NULL,
	[ShkMalyTutar] [money] NULL,
	[ShkKdvOran] [money] NULL,
	[ShkCariId] [decimal](18, 0) NULL,
 CONSTRAINT [PK_Tb_StokHarKalem] PRIMARY KEY CLUSTERED 
(
	[ShkId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_StokKart](
	[StkId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[StkKod] [nvarchar](30) NULL,
	[StkCins] [nvarchar](100) NULL,
	[StkKisaCins] [nvarchar](50) NULL,
	[StkAnaDoviz] [nvarchar](4) NULL,
	[StkAnaDovTip] [nvarchar](5) NULL,
	[StkAnaBirim] [nvarchar](10) NULL,
	[StkFiyat1] [money] NULL,
	[StkFiyat2] [money] NULL,
	[StkFiyat3] [money] NULL,
	[StkFiyat4] [money] NULL,
	[StkFiyat5] [money] NULL,
	[StkDoviz1] [nvarchar](4) NULL,
	[StkDoviz2] [nvarchar](4) NULL,
	[StkDoviz3] [nvarchar](4) NULL,
	[StkDoviz4] [nvarchar](4) NULL,
	[StkDoviz5] [nvarchar](4) NULL,
	[StkDovTip1] [nvarchar](5) NULL,
	[StkDovTip2] [nvarchar](5) NULL,
	[StkDovTip3] [nvarchar](5) NULL,
	[StkDovTip4] [nvarchar](5) NULL,
	[StkDovTip5] [nvarchar](5) NULL,
	[StkOzelKod1] [nvarchar](20) NULL,
	[StkOzelKod2] [nvarchar](20) NULL,
	[StkOzelKod3] [nvarchar](20) NULL,
	[StkOzelKod4] [nvarchar](20) NULL,
	[StkOzelKod5] [nvarchar](20) NULL,
	[StkAnaKdv] [money] NULL,
	[StkAnaIskonto] [money] NULL,
	[StkNormalSeviye] [money] NULL,
	[StkKritikSeviye] [money] NULL,
	[StkAnaGrup] [nvarchar](5) NULL,
	[StkBarkodTipi] [tinyint] NULL,
	[StkBarkod] [nvarchar](50) NULL,
	[StkAciklama] [nvarchar](1000) NULL,
	[StkUyari] [nvarchar](200) NULL,
	[StkResim] [nvarchar](200) NULL,
	[StkDepId] [decimal](18, 0) NULL,
	[StkMarId] [decimal](18, 0) NULL,
	[StkModId] [decimal](18, 0) NULL,
	[StkKatId] [decimal](18, 0) NULL,
	[StkKolId] [decimal](18, 0) NULL,
	[StkRenId] [decimal](18, 0) NULL,
	[StkBeden] [nvarchar](10) NULL,
	[StkTurId] [decimal](18, 0) NULL,
	[StkSezId] [decimal](18, 0) NULL,
	[StkYil] [nvarchar](4) NULL,
	[StkSekId] [decimal](18, 0) NULL,
	[StkHamTip] [tinyint] NULL,
	[StkHamId] [decimal](18, 0) NULL,
	[StkReyId] [decimal](18, 0) NULL,
	[StkCinsiyet] [tinyint] NULL,
	[StkRaf1] [nvarchar](20) NULL,
	[StkRaf2] [nvarchar](20) NULL,
	[StkToptanKdv] [money] NULL,
	[StkPerakKdv] [money] NULL,
	[StkTopAlisIsk] [money] NULL,
	[StkPerAlisIsk] [money] NULL,
	[StkTopSatisIsk] [money] NULL,
	[StkPerSatisIsk] [money] NULL,
	[StkPrimMaxIsk] [money] NULL,
	[StkPrimGun] [int] NULL,
	[StkEn] [money] NULL,
	[StkBoy] [money] NULL,
	[StkYukseklik] [money] NULL,
	[StkAgirlik] [money] NULL,
	[StkOtvTipi] [tinyint] NULL,
	[StkOtvOranTutar] [money] NULL,
	[StkKarOran] [money] NULL,
	[StkFireOran] [money] NULL,
	[StkPrimOran] [money] NULL,
	[StkGaranti] [int] NULL,
	[StkTevkifatOrani] [money] NULL,
	[StkPuanDegeri] [money] NULL,
	[StkRafOmru] [int] NULL,
	[StkUreticiId] [decimal](18, 0) NULL,
	[StkTedarikciId] [decimal](18, 0) NULL,
	[StkUreticiTip] [tinyint] NULL,
	[StkUrStokKodu] [nvarchar](30) NULL,
	[StkUrStokCinsi] [nvarchar](50) NULL,
	[StkTanimlar] [nvarchar](50) NULL,
	[StkUrunTipi] [nvarchar](50) NULL,
	[StkAlisFiyTip] [tinyint] NULL,
	[StkSatisFiyTip] [tinyint] NULL,
	[StkUretFiyTip] [tinyint] NULL,
	[StkSiprFiyTip] [tinyint] NULL,
	[StkTekFiyTip] [tinyint] NULL,
	[StkSiparisGun] [nvarchar](10) NULL,
	[StkUrunSorumluId] [decimal](18, 0) NULL,
	[StkCikisDepoId] [decimal](18, 0) NULL,
	[StkGirisDepoId] [decimal](18, 0) NULL,
	[StkAltGrup] [nvarchar](5) NULL,
	[StkSiparisBirim] [tinyint] NULL,
	[StkAciklama1] [nvarchar](50) NULL,
	[StkAciklama2] [nvarchar](50) NULL,
	[StkAciklama3] [nvarchar](50) NULL,
	[StkEkTutar1] [money] NULL,
	[StkEkTutar2] [money] NULL,
	[StkEkTutar3] [money] NULL,
	[StkEkOran1] [money] NULL,
	[StkEkOran2] [money] NULL,
	[StkEkOran3] [money] NULL,
	[StkKayKullanici] [nvarchar](20) NULL,
	[StkKayitTarihi] [date] NULL,
	[StkKayitSaati] [time](5) NULL,
	[StkDuzKullanici] [nvarchar](20) NULL,
	[StkDuzeltTarihi] [date] NULL,
	[StkDuzeltSaat] [time](5) NULL,
	[StkMagazaKodu] [nvarchar](20) NULL,
	[StkBedenSeriId] [decimal](18, 0) NULL,
	[StkBirim1] [nvarchar](10) NULL,
	[StkBirim2] [nvarchar](10) NULL,
	[StkBirim3] [nvarchar](10) NULL,
	[StkBirim4] [nvarchar](10) NULL,
	[StkBirim5] [nvarchar](10) NULL,
	[StkCarpan1] [money] NULL,
	[StkCarpan2] [money] NULL,
	[StkCarpan3] [money] NULL,
	[StkCarpan4] [money] NULL,
	[StkCarpan5] [money] NULL,
	[StkBolen1] [money] NULL,
	[StkBolen2] [money] NULL,
	[StkBolen3] [money] NULL,
	[StkBolen4] [money] NULL,
	[StkBolen5] [money] NULL,
	[StkBakiye] [money] NULL,
	[StkDevirGir] [money] NULL,
	[StkDevirCik] [money] NULL,
	[StkKnDevirGir] [money] NULL,
	[StkKnDevirCik] [money] NULL,
	[StkStokGiren] [money] NULL,
	[StkStokCikan] [money] NULL,
	[StkUretGiren] [money] NULL,
	[StkUretCikan] [money] NULL,
	[StkKonGiren] [money] NULL,
	[StkKonCikan] [money] NULL,
	[StkSiprGiren] [money] NULL,
	[StkSiprCikan] [money] NULL,
	[StkFireCikan] [money] NULL,
	[StkSonAlisTarih] [date] NULL,
	[StkSonSatisTarih] [date] NULL,
	[StkOrtAlisMik] [money] NULL,
	[StkOrtAlisTut] [money] NULL,
	[StkOrtSatMik] [money] NULL,
	[StkOrtSatTut] [money] NULL,
	[StkSonAlis] [money] NULL,
	[StkSonSatis] [money] NULL,
	[StkYaoMik] [money] NULL,
	[StkYaoTut] [money] NULL,
	[StkEnUcAlis] [money] NULL,
	[StkEnUcSatis] [money] NULL,
	[StkEnPhAlis] [money] NULL,
	[StkEnPhSatis] [money] NULL,
	[StkEn1] [money] NULL,
	[StkEn2] [money] NULL,
	[StkEn3] [money] NULL,
	[StkEn4] [money] NULL,
	[StkEn5] [money] NULL,
	[StkBoy1] [money] NULL,
	[StkBoy2] [money] NULL,
	[StkBoy3] [money] NULL,
	[StkBoy4] [money] NULL,
	[StkBoy5] [money] NULL,
	[StkYuk1] [money] NULL,
	[StkYuk2] [money] NULL,
	[StkYuk3] [money] NULL,
	[StkYuk4] [money] NULL,
	[StkYuk5] [money] NULL,
	[StkAgr1] [money] NULL,
	[StkAgr2] [money] NULL,
	[StkAgr3] [money] NULL,
	[StkAgr4] [money] NULL,
	[StkAgr5] [money] NULL,
	[StkKdvId] [decimal](18, 0) NULL,
	[StkTopKdvId] [decimal](18, 0) NULL,
	[StkPerKdvId] [decimal](18, 0) NULL,
	[StkTevkId] [decimal](18, 0) NULL,
	[StkYaoFiyat] [money] NULL,
	[StkOtvTip] [nvarchar](5) NULL,
 CONSTRAINT [PK_Tb_StokKart] PRIMARY KEY CLUSTERED 
(
	[StkId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_StokRbSeri](
	[SrbId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[SrbStokId] [decimal](18, 0) NULL,
	[SrbRenId] [decimal](18, 0) NULL,
	[SrbBeden] [nvarchar](10) NULL,
	[SrbBarkod] [nvarchar](50) NULL,
	[SrbBarkodTipi] [tinyint] NULL,
	[SrbAsoMiktar] [money] NULL,
 CONSTRAINT [PK_Tb_StokRbSeri] PRIMARY KEY CLUSTERED 
(
	[SrbId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_SubeKart](
	[SubId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[SubKod] [nvarchar](30) NULL,
	[SubAd] [nvarchar](100) NULL,
	[SubMusteriNo] [nvarchar](20) NULL,
	[SubTelf1] [nvarchar](20) NULL,
	[SubTelf2] [nvarchar](20) NULL,
	[SubTelf3] [nvarchar](20) NULL,
	[SubTelf4] [nvarchar](20) NULL,
	[SubTelf5] [nvarchar](20) NULL,
	[SubOzelKod1] [nvarchar](20) NULL,
	[SubOzelKod2] [nvarchar](20) NULL,
	[SubOzelKod3] [nvarchar](20) NULL,
	[SubOzelKod4] [nvarchar](20) NULL,
	[SubOzelKod5] [nvarchar](20) NULL,
	[SubAnaGrup] [nvarchar](5) NULL,
	[SubWebAdres] [nvarchar](100) NULL,
	[SubAdres] [nvarchar](100) NULL,
	[SubSemt] [nvarchar](20) NULL,
	[SubIlce] [nvarchar](20) NULL,
	[SubIl] [nvarchar](20) NULL,
	[SubUlke] [nvarchar](20) NULL,
	[SubPostaKodu] [nvarchar](10) NULL,
	[SubAciklama] [nvarchar](1000) NULL,
	[SubUyari] [nvarchar](200) NULL,
	[SubBankaId] [decimal](18, 0) NULL,
	[SubSubeId] [decimal](18, 0) NULL,
	[SubSorumId] [decimal](18, 0) NULL,
	[SubWebAdr] [nvarchar](200) NULL,
	[SubAltGrup] [nvarchar](5) NULL,
	[SubAciklama1] [nvarchar](50) NULL,
	[SubAciklama2] [nvarchar](50) NULL,
	[SubAciklama3] [nvarchar](50) NULL,
	[SubEkTutar1] [money] NULL,
	[SubEkTutar2] [money] NULL,
	[SubEkTutar3] [money] NULL,
	[SubEkOran1] [money] NULL,
	[SubEkOran2] [money] NULL,
	[SubEkOran3] [money] NULL,
	[SubKayKullanici] [nvarchar](20) NULL,
	[SubKayitTarihi] [date] NULL,
	[SubKayitSaati] [time](5) NULL,
	[SubDuzKullanici] [nvarchar](20) NULL,
	[SubDuzeltTarihi] [date] NULL,
	[SubDuzeltSaati] [time](5) NULL,
	[SubMagazaKodu] [nvarchar](50) NULL,
	[SubIlceId] [decimal](18, 0) NULL,
	[SubIlId] [decimal](18, 0) NULL,
	[SubUlkeId] [decimal](18, 0) NULL,
 CONSTRAINT [PK_Tb_SubeKart] PRIMARY KEY CLUSTERED 
(
	[SubId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Taksit](
	[TakId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[TakTutar] [money] NULL,
	[TakVade] [date] NULL,
	[TakSatisId] [decimal](18, 4) NULL,
	[TakCariId] [decimal](18, 0) NULL,
	[TakKefilId1] [decimal](18, 4) NULL,
	[TakKefilId2] [decimal](18, 4) NULL,
	[TakKefilId3] [decimal](18, 4) NULL,
	[TakKefilId4] [decimal](18, 4) NULL,
	[TakKefilTip] [tinyint] NULL,
	[TakSiraNo] [nvarchar](10) NULL,
	[TakKaynak] [tinyint] NULL,
	[TakKayKullanici] [nvarchar](20) NULL,
	[TakKayitTarihi] [date] NULL,
	[TakKayitSaati] [time](5) NULL,
	[TakDuzKullanýcý] [nvarchar](20) NULL,
	[TakDuzTarihi] [date] NULL,
	[TakDuzSaati] [time](5) NULL,
	[TakMagazaKodu] [nvarchar](20) NULL,
	[TakKaraListe] [tinyint] NULL,
	[TakSenetId] [decimal](18, 4) NULL,
	[TakOdendi] [tinyint] NULL,
	[TakCikisId] [decimal](18, 4) NULL,
 CONSTRAINT [PK_Tb_Taksit] PRIMARY KEY CLUSTERED 
(
	[TakId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_TaksitTahsil](
	[TkOId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[TkOTaksitId] [decimal](18, 0) NULL,
	[TkOTahsilId] [decimal](18, 0) NULL,
	[TkOTutar] [money] NULL,
	[TkOTarih] [date] NULL,
	[TkOCariId] [decimal](18, 0) NULL,
	[TkOTipi] [tinyint] NULL,
	[TkOModul] [tinyint] NULL,
 CONSTRAINT [PK_Tb_TaksitTahsil] PRIMARY KEY CLUSTERED 
(
	[TkOId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_TekKalem](
	[TkKId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[TkKFisId] [decimal](18, 0) NULL,
	[TkKTarih] [date] NULL,
	[TkKSaat] [nvarchar](5) NULL,
	[TkKTipi] [tinyint] NULL,
	[TkKKdvTipi] [tinyint] NULL,
	[TkKOtvTipi] [tinyint] NULL,
	[TkKSatirTipi] [tinyint] NULL,
	[TkKStokId] [decimal](18, 0) NULL,
	[TkKBirim] [nvarchar](10) NULL,
	[TkKMiktar] [money] NULL,
	[TkKFiyat] [money] NULL,
	[TkKDoviz] [nvarchar](4) NULL,
	[TkKDovizTipi] [nvarchar](5) NULL,
	[TkKDovizFiyat] [money] NULL,
	[TkKKur] [money] NULL,
	[TkKTutar] [money] NULL,
	[TkKBirimMiktar] [money] NULL,
	[TkKBirimFiyat] [money] NULL,
	[TkKMalyFiyat] [money] NULL,
	[TkKMalyTutar] [money] NULL,
	[TkKKdvOran] [money] NULL,
	[TkKOtvOran] [money] NULL,
	[TkKIskOrn1] [money] NULL,
	[TkKIskOrn2] [money] NULL,
	[TkKIskOrn3] [money] NULL,
	[TkKIskOrn4] [money] NULL,
	[TkKIskOrn5] [money] NULL,
	[TkKIskTut1] [money] NULL,
	[TkKIskTut2] [money] NULL,
	[TkKIskTut3] [money] NULL,
	[TkKIskTut4] [money] NULL,
	[TkKIskTut5] [money] NULL,
	[TkKAciklama] [nvarchar](100) NULL,
	[TkKOtvTutar] [money] NULL,
	[TkKFtIrMiktar] [money] NULL,
 CONSTRAINT [PK_Tb_TekKalem] PRIMARY KEY CLUSTERED 
(
	[TkKId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Teklif](
	[TekId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[TekTur] [tinyint] NULL,
	[TekTarih] [date] NULL,
	[TekSaat] [nvarchar](5) NULL,
	[TekVade] [date] NULL,
	[TekNo] [nvarchar](20) NULL,
	[TekCariId] [decimal](18, 0) NULL,
	[TekPersId] [decimal](18, 0) NULL,
	[TekKdvTip] [tinyint] NULL,
	[TekMsMerkId] [decimal](18, 0) NULL,
	[TekOtvTip] [tinyint] NULL,
	[TekTip] [tinyint] NULL,
	[TekOzelKod1] [nvarchar](20) NULL,
	[TekOzelKod2] [nvarchar](20) NULL,
	[TekOzelKod3] [nvarchar](20) NULL,
	[TekAciklama] [nvarchar](200) NULL,
	[TekAdresTip] [tinyint] NULL,
	[TekIskTutar1] [money] NULL,
	[TekIskTutar2] [money] NULL,
	[TekIskTutar3] [money] NULL,
	[TekIskTutar4] [money] NULL,
	[TekIskTutar5] [money] NULL,
	[TekIskOran1] [money] NULL,
	[TekIskOran2] [money] NULL,
	[TekIskOran3] [money] NULL,
	[TekIskOran4] [money] NULL,
	[TekIskOran5] [money] NULL,
	[TekIskDvTip1] [nvarchar](5) NULL,
	[TekIskDvTip2] [nvarchar](5) NULL,
	[TekIskDvTip3] [nvarchar](5) NULL,
	[TekIskDvTip4] [nvarchar](5) NULL,
	[TekIskDvTip5] [nvarchar](5) NULL,
	[TekIskDov1] [nvarchar](5) NULL,
	[TekIskDov2] [nvarchar](5) NULL,
	[TekIskDov3] [nvarchar](5) NULL,
	[TekIskDov4] [nvarchar](5) NULL,
	[TekIskDov5] [nvarchar](5) NULL,
	[TekIskDvTut1] [money] NULL,
	[TekIskDvTut2] [money] NULL,
	[TekIskDvTut3] [money] NULL,
	[TekIskDvTut4] [money] NULL,
	[TekIskDvTut5] [money] NULL,
	[TekIskKur1] [money] NULL,
	[TekIskKur2] [money] NULL,
	[TekIskKur3] [money] NULL,
	[TekIskKur4] [money] NULL,
	[TekIskKur5] [money] NULL,
	[TekMasTutar1] [money] NULL,
	[TekMasTutar2] [money] NULL,
	[TekMasTutar3] [money] NULL,
	[TekMasTutar4] [money] NULL,
	[TekMasTutar5] [money] NULL,
	[TekMasOran1] [money] NULL,
	[TekMasOran2] [money] NULL,
	[TekMasOran3] [money] NULL,
	[TekMasOran4] [money] NULL,
	[TekMasOran5] [money] NULL,
	[TekMasDvTip1] [nvarchar](5) NULL,
	[TekMasDvTip2] [nvarchar](5) NULL,
	[TekMasDvTip3] [nvarchar](5) NULL,
	[TekMasDvTip4] [nvarchar](5) NULL,
	[TekMasDvTip5] [nvarchar](5) NULL,
	[TekMasDov1] [nvarchar](5) NULL,
	[TekMasDov2] [nvarchar](5) NULL,
	[TekMasDov3] [nvarchar](5) NULL,
	[TekMasDov4] [nvarchar](5) NULL,
	[TekMasDov5] [nvarchar](5) NULL,
	[TekMasDvTut1] [money] NULL,
	[TekMasDvTut2] [money] NULL,
	[TekMasDvTut3] [money] NULL,
	[TekMasDvTut4] [money] NULL,
	[TekMasDvTut5] [money] NULL,
	[TekMasKur1] [money] NULL,
	[TekMasKur2] [money] NULL,
	[TekMasKur3] [money] NULL,
	[TekMasKur4] [money] NULL,
	[TekMasKur5] [money] NULL,
	[TekKdvAlIn1] [money] NULL,
	[TekKdvAlIn2] [money] NULL,
	[TekKdvAlEk1] [money] NULL,
	[TekKdvAlEk2] [money] NULL,
	[TekTevkOran] [money] NULL,
	[TekKdvOran] [money] NULL,
	[TekMalToplam] [money] NULL,
	[TekKalIsk] [money] NULL,
	[TekGenIsk] [money] NULL,
	[TekTopIsk] [money] NULL,
	[TekTopMas] [money] NULL,
	[TekAraTop] [money] NULL,
	[TekOtvTop] [money] NULL,
	[TekKdvMat] [money] NULL,
	[TekKdvTut] [money] NULL,
	[TekBrtTop] [money] NULL,
	[TekKdvAIn] [money] NULL,
	[TekKdvAEk] [money] NULL,
	[TekGenTop] [money] NULL,
	[TekVerTop] [money] NULL,
	[TekTevTut] [money] NULL,
	[TekOdnVer] [money] NULL,
	[TekKayKullanici] [nvarchar](20) NULL,
	[TekKayTarihi] [date] NULL,
	[TekKaySaati] [time](5) NULL,
	[TekDuzKullanici] [nvarchar](20) NULL,
	[TekDuzeltTarihi] [date] NULL,
	[TekDuzeltSaat] [time](5) NULL,
	[TekMagazaKodu] [nvarchar](20) NULL,
	[TekYazdirildi] [tinyint] NULL,
	[TekDepoId] [decimal](18, 0) NULL,
	[TekEkVerTut] [money] NULL,
 CONSTRAINT [PK_Tb_Teklif] PRIMARY KEY CLUSTERED 
(
	[TekId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Tur](
	[TurId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[TurKod] [nvarchar](10) NULL,
	[TurAd] [nvarchar](50) NULL,
	[TurTip] [tinyint] NULL,
 CONSTRAINT [PK_Tb_Tur] PRIMARY KEY CLUSTERED 
(
	[TurId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_Yetkili](
	[YtKId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[YtKAd] [nvarchar](20) NULL,
	[YtKSoyad] [nvarchar](20) NULL,
	[YtKGorev] [nvarchar](20) NULL,
	[YtKTel] [nvarchar](20) NULL,
	[YtKFax] [nvarchar](20) NULL,
	[YtKMail] [nvarchar](30) NULL,
	[YtKTip] [tinyint] NULL,
	[YtKKartId] [decimal](18, 0) NULL,
 CONSTRAINT [PK_Tb_CariYetk] PRIMARY KEY CLUSTERED 
(
	[YtKId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_YzKKalem](
	[YkKId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[YkKFisId] [decimal](18, 0) NULL,
	[YkKTarih] [date] NULL,
	[YkKSaat] [nvarchar](5) NULL,
	[YkKStokId] [decimal](18, 0) NULL,
	[YkKBirim] [nvarchar](10) NULL,
	[YkKMiktar] [money] NULL,
	[YkKFiyat] [money] NULL,
	[YkKTutar] [money] NULL,
	[YkKDepoId] [decimal](18, 0) NULL,
	[YkKPartiId] [decimal](18, 0) NULL,
	[YkKBirimMiktar] [money] NULL,
	[YkKBirimFiyat] [money] NULL,
	[YkKMalyFiyat] [money] NULL,
	[YkKMalyTutar] [money] NULL,
	[YkKKdvOran] [money] NULL,
	[YkKAciklama] [nvarchar](200) NULL,
	[YkKKdvTutar] [money] NULL,
	[YkKKdvMatrah] [money] NULL,
 CONSTRAINT [PK_Tb_YzKKalem] PRIMARY KEY CLUSTERED 
(
	[YkKId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tb_YzKsSatis](
	[YzKId] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[YzKTarih] [date] NULL,
	[YzKSaat] [nvarchar](5) NULL,
	[YzKNo] [nvarchar](20) NULL,
	[YzKCariId] [decimal](18, 0) NULL,
	[YzKPersId] [decimal](18, 0) NULL,
	[YzKMsMerkId] [decimal](18, 0) NULL,
	[YzKOzelKod1] [nvarchar](20) NULL,
	[YzKOzelKod2] [nvarchar](20) NULL,
	[YzKOzelKod3] [nvarchar](20) NULL,
	[YzKAciklama] [nvarchar](200) NULL,
	[YzKMalToplam] [money] NULL,
	[YzKKdvMat] [money] NULL,
	[YzKKdvTut] [money] NULL,
	[YzKGenTop] [money] NULL,
	[YzKKayKullanici] [nvarchar](20) NULL,
	[YzKKayTarihi] [date] NULL,
	[YzKKaySaati] [time](5) NULL,
	[YzKDuzKullanici] [nvarchar](20) NULL,
	[YzKDuzeltTarihi] [date] NULL,
	[YzKDuzeltSaat] [time](5) NULL,
	[YzKMagazaKodu] [nvarchar](20) NULL,
 CONSTRAINT [PK_Tb_YzKsSatis] PRIMARY KEY CLUSTERED 
(
	[YzKId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX X_INDEX_BnHFisId ON Tb_BankaHareket(BnHFisId)
GO
CREATE NONCLUSTERED INDEX X_INDEX_CrHFisId ON Tb_CariHareket(CrHFisId)
GO
CREATE NONCLUSTERED INDEX X_INDEX_CsHFisId ON Tb_CkSnHareket(CsHFisId)
GO
CREATE NONCLUSTERED INDEX X_INDEX_FtKFisId ON Tb_FatKalem(FtKFisId)
GO
CREATE NONCLUSTERED INDEX X_INDEX_IrKFisId ON Tb_IrsKalem(IrKFisId)
GO
CREATE NONCLUSTERED INDEX X_INDEX_KsHFisId ON Tb_KasaHareket(KsHFisId)
GO
CREATE NONCLUSTERED INDEX X_INDEX_SKlFisId ON Tb_SatKalem(SKlFisId)
GO
CREATE NONCLUSTERED INDEX X_INDEX_SpKFisId ON Tb_SipKalem(SpKFisId)
GO
CREATE NONCLUSTERED INDEX X_INDEX_ShkBaslikId ON Tb_StkHarKalem(ShkBaslikId)
GO
CREATE NONCLUSTERED INDEX X_INDEX_TkOTaksitId ON Tb_TaksitTahsil(TkOTaksitId)
GO
CREATE NONCLUSTERED INDEX X_INDEX_TkOTahsilId ON Tb_TaksitTahsil(TkOTahsilId)
GO
CREATE NONCLUSTERED INDEX X_INDEX_TkKFisId ON Tb_TekKalem(TkKFisId)
GO
CREATE NONCLUSTERED INDEX X_INDEX_YkKFisId ON Tb_YzKKalem(YkKFisId)
GO