/*
Run this script on SQL Server 2008 or later. There may be flaws if running on earlier versions of SQL Server.
*/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DetailsStore]') AND type in (N'U'))
DROP TABLE [dbo].[DetailsStore]
GO
CREATE TABLE [dbo].[DetailsStore] (
	[ExpenditureCategory]			[varchar](100)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Type]							[varchar](10)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[UseQuantityCostCalculated]		[varchar](25)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CGEFX]							[varchar](3)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[GLDept]						[varchar](10)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CreditDept]					[varchar](10)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[uom]							[varchar](20)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[HrsWeek]						[varchar](10)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[IncomeStmtType]				[varchar](100)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[UserDefined1]					[varchar](100)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[AverageRate]					[varchar](32)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO