Property | Value |
---|---|
Collation | SQL_Latin1_General_CP1_CI_AS |
Heap | True |
Row Count (~) | 0 |
Created | 12:59:19 AM Thursday, March 21, 2019 |
Last Modified | 1:07:57 AM Thursday, March 21, 2019 |
Name | Data Type | Max Length (Bytes) | Allow Nulls | Default |
---|---|---|---|---|
EquipmentID | int | 4 | False | |
EquipLocationID | int | 4 | True | |
EquipCustomerID | int | 4 | True | |
Period | int | 4 | False | |
DatePeriod | int | 4 | False | |
GLPeriod | int | 4 | False | |
ContractID | int | 4 | True | |
ContractMajor | varchar(32) | 32 | True | |
BillingTypeID | int | 4 | False | |
InvoiceID | int | 4 | True | |
ItemID | int | 4 | True | |
Quantity | decimal(18,6) | 9 | True | ((0)) |
Amount | money | 8 | False | |
Cost | money | 8 | False | |
MeterID | int | 4 | True | |
MeterTotal | decimal(18,0) | 9 | True | |
OverageMeterTotal | decimal(18,0) | 9 | True | |
BilledMeterTotal | decimal(18,0) | 9 | True | |
UnderageMeterTotal | decimal(18,0) | 9 | True | |
MeterBW | decimal(18,0) | 9 | True | |
OverageMeterBW | decimal(18,0) | 9 | True | |
BilledMeterBW | decimal(18,0) | 9 | True | |
UnderageMeterBW | decimal(18,0) | 9 | True | |
MeterColor | decimal(18,0) | 9 | True | |
OverageMeterColor | decimal(18,0) | 9 | True | |
BilledMeterColor | decimal(18,0) | 9 | True | |
UnderageMeterColor | decimal(18,0) | 9 | True | |
MeterScanner | decimal(18,0) | 9 | True | |
OverageMeterScanner | decimal(18,0) | 9 | True | |
BilledMeterScanner | decimal(18,0) | 9 | True | |
UnderageMeterScanner | decimal(18,0) | 9 | True | |
MeterOther | decimal(18,0) | 9 | True | |
OverageMeterOther | decimal(18,0) | 9 | True | |
BilledMeterOther | decimal(18,0) | 9 | True | |
UnderageMeterOther | decimal(18,0) | 9 | True | |
CostBW | money | 8 | False | ((0)) |
CostColor | money | 8 | False | ((0)) |