Tables [dbo].[rptGLPresTransDetail_Benchmarks_EX]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:58:50 AM Thursday, March 21, 2019
Last Modified1:05:46 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
RowIDint4
False
1 - 1
ReportLeaseIDint4
False
TransactionDetailIDint4
True
AccountIDint4
False
DeptIDint4
True
ItemIDint4
True
ModelIDint4
True
ParentModelIDint4
True
EquipmentIDint4
True
MeterIDint4
True
OrigAmountmoney8
False
Amountmoney8
False
MonthlyAmountmoney8
False
((0))
TransactionTypeIDint4
False
Referencevarchar(512)512
True
SubReferencevarchar(64)64
True
Datedatetime8
False
Periodint4
False
BranchIDint4
True
Descriptionvarchar(255)255
True
ContractIDint4
True
CustomerIDint4
True
BillToIDint4
True
SegmentIDint4
True
CategoryIDint4
True
Categoryvarchar(64)64
True
PresAccountIDvarchar(64)64
True
Percentagedecimal(16,4)9
True
Multiplierint4
False
((1))
CountedCopiesint4
True
OrigMeterCovCopiesint4
True
CoveredCopiesint4
True
MonthlyCovCopiesint4
True
BillableCopiesint4
True
MonthlyBillableCopiesint4
True
FromDatedatetime8
True
ToDatedatetime8
True
NoMonthsint4
True
TypeIDint4
True
CREATE TABLE [dbo].[rptGLPresTransDetail_Benchmarks_EX]
(
[RowID] [int] NOT NULL IDENTITY(1, 1),
[ReportLeaseID] [int] NOT NULL,
[TransactionDetailID] [int] NULL,
[AccountID] [int] NOT NULL,
[DeptID] [int] NULL,
[ItemID] [int] NULL,
[ModelID] [int] NULL,
[ParentModelID] [int] NULL,
[EquipmentID] [int] NULL,
[MeterID] [int] NULL,
[OrigAmount] [money] NOT NULL,
[Amount] [money] NOT NULL,
[MonthlyAmount] [money] NOT NULL CONSTRAINT [DF_rptGLPresTransDetail_Benchmarks_EX_MonthlyAmount] DEFAULT ((0)),
[TransactionTypeID] [int] NOT NULL,
[Reference] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SubReference] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Date] [datetime] NOT NULL,
[Period] [int] NOT NULL,
[BranchID] [int] NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContractID] [int] NULL,
[CustomerID] [int] NULL,
[BillToID] [int] NULL,
[SegmentID] [int] NULL,
[CategoryID] [int] NULL,
[Category] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PresAccountID] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Percentage] [decimal] (16, 4) NULL,
[Multiplier] [int] NOT NULL CONSTRAINT [DF_rptGLPresTransDetail_Benchmarks_EX_Multiplier] DEFAULT ((1)),
[CountedCopies] [int] NULL,
[OrigMeterCovCopies] [int] NULL,
[CoveredCopies] [int] NULL,
[MonthlyCovCopies] [int] NULL,
[BillableCopies] [int] NULL,
[MonthlyBillableCopies] [int] NULL,
[FromDate] [datetime] NULL,
[ToDate] [datetime] NULL,
[NoMonths] [int] NULL,
[TypeID] [int] NULL
) ON [PRIMARY]
GO