Tables [dbo].[EXT_GLPresReportDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:57:21 AM Thursday, March 21, 2019
Last Modified1:10:49 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Foreign Keys FK_EXT_GLPresReportDetails_RunID_EXT_GLPresReport: [dbo].[EXT_GLPresReport].RunIDRunIDint4
True
ReportLeaseIDint4
True
CategoryIDint4
True
Categoryvarchar(64)64
True
PresAccountIDint4
True
PresAccountvarchar(64)64
False
('')
ISTypevarchar(64)64
True
RptSectionvarchar(64)64
True
OrderByint4
True
Totalmoney8
True
SUMFlagint4
True
% of GP$decimal(10,4)9
False
((0))
MPSmoney8
False
((0))
Copiermoney8
False
((0))
Othermoney8
False
((0))
Multiplierint4
False
((-1))
UnmappedAmountmoney8
False
((0))
AllCompanyTotalmoney8
False
((0))
BenchmarkGroupNamevarchar(64)64
False
('')
BenchmarkNamevarchar(64)64
False
('')
BenchmarkValuedecimal(18,6)9
False
((0))
BenchmarkValue2decimal(18,6)9
True
BenchmarkValue3decimal(18,6)9
True
BenchmarkValue4decimal(18,6)9
True
BenchmarkTypeint4
False
((0))
BenchmarkDecimalsint4
False
((0))
BenchmarkDrillDownTypeint4
False
((0))
BenchmarkDrillDownWherevarchar(256)256
True
NameColumns
FK_EXT_GLPresReportDetails_RunID_EXT_GLPresReportRunID->[dbo].[EXT_GLPresReport].[RunID]
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