USE [LOGO_BAKI2018]
GO

/****** Object:  Table [dbo].[LG_011_08_CLFLINE]    Script Date: 17.01.2026 01:07:40 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[LG_011_08_CLFLINE](
	[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
	[CLIENTREF] [int] NULL,
	[CLACCREF] [int] NULL,
	[CLCENTERREF] [int] NULL,
	[CASHCENTERREF] [int] NULL,
	[CASHACCOUNTREF] [int] NULL,
	[VIRMANREF] [int] NULL,
	[SOURCEFREF] [int] NULL,
	[DATE_] [datetime] NULL,
	[DEPARTMENT] [smallint] NULL,
	[BRANCH] [smallint] NULL,
	[MODULENR] [smallint] NULL,
	[TRCODE] [smallint] NULL,
	[LINENR] [smallint] NULL,
	[SPECODE] [varchar](11) NULL,
	[CYPHCODE] [varchar](11) NULL,
	[TRANNO] [varchar](17) NULL,
	[DOCODE] [varchar](33) NULL,
	[LINEEXP] [varchar](251) NULL,
	[ACCOUNTED] [smallint] NULL,
	[SIGN] [smallint] NULL,
	[AMOUNT] [float] NULL,
	[TRCURR] [smallint] NULL,
	[TRRATE] [float] NULL,
	[TRNET] [float] NULL,
	[REPORTRATE] [float] NULL,
	[REPORTNET] [float] NULL,
	[EXTENREF] [int] NULL,
	[PAYDEFREF] [int] NULL,
	[ACCFICHEREF] [int] NULL,
	[PRINTCNT] [smallint] 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,
	[CANCELLED] [smallint] NULL,
	[TRGFLAG] [smallint] NULL,
	[TRADINGGRP] [varchar](17) NULL,
	[LINEEXCTYP] [smallint] NULL,
	[ONLYONEPAYLINE] [smallint] NULL,
	[DISCFLAG] [smallint] NULL,
	[DISCRATE] [float] NULL,
	[VATRATE] [float] NULL,
	[CASHAMOUNT] [float] NULL,
	[DISCACCREF] [int] NULL,
	[DISCCENREF] [int] NULL,
	[VATRACCREF] [int] NULL,
	[VATRCENREF] [int] NULL,
	[PAYMENTREF] [int] NULL,
	[VATAMOUNT] [float] NULL,
	[SITEID] [smallint] NULL,
	[RECSTATUS] [smallint] NULL,
	[ORGLOGICREF] [int] NULL,
	[INFIDX] [float] NULL,
	[POSCOMMACCREF] [int] NULL,
	[POSCOMMCENREF] [int] NULL,
	[POINTCOMMACCREF] [int] NULL,
	[POINTCOMMCENREF] [int] NULL,
	[CHEQINFO] [varchar](121) NULL,
	[CREDITCNO] [varchar](25) NULL,
	[CLPRJREF] [int] NULL,
	[STATUS] [smallint] NULL,
	[EXIMFILEREF] [int] NULL,
	[EXIMPROCNR] [smallint] NULL,
	[MONTH_] [smallint] NULL,
	[YEAR_] [smallint] NULL,
	[FUNDSHARERAT] [float] NULL,
	[AFFECTCOLLATRL] [smallint] NULL,
	[GRPFIRMTRANS] [smallint] NULL,
	[REFLVATACCREF] [int] NULL,
	[REFLVATOTHACCREF] [int] NULL,
	[AFFECTRISK] [smallint] NULL,
	[BATCHNR] [int] NULL,
	[APPROVENR] [int] NULL,
	[BATCHNUM] [varchar](17) NULL,
	[APPROVENUM] [varchar](17) NULL,
	[EUVATSTATUS] [int] NULL,
	[ORGLOGOID] [varchar](25) NULL,
	[EXIMTYPE] [smallint] NULL,
	[EIDISTFLNNR] [smallint] NULL,
	[EISRVDSTTYP] [smallint] NULL,
	[EXIMDISTTYP] [smallint] NULL,
	[SALESMANREF] [int] NULL,
	[BANKACCREF] [int] NULL,
	[BNACCREF] [int] NULL,
	[BNCENTERREF] [int] NULL,
	[DEVIRPROCDATE] [datetime] NULL,
	[DOCDATE] [datetime] NULL,
	[INSTALREF] [int] NULL,
	[DEVIR] [smallint] NULL,
	[DEVIRMODULENR] [int] NULL,
	[FTIME] [int] NULL,
	[OFFERREF] [int] NULL,
	[RETCCFCREF] [int] NULL,
	[EMFLINEREF] [int] NULL,
	[FROMEXCHDIFF] [smallint] NULL,
	[CANDEDUCT] [smallint] NULL,
	[DEDUCTIONPART1] [smallint] NULL,
	[DEDUCTIONPART2] [smallint] NULL,
	[UNDERDEDUCTLIMIT] [smallint] NULL,
	[VATDEDUCTRATE] [float] NULL,
	[VATDEDUCTACCREF] [int] NULL,
	[VATDEDUCTOTHACCREF] [int] NULL,
	[VATDEDUCTCENREF] [int] NULL,
	[VATDEDUCTOTHCENREF] [int] NULL,
	[CANTCREDEDUCT] [smallint] NULL,
	[GUID] [varchar](37) NULL,
	[PAIDINCASH] [smallint] NULL,
	[BRUTAMOUNT] [float] NULL,
	[NETAMOUNT] [float] NULL,
	[BRUTAMOUNTTR] [float] NULL,
	[NETAMOUNTTR] [float] NULL,
	[BRUTAMOUNTREP] [float] NULL,
	[NETAMOUNTREP] [float] NULL,
	[BNLNTRCURR] [smallint] NULL,
	[BNLNTRRATE] [float] NULL,
	[BNLNTRNET] [float] NULL,
	[PRINTDATE] [datetime] NULL,
	[INCDEDUCTAMNT] [smallint] NULL,
	[AFFECTCOST] [smallint] NULL,
	[FOREXIM] [smallint] NULL,
	[EXIMFILECODECLF] [varchar](25) NULL,
	[SPECODE2] [varchar](41) NULL,
	[SERVREASONDEF] [varchar](251) NULL,
 CONSTRAINT [I011_08_CLFLINE_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