USE [LOGO_BAKI2018]
GO

/****** Object:  Table [dbo].[LG_011_08_STFICHE]    Script Date: 17.01.2026 01:10:39 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[LG_011_08_STFICHE](
	[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
	[GRPCODE] [smallint] NULL,
	[TRCODE] [smallint] NULL,
	[IOCODE] [smallint] NULL,
	[FICHENO] [varchar](17) NULL,
	[DATE_] [datetime] NULL,
	[FTIME] [int] NULL,
	[DOCODE] [varchar](33) NULL,
	[INVNO] [varchar](17) NULL,
	[SPECODE] [varchar](11) NULL,
	[CYPHCODE] [varchar](11) NULL,
	[INVOICEREF] [int] NULL,
	[CLIENTREF] [int] NULL,
	[RECVREF] [int] NULL,
	[ACCOUNTREF] [int] NULL,
	[CENTERREF] [int] NULL,
	[PRODORDERREF] [int] NULL,
	[PORDERFICHENO] [varchar](17) NULL,
	[SOURCETYPE] [smallint] NULL,
	[SOURCEINDEX] [smallint] NULL,
	[SOURCEWSREF] [int] NULL,
	[SOURCEPOLNREF] [int] NULL,
	[SOURCECOSTGRP] [smallint] NULL,
	[DESTTYPE] [smallint] NULL,
	[DESTINDEX] [smallint] NULL,
	[DESTWSREF] [int] NULL,
	[DESTPOLNREF] [int] NULL,
	[DESTCOSTGRP] [smallint] NULL,
	[FACTORYNR] [smallint] NULL,
	[BRANCH] [smallint] NULL,
	[DEPARTMENT] [smallint] NULL,
	[COMPBRANCH] [smallint] NULL,
	[COMPDEPARTMENT] [smallint] NULL,
	[COMPFACTORY] [smallint] NULL,
	[PRODSTAT] [smallint] NULL,
	[DEVIR] [smallint] NULL,
	[CANCELLED] [smallint] NULL,
	[BILLED] [smallint] NULL,
	[ACCOUNTED] [smallint] NULL,
	[UPDCURR] [smallint] NULL,
	[INUSE] [smallint] NULL,
	[INVKIND] [smallint] NULL,
	[ADDDISCOUNTS] [float] NULL,
	[TOTALDISCOUNTS] [float] NULL,
	[TOTALDISCOUNTED] [float] NULL,
	[ADDEXPENSES] [float] NULL,
	[TOTALEXPENSES] [float] NULL,
	[TOTALDEPOZITO] [float] NULL,
	[TOTALPROMOTIONS] [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,
	[REPORTRATE] [float] NULL,
	[REPORTNET] [float] NULL,
	[EXTENREF] [int] NULL,
	[PAYDEFREF] [int] NULL,
	[PRINTCNT] [smallint] NULL,
	[FICHECNT] [smallint] NULL,
	[ACCFICHEREF] [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,
	[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,
	[WFSTATUS] [int] NULL,
	[SHIPINFOREF] [int] NULL,
	[DISTORDERREF] [int] NULL,
	[SENDCNT] [smallint] NULL,
	[DLVCLIENT] [smallint] NULL,
	[DOCTRACKINGNR] [varchar](21) NULL,
	[ADDTAXCALC] [smallint] NULL,
	[TOTALADDTAX] [float] NULL,
	[UGIRTRACKINGNO] [varchar](17) NULL,
	[QPRODFCREF] [int] NULL,
	[VAACCREF] [int] NULL,
	[VACENTERREF] [int] NULL,
	[ORGLOGOID] [varchar](25) NULL,
	[FROMEXIM] [smallint] NULL,
	[FRGTYPCOD] [varchar](13) NULL,
	[TRCURR] [smallint] NULL,
	[TRRATE] [float] NULL,
	[TRNET] [float] NULL,
	[EXIMWHFCREF] [int] NULL,
	[EXIMFCTYPE] [smallint] NULL,
	[MAINSTFCREF] [int] NULL,
	[FROMORDWITHPAY] [smallint] NULL,
	[PROJECTREF] [int] NULL,
	[WFLOWCRDREF] [int] NULL,
	[STATUS] [smallint] NULL,
	[UPDTRCURR] [smallint] NULL,
	[TOTALEXADDTAX] [float] NULL,
	[AFFECTCOLLATRL] [smallint] NULL,
	[DEDUCTIONPART1] [smallint] NULL,
	[DEDUCTIONPART2] [smallint] NULL,
	[GRPFIRMTRANS] [smallint] NULL,
	[AFFECTRISK] [smallint] NULL,
	[DISPSTATUS] [smallint] NULL,
	[APPROVE] [smallint] NULL,
	[APPROVEDATE] [datetime] NULL,
	[CANTCREDEDUCT] [smallint] NULL,
	[SHIPDATE] [datetime] NULL,
	[SHIPTIME] [int] NULL,
	[ENTRUSTDEVIR] [smallint] NULL,
	[RELTRANSFCREF] [int] NULL,
	[FROMTRANSFER] [smallint] NULL,
	[GUID] [varchar](37) NULL,
	[GLOBALID] [varchar](51) NULL,
	[COMPSTFCREF] [int] NULL,
	[COMPINVREF] [int] NULL,
	[TOTALSERVICES] [float] NULL,
	[CAMPAIGNCODE] [varchar](25) NULL,
	[OFFERREF] [int] NULL,
	[EINVOICETYP] [smallint] NULL,
	[EINVOICE] [smallint] NULL,
	[NOCALCULATE] [smallint] NULL,
	[PRODORDERTYP] [smallint] NULL,
	[QPRODFCTYP] [smallint] NULL,
	[PRINTDATE] [datetime] NULL,
	[PRDORDSLPLNRESERVE] [smallint] NULL,
	[CONTROLINFO] [smallint] NULL,
	[EDESPATCH] [smallint] NULL,
	[DOCDATE] [datetime] NULL,
	[DOCTIME] [int] NULL,
	[EDESPSTATUS] [smallint] NULL,
	[PROFILEID] [smallint] NULL,
	[DELIVERYCODE] [varchar](11) NULL,
	[DESTSTATUS] [smallint] NULL,
	[CANCELEXP] [varchar](251) NULL,
	[UNDOEXP] [varchar](251) NULL,
	[CANCELDATE] [datetime] NULL,
	[CREATEWHERE] [smallint] NULL,
	[PUBLICBNACCREF] [int] NULL,
	[ACCEPTEINVPUBLIC] [smallint] NULL,
	[VATEXCEPTCODE] [varchar](11) NULL,
	[VATEXCEPTREASON] [varchar](201) NULL,
	[ATAXEXCEPTCODE] [varchar](11) NULL,
	[ATAXEXCEPTREASON] [varchar](201) NULL,
	[TAXFREECHX] [smallint] NULL,
	[MNTORDERFREF] [int] NULL,
	[PRINTEDDESPFCNO] [varchar](17) NULL,
	[OKCFICHE] [smallint] NULL,
	[ESENDDATE] [datetime] NULL,
	[NOTIFYCRDREF] [int] NULL,
	[CANCELLEDINVREF1] [int] NULL,
	[CANCELLEDINVREF2] [int] NULL,
	[CANCELLEDINVREF3] [int] NULL,
	[CANCELLEDINVREF4] [int] NULL,
	[FROMINTEGTYPE] [smallint] NULL,
	[FROMINTEGREF] [int] NULL,
	[EPRINTCNT] [smallint] NULL,
	[CLNOTREFLAACCREF] [int] NULL,
	[CLNOTREFLACNTRREF] [int] NULL,
	[PAYERCRPROVIDER] [varchar](101) NULL,
	[PAYERCRKEY] [varchar](21) NULL,
	[FORENTRUST] [smallint] NULL,
	[ORDFICHECMREF] [int] NULL,
	[RECHASH] [varchar](100) NULL,
	[ESENDTIME] [int] NULL,
 CONSTRAINT [I011_08_STFICHE_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