USE [LOGO_BAKI2018] GO /****** Object: Table [dbo].[LG_011_ITEMS] Script Date: 17.01.2026 01:06:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[LG_011_ITEMS]( [LOGICALREF] [int] IDENTITY(1,1) NOT NULL, [ACTIVE] [smallint] NULL, [CARDTYPE] [smallint] NULL, [CODE] [varchar](25) NULL, [NAME] [varchar](51) NULL, [STGRPCODE] [varchar](25) NULL, [PRODUCERCODE] [varchar](101) NULL, [SPECODE] [varchar](11) NULL, [CYPHCODE] [varchar](11) NULL, [CLASSTYPE] [smallint] NULL, [PURCHBRWS] [smallint] NULL, [SALESBRWS] [smallint] NULL, [MTRLBRWS] [smallint] NULL, [VAT] [float] NULL, [PAYMENTREF] [int] NULL, [TRACKTYPE] [smallint] NULL, [LOCTRACKING] [smallint] NULL, [TOOL] [smallint] NULL, [AUTOINCSL] [smallint] NULL, [DIVLOTSIZE] [smallint] NULL, [SHELFLIFE] [float] NULL, [SHELFDATE] [smallint] NULL, [DOMINANTREFS1] [int] NULL, [DOMINANTREFS2] [int] NULL, [DOMINANTREFS3] [int] NULL, [DOMINANTREFS4] [int] NULL, [DOMINANTREFS5] [int] NULL, [DOMINANTREFS6] [int] NULL, [DOMINANTREFS7] [int] NULL, [DOMINANTREFS8] [int] NULL, [DOMINANTREFS9] [int] NULL, [DOMINANTREFS10] [int] NULL, [DOMINANTREFS11] [int] NULL, [DOMINANTREFS12] [int] NULL, [IMAGEINC] [smallint] NULL, [TEXTINC] [smallint] NULL, [DEPRTYPE] [smallint] NULL, [DEPRRATE] [float] NULL, [DEPRDUR] [smallint] NULL, [SALVAGEVAL] [float] NULL, [REVALFLAG] [smallint] NULL, [REVDEPRFLAG] [smallint] NULL, [PARTDEP] [smallint] NULL, [DEPRTYPE2] [smallint] NULL, [DEPRRATE2] [float] NULL, [DEPRDUR2] [smallint] NULL, [REVALFLAG2] [smallint] NULL, [REVDEPRFLAG2] [smallint] NULL, [PARTDEP2] [smallint] NULL, [APPROVED] [smallint] NULL, [UNITSETREF] [int] NULL, [QCCSETREF] [int] NULL, [DISTAMOUNT] [float] 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, [SITEID] [smallint] NULL, [RECSTATUS] [smallint] NULL, [ORGLOGICREF] [int] NULL, [UNIVID] [varchar](25) NULL, [DISTLOTUNITS] [smallint] NULL, [COMBLOTUNITS] [smallint] NULL, [WFSTATUS] [int] NULL, [DISTPOINT] [float] NULL, [CAMPPOINT] [float] NULL, [CANUSEINTRNS] [smallint] NULL, [ISONR] [varchar](11) NULL, [GROUPNR] [varchar](9) NULL, [PRODCOUNTRY] [varchar](13) NULL, [ADDTAXREF] [int] NULL, [QPRODAMNT] [float] NULL, [QPRODUOM] [int] NULL, [QPRODSRCINDEX] [smallint] NULL, [EXTACCESSFLAGS] [int] NULL, [PACKET] [smallint] NULL, [SALVAGEVAL2] [float] NULL, [SELLVAT] [float] NULL, [RETURNVAT] [float] NULL, [LOGOID] [varchar](25) NULL, [LIDCONFIRMED] [smallint] NULL, [GTIPCODE] [varchar](25) NULL, [EXPCTGNO] [varchar](25) NULL, [B2CCODE] [varchar](25) NULL, [MARKREF] [int] NULL, [IMAGE2INC] [smallint] NULL, [AVRWHDURATION] [float] NULL, [EXTCARDFLAGS] [int] NULL, [MINORDAMOUNT] [float] NULL, [FREIGHTPLACE] [varchar](51) NULL, [FREIGHTTYPCODE1] [varchar](13) NULL, [FREIGHTTYPCODE2] [varchar](13) NULL, [FREIGHTTYPCODE3] [varchar](13) NULL, [FREIGHTTYPCODE4] [varchar](13) NULL, [FREIGHTTYPCODE5] [varchar](13) NULL, [FREIGHTTYPCODE6] [varchar](13) NULL, [FREIGHTTYPCODE7] [varchar](13) NULL, [FREIGHTTYPCODE8] [varchar](13) NULL, [FREIGHTTYPCODE9] [varchar](13) NULL, [FREIGHTTYPCODE10] [varchar](13) NULL, [STATECODE] [varchar](13) NULL, [STATENAME] [varchar](41) NULL, [EXPCATEGORY] [varchar](25) NULL, [LOSTFACTOR] [float] NULL, [TEXTINCENG] [smallint] NULL, [EANBARCODE] [varchar](25) NULL, [DEPRCLASSTYPE] [varchar](31) NULL, [WFLOWCRDREF] [int] NULL, [SELLPRVAT] [float] NULL, [RETURNPRVAT] [float] NULL, [LOWLEVELCODES1] [int] NULL, [LOWLEVELCODES2] [int] NULL, [LOWLEVELCODES3] [int] NULL, [LOWLEVELCODES4] [int] NULL, [LOWLEVELCODES5] [int] NULL, [LOWLEVELCODES6] [int] NULL, [LOWLEVELCODES7] [int] NULL, [LOWLEVELCODES8] [int] NULL, [LOWLEVELCODES9] [int] NULL, [LOWLEVELCODES10] [int] NULL, [ORGLOGOID] [varchar](25) NULL, [QPRODDEPART] [smallint] NULL, [CANCONFIGURE] [smallint] NULL, [CHARSETREF] [int] NULL, [CANDEDUCT] [smallint] NULL, [CONSCODEREF] [int] NULL, [SPECODE2] [varchar](11) NULL, [SPECODE3] [varchar](11) NULL, [SPECODE4] [varchar](11) NULL, [SPECODE5] [varchar](11) NULL, [EXPENSE] [smallint] NULL, [ORIGIN] [varchar](25) NULL, [NAME2] [varchar](51) NULL, [COMPKDVUSE] [smallint] NULL, [USEDINPERIODS] [smallint] NULL, [EXIMTAX1] [float] NULL, [EXIMTAX2] [float] NULL, [EXIMTAX3] [float] NULL, [EXIMTAX4] [float] NULL, [EXIMTAX5] [float] NULL, [PRODUCTLEVEL] [smallint] NULL, [APPSPEVATMATRAH] [smallint] NULL, [NAME3] [varchar](201) NULL, [FACOSTKEYS] [smallint] NULL, [KKLINESDISABLE] [smallint] NULL, [APPROVE] [smallint] NULL, [APPROVEDATE] [datetime] NULL, [GLOBALID] [varchar](51) NULL, [SALEDEDUCTPART1] [smallint] NULL, [SALEDEDUCTPART2] [smallint] NULL, [PURCDEDUCTPART1] [smallint] NULL, [PURCDEDUCTPART2] [smallint] NULL, [CATEGORYID] [varchar](51) NULL, [CATEGORYNAME] [varchar](256) NULL, [KEYWORD1] [varchar](121) NULL, [KEYWORD2] [varchar](121) NULL, [KEYWORD3] [varchar](121) NULL, [KEYWORD4] [varchar](121) NULL, [KEYWORD5] [varchar](121) NULL, [GUID] [varchar](37) NULL, [DEMANDMEETSORTFLD1] [varchar](51) NULL, [DEMANDMEETSORTFLD2] [varchar](51) NULL, [DEMANDMEETSORTFLD3] [varchar](51) NULL, [DEMANDMEETSORTFLD4] [varchar](51) NULL, [DEMANDMEETSORTFLD5] [varchar](51) NULL, [DEDUCTCODE] [varchar](11) NULL, [PROJECTREF] [int] NULL, [MOLDLIFETRACKTYPE] [smallint] NULL, [MOLDUSAGELIFE] [float] NULL, [MOLD] [smallint] NULL, [FAUSEFULLIFECODE] [varchar](11) NULL, [FAUSEFULLIFECODE2] [varchar](11) NULL, [MOLDMAINTLIFE] [float] NULL, [MOLDLIFEASRATIO] [smallint] NULL, [MOLDMAINTLIFETYPE] [smallint] NULL, [MOLDFACTOR] [smallint] NULL, [MOLDMAINTNUMBER] [int] NULL, [QPRODSUBSRCINDEX] [smallint] NULL, [QPRODSUBDEPART] [smallint] NULL, [QPRODSUBUOM] [int] NULL, [NAME4] [varchar](201) NULL, [QPRODSUBAMNT] [float] NULL, [CPACODE] [varchar](25) NULL, [PUBLICCOUNTRYREF] [int] NULL, [MULTIADDTAX] [smallint] NULL, [PORDAMNTTOLERANCE] [float] NULL, [SORDAMNTTOLERANCE] [float] NULL, [FORECASTCODE] [varchar](25) NULL, [GAINTYPE] [smallint] NULL, [SALESLIMITQUANTITY] [float] NULL, [LEVELCONTROL] [smallint] NULL, [NODISCOUNT] [smallint] NULL, [MOLDMAINTBEGDATE] [datetime] NULL, [MOLDMAINTTYPE] [smallint] NULL, [MOLDMAINTPERIOD] [float] NULL, [OBTAINTYPE] [smallint] NULL, [MOLDMAINTPERUNIT] [smallint] NULL, [NOTIFYCRDREF] [int] NULL, [UETDSUNCODE] [varchar](9) NULL, [UETDSUNDEF] [varchar](256) NULL, [UETDSLOADUNIT] [varchar](5) NULL, [UETDSTRANSPORTMODE] [smallint] NULL, [UETDSTRANSPORTTYPE] [smallint] NULL, [UETDSLOADTYPE] [varchar](5) NULL, [UETDSLOADTYPEDEF] [varchar](256) NULL, [TSENR] [varchar](41) NULL, [PAYERSALESPRICE] [float] NULL, [PAYERID] [varchar](37) NULL, [PAYERACTIVE] [smallint] NULL, [PAYERPURCHPRICE] [float] NULL, [PAYERNAME] [varchar](256) NULL, [PAYERSUBTITLE] [varchar](256) NULL, [PAYERBARCODE] [varchar](256) NULL, [PURCHDEDUCTCODE] [varchar](11) NULL, [ADDTAXSALESBRWS] [smallint] NULL, [ADDTAXPURCHBRWS] [smallint] NULL, [PRODCLREF] [int] NULL, [DRAFTOFFERBRWS] [smallint] NULL, [SALESDISPRATETOT] [float] NULL, [PROFITMARGINRATE] [float] NULL, [EXIMREGTYPREF] [int] NULL, [PURCHDISPRATETOT] [float] NULL, [ORDCMPRICETYPECODE] [varchar](21) NULL, [TIBBICIHAZ] [smallint] NULL, [GTIN_UNO] [varchar](101) NULL, CONSTRAINT [I011_ITEMS_I1] PRIMARY KEY CLUSTERED ( [LOGICALREF] ASC )WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO