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


