Property | Value |
---|---|
Heap | True |
Row Count (~) | 0 |
Created | 1:00:21 AM Thursday, March 21, 2019 |
Last Modified | 1:09:25 AM Thursday, March 21, 2019 |
Name | Data Type | Max Length (Bytes) | Allow Nulls | Default |
---|---|---|---|---|
EquipmentID | int | 4 | False | |
FromPeriod | int | 4 | False | |
ToPeriod | int | 4 | False | |
PeriodCount | int | 4 | False | |
EquipLocationID | int | 4 | True | |
EquipCustomerID | int | 4 | True | |
TotalRevenue | money | 8 | True | |
TotalCost | money | 8 | True | |
LaborRevenue | money | 8 | True | |
LaborCost | money | 8 | True | |
PartsRevenue | money | 8 | True | |
PartsCost | money | 8 | True | |
SuppliesRevenue | money | 8 | True | |
SuppliesCost | money | 8 | True | |
TonerCostBW | money | 8 | True | |
TonerCostColor | money | 8 | True | |
OtherRevenue | money | 8 | True | |
OtherCost | money | 8 | True | |
MeterTotal | decimal(18,0) | 9 | True | |
MeterBW | decimal(18,0) | 9 | True | |
MeterColor | decimal(18,0) | 9 | True | |
OverageMeterTotal | decimal(18,0) | 9 | True | |
BilledMeterTotal | decimal(18,0) | 9 | True | |
UnderageMeterTotal | decimal(18,0) | 9 | True | |
MCBV | int | 4 | False | ((0)) |
MCBF | int | 4 | False | ((0)) |
MTBV | decimal(12,2) | 9 | False | ((0)) |
MTBF | decimal(12,2) | 9 | False | ((0)) |
AvgRepairAndTravelHours | decimal(12,2) | 9 | False | ((0)) |
ReqMonthlyCalls | decimal(12,3) | 9 | False | ((0)) |
ReqMonthlyServiceHours | decimal(12,2) | 9 | False | ((0)) |
ManpowerRequired | decimal(12,5) | 9 | False | ((0)) |