USE [LOGO_BAKI2018]
GO

/****** Object:  Table [dbo].[LG_011_CLCARD]    Script Date: 17.01.2026 01:05:47 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[LG_011_CLCARD](
	[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
	[ACTIVE] [smallint] NULL,
	[CARDTYPE] [smallint] NULL,
	[CODE] [varchar](17) NULL,
	[DEFINITION_] [varchar](201) NULL,
	[SPECODE] [varchar](11) NULL,
	[CYPHCODE] [varchar](11) NULL,
	[ADDR1] [varchar](201) NULL,
	[ADDR2] [varchar](201) NULL,
	[CITY] [varchar](21) NULL,
	[COUNTRY] [varchar](41) NULL,
	[POSTCODE] [varchar](11) NULL,
	[TELNRS1] [varchar](51) NULL,
	[TELNRS2] [varchar](51) NULL,
	[FAXNR] [varchar](51) NULL,
	[TAXNR] [varchar](16) NULL,
	[TAXOFFICE] [varchar](31) NULL,
	[INCHARGE] [varchar](41) NULL,
	[DISCRATE] [float] NULL,
	[EXTENREF] [int] NULL,
	[PAYMENTREF] [int] NULL,
	[EMAILADDR] [varchar](251) NULL,
	[WEBADDR] [varchar](101) NULL,
	[WARNMETHOD] [smallint] NULL,
	[WARNEMAILADDR] [varchar](251) NULL,
	[WARNFAXNR] [varchar](16) NULL,
	[CLANGUAGE] [smallint] NULL,
	[VATNR] [varchar](33) NULL,
	[BLOCKED] [smallint] NULL,
	[BANKBRANCHS1] [varchar](17) NULL,
	[BANKBRANCHS2] [varchar](17) NULL,
	[BANKBRANCHS3] [varchar](17) NULL,
	[BANKBRANCHS4] [varchar](17) NULL,
	[BANKBRANCHS5] [varchar](17) NULL,
	[BANKBRANCHS6] [varchar](17) NULL,
	[BANKBRANCHS7] [varchar](17) NULL,
	[BANKACCOUNTS1] [varchar](51) NULL,
	[BANKACCOUNTS2] [varchar](51) NULL,
	[BANKACCOUNTS3] [varchar](51) NULL,
	[BANKACCOUNTS4] [varchar](51) NULL,
	[BANKACCOUNTS5] [varchar](51) NULL,
	[BANKACCOUNTS6] [varchar](51) NULL,
	[BANKACCOUNTS7] [varchar](51) NULL,
	[DELIVERYMETHOD] [varchar](13) NULL,
	[DELIVERYFIRM] [varchar](13) NULL,
	[CCURRENCY] [smallint] NULL,
	[TEXTINC] [smallint] NULL,
	[SITEID] [smallint] NULL,
	[RECSTATUS] [smallint] NULL,
	[ORGLOGICREF] [int] NULL,
	[EDINO] [varchar](25) NULL,
	[TRADINGGRP] [varchar](17) 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,
	[PAYMENTPROC] [smallint] NULL,
	[CRATEDIFFPROC] [smallint] NULL,
	[WFSTATUS] [int] NULL,
	[PPGROUPCODE] [varchar](17) NULL,
	[PPGROUPREF] [int] NULL,
	[TAXOFFCODE] [varchar](31) NULL,
	[TOWNCODE] [varchar](13) NULL,
	[TOWN] [varchar](51) NULL,
	[DISTRICTCODE] [varchar](13) NULL,
	[DISTRICT] [varchar](51) NULL,
	[CITYCODE] [varchar](13) NULL,
	[COUNTRYCODE] [varchar](13) NULL,
	[ORDSENDMETHOD] [smallint] NULL,
	[ORDSENDEMAILADDR] [varchar](251) NULL,
	[ORDSENDFAXNR] [varchar](16) NULL,
	[DSPSENDMETHOD] [smallint] NULL,
	[DSPSENDEMAILADDR] [varchar](251) NULL,
	[DSPSENDFAXNR] [varchar](16) NULL,
	[INVSENDMETHOD] [smallint] NULL,
	[INVSENDEMAILADDR] [varchar](251) NULL,
	[INVSENDFAXNR] [varchar](16) NULL,
	[SUBSCRIBERSTAT] [smallint] NULL,
	[SUBSCRIBEREXT] [varchar](17) NULL,
	[AUTOPAIDBANK] [varchar](25) NULL,
	[PAYMENTTYPE] [smallint] NULL,
	[LASTSENDREMLEV] [int] NULL,
	[EXTACCESSFLAGS] [int] NULL,
	[ORDSENDFORMAT] [smallint] NULL,
	[DSPSENDFORMAT] [smallint] NULL,
	[INVSENDFORMAT] [smallint] NULL,
	[REMSENDFORMAT] [smallint] NULL,
	[STORECREDITCARDNO] [varchar](17) NULL,
	[CLORDFREQ] [smallint] NULL,
	[ORDDAY] [smallint] NULL,
	[LOGOID] [varchar](25) NULL,
	[LIDCONFIRMED] [smallint] NULL,
	[EXPREGNO] [varchar](25) NULL,
	[EXPDOCNO] [varchar](33) NULL,
	[EXPBUSTYPREF] [int] NULL,
	[INVPRINTCNT] [smallint] NULL,
	[PIECEORDINFLICT] [smallint] NULL,
	[COLLECTINVOICING] [smallint] NULL,
	[EBUSDATASENDTYPE] [smallint] NULL,
	[INISTATUSFLAGS] [int] NULL,
	[SLSORDERSTATUS] [smallint] NULL,
	[SLSORDERPRICE] [smallint] NULL,
	[LTRSENDMETHOD] [smallint] NULL,
	[LTRSENDEMAILADDR] [varchar](251) NULL,
	[LTRSENDFAXNR] [varchar](16) NULL,
	[LTRSENDFORMAT] [smallint] NULL,
	[IMAGEINC] [smallint] NULL,
	[CELLPHONE] [varchar](18) NULL,
	[SAMEITEMCODEUSE] [smallint] NULL,
	[STATECODE] [varchar](13) NULL,
	[STATENAME] [varchar](41) NULL,
	[WFLOWCRDREF] [int] NULL,
	[PARENTCLREF] [int] NULL,
	[LOWLEVELCODES1] [int] NULL,
	[LOWLEVELCODES2] [int] NULL,
	[LOWLEVELCODES3] [int] NULL,
	[LOWLEVELCODES4] [int] NULL,
	[LOWLEVELCODES5] [int] NULL,
	[LOWLEVELCODES6] [int] NULL,
	[LOWLEVELCODES7] [int] NULL,
	[LOWLEVELCODES8] [int] NULL,
	[LOWLEVELCODES9] [int] NULL,
	[LOWLEVELCODES10] [int] NULL,
	[TELCODES1] [varchar](9) NULL,
	[TELCODES2] [varchar](9) NULL,
	[FAXCODE] [varchar](9) NULL,
	[PURCHBRWS] [smallint] NULL,
	[SALESBRWS] [smallint] NULL,
	[IMPBRWS] [smallint] NULL,
	[EXPBRWS] [smallint] NULL,
	[FINBRWS] [smallint] NULL,
	[ORGLOGOID] [varchar](25) NULL,
	[ADDTOREFLIST] [smallint] NULL,
	[TEXTREFTR] [smallint] NULL,
	[TEXTREFEN] [smallint] NULL,
	[ARPQUOTEINC] [smallint] NULL,
	[CLCRM] [smallint] NULL,
	[GRPFIRMNR] [smallint] NULL,
	[CONSCODEREF] [int] NULL,
	[SPECODE2] [varchar](11) NULL,
	[SPECODE3] [varchar](11) NULL,
	[SPECODE4] [varchar](11) NULL,
	[SPECODE5] [varchar](11) NULL,
	[OFFSENDMETHOD] [smallint] NULL,
	[OFFSENDEMAILADDR] [varchar](251) NULL,
	[OFFSENDFAXNR] [varchar](16) NULL,
	[OFFSENDFORMAT] [smallint] NULL,
	[EBANKNO] [smallint] NULL,
	[LOANGRPCTRL] [smallint] NULL,
	[BANKNAMES1] [varchar](51) NULL,
	[BANKNAMES2] [varchar](51) NULL,
	[BANKNAMES3] [varchar](51) NULL,
	[BANKNAMES4] [varchar](51) NULL,
	[BANKNAMES5] [varchar](51) NULL,
	[BANKNAMES6] [varchar](51) NULL,
	[BANKNAMES7] [varchar](51) NULL,
	[LDXFIRMNR] [smallint] NULL,
	[MAPID] [varchar](33) NULL,
	[LONGITUDE] [varchar](41) NULL,
	[LATITUTE] [varchar](41) NULL,
	[CITYID] [varchar](9) NULL,
	[TOWNID] [varchar](18) NULL,
	[BANKIBANS1] [varchar](51) NULL,
	[BANKIBANS2] [varchar](51) NULL,
	[BANKIBANS3] [varchar](51) NULL,
	[BANKIBANS4] [varchar](51) NULL,
	[BANKIBANS5] [varchar](51) NULL,
	[BANKIBANS6] [varchar](51) NULL,
	[BANKIBANS7] [varchar](51) NULL,
	[TCKNO] [varchar](16) NULL,
	[ISPERSCOMP] [smallint] NULL,
	[EXTSENDMETHOD] [smallint] NULL,
	[EXTSENDEMAILADDR] [varchar](251) NULL,
	[EXTSENDFAXNR] [varchar](16) NULL,
	[EXTSENDFORMAT] [smallint] NULL,
	[BANKBICS1] [varchar](25) NULL,
	[BANKBICS2] [varchar](25) NULL,
	[BANKBICS3] [varchar](25) NULL,
	[BANKBICS4] [varchar](25) NULL,
	[BANKBICS5] [varchar](25) NULL,
	[BANKBICS6] [varchar](25) NULL,
	[BANKBICS7] [varchar](25) NULL,
	[CASHREF] [int] NULL,
	[USEDINPERIODS] [smallint] NULL,
	[INCHARGE2] [varchar](41) NULL,
	[INCHARGE3] [varchar](41) NULL,
	[EMAILADDR2] [varchar](251) NULL,
	[EMAILADDR3] [varchar](251) NULL,
	[RSKLIMCR] [smallint] NULL,
	[RSKDUEDATECR] [smallint] NULL,
	[RSKAGINGCR] [smallint] NULL,
	[RSKAGINGDAY] [smallint] NULL,
	[ACCEPTEINV] [smallint] NULL,
	[EINVOICEID] [varchar](41) NULL,
	[PROFILEID] [smallint] NULL,
	[BANKBCURRENCY1] [varchar](4) NULL,
	[BANKBCURRENCY2] [varchar](4) NULL,
	[BANKBCURRENCY3] [varchar](4) NULL,
	[BANKBCURRENCY4] [varchar](4) NULL,
	[BANKBCURRENCY5] [varchar](4) NULL,
	[BANKBCURRENCY6] [varchar](4) NULL,
	[BANKBCURRENCY7] [varchar](4) NULL,
	[PURCORDERSTATUS] [smallint] NULL,
	[PURCORDERPRICE] [smallint] NULL,
	[ISFOREIGN] [smallint] NULL,
	[SHIPBEGTIME1] [int] NULL,
	[SHIPBEGTIME2] [int] NULL,
	[SHIPBEGTIME3] [int] NULL,
	[SHIPENDTIME1] [int] NULL,
	[SHIPENDTIME2] [int] NULL,
	[SHIPENDTIME3] [int] NULL,
	[DBSLIMIT1] [float] NULL,
	[DBSLIMIT2] [float] NULL,
	[DBSLIMIT3] [float] NULL,
	[DBSLIMIT4] [float] NULL,
	[DBSLIMIT5] [float] NULL,
	[DBSLIMIT6] [float] NULL,
	[DBSLIMIT7] [float] NULL,
	[DBSTOTAL1] [float] NULL,
	[DBSTOTAL2] [float] NULL,
	[DBSTOTAL3] [float] NULL,
	[DBSTOTAL4] [float] NULL,
	[DBSTOTAL5] [float] NULL,
	[DBSTOTAL6] [float] NULL,
	[DBSTOTAL7] [float] NULL,
	[DBSBANKNO1] [smallint] NULL,
	[DBSBANKNO2] [smallint] NULL,
	[DBSBANKNO3] [smallint] NULL,
	[DBSBANKNO4] [smallint] NULL,
	[DBSBANKNO5] [smallint] NULL,
	[DBSBANKNO6] [smallint] NULL,
	[DBSBANKNO7] [smallint] NULL,
	[DBSRISKCNTRL1] [smallint] NULL,
	[DBSRISKCNTRL2] [smallint] NULL,
	[DBSRISKCNTRL3] [smallint] NULL,
	[DBSRISKCNTRL4] [smallint] NULL,
	[DBSRISKCNTRL5] [smallint] NULL,
	[DBSRISKCNTRL6] [smallint] NULL,
	[DBSRISKCNTRL7] [smallint] NULL,
	[DBSBANKCURRENCY1] [smallint] NULL,
	[DBSBANKCURRENCY2] [smallint] NULL,
	[DBSBANKCURRENCY3] [smallint] NULL,
	[DBSBANKCURRENCY4] [smallint] NULL,
	[DBSBANKCURRENCY5] [smallint] NULL,
	[DBSBANKCURRENCY6] [smallint] NULL,
	[DBSBANKCURRENCY7] [smallint] NULL,
	[BANKCORRPACC1] [varchar](51) NULL,
	[BANKCORRPACC2] [varchar](51) NULL,
	[BANKCORRPACC3] [varchar](51) NULL,
	[BANKCORRPACC4] [varchar](51) NULL,
	[BANKCORRPACC5] [varchar](51) NULL,
	[BANKCORRPACC6] [varchar](51) NULL,
	[BANKCORRPACC7] [varchar](51) NULL,
	[BANKVOEN1] [varchar](51) NULL,
	[BANKVOEN2] [varchar](51) NULL,
	[BANKVOEN3] [varchar](51) NULL,
	[BANKVOEN4] [varchar](51) NULL,
	[BANKVOEN5] [varchar](51) NULL,
	[BANKVOEN6] [varchar](51) NULL,
	[BANKVOEN7] [varchar](51) NULL,
	[EINVOICETYPE] [smallint] NULL,
	[DEFINITION2] [varchar](201) NULL,
	[TELEXTNUMS1] [varchar](9) NULL,
	[TELEXTNUMS2] [varchar](9) NULL,
	[FAXEXTNUM] [varchar](9) NULL,
	[FACEBOOKURL] [varchar](121) NULL,
	[TWITTERURL] [varchar](121) NULL,
	[APPLEID] [varchar](121) NULL,
	[SKYPEID] [varchar](121) NULL,
	[GLOBALID] [varchar](51) NULL,
	[GUID] [varchar](37) NULL,
	[DUEDATECOUNT] [smallint] NULL,
	[DUEDATELIMIT] [float] NULL,
	[DUEDATETRACK] [smallint] NULL,
	[DUEDATECONTROL1] [smallint] NULL,
	[DUEDATECONTROL2] [smallint] NULL,
	[DUEDATECONTROL3] [smallint] NULL,
	[DUEDATECONTROL4] [smallint] NULL,
	[DUEDATECONTROL5] [smallint] NULL,
	[DUEDATECONTROL6] [smallint] NULL,
	[DUEDATECONTROL7] [smallint] NULL,
	[DUEDATECONTROL8] [smallint] NULL,
	[DUEDATECONTROL9] [smallint] NULL,
	[DUEDATECONTROL10] [smallint] NULL,
	[DUEDATECONTROL11] [smallint] NULL,
	[DUEDATECONTROL12] [smallint] NULL,
	[DUEDATECONTROL13] [smallint] NULL,
	[DUEDATECONTROL14] [smallint] NULL,
	[DUEDATECONTROL15] [smallint] NULL,
	[ADRESSNO] [varchar](11) NULL,
	[POSTLABELCODE] [varchar](101) NULL,
	[SENDERLABELCODE] [varchar](101) NULL,
	[CLOSEDATECOUNT] [smallint] NULL,
	[CLOSEDATETRACK] [smallint] NULL,
	[DEGACTIVE] [smallint] NULL,
	[DEGCURR] [smallint] NULL,
	[NAME] [varchar](51) NULL,
	[SURNAME] [varchar](51) NULL,
	[LABELINFO] [smallint] NULL,
	[DEFBNACCREF] [int] NULL,
	[PROJECTREF] [int] NULL,
	[DISCTYPE] [smallint] NULL,
	[SENDMOD] [smallint] NULL,
	[ISPERCURR] [smallint] NULL,
	[CURRATETYPE] [smallint] NULL,
	[INSTEADOFDESP] [smallint] NULL,
	[EINVOICETYP] [smallint] NULL,
	[FBSSENDMETHOD] [smallint] NULL,
	[FBSSENDEMAILADDR] [varchar](251) NULL,
	[FBSSENDFORMAT] [smallint] NULL,
	[FBSSENDFAXNR] [varchar](16) NULL,
	[FBASENDMETHOD] [smallint] NULL,
	[FBASENDEMAILADDR] [varchar](251) NULL,
	[FBASENDFORMAT] [smallint] NULL,
	[FBASENDFAXNR] [varchar](16) NULL,
	[SECTORMAINREF] [int] NULL,
	[SECTORSUBREF] [int] NULL,
	[PERSONELCOSTS] [smallint] NULL,
	[POSTLABELCODEDESP] [varchar](101) NULL,
	[SENDERLABELCODEDESP] [varchar](101) NULL,
	[ACCEPTEINVPUBLIC] [smallint] NULL,
	[LABELINFODESP] [smallint] NULL,
	[ORDPRIORITY] [smallint] NULL,
	[ACCEPTEDESP] [smallint] NULL,
	[PROFILEIDDESP] [smallint] NULL,
	[PUBLICBNACCREF] [int] NULL,
	[KVKKCANCELDATE] [datetime] NULL,
	[KVKKANONYSTATUS] [smallint] NULL,
	[KVKKANONYDATE] [datetime] NULL,
	[KVKKENDDATE] [datetime] NULL,
	[PAYMENTPROCBRANCH] [smallint] NULL,
	[KVKKPERMSTATUS] [smallint] NULL,
	[KVKKBEGDATE] [datetime] NULL,
	[SUBCONT] [smallint] NULL,
	[FACTORYNR] [smallint] NULL,
	[ININVENNR] [smallint] NULL,
	[OUTINVENNR] [smallint] NULL,
	[FACTORYDIVNR] [smallint] NULL,
	[EARCEMAILADDR1] [varchar](251) NULL,
	[EARCEMAILADDR2] [varchar](251) NULL,
	[EARCEMAILADDR3] [varchar](251) NULL,
	[QTYDEPDURATION] [float] NULL,
	[BROKERCOMP] [smallint] NULL,
	[CREATEWHFICHE] [smallint] NULL,
	[EINVCUSTOM] [smallint] NULL,
	[OVERLAPPERC] [float] NULL,
	[QTYINDEPDURATION] [float] NULL,
	[OVERLAPTYPE] [smallint] NULL,
	[OVERLAPAMNT] [float] NULL,
	[EXIMSENDFAXNR] [varchar](16) NULL,
	[CLCCANDEDUCT] [smallint] NULL,
	[DRIVERREF] [int] NULL,
	[EXIMSENDMETHOD] [smallint] NULL,
	[EXIMSENDEMAILADDR] [varchar](251) NULL,
	[EXIMSENDFORMAT] [smallint] NULL,
	[INCHTELEXTNUMS1] [varchar](9) NULL,
	[INCHTELNRS3] [varchar](51) NULL,
	[INCHTELEXTNUMS2] [varchar](9) NULL,
	[NOTIFYCRDREF] [int] NULL,
	[INCHTELEXTNUMS3] [varchar](9) NULL,
	[INCHTELCODES2] [varchar](9) NULL,
	[INCHTELCODES1] [varchar](9) NULL,
	[INCHTELCODES3] [varchar](9) NULL,
	[INCHTELNRS2] [varchar](51) NULL,
	[INCHTELNRS1] [varchar](51) NULL,
	[EXIMCNSLTCLREF] [int] NULL,
	[EXIMNTFYCLREF] [int] NULL,
	[EXIMREGTYPREF] [int] NULL,
	[ORDPRINTCNT] [smallint] NULL,
	[DISPPRINTCNT] [smallint] NULL,
	[EXIMFRGHTCLREF] [int] NULL,
	[EXIMCUSTOMREF] [int] NULL,
	[IMCNTRYTYP] [smallint] NULL,
	[EXCNTRYREF] [int] NULL,
	[EXCNTRYTYP] [smallint] NULL,
	[EXIMBRBANKREF] [int] NULL,
	[EXIMPAYTYPREF] [int] NULL,
	[IMCNTRYREF] [int] NULL,
	[CLSTYPEFORPPAYDT] [smallint] NULL,
	[CLPTYPEFORPPAYDT] [smallint] NULL,
	[COMMRECORDNO] [varchar](33) NULL,
	[MERSISNO] [varchar](17) NULL,
	[WHATSAPPID] [varchar](121) NULL,
	[LINKEDINURL] [varchar](121) NULL,
	[INSTAGRAMURL] [varchar](121) NULL,
 CONSTRAINT [I011_CLCARD_I1] PRIMARY KEY CLUSTERED 
(
	[LOGICALREF] ASC
)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO


