USE [LOGO_BAKI2018]
GO

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

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[LG_011_08_CLFICHE](
	[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
	[FICHENO] [varchar](17) NULL,
	[DATE_] [datetime] NULL,
	[DOCODE] [varchar](33) NULL,
	[TRCODE] [smallint] NULL,
	[SPECCODE] [varchar](11) NULL,
	[CYPHCODE] [varchar](11) NULL,
	[BRANCH] [smallint] NULL,
	[DEPARTMENT] [smallint] NULL,
	[GENEXP1] [varchar](51) NULL,
	[GENEXP2] [varchar](51) NULL,
	[GENEXP3] [varchar](51) NULL,
	[GENEXP4] [varchar](51) NULL,
	[GENEXP5] [varchar](51) NULL,
	[GENEXP6] [varchar](51) NULL,
	[DEBIT] [float] NULL,
	[CREDIT] [float] NULL,
	[REPDEBIT] [float] NULL,
	[REPCREDIT] [float] 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,
	[ACCOUNTED] [smallint] NULL,
	[INVOREF] [int] NULL,
	[CASHACCREF] [int] NULL,
	[CASHCENREF] [int] NULL,
	[PRINTCNT] [smallint] NULL,
	[CANCELLED] [smallint] NULL,
	[CANCELLEDACC] [smallint] NULL,
	[ACCFICHEREF] [int] NULL,
	[GENEXCTYP] [smallint] NULL,
	[LINEEXCTYP] [smallint] NULL,
	[TEXTINC] [smallint] NULL,
	[SITEID] [smallint] NULL,
	[RECSTATUS] [smallint] NULL,
	[ORGLOGICREF] [int] NULL,
	[WFSTATUS] [int] NULL,
	[TIME] [int] NULL,
	[CLCARDREF] [int] NULL,
	[BANKACCREF] [int] NULL,
	[BNACCREF] [int] NULL,
	[BNCENTERREF] [int] NULL,
	[TRADINGGRP] [varchar](17) NULL,
	[POSCOMMACCREF] [int] NULL,
	[POSCOMMCENREF] [int] NULL,
	[POINTCOMMACCREF] [int] NULL,
	[POINTCOMMCENREF] [int] NULL,
	[PROJECTREF] [int] NULL,
	[STATUS] [smallint] NULL,
	[WFLOWCRDREF] [int] NULL,
	[ORGLOGOID] [varchar](25) NULL,
	[AFFECTCOLLATRL] [smallint] NULL,
	[GRPFIRMTRANS] [smallint] NULL,
	[AFFECTRISK] [smallint] NULL,
	[POSTERMINALNR] [int] NULL,
	[POSTERMINALNUM] [varchar](31) NULL,
	[APPROVE] [smallint] NULL,
	[APPROVEDATE] [datetime] NULL,
	[SALESMANREF] [int] NULL,
	[CSTRANSREF] [int] NULL,
	[DOCDATE] [datetime] NULL,
	[GUID] [varchar](37) NULL,
	[DEVIR] [smallint] NULL,
	[PRINTDATE] [datetime] NULL,
	[FOREXIM] [smallint] NULL,
	[TYPECODE] [varchar](5) NULL,
	[EINVOICE] [smallint] NULL,
	[HOUR_] [smallint] NULL,
	[MINUTE_] [smallint] NULL,
	[DEDUCTCODE] [varchar](11) NULL,
	[ELECTDOC] [smallint] NULL,
	[NOTIFYCRDREF] [int] NULL,
	[GIBACCFICHEREF] [int] NULL,
	[PARTIALCSPAYREF] [int] NULL,
	[GIBINCMTAXREF] [int] NULL,
	[EXIMVAT] [smallint] NULL,
	[RECHASH] [varchar](100) NULL,
 CONSTRAINT [I011_08_CLFICHE_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