USE [LOGO_BAKI2018]
GO

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

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[LG_011_08_INVOICE](
	[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
	[GRPCODE] [smallint] NULL,
	[TRCODE] [smallint] NULL,
	[FICHENO] [varchar](17) NULL,
	[DATE_] [datetime] NULL,
	[TIME_] [int] NULL,
	[DOCODE] [varchar](33) NULL,
	[SPECODE] [varchar](11) NULL,
	[CYPHCODE] [varchar](11) NULL,
	[CLIENTREF] [int] NULL,
	[RECVREF] [int] NULL,
	[CENTERREF] [int] NULL,
	[ACCOUNTREF] [int] NULL,
	[SOURCEINDEX] [smallint] NULL,
	[SOURCECOSTGRP] [smallint] NULL,
	[CANCELLED] [smallint] NULL,
	[ACCOUNTED] [smallint] NULL,
	[PAIDINCASH] [smallint] NULL,
	[FROMKASA] [smallint] NULL,
	[ENTEGSET] [smallint] NULL,
	[VAT] [float] NULL,
	[ADDDISCOUNTS] [float] NULL,
	[TOTALDISCOUNTS] [float] NULL,
	[TOTALDISCOUNTED] [float] NULL,
	[ADDEXPENSES] [float] NULL,
	[TOTALEXPENSES] [float] NULL,
	[DISTEXPENSE] [float] NULL,
	[TOTALDEPOZITO] [float] NULL,
	[TOTALPROMOTIONS] [float] NULL,
	[VATINCGROSS] [float] NULL,
	[TOTALVAT] [float] NULL,
	[GROSSTOTAL] [float] NULL,
	[NETTOTAL] [float] 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,
	[INTERESTAPP] [float] NULL,
	[TRCURR] [smallint] NULL,
	[TRRATE] [float] NULL,
	[TRNET] [float] NULL,
	[REPORTRATE] [float] NULL,
	[REPORTNET] [float] NULL,
	[ONLYONEPAYLINE] [smallint] NULL,
	[KASTRANSREF] [int] NULL,
	[PAYDEFREF] [int] NULL,
	[PRINTCNT] [smallint] NULL,
	[GVATINC] [smallint] NULL,
	[BRANCH] [smallint] NULL,
	[DEPARTMENT] [smallint] NULL,
	[ACCFICHEREF] [int] NULL,
	[ADDEXPACCREF] [int] NULL,
	[ADDEXPCENTREF] [int] NULL,
	[DECPRDIFF] [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,
	[SALESMANREF] [int] NULL,
	[CANCELLEDACC] [smallint] NULL,
	[SHPTYPCOD] [varchar](13) NULL,
	[SHPAGNCOD] [varchar](13) NULL,
	[TRACKNR] [varchar](65) NULL,
	[GENEXCTYP] [smallint] NULL,
	[LINEEXCTYP] [smallint] NULL,
	[TRADINGGRP] [varchar](17) NULL,
	[TEXTINC] [smallint] NULL,
	[SITEID] [smallint] NULL,
	[RECSTATUS] [smallint] NULL,
	[ORGLOGICREF] [int] NULL,
	[FACTORYNR] [smallint] NULL,
	[WFSTATUS] [int] NULL,
	[SHIPINFOREF] [int] NULL,
	[DISTORDERREF] [int] NULL,
	[SENDCNT] [smallint] NULL,
	[DLVCLIENT] [smallint] NULL,
	[COSTOFSALEFCREF] [int] NULL,
	[OPSTAT] [smallint] NULL,
	[DOCTRACKINGNR] [varchar](21) NULL,
	[TOTALADDTAX] [float] NULL,
	[PAYMENTTYPE] [smallint] NULL,
	[INFIDX] [float] NULL,
	[ACCOUNTEDCNT] [smallint] NULL,
	[ORGLOGOID] [varchar](25) NULL,
	[FROMEXIM] [smallint] NULL,
	[FRGTYPCOD] [varchar](13) NULL,
	[EXIMFCTYPE] [smallint] NULL,
	[FROMORDWITHPAY] [smallint] NULL,
	[PROJECTREF] [int] NULL,
	[WFLOWCRDREF] [int] NULL,
	[STATUS] [smallint] NULL,
	[DEDUCTIONPART1] [smallint] NULL,
	[DEDUCTIONPART2] [smallint] NULL,
	[TOTALEXADDTAX] [float] NULL,
	[EXACCOUNTED] [smallint] NULL,
	[FROMBANK] [smallint] NULL,
	[BNTRANSREF] [int] NULL,
	[AFFECTCOLLATRL] [smallint] NULL,
	[GRPFIRMTRANS] [smallint] NULL,
	[AFFECTRISK] [smallint] NULL,
	[CONTROLINFO] [smallint] NULL,
	[POSTRANSFERINFO] [smallint] NULL,
	[TAXFREECHX] [smallint] NULL,
	[PASSPORTNO] [varchar](51) NULL,
	[CREDITCARDNO] [varchar](17) NULL,
	[INEFFECTIVECOST] [smallint] NULL,
	[REFLECTED] [smallint] NULL,
	[REFLACCFICHEREF] [int] NULL,
	[CANCELLEDREFLACC] [smallint] NULL,
	[CREDITCARDNUM] [varchar](17) NULL,
	[APPROVE] [smallint] NULL,
	[APPROVEDATE] [datetime] NULL,
	[CANTCREDEDUCT] [smallint] NULL,
	[ENTRUST] [smallint] NULL,
	[DOCDATE] [datetime] NULL,
	[EINVOICE] [smallint] NULL,
	[PROFILEID] [smallint] NULL,
	[GUID] [varchar](37) NULL,
	[ESTATUS] [smallint] NULL,
	[ESTARTDATE] [datetime] NULL,
	[EENDDATE] [datetime] NULL,
	[EDESCRIPTION] [varchar](51) NULL,
	[EDURATION] [float] NULL,
	[EDURATIONTYPE] [smallint] NULL,
	[DEVIR] [smallint] NULL,
	[DISTADJPRICEUFRS] [float] NULL,
	[COSFCREFUFRS] [int] NULL,
	[GLOBALID] [varchar](51) NULL,
	[TOTALSERVICES] [float] NULL,
	[FROMLEASING] [smallint] NULL,
	[CANCELEXP] [varchar](251) NULL,
	[UNDOEXP] [varchar](251) NULL,
	[VATEXCEPTREASON] [varchar](201) NULL,
	[CAMPAIGNCODE] [varchar](25) NULL,
	[CANCELDESPSINV] [smallint] NULL,
	[FROMEXCHDIFF] [smallint] NULL,
	[EXIMVAT] [smallint] NULL,
	[SERIALCODE] [varchar](17) NULL,
	[APPCLDEDUCTLIM] [smallint] NULL,
	[EINVOICETYP] [smallint] NULL,
	[VATEXCEPTCODE] [varchar](11) NULL,
	[OFFERREF] [int] NULL,
	[ATAXEXCEPTREASON] [varchar](201) NULL,
	[ATAXEXCEPTCODE] [varchar](11) NULL,
	[FROMSTAFFOTHEREX] [smallint] NULL,
	[NOCALCULATE] [smallint] NULL,
	[INSTEADOFDESP] [smallint] NULL,
	[OKCFICHE] [smallint] NULL,
	[CANCELDATE] [datetime] NULL,
	[FRGTYPDESC] [varchar](251) NULL,
	[MARKREF] [int] NULL,
	[PRINTDATE] [datetime] NULL,
	[DELIVERCODE] [varchar](11) NULL,
	[ACCEPTEINVPUBLIC] [smallint] NULL,
	[PUBLICBNACCREF] [int] NULL,
	[TYPECODE] [varchar](5) NULL,
	[FUTMNTHYREXPINC] [smallint] NULL,
	[DOCDETAIL] [smallint] NULL,
	[CALCADDTAXVATSEP] [smallint] NULL,
	[ESENDDATE] [datetime] NULL,
	[ELECTDOC] [smallint] NULL,
	[NOTIFYCRDREF] [int] NULL,
	[GIBACCFICHEREF] [int] NULL,
	[FROMINTEGTYPE] [smallint] NULL,
	[EPRINTCNT] [smallint] NULL,
	[CLNOTREFLAACCREF] [int] NULL,
	[CLNOTREFLACNTRREF] [int] NULL,
	[RIGHTOFRETURNTYP] [varchar](4) NULL,
	[ORDFICHECMREF] [int] NULL,
	[RECHASH] [varchar](100) NULL,
	[RECEIPT] [smallint] NULL,
	[ESENDTIME] [int] NULL,
	[COSFCREFINFL] [int] NULL,
 CONSTRAINT [I011_08_INVOICE_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