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