USE [LOGO_BAKI2018]
GO

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

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[LG_011_08_ORFLINE](
	[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
	[STOCKREF] [int] NULL,
	[ORDFICHEREF] [int] NULL,
	[CLIENTREF] [int] NULL,
	[LINETYPE] [smallint] NULL,
	[PREVLINEREF] [int] NULL,
	[PREVLINENO] [smallint] NULL,
	[DETLINE] [smallint] NULL,
	[LINENO_] [smallint] NULL,
	[TRCODE] [smallint] NULL,
	[DATE_] [datetime] NULL,
	[TIME_] [int] NULL,
	[GLOBTRANS] [smallint] NULL,
	[CALCTYPE] [smallint] 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,
	[SPECODE] [varchar](17) NULL,
	[DELVRYCODE] [varchar](11) NULL,
	[AMOUNT] [float] NULL,
	[PRICE] [float] NULL,
	[TOTAL] [float] NULL,
	[SHIPPEDAMOUNT] [float] NULL,
	[DISCPER] [float] NULL,
	[DISTCOST] [float] NULL,
	[DISTDISC] [float] NULL,
	[DISTEXP] [float] NULL,
	[DISTPROM] [float] NULL,
	[VAT] [float] NULL,
	[VATAMNT] [float] NULL,
	[VATMATRAH] [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,
	[VATINC] [smallint] NULL,
	[CLOSED] [smallint] NULL,
	[DORESERVE] [smallint] NULL,
	[INUSE] [smallint] NULL,
	[DUEDATE] [datetime] NULL,
	[PRCURR] [smallint] NULL,
	[PRPRICE] [float] NULL,
	[REPORTRATE] [float] NULL,
	[BILLEDITEM] [int] NULL,
	[PAYDEFREF] [int] NULL,
	[EXTENREF] [int] NULL,
	[CPSTFLAG] [smallint] NULL,
	[SOURCEINDEX] [smallint] NULL,
	[SOURCECOSTGRP] [smallint] NULL,
	[BRANCH] [smallint] NULL,
	[DEPARTMENT] [smallint] NULL,
	[LINENET] [float] NULL,
	[SALESMANREF] [int] NULL,
	[STATUS] [smallint] NULL,
	[DREF] [int] NULL,
	[TRGFLAG] [smallint] NULL,
	[SITEID] [smallint] NULL,
	[RECSTATUS] [smallint] NULL,
	[ORGLOGICREF] [int] NULL,
	[FACTORYNR] [smallint] NULL,
	[WFSTATUS] [int] NULL,
	[NETDISCFLAG] [smallint] NULL,
	[NETDISCPERC] [float] NULL,
	[NETDISCAMNT] [float] NULL,
	[CONDITIONREF] [int] NULL,
	[DISTRESERVED] [float] NULL,
	[ONVEHICLE] [float] 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,
	[REASONFORNOTSHP] [smallint] NULL,
	[CMPGLINEREF] [int] NULL,
	[PRRATE] [float] NULL,
	[GROSSUINFO1] [float] NULL,
	[GROSSUINFO2] [float] NULL,
	[CANCELLED] [smallint] NULL,
	[DEMPEGGEDAMNT] [float] NULL,
	[TEXTINC] [smallint] NULL,
	[OFFERREF] [int] NULL,
	[ORDERPARAM] [smallint] NULL,
	[ITEMASGREF] [int] NULL,
	[EXIMAMOUNT] [float] NULL,
	[OFFTRANSREF] [int] NULL,
	[ORDEREDAMOUNT] [float] NULL,
	[ORGLOGOID] [varchar](25) NULL,
	[TRCURR] [smallint] NULL,
	[TRRATE] [float] NULL,
	[WITHPAYTRANS] [smallint] NULL,
	[PROJECTREF] [int] 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,
	[AFFECTCOLLATRL] [smallint] NULL,
	[FCTYP] [smallint] NULL,
	[PURCHOFFNR] [smallint] NULL,
	[DEMFICHEREF] [int] NULL,
	[DEMTRANSREF] [int] NULL,
	[ALTPROMFLAG] [smallint] NULL,
	[VARIANTREF] [int] NULL,
	[REFLVATACCREF] [int] NULL,
	[REFLVATOTHACCREF] [int] NULL,
	[PRIORITY] [smallint] NULL,
	[AFFECTRISK] [smallint] NULL,
	[BOMREF] [int] NULL,
	[BOMREVREF] [int] NULL,
	[ROUTINGREF] [int] NULL,
	[OPERATIONREF] [int] NULL,
	[WSREF] [int] NULL,
	[ADDTAXRATE] [float] NULL,
	[ADDTAXCONVFACT] [float] NULL,
	[ADDTAXAMOUNT] [float] NULL,
	[ADDTAXACCREF] [int] NULL,
	[ADDTAXCENTERREF] [int] NULL,
	[ADDTAXAMNTISUPD] [smallint] NULL,
	[ADDTAXDISCAMOUNT] [float] NULL,
	[EXADDTAXRATE] [float] NULL,
	[EXADDTAXCONVF] [float] NULL,
	[EXADDTAXAMNT] [float] NULL,
	[EUVATSTATUS] [int] NULL,
	[ADDTAXVATMATRAH] [float] NULL,
	[CAMPPAYDEFREF] [int] NULL,
	[RPRICE] [float] NULL,
	[ORGDUEDATE] [datetime] NULL,
	[ORGAMOUNT] [float] NULL,
	[ORGPRICE] [float] NULL,
	[SPECODE2] [varchar](41) NULL,
	[RESERVEDATE] [datetime] NULL,
	[CANDEDUCT] [smallint] NULL,
	[UNDERDEDUCTLIMIT] [smallint] NULL,
	[GLOBALID] [varchar](51) NULL,
	[DEDUCTIONPART1] [smallint] NULL,
	[DEDUCTIONPART2] [smallint] NULL,
	[PARENTLNREF] [int] NULL,
	[GUID] [varchar](37) NULL,
	[DISTEXPVAT] [float] NULL,
	[SHIPPEDAMNTSUGG] [float] NULL,
	[RESERVEAMOUNT] [float] NULL,
	[DEDUCTCODE] [varchar](11) NULL,
	[BOMTYPE] [smallint] NULL,
	[DEVIR] [smallint] NULL,
	[FAREGREF] [int] NULL,
	[VATEXCEPTCODE] [varchar](11) NULL,
	[VATEXCEPTREASON] [varchar](201) NULL,
	[ATAXEXCEPTCODE] [varchar](11) NULL,
	[ATAXEXCEPTREASON] [varchar](201) NULL,
	[CPACODE] [varchar](25) NULL,
	[GTIPCODE] [varchar](25) NULL,
	[PUBLICCOUNTRYREF] [int] NULL,
	[DISTDISCVAT] [float] NULL,
	[ITMDISC] [smallint] NULL,
	[ADDTAXREF] [int] NULL,
	[ADDTAXEFFECTKDV] [smallint] NULL,
	[ADDTAXINLINENET] [smallint] NULL,
	[DRAFTSTOCKNAME] [varchar](51) NULL,
	[DRAFTSTOCKNAME2] [varchar](201) NULL,
	[DRAFTSTOCKNAME3] [varchar](201) NULL,
	[PARENTSTOCKREF] [int] NULL,
	[PURCHOFFCAPTION] [varchar](51) NULL,
 CONSTRAINT [I011_08_ORFLINE_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


