USE [LOGO_BAKI2018]
GO

/****** Object:  Table [dbo].[LG_011_08_ORFICHE]    Script Date: 17.01.2026 01:09:29 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[LG_011_08_ORFICHE](
	[LOGICALREF] [int] IDENTITY(1,1) NOT 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,
	[ACCOUNTREF] [int] NULL,
	[CENTERREF] [int] NULL,
	[SOURCEINDEX] [smallint] NULL,
	[SOURCECOSTGRP] [smallint] NULL,
	[UPDCURR] [smallint] NULL,
	[ADDDISCOUNTS] [float] NULL,
	[TOTALDISCOUNTS] [float] NULL,
	[TOTALDISCOUNTED] [float] NULL,
	[ADDEXPENSES] [float] NULL,
	[TOTALEXPENSES] [float] NULL,
	[TOTALPROMOTIONS] [float] NULL,
	[TOTALVAT] [float] NULL,
	[GROSSTOTAL] [float] NULL,
	[NETTOTAL] [float] NULL,
	[REPORTRATE] [float] NULL,
	[REPORTNET] [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,
	[EXTENREF] [int] NULL,
	[PAYDEFREF] [int] NULL,
	[PRINTCNT] [smallint] NULL,
	[BRANCH] [smallint] NULL,
	[DEPARTMENT] [smallint] NULL,
	[STATUS] [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,
	[SHPTYPCOD] [varchar](13) NULL,
	[SHPAGNCOD] [varchar](13) 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,
	[CUSTORDNO] [varchar](51) NULL,
	[SENDCNT] [smallint] NULL,
	[DLVCLIENT] [smallint] NULL,
	[DOCTRACKINGNR] [varchar](21) NULL,
	[CANCELLED] [smallint] NULL,
	[ORGLOGOID] [varchar](25) NULL,
	[OFFERREF] [int] NULL,
	[OFFALTREF] [int] NULL,
	[TYP] [smallint] NULL,
	[ALTNR] [smallint] NULL,
	[ADVANCEPAYM] [float] NULL,
	[TRCURR] [smallint] NULL,
	[TRRATE] [float] NULL,
	[TRNET] [float] NULL,
	[PAYMENTTYPE] [smallint] NULL,
	[ONLYONEPAYLINE] [smallint] NULL,
	[OPSTAT] [smallint] NULL,
	[WITHPAYTRANS] [smallint] NULL,
	[PROJECTREF] [int] NULL,
	[WFLOWCRDREF] [int] NULL,
	[UPDTRCURR] [smallint] NULL,
	[AFFECTCOLLATRL] [smallint] NULL,
	[POFFERBEGDT] [datetime] NULL,
	[POFFERENDDT] [datetime] NULL,
	[REVISNR] [varchar](17) NULL,
	[LASTREVISION] [smallint] NULL,
	[CHECKAMOUNT] [smallint] NULL,
	[SLSOPPRREF] [int] NULL,
	[SLSACTREF] [int] NULL,
	[SLSCUSTREF] [int] NULL,
	[AFFECTRISK] [smallint] NULL,
	[TOTALADDTAX] [float] NULL,
	[TOTALEXADDTAX] [float] NULL,
	[APPROVE] [smallint] NULL,
	[APPROVEDATE] [datetime] NULL,
	[CHECKPRICE] [smallint] NULL,
	[TRANSFERWITHPAY] [smallint] NULL,
	[FCSTATUSREF] [int] NULL,
	[CHECKTOTAL] [smallint] NULL,
	[GUID] [varchar](37) NULL,
	[CANTCREDEDUCT] [smallint] NULL,
	[DEDUCTIONPART1] [smallint] NULL,
	[DEDUCTIONPART2] [smallint] NULL,
	[GLOBALID] [varchar](51) NULL,
	[DEFAULTFICHE] [smallint] NULL,
	[LEASINGREF] [int] NULL,
	[CAMPAIGNCODE] [varchar](25) NULL,
	[ADDEXPENSESVAT] [float] NULL,
	[TOTALEXPENSESVAT] [float] NULL,
	[DEVIR] [smallint] NULL,
	[PRINTDATE] [datetime] NULL,
	[DELIVERYCODE] [varchar](11) NULL,
	[EINVOICETYP] [smallint] NULL,
	[EINVOICE] [smallint] NULL,
	[PUBLICBNACCREF] [int] NULL,
	[ACCEPTEINVPUBLIC] [smallint] NULL,
	[INSTEADOFDESP] [smallint] NULL,
	[VATEXCEPTCODE] [varchar](11) NULL,
	[VATEXCEPTREASON] [varchar](201) NULL,
	[ATAXEXCEPTCODE] [varchar](11) NULL,
	[ATAXEXCEPTREASON] [varchar](201) NULL,
	[TAXFREECHX] [smallint] NULL,
	[ORGDATE] [datetime] NULL,
	[ACTRENTING] [smallint] NULL,
	[ADDDISCOUNTSVAT] [float] NULL,
	[NOTIFYCRDREF] [int] NULL,
	[PAYERID] [varchar](37) NULL,
	[PAYERTYPE] [smallint] NULL,
	[COMMITMENT] [smallint] NULL,
	[CMBEGDATE] [datetime] NULL,
	[CMENDDATE] [datetime] NULL,
	[CMEXP] [varchar](251) NULL,
	[CMTYPE] [smallint] NULL,
	[CMAMOUNT] [float] NULL,
	[CMTOTAL] [float] NULL,
	[CMSHIPPEDAMOUNT] [float] NULL,
	[CMSHIPPEDTOTAL] [float] NULL,
	[CMPAYMENTTOTAL] [float] NULL,
	[CMPRICE] [float] NULL,
	[CMPAIDTOTAL] [float] NULL,
	[CMCANDEDUCT] [smallint] NULL,
	[CMDEDUCTPART1] [smallint] NULL,
	[CMDEDUCTPART2] [smallint] NULL,
	[CMVAT] [float] NULL,
	[CMDEVIRODEMEBAKIYE] [float] NULL,
	[RECHASH] [varchar](100) NULL,
	[CONTACTREF] [int] NULL,
	[PAYERMICRO] [smallint] NULL,
 CONSTRAINT [I011_08_ORFICHE_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