USE [LOGO_BAKI2018]
GO

/****** Object:  Table [dbo].[LG_011_08_STLINE]    Script Date: 17.01.2026 01:11:11 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[LG_011_08_STLINE](
	[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
	[STOCKREF] [int] NULL,
	[LINETYPE] [smallint] NULL,
	[PREVLINEREF] [int] NULL,
	[PREVLINENO] [smallint] NULL,
	[DETLINE] [smallint] NULL,
	[TRCODE] [smallint] NULL,
	[DATE_] [datetime] NULL,
	[FTIME] [int] NULL,
	[GLOBTRANS] [smallint] NULL,
	[CALCTYPE] [smallint] NULL,
	[PRODORDERREF] [int] NULL,
	[SOURCETYPE] [smallint] NULL,
	[SOURCEINDEX] [smallint] NULL,
	[SOURCECOSTGRP] [smallint] NULL,
	[SOURCEWSREF] [int] NULL,
	[SOURCEPOLNREF] [int] NULL,
	[DESTTYPE] [smallint] NULL,
	[DESTINDEX] [smallint] NULL,
	[DESTCOSTGRP] [smallint] NULL,
	[DESTWSREF] [int] NULL,
	[DESTPOLNREF] [int] NULL,
	[FACTORYNR] [smallint] NULL,
	[IOCODE] [smallint] NULL,
	[STFICHEREF] [int] NULL,
	[STFICHELNNO] [smallint] NULL,
	[INVOICEREF] [int] NULL,
	[INVOICELNNO] [smallint] NULL,
	[CLIENTREF] [int] NULL,
	[ORDTRANSREF] [int] NULL,
	[ORDFICHEREF] [int] NULL,
	[CENTERREF] [int] NULL,
	[ACCOUNTREF] [int] NULL,
	[VATACCREF] [int] NULL,
	[VATCENTERREF] [int] NULL,
	[PRACCREF] [int] NULL,
	[PRCENTERREF] [int] NULL,
	[PRVATACCREF] [int] NULL,
	[PRVATCENREF] [int] NULL,
	[PROMREF] [int] NULL,
	[PAYDEFREF] [int] NULL,
	[SPECODE] [varchar](17) NULL,
	[DELVRYCODE] [varchar](11) NULL,
	[AMOUNT] [float] NULL,
	[PRICE] [float] NULL,
	[TOTAL] [float] NULL,
	[PRCURR] [smallint] NULL,
	[PRPRICE] [float] NULL,
	[TRCURR] [smallint] NULL,
	[TRRATE] [float] NULL,
	[REPORTRATE] [float] NULL,
	[DISTCOST] [float] NULL,
	[DISTDISC] [float] NULL,
	[DISTEXP] [float] NULL,
	[DISTPROM] [float] NULL,
	[DISCPER] [float] NULL,
	[LINEEXP] [varchar](251) NULL,
	[UOMREF] [int] NULL,
	[USREF] [int] NULL,
	[UINFO1] [float] NULL,
	[UINFO2] [float] NULL,
	[UINFO3] [float] NULL,
	[UINFO4] [float] NULL,
	[UINFO5] [float] NULL,
	[UINFO6] [float] NULL,
	[UINFO7] [float] NULL,
	[UINFO8] [float] NULL,
	[PLNAMOUNT] [float] NULL,
	[VATINC] [smallint] NULL,
	[VAT] [float] NULL,
	[VATAMNT] [float] NULL,
	[VATMATRAH] [float] NULL,
	[BILLEDITEM] [int] NULL,
	[BILLED] [smallint] NULL,
	[CPSTFLAG] [smallint] NULL,
	[RETCOSTTYPE] [smallint] NULL,
	[SOURCELINK] [int] NULL,
	[RETCOST] [float] NULL,
	[RETCOSTCURR] [float] NULL,
	[OUTCOST] [float] NULL,
	[OUTCOSTCURR] [float] NULL,
	[RETAMOUNT] [float] NULL,
	[FAREGREF] [int] NULL,
	[FAATTRIB] [smallint] NULL,
	[CANCELLED] [smallint] NULL,
	[LINENET] [float] NULL,
	[DISTADDEXP] [float] NULL,
	[FADACCREF] [int] NULL,
	[FADCENTERREF] [int] NULL,
	[FARACCREF] [int] NULL,
	[FARCENTERREF] [int] NULL,
	[DIFFPRICE] [float] NULL,
	[DIFFPRCOST] [float] NULL,
	[DECPRDIFF] [smallint] NULL,
	[LPRODSTAT] [smallint] NULL,
	[PRDEXPTOTAL] [float] NULL,
	[DIFFREPPRICE] [float] NULL,
	[DIFFPRCRCOST] [float] NULL,
	[SALESMANREF] [int] NULL,
	[FAPLACCREF] [int] NULL,
	[FAPLCENTERREF] [int] NULL,
	[OUTPUTIDCODE] [varchar](25) NULL,
	[DREF] [int] NULL,
	[COSTRATE] [float] NULL,
	[XPRICEUPD] [smallint] NULL,
	[XPRICE] [float] NULL,
	[XREPRATE] [float] NULL,
	[DISTCOEF] [float] NULL,
	[TRANSQCOK] [smallint] NULL,
	[SITEID] [smallint] NULL,
	[RECSTATUS] [smallint] NULL,
	[ORGLOGICREF] [int] NULL,
	[WFSTATUS] [int] NULL,
	[POLINEREF] [int] NULL,
	[PLNSTTRANSREF] [int] NULL,
	[NETDISCFLAG] [smallint] NULL,
	[NETDISCPERC] [float] NULL,
	[NETDISCAMNT] [float] NULL,
	[VATCALCDIFF] [float] NULL,
	[CONDITIONREF] [int] NULL,
	[DISTORDERREF] [int] NULL,
	[DISTORDLINEREF] [int] NULL,
	[CAMPAIGNREFS1] [int] NULL,
	[CAMPAIGNREFS2] [int] NULL,
	[CAMPAIGNREFS3] [int] NULL,
	[CAMPAIGNREFS4] [int] NULL,
	[CAMPAIGNREFS5] [int] NULL,
	[POINTCAMPREF] [int] NULL,
	[CAMPPOINT] [float] NULL,
	[PROMCLASITEMREF] [int] NULL,
	[CMPGLINEREF] [int] NULL,
	[PLNSTTRANSPERNR] [int] NULL,
	[PORDCLSPLNAMNT] [float] NULL,
	[VENDCOMM] [float] NULL,
	[PREVIOUSOUTCOST] [float] NULL,
	[COSTOFSALEACCREF] [int] NULL,
	[PURCHACCREF] [int] NULL,
	[COSTOFSALECNTREF] [int] NULL,
	[PURCHCENTREF] [int] NULL,
	[PREVOUTCOSTCURR] [float] NULL,
	[ABVATAMOUNT] [float] NULL,
	[ABVATSTATUS] [int] NULL,
	[PRRATE] [float] NULL,
	[ADDTAXRATE] [float] NULL,
	[ADDTAXCONVFACT] [float] NULL,
	[ADDTAXAMOUNT] [float] NULL,
	[ADDTAXPRCOST] [float] NULL,
	[ADDTAXRETCOST] [float] NULL,
	[ADDTAXRETCOSTCURR] [float] NULL,
	[GROSSUINFO1] [float] NULL,
	[GROSSUINFO2] [float] NULL,
	[ADDTAXPRCOSTCURR] [float] NULL,
	[ADDTAXACCREF] [int] NULL,
	[ADDTAXCENTERREF] [int] NULL,
	[ADDTAXAMNTISUPD] [smallint] NULL,
	[INFIDX] [float] NULL,
	[ADDTAXCOSACCREF] [int] NULL,
	[ADDTAXCOSCNTREF] [int] NULL,
	[PREVIOUSATAXPRCOST] [float] NULL,
	[PREVATAXPRCOSTCURR] [float] NULL,
	[PRDORDTOTCOEF] [float] NULL,
	[DEMPEGGEDAMNT] [float] NULL,
	[STDUNITCOST] [float] NULL,
	[STDRPUNITCOST] [float] NULL,
	[COSTDIFFACCREF] [int] NULL,
	[COSTDIFFCENREF] [int] NULL,
	[TEXTINC] [smallint] NULL,
	[ADDTAXDISCAMOUNT] [float] NULL,
	[ORGLOGOID] [varchar](25) NULL,
	[EXIMFICHENO] [varchar](31) NULL,
	[EXIMFCTYPE] [smallint] NULL,
	[TRANSEXPLINE] [smallint] NULL,
	[INSEXPLINE] [smallint] NULL,
	[EXIMWHFCREF] [int] NULL,
	[EXIMWHLNREF] [int] NULL,
	[EXIMFILEREF] [int] NULL,
	[EXIMPROCNR] [smallint] NULL,
	[EISRVDSTTYP] [smallint] NULL,
	[MAINSTLNREF] [int] NULL,
	[MADEOFSHRED] [smallint] NULL,
	[FROMORDWITHPAY] [smallint] NULL,
	[PROJECTREF] [int] NULL,
	[STATUS] [smallint] NULL,
	[DORESERVE] [smallint] NULL,
	[POINTCAMPREFS1] [int] NULL,
	[POINTCAMPREFS2] [int] NULL,
	[POINTCAMPREFS3] [int] NULL,
	[POINTCAMPREFS4] [int] NULL,
	[CAMPPOINTS1] [float] NULL,
	[CAMPPOINTS2] [float] NULL,
	[CAMPPOINTS3] [float] NULL,
	[CAMPPOINTS4] [float] NULL,
	[CMPGLINEREFS1] [int] NULL,
	[CMPGLINEREFS2] [int] NULL,
	[CMPGLINEREFS3] [int] NULL,
	[CMPGLINEREFS4] [int] NULL,
	[PRCLISTREF] [int] NULL,
	[PORDSYMOUTLN] [smallint] NULL,
	[MONTH_] [smallint] NULL,
	[YEAR_] [smallint] NULL,
	[EXADDTAXRATE] [float] NULL,
	[EXADDTAXCONVF] [float] NULL,
	[EXADDTAXAREF] [int] NULL,
	[EXADDTAXCREF] [int] NULL,
	[OTHRADDTAXAREF] [int] NULL,
	[OTHRADDTAXCREF] [int] NULL,
	[EXADDTAXAMNT] [float] NULL,
	[AFFECTCOLLATRL] [smallint] NULL,
	[ALTPROMFLAG] [smallint] NULL,
	[EIDISTFLNNR] [smallint] NULL,
	[EXIMTYPE] [smallint] NULL,
	[VARIANTREF] [int] NULL,
	[CANDEDUCT] [smallint] NULL,
	[OUTREMAMNT] [float] NULL,
	[OUTREMCOST] [float] NULL,
	[OUTREMCOSTCURR] [float] NULL,
	[REFLVATACCREF] [int] NULL,
	[REFLVATOTHACCREF] [int] NULL,
	[PARENTLNREF] [int] NULL,
	[AFFECTRISK] [smallint] NULL,
	[INEFFECTIVECOST] [smallint] NULL,
	[ADDTAXVATMATRAH] [float] NULL,
	[REFLACCREF] [int] NULL,
	[REFLOTHACCREF] [int] NULL,
	[CAMPPAYDEFREF] [int] NULL,
	[FAREGBINDDATE] [datetime] NULL,
	[RELTRANSLNREF] [int] NULL,
	[FROMTRANSFER] [smallint] NULL,
	[COSTDISTPRICE] [float] NULL,
	[COSTDISTREPPRICE] [float] NULL,
	[DIFFPRICEUFRS] [float] NULL,
	[DIFFREPPRICEUFRS] [float] NULL,
	[OUTCOSTUFRS] [float] NULL,
	[OUTCOSTCURRUFRS] [float] NULL,
	[DIFFPRCOSTUFRS] [float] NULL,
	[DIFFPRCRCOSTUFRS] [float] NULL,
	[RETCOSTUFRS] [float] NULL,
	[RETCOSTCURRUFRS] [float] NULL,
	[OUTREMCOSTUFRS] [float] NULL,
	[OUTREMCOSTCURRUFRS] [float] NULL,
	[INFIDXUFRS] [float] NULL,
	[ADJPRICEUFRS] [float] NULL,
	[ADJREPPRICEUFRS] [float] NULL,
	[ADJPRCOSTUFRS] [float] NULL,
	[ADJPRCRCOSTUFRS] [float] NULL,
	[COSTDISTPRICEUFRS] [float] NULL,
	[COSTDISTREPPRICEUFRS] [float] NULL,
	[PURCHACCREFUFRS] [int] NULL,
	[PURCHCENTREFUFRS] [int] NULL,
	[COSACCREFUFRS] [int] NULL,
	[COSCNTREFUFRS] [int] NULL,
	[PROUTCOSTUFRSDIFF] [float] NULL,
	[PROUTCOSTCRUFRSDIFF] [float] NULL,
	[UNDERDEDUCTLIMIT] [smallint] NULL,
	[GLOBALID] [varchar](51) NULL,
	[DEDUCTIONPART1] [smallint] NULL,
	[DEDUCTIONPART2] [smallint] NULL,
	[GUID] [varchar](37) NULL,
	[SPECODE2] [varchar](41) NULL,
	[OFFERREF] [int] NULL,
	[OFFTRANSREF] [int] NULL,
	[VATEXCEPTREASON] [varchar](201) NULL,
	[PLNDEFSERILOTNO] [varchar](101) NULL,
	[PLNUNRSRVAMOUNT] [float] NULL,
	[PORDCLSPLNUNRSRVAMNT] [float] NULL,
	[LPRODRSRVSTAT] [smallint] NULL,
	[FALINKTYPE] [smallint] NULL,
	[DEDUCTCODE] [varchar](11) NULL,
	[UPDTHISLINE] [smallint] NULL,
	[VATEXCEPTCODE] [varchar](11) NULL,
	[PORDERFICHENO] [varchar](17) NULL,
	[QPRODFCREF] [int] NULL,
	[RELTRANSFCREF] [int] NULL,
	[ATAXEXCEPTREASON] [varchar](201) NULL,
	[ATAXEXCEPTCODE] [varchar](11) NULL,
	[PRODORDERTYP] [smallint] NULL,
	[SUBCONTORDERREF] [int] NULL,
	[QPRODFCTYP] [smallint] NULL,
	[PRDORDSLPLNRESERVE] [smallint] NULL,
	[INFDATE] [datetime] NULL,
	[DESTSTATUS] [smallint] NULL,
	[REGTYPREF] [int] NULL,
	[FAPROFITACCREF] [int] NULL,
	[FAPROFITCENTREF] [int] NULL,
	[FALOSSACCREF] [int] NULL,
	[FALOSSCENTREF] [int] NULL,
	[CPACODE] [varchar](25) NULL,
	[GTIPCODE] [varchar](25) NULL,
	[PUBLICCOUNTRYREF] [int] NULL,
	[QPRODITEMTYPE] [smallint] NULL,
	[FUTMONTHCNT] [smallint] NULL,
	[FUTMONTHBEGDATE] [int] NULL,
	[QCTRANSFERREF] [int] NULL,
	[QCTRANSFERAMNT] [float] NULL,
	[FUTMONTHENDDATE] [datetime] NULL,
	[KKEGACCREF] [int] NULL,
	[KKEGCENTREF] [int] NULL,
	[MNTORDERFREF] [int] NULL,
	[FAKKEGAMOUNT] [float] NULL,
	[MIDDLEMANEXPTYP] [smallint] NULL,
	[EXPRACCREF] [int] NULL,
	[EXPRCNTRREF] [int] NULL,
	[KKEGVATACCREF] [int] NULL,
	[KKEGVATCENTREF] [int] NULL,
	[MARKINGTAGNO] [varchar](21) NULL,
	[OWNER] [varchar](201) NULL,
	[TCKTAXNR] [varchar](16) NULL,
	[FUTMONTHBEGDATE_] [datetime] NULL,
	[ADDTAXVATACCREF] [int] NULL,
	[ADDTAXVATCENREF] [int] NULL,
	[EXPDAYS] [smallint] NULL,
	[CANCELLEDINVREF1] [int] NULL,
	[CANCELLEDINVREF2] [int] NULL,
	[CANCELLEDINVREF3] [int] NULL,
	[CANCELLEDINVREF4] [int] NULL,
	[FROMINTEGTYPE] [smallint] NULL,
	[FROMINTEGREF] [int] NULL,
	[TAXFREEACCREF] [int] NULL,
	[TAXFREECNTRREF] [int] NULL,
	[EISRVDSTADDTAXINC] [smallint] NULL,
	[QCTRANSFERREF2] [int] NULL,
	[QCTRANSFERAMNT2] [float] NULL,
	[ITMDISC] [smallint] NULL,
	[ADDTAXREF] [int] NULL,
	[ADDTAXEFFECTKDV] [smallint] NULL,
	[ADDTAXINLINENET] [smallint] NULL,
	[ORDFICHECMREF] [int] NULL,
	[PROUTCOSTCRINFLDIFF] [float] NULL,
	[ORGPRICE] [float] NULL,
	[RETSOURCELINK] [int] NULL,
	[DIIBLINECODE] [varchar](12) NULL,
	[PROUTCOSTINFLDIFF] [float] NULL,
	[PURCHACCREFINFL] [int] NULL,
	[PURCHCENTREFINFL] [int] NULL,
	[COSACCREFINFL] [int] NULL,
	[COSCNTREFINFL] [int] NULL,
 CONSTRAINT [I011_08_STLINE_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


