USE [Ariens_QA_AX2009_SP1]
GO

/****** Object:  Table [dbo].[INVENTTABLE]    Script Date: 1/27/2015 10:09:19 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[INVENTTABLE](
	[ITEMGROUPID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[ITEMID] [NVARCHAR](20) NOT NULL DEFAULT (''),
	[ITEMNAME] [NVARCHAR](60) NOT NULL DEFAULT (''),
	[ITEMTYPE] [INT] NOT NULL DEFAULT ((0)),
	[PURCHMODEL] [INT] NOT NULL DEFAULT ((0)),
	[HEIGHT] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[WIDTH] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[SALESMODEL] [INT] NOT NULL DEFAULT ((0)),
	[COSTGROUPID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[REQGROUPID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[EPCMANAGER] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[PRIMARYVENDORID] [NVARCHAR](20) NOT NULL DEFAULT (''),
	[NETWEIGHT] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[DEPTH] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[UNITVOLUME] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[BOMUNITID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[ITEMPRICETOLERANCEGROUPID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[DENSITY] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[DIMENSION] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[DIMENSION2_] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[DIMENSION3_] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[COSTMODEL] [INT] NOT NULL DEFAULT ((0)),
	[USEALTITEMID] [INT] NOT NULL DEFAULT ((0)),
	[ALTITEMID] [NVARCHAR](20) NOT NULL DEFAULT (''),
	[INTRACODE] [NVARCHAR](12) NOT NULL DEFAULT (''),
	[PRODFLUSHINGPRINCIP] [INT] NOT NULL DEFAULT ((0)),
	[MINIMUMPALLETQUANTITY] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[PBAITEMAUTOGENERATED] [INT] NOT NULL DEFAULT ((0)),
	[WMSARRIVALHANDLINGTIME] [INT] NOT NULL DEFAULT ((0)),
	[BOMMANUALRECEIPT] [INT] NOT NULL DEFAULT ((0)),
	[STOPEXPLODE] [INT] NOT NULL DEFAULT ((0)),
	[PHANTOM] [INT] NOT NULL DEFAULT ((0)),
	[INTRAUNIT] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[BOMLEVEL] [INT] NOT NULL DEFAULT ((0)),
	[BATCHNUMGROUPID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[AUTOREPORTFINISHED] [INT] NOT NULL DEFAULT ((0)),
	[ORIGCOUNTRYREGIONID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[STATISTICSFACTOR] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[ALTCONFIGID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[STANDARDCONFIGID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[PRODPOOLID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[ABCTIEUP] [INT] NOT NULL DEFAULT ((0)),
	[ABCREVENUE] [INT] NOT NULL DEFAULT ((0)),
	[ABCVALUE] [INT] NOT NULL DEFAULT ((0)),
	[ABCCONTRIBUTIONMARGIN] [INT] NOT NULL DEFAULT ((0)),
	[COMMISSIONGROUPID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[CONFIGURABLE] [INT] NOT NULL DEFAULT ((0)),
	[SALESPERCENTMARKUP] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[SALESCONTRIBUTIONRATIO] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[SALESPRICEMODELBASIC] [INT] NOT NULL DEFAULT ((0)),
	[NAMEALIAS] [NVARCHAR](20) NOT NULL DEFAULT (''),
	[PRODGROUPID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[PROJCATEGORYID] [NVARCHAR](20) NOT NULL DEFAULT (''),
	[GROSSDEPTH] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[GROSSWIDTH] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[GROSSHEIGHT] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[STANDARDPALLETQUANTITY] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[QTYPERLAYER] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[SORTCODE] [INT] NOT NULL DEFAULT ((0)),
	[CONFIGSIMILAR] [INT] NOT NULL DEFAULT ((0)),
	[SERIALNUMGROUPID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[DIMGROUPID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[MODELGROUPID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[ITEMBUYERGROUPID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[TAXPACKAGINGQTY] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[WMSPALLETTYPEID] [NVARCHAR](15) NOT NULL DEFAULT (''),
	[ORIGSTATEID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[WMSPICKINGQTYTIME] [INT] NOT NULL DEFAULT ((0)),
	[TARAWEIGHT] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[PACKAGINGGROUPID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[SCRAPVAR] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[SCRAPCONST] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[STANDARDINVENTCOLORID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[STANDARDINVENTSIZEID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[ITEMDIMCOMBINATIONAUTOCREATE] [INT] NOT NULL DEFAULT ((0)),
	[ITEMDIMCOSTPRICE] [INT] NOT NULL DEFAULT ((0)),
	[ITEMIDCOMPANY] [NVARCHAR](20) NOT NULL DEFAULT (''),
	[ALTINVENTSIZEID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[ALTINVENTCOLORID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[FORECASTDMPINCLUDE] [INT] NOT NULL DEFAULT ((0)),
	[PALLETTAGGING] [INT] NOT NULL DEFAULT ((0)),
	[ITEMTAGGINGLEVEL] [INT] NOT NULL DEFAULT ((0)),
	[BOMCALCGROUPID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[DATAAREAID] [NVARCHAR](4) NOT NULL DEFAULT ('dat'),
	[RECVERSION] [INT] NOT NULL DEFAULT ((1)),
	[RECID] [BIGINT] NOT NULL,
	[CATALOGPAGENUMBER] [INT] NOT NULL DEFAULT ((0)),
	[INTRODATE] [DATETIME] NOT NULL DEFAULT ('1900-01-01 00:00:00.000'),
	[ENDDATE] [DATETIME] NOT NULL DEFAULT ('1900-01-01 00:00:00.000'),
	[RETURNABLE] [INT] NOT NULL DEFAULT ((0)),
	[PRINTRCPTLABELS] [INT] NOT NULL DEFAULT ((0)),
	[DROPSHIPONLY] [INT] NOT NULL DEFAULT ((0)),
	[ITEMSTATUS] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[PRODUCTCLASS] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[ARSHAZARDOUS] [INT] NOT NULL DEFAULT ((0)),
	[ITEMTYPE1] [INT] NOT NULL DEFAULT ((0)),
	[MODIFIEDDATETIME] [DATETIME] NOT NULL DEFAULT (DATEADD(MILLISECOND, -DATEPART(MILLISECOND,GETUTCDATE()),GETUTCDATE())),
	[MODIFIEDBY] [NVARCHAR](5) NOT NULL DEFAULT ('?'),
	[MODIFIEDTRANSACTIONID] [BIGINT] NOT NULL DEFAULT ((0)),
	[CREATEDDATETIME] [DATETIME] NOT NULL DEFAULT (DATEADD(MILLISECOND, -DATEPART(MILLISECOND,GETUTCDATE()),GETUTCDATE())),
	[CREATEDBY] [NVARCHAR](5) NOT NULL DEFAULT ('?'),
	[CREATEDTRANSACTIONID] [BIGINT] NOT NULL DEFAULT ((0)),
	[ARSSALESCATEGORYIDBASE] [NVARCHAR](5) NOT NULL DEFAULT (''),
	[ARSSCHEDULEBCODE] [NVARCHAR](12) NOT NULL DEFAULT (''),
	[ARSRECEIVINGINSPECTREQUIRED] [INT] NOT NULL DEFAULT ((0)),
	[ARSFLATRATETIME] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[ARSFLATRATEGROUPID] [NVARCHAR](6) NOT NULL DEFAULT (''),
	[ARSEXCLUDESALESFORECASTHISTORY] [INT] NOT NULL DEFAULT ((0)),
	[ARSITEMSTARTDATE] [DATETIME] NOT NULL DEFAULT ('1900-01-01 00:00:00.000'),
	[JSDECLAREDVALUEPERCENT] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[JSDECLAREDVALUEPRICEMODEL] [INT] NOT NULL DEFAULT ((0)),
	[JSNAFTARVC] [INT] NOT NULL DEFAULT ((0)),
	[JSNAFTAPRODUCERFLAG] [INT] NOT NULL DEFAULT ((0)),
	[JSNAFTAPREFERENCECRITERION] [INT] NOT NULL DEFAULT ((0)),
	[ARSINCLUDEGOODSSCREEN] [INT] NOT NULL DEFAULT ((0)),
	[ARSCANADIANCODE] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[ARSUPCCODE] [NVARCHAR](12) NOT NULL DEFAULT (''),
	[ARSRAWMATERIAL] [INT] NOT NULL DEFAULT ((0)),
	[ARSENABLEWEBUSE] [INT] NOT NULL DEFAULT ((0)),
	[DIMENSION4_] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[ARSABCPICKLINES] [INT] NOT NULL DEFAULT ((0)),
	[ARSMULTIPLECOUNTIESOFORIG50027] [INT] NOT NULL DEFAULT ((0)),
	[ARSATPSTATUS] [INT] NOT NULL DEFAULT ((0)),
	[ARSUPCCODEOVERRIDE] [INT] NOT NULL DEFAULT ((0)),
	[ARSWHEREUSEDCOUNT] [INT] NOT NULL DEFAULT ((0)),
	[ARSDRWREVLETTER] [NVARCHAR](30) NOT NULL DEFAULT (''),
	[ARSSUPPLIERFORECAST] [INT] NOT NULL DEFAULT ((0)),
	[ARSSERLABSAFETY] [NVARCHAR](40) NOT NULL DEFAULT (''),
	[ARSCECERT] [INT] NOT NULL DEFAULT ((0)),
	[ARSULCERT] [INT] NOT NULL DEFAULT ((0)),
	[ARSSACERT] [INT] NOT NULL DEFAULT ((0)),
	[ARSSOUNDPOWER] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[ARSBARSCODE] [INT] NOT NULL DEFAULT ((0)),
	[ARSFORECAST] [INT] NOT NULL DEFAULT ((0)),
	[ARSOEMUPC] [NVARCHAR](12) NOT NULL DEFAULT (''),
	[ARSPCS] [NVARCHAR](6) NOT NULL DEFAULT (''),
	[ARSITEMKIND] [NVARCHAR](20) NOT NULL DEFAULT (''),
	[ARSSERLABDESC1] [NVARCHAR](9) NOT NULL DEFAULT (''),
	[ARSSERLABDESC2] [NVARCHAR](9) NOT NULL DEFAULT (''),
	[ARSSOUNDPRESS] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[ARSITEMBRANDID] [NVARCHAR](20) NOT NULL DEFAULT (''),
	[ARSSERVICESALESSTATUS] [NVARCHAR](20) NOT NULL DEFAULT (''),
	[ARSVALUESTREAM] [NVARCHAR](40) NOT NULL DEFAULT (''),
	[ARSPAINTCOATING] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[ARSDRAWINGNUM] [NVARCHAR](30) NOT NULL DEFAULT (''),
	[ARSMODELAREA] [NVARCHAR](30) NOT NULL DEFAULT (''),
	[ARSMODELSERIES] [NVARCHAR](30) NOT NULL DEFAULT (''),
	[ARSSEQUENTIAL] [NVARCHAR](30) NOT NULL DEFAULT (''),
	[ARSATPOVDATE] [DATETIME] NOT NULL DEFAULT ('1900-01-01 00:00:00.000'),
	[ARSATPOVERRIDE] [INT] NOT NULL DEFAULT ((0)),
	[ARSBUSINESSUNITBRANDID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[ARSLONGERDESCRIPTION] [NTEXT] NULL DEFAULT (NULL),
	[ARSREASONFORNOEXPORT] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[ARSEXPIREDATESERVICE] [NVARCHAR](50) NOT NULL DEFAULT (''),
	[ARSEXPIREDATELOC] [NVARCHAR](25) NOT NULL DEFAULT (''),
	[ARSEXPIREDATEID] [NVARCHAR](50) NOT NULL DEFAULT (''),
	[ARSDATESENSITIVETYPE] [NVARCHAR](25) NOT NULL DEFAULT (''),
	[ARSDATESENSITIVE] [INT] NOT NULL DEFAULT ((0)),
	[ARSSEARCHTEXT] [NTEXT] NULL DEFAULT (NULL),
	[ARSPARENTCODE] [NVARCHAR](25) NOT NULL DEFAULT (''),
	[ARSOPLABELED] [INT] NOT NULL DEFAULT ((0)),
	[ARSIPLABELED] [INT] NOT NULL DEFAULT ((0)),
	[ARSMSDS] [INT] NOT NULL DEFAULT ((0)),
	[ARSFREIGHTCLASS] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[ARSNAFTAENDDATE] [DATETIME] NOT NULL DEFAULT ('1900-01-01 00:00:00.000'),
	[ARSNAFTASTARTDATE] [DATETIME] NOT NULL DEFAULT ('1900-01-01 00:00:00.000'),
	[ARSECCN] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[ARSSHELFLIFEMONTHS] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[ARSPERSONALIZATIONPRODUCTID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[ARSPERSONALIZATIONCOLOR] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[ARSPERSONALIZATIONCODE] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[ARSNMFC] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[ARSSEASONCODE] [NVARCHAR](15) NOT NULL DEFAULT (''),
	[AXATJOVERDELIVERYPCT] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[NGPCODE_FR] [INT] NOT NULL DEFAULT ((0)),
	[ARSRESTRICTED] [INT] NOT NULL DEFAULT ((0)),
	[ARSKITTYPE] [INT] NOT NULL DEFAULT ((0)),
	[ARSSPCUSTPARENTITEM] [NVARCHAR](20) NOT NULL DEFAULT (''),
	[ARSSPECIALORDER] [INT] NOT NULL DEFAULT ((0)),
	[ARSCUSTPRODUCT] [INT] NOT NULL DEFAULT ((0)),
	[ARSPERSONALIZATIONNOTEID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[ARSGARMENTTYPEID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[ARSISSHIPSAVERITEM] [INT] NOT NULL DEFAULT ((0)),
	[ARSEPAREGISTRATIONNUM] [NVARCHAR](25) NOT NULL DEFAULT (''),
	[ARSAEROSOLCLASS] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[ARSMSDSFILE] [NVARCHAR](15) NOT NULL DEFAULT (''),
	[ARSNETCONTENT] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[ARSNETCONTENTUOM] [NVARCHAR](5) NOT NULL DEFAULT (''),
	[ARSDONOTEXPORT] [INT] NOT NULL DEFAULT ((0)),
	[ARSVALIDATEDDATE] [DATETIME] NOT NULL DEFAULT ('1900-01-01 00:00:00.000'),
	[ARSEXCLUDEBACKORDERS] [INT] NOT NULL DEFAULT ((0)),
	[ARSUNNUMBERPACKGR] [NVARCHAR](20) NOT NULL DEFAULT (''),
	[ARSFREIGHTTRUCK] [INT] NOT NULL DEFAULT ((0)),
	[ARSFREIGHTOVERSIZE] [INT] NOT NULL DEFAULT ((0)),
 CONSTRAINT [I_175ITEMIDX] PRIMARY KEY CLUSTERED 
(
	[DATAAREAID] ASC,
	[ITEMID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

ALTER TABLE [dbo].[INVENTTABLE]  WITH CHECK ADD CHECK  (([RECID]<>(0)))
GO


USE [Ariens_QA_AX2009_SP1]
GO

/****** Object:  Index [I_175ITEMIDX]    Script Date: 1/27/2015 10:10:21 PM ******/
ALTER TABLE [dbo].[INVENTTABLE] ADD  CONSTRAINT [I_175ITEMIDX] PRIMARY KEY CLUSTERED 
(
	[DATAAREAID] ASC,
	[ITEMID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

USE [Ariens_QA_AX2009_SP1]
GO

/****** Object:  Table [dbo].[REQTRANS]    Script Date: 1/27/2015 10:10:49 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[REQTRANS](
	[REQPLANID] [NVARCHAR](10) NOT NULL DEFAULT (''),
	[ITEMID] [NVARCHAR](20) NOT NULL DEFAULT (''),
	[COVINVENTDIMID] [NVARCHAR](20) NOT NULL DEFAULT (''),
	[REQDATE] [DATETIME] NOT NULL DEFAULT ('1900-01-01 00:00:00.000'),
	[DIRECTION] [INT] NOT NULL DEFAULT ((0)),
	[REFTYPE] [INT] NOT NULL DEFAULT ((0)),
	[OPENSTATUS] [INT] NOT NULL DEFAULT ((0)),
	[QTY] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[COVQTY] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[INVENTTRANSID] [NVARCHAR](20) NOT NULL DEFAULT (''),
	[REFID] [NVARCHAR](20) NOT NULL DEFAULT (''),
	[KEEP] [INT] NOT NULL DEFAULT ((0)),
	[REQDATEDLVORIG] [DATETIME] NOT NULL DEFAULT ('1900-01-01 00:00:00.000'),
	[FUTURESDAYS] [INT] NOT NULL DEFAULT ((0)),
	[FUTURESMARKED] [INT] NOT NULL DEFAULT ((0)),
	[OPRNUM] [INT] NOT NULL DEFAULT ((0)),
	[ACTIONQTYADD] [NUMERIC](28, 12) NOT NULL DEFAULT ((0)),
	[ACTIONDAYS] [INT] NOT NULL DEFAULT ((0)),
	[ACTIONMARKED] [INT] NOT NULL DEFAULT ((0)),
	[ACTIONTYPE] [INT] NOT NULL DEFAULT ((0)),
	[ISDERIVEDDIRECTLY] [INT] NOT NULL DEFAULT ((0)),
	[PRIORITY] [INT] NOT NULL DEFAULT ((0)),
	[ACTIONDATE] [DATETIME] NOT NULL DEFAULT ('1900-01-01 00:00:00.000'),
	[FUTURESDATE] [DATETIME] NOT NULL DEFAULT ('1900-01-01 00:00:00.000'),
	[BOMREFRECID] [BIGINT] NOT NULL DEFAULT ((0)),
	[LEVEL_] [INT] NOT NULL DEFAULT ((0)),
	[BOMTYPE] [INT] NOT NULL DEFAULT ((0)),
	[ITEMROUTEID] [NVARCHAR](20) NOT NULL DEFAULT (''),
	[ITEMBOMID] [NVARCHAR](20) NOT NULL DEFAULT (''),
	[ISFORECASTPURCH] [INT] NOT NULL DEFAULT ((0)),
	[INVENTREFTRANSID] [NVARCHAR](20) NOT NULL DEFAULT (''),
	[REQTIME] [INT] NOT NULL DEFAULT ((0)),
	[FUTURESTIME] [INT] NOT NULL DEFAULT ((0)),
	[DATAAREAID] [NVARCHAR](4) NOT NULL DEFAULT ('dat'),
	[RECVERSION] [INT] NOT NULL DEFAULT ((1)),
	[RECID] [BIGINT] NOT NULL,
	[MODIFIEDDATETIME] [DATETIME] NOT NULL DEFAULT (DATEADD(MILLISECOND, -DATEPART(MILLISECOND,GETUTCDATE()),GETUTCDATE())),
	[MODIFIEDBY] [NVARCHAR](5) NOT NULL DEFAULT ('?'),
	[CREATEDDATETIME] [DATETIME] NOT NULL DEFAULT (DATEADD(MILLISECOND, -DATEPART(MILLISECOND,GETUTCDATE()),GETUTCDATE())),
	[CREATEDBY] [NVARCHAR](5) NOT NULL DEFAULT ('?'),
 CONSTRAINT [I_161ITEMIDX] PRIMARY KEY NONCLUSTERED 
(
	[DATAAREAID] ASC,
	[REQPLANID] ASC,
	[ITEMID] ASC,
	[COVINVENTDIMID] ASC,
	[RECID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[REQTRANS]  WITH CHECK ADD CHECK  (([RECID]<>(0)))
GO


USE [Ariens_QA_AX2009_SP1]
GO

/****** Object:  Index [I_161INVENTIDX]    Script Date: 1/27/2015 10:11:17 PM ******/
CREATE NONCLUSTERED INDEX [I_161INVENTIDX] ON [dbo].[REQTRANS]
(
	[DATAAREAID] ASC,
	[INVENTTRANSID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO