Tables [dbo].[SCSuperReportEx]
PropertyValue
HeapTrue
Row Count (~)0
Created1:00:21 AM Thursday, March 21, 2019
Last Modified1:09:25 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow NullsDefault
EquipmentIDint4
False
FromPeriodint4
False
ToPeriodint4
False
PeriodCountint4
False
EquipLocationIDint4
True
EquipCustomerIDint4
True
TotalRevenuemoney8
True
TotalCostmoney8
True
LaborRevenuemoney8
True
LaborCostmoney8
True
PartsRevenuemoney8
True
PartsCostmoney8
True
SuppliesRevenuemoney8
True
SuppliesCostmoney8
True
TonerCostBWmoney8
True
TonerCostColormoney8
True
OtherRevenuemoney8
True
OtherCostmoney8
True
MeterTotaldecimal(18,0)9
True
MeterBWdecimal(18,0)9
True
MeterColordecimal(18,0)9
True
OverageMeterTotaldecimal(18,0)9
True
BilledMeterTotaldecimal(18,0)9
True
UnderageMeterTotaldecimal(18,0)9
True
MCBVint4
False
((0))
MCBFint4
False
((0))
MTBVdecimal(12,2)9
False
((0))
MTBFdecimal(12,2)9
False
((0))
AvgRepairAndTravelHoursdecimal(12,2)9
False
((0))
ReqMonthlyCallsdecimal(12,3)9
False
((0))
ReqMonthlyServiceHoursdecimal(12,2)9
False
((0))
ManpowerRequireddecimal(12,5)9
False
((0))
CREATE TABLE [dbo].[SCSuperReportEx]
(
[EquipmentID] [int] NOT NULL,
[FromPeriod] [int] NOT NULL,
[ToPeriod] [int] NOT NULL,
[PeriodCount] [int] NOT NULL,
[EquipLocationID] [int] NULL,
[EquipCustomerID] [int] NULL,
[TotalRevenue] [money] NULL,
[TotalCost] [money] NULL,
[LaborRevenue] [money] NULL,
[LaborCost] [money] NULL,
[PartsRevenue] [money] NULL,
[PartsCost] [money] NULL,
[SuppliesRevenue] [money] NULL,
[SuppliesCost] [money] NULL,
[TonerCostBW] [money] NULL,
[TonerCostColor] [money] NULL,
[OtherRevenue] [money] NULL,
[OtherCost] [money] NULL,
[MeterTotal] [decimal] (18, 0) NULL,
[MeterBW] [decimal] (18, 0) NULL,
[MeterColor] [decimal] (18, 0) NULL,
[OverageMeterTotal] [decimal] (18, 0) NULL,
[BilledMeterTotal] [decimal] (18, 0) NULL,
[UnderageMeterTotal] [decimal] (18, 0) NULL,
[MCBV] [int] NOT NULL CONSTRAINT [DF_SCSuperReportEx_MCBV] DEFAULT ((0)),
[MCBF] [int] NOT NULL CONSTRAINT [DF_SCSuperReportEx_MCBF] DEFAULT ((0)),
[MTBV] [decimal] (12, 2) NOT NULL CONSTRAINT [DF_SCSuperReportEx_MTBV] DEFAULT ((0)),
[MTBF] [decimal] (12, 2) NOT NULL CONSTRAINT [DF_SCSuperReportEx_MTBF] DEFAULT ((0)),
[AvgRepairAndTravelHours] [decimal] (12, 2) NOT NULL CONSTRAINT [DF_SCSuperReportEx_AvgRepairAndTravelHours] DEFAULT ((0)),
[ReqMonthlyCalls] [decimal] (12, 3) NOT NULL CONSTRAINT [DF_SCSuperReportEx_ReqMonthlyCalls] DEFAULT ((0)),
[ReqMonthlyServiceHours] [decimal] (12, 2) NOT NULL CONSTRAINT [DF_SCSuperReportEx_ReqMonthlyServiceHours] DEFAULT ((0)),
[ManpowerRequired] [decimal] (12, 5) NOT NULL CONSTRAINT [DF_SCSuperReportEx_ManpowerRequired] DEFAULT ((0))
) ON [PRIMARY]
GO