CREATE TABLE [dbo].[EXT_GLPresReportDetails]
(
[RunID] [int] NULL,
[ReportLeaseID] [int] NULL,
[CategoryID] [int] NULL,
[Category] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PresAccountID] [int] NULL,
[PresAccount] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_EXT_GLPresReportDetails_PresAccount] DEFAULT (''),
[ISType] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RptSection] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OrderBy] [int] NULL,
[Total] [money] NULL,
[SUMFlag] [int] NULL,
[% of GP$] [decimal] (10, 4) NOT NULL CONSTRAINT [DF_EXT_GLPresReportDetails_% of GP$] DEFAULT ((0)),
[MPS] [money] NOT NULL CONSTRAINT [DF_EXT_GLPresReportDetails_MPS] DEFAULT ((0)),
[Copier] [money] NOT NULL CONSTRAINT [DF_EXT_GLPresReportDetails_Copier] DEFAULT ((0)),
[Other] [money] NOT NULL CONSTRAINT [DF_EXT_GLPresReportDetails_Other] DEFAULT ((0)),
[Multiplier] [int] NOT NULL CONSTRAINT [DF_EXT_GLPresReportDetails_Multiplier] DEFAULT ((-1)),
[UnmappedAmount] [money] NOT NULL CONSTRAINT [DF_EXT_GLPresReportDetails_UnmappedAmount] DEFAULT ((0)),
[AllCompanyTotal] [money] NOT NULL CONSTRAINT [DF_EXT_GLPresReportDetails_AllCompanyTotal] DEFAULT ((0)),
[BenchmarkGroupName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_EXT_GLPresReportDetails_BenchmarkGroupName] DEFAULT (''),
[BenchmarkName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_EXT_GLPresReportDetails_BenchmarkName] DEFAULT (''),
[BenchmarkValue] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_EXT_GLPresReportDetails_BenchmarkValue] DEFAULT ((0)),
[BenchmarkValue2] [decimal] (18, 6) NULL,
[BenchmarkValue3] [decimal] (18, 6) NULL,
[BenchmarkValue4] [decimal] (18, 6) NULL,
[BenchmarkType] [int] NOT NULL CONSTRAINT [DF_EXT_GLPresReportDetails_BenchmarkType] DEFAULT ((0)),
[BenchmarkDecimals] [int] NOT NULL CONSTRAINT [DF_EXT_GLPresReportDetails_BenchmarkDecimals] DEFAULT ((0)),
[BenchmarkDrillDownType] [int] NOT NULL CONSTRAINT [DF_EXT_GLPresReportDetails_BenchmarkDrillDownType] DEFAULT ((0)),
[BenchmarkDrillDownWhere] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[EXT_GLPresReportDetails] ADD CONSTRAINT [FK_EXT_GLPresReportDetails_RunID_EXT_GLPresReport] FOREIGN KEY ([RunID]) REFERENCES [dbo].[EXT_GLPresReport] ([RunID])
GO