USE [LOGO_BAKI2018]
GO

/****** Object:  Table [dbo].[LG_011_08_CSCARD]    Script Date: 17.01.2026 01:08:01 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[LG_011_08_CSCARD](
	[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
	[DOC] [smallint] NULL,
	[CURRSTAT] [smallint] NULL,
	[OURBANKREF] [int] NULL,
	[PORTFOYNO] [varchar](17) NULL,
	[SERINO] [varchar](25) NULL,
	[BANKNAME] [varchar](101) NULL,
	[SPECODE] [varchar](11) NULL,
	[CYPHCODE] [varchar](11) NULL,
	[CITY] [varchar](51) NULL,
	[OWING] [varchar](201) NULL,
	[KEFIL] [varchar](31) NULL,
	[MUHABIR] [varchar](101) NULL,
	[BRANCH] [smallint] NULL,
	[DUEDATE] [datetime] NULL,
	[SETDATE] [datetime] NULL,
	[STAMP] [float] NULL,
	[AMOUNT] [float] NULL,
	[TRCURR] [smallint] NULL,
	[TRRATE] [float] NULL,
	[TRNET] [float] NULL,
	[REPORTRATE] [float] NULL,
	[REPORTNET] [float] NULL,
	[RISKUPDATE] [smallint] NULL,
	[DEVIR] [smallint] NULL,
	[INUSE] [smallint] NULL,
	[EXTENREF] [int] NULL,
	[CAPIBLOCK_CREATEDBY] [smallint] NULL,
	[CAPIBLOCK_CREADEDDATE] [datetime] NULL,
	[CAPIBLOCK_CREATEDHOUR] [smallint] NULL,
	[CAPIBLOCK_CREATEDMIN] [smallint] NULL,
	[CAPIBLOCK_CREATEDSEC] [smallint] NULL,
	[CAPIBLOCK_MODIFIEDBY] [smallint] NULL,
	[CAPIBLOCK_MODIFIEDDATE] [datetime] NULL,
	[CAPIBLOCK_MODIFIEDHOUR] [smallint] NULL,
	[CAPIBLOCK_MODIFIEDMIN] [smallint] NULL,
	[CAPIBLOCK_MODIFIEDSEC] [smallint] NULL,
	[COLLREPRATE] [float] NULL,
	[COLLTRRATE] [float] NULL,
	[CANCELLED] [smallint] NULL,
	[LINEEXCTYP] [smallint] NULL,
	[TEXTINC] [smallint] NULL,
	[SITEID] [smallint] NULL,
	[RECSTATUS] [smallint] NULL,
	[ORGLOGICREF] [int] NULL,
	[WFSTATUS] [int] NULL,
	[BNBRANCHNO] [varchar](51) NULL,
	[BNACCOUNTNO] [varchar](51) NULL,
	[DEPTADDR1] [varchar](51) NULL,
	[DEPTADDR2] [varchar](51) NULL,
	[DEPTCITY] [varchar](21) NULL,
	[DEPTCITYCODE] [varchar](13) NULL,
	[DEPTCOUNTRY] [varchar](41) NULL,
	[DEPTCOUNTRYCODE] [varchar](13) NULL,
	[DEPTPOSTCODE] [varchar](11) NULL,
	[DEPTTELNRS1] [varchar](16) NULL,
	[DEPTTELNRS2] [varchar](16) NULL,
	[DEPTFAXNR] [varchar](16) NULL,
	[DEPTTOWN] [varchar](51) NULL,
	[DEPTTOWNCODE] [varchar](13) NULL,
	[DEPTDISTRICT] [varchar](51) NULL,
	[DEPTDISTRICTCODE] [varchar](13) NULL,
	[OPSTAT] [smallint] NULL,
	[PRINTCNT] [smallint] NULL,
	[NEWSERINO] [varchar](31) NULL,
	[PROJECTREF] [int] NULL,
	[TELCODES1] [varchar](9) NULL,
	[TELCODES2] [varchar](9) NULL,
	[FAXCODE] [varchar](9) NULL,
	[AFFECTCOLLATRL] [smallint] NULL,
	[COLLATROLLREF] [int] NULL,
	[COLLATCARDREF] [int] NULL,
	[AFFECTRISK] [smallint] NULL,
	[GIROREPRATE] [float] NULL,
	[GIROTRRATE] [float] NULL,
	[ORGLOGOID] [varchar](25) NULL,
	[GIROAMOUNT] [float] NULL,
	[GIROREPNET] [float] NULL,
	[USEGIRORATE] [smallint] NULL,
	[TAXNR] [varchar](51) NULL,
	[IBAN] [varchar](51) NULL,
	[TRADINGGRP] [varchar](17) NULL,
	[USERAISEDVAL] [smallint] NULL,
	[RAISEDVALAMOUNT] [float] NULL,
	[RAISEDVALREPNET] [float] NULL,
	[SALESMANREF] [int] NULL,
	[SUBDURATION] [int] NULL,
	[DEGACTIVE] [smallint] NULL,
	[DEGCURR] [smallint] NULL,
	[DEGCURRRATE] [float] NULL,
	[CIRO] [smallint] NULL,
	[KEFIL2] [varchar](31) NULL,
	[GUID] [varchar](37) NULL,
	[OFFERREF] [int] NULL,
	[PRINTDATE] [datetime] NULL,
	[STATUS] [smallint] NULL,
	[BNCREREF] [int] NULL,
	[PARTIAL_] [smallint] NULL,
	[CLTRCURR] [smallint] NULL,
	[CLTRRATE] [float] NULL,
	[CLTRNET] [float] NULL,
 CONSTRAINT [I011_08_CSCARD_I1] PRIMARY KEY CLUSTERED 
(
	[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO


