Property | Value |
---|---|
Collation | SQL_Latin1_General_CP1_CI_AS |
Heap | True |
Row Count (~) | 0 |
Created | 1:00:45 AM Thursday, March 21, 2019 |
Last Modified | 1:00:45 AM Thursday, March 21, 2019 |
Name | Data Type | Max Length (Bytes) | Allow Nulls |
---|---|---|---|
EquipmentNumber | varchar(30) | 30 | True |
SerialNumber | varchar(50) | 50 | True |
Model | varchar(50) | 50 | True |
Equipmentid | int | 4 | True |
Contractid | int | 4 | True |
ContractNumber | varchar(35) | 35 | True |
ContractCode | varchar(15) | 15 | True |
ContractCodeDesc | varchar(50) | 50 | True |
StartDate | datetime | 8 | True |
ExpDate | datetime | 8 | True |
ContractCustomerid | int | 4 | True |
ContractBillToId | int | 4 | True |
ContractBranchId | int | 4 | True |
ContractBillToName | varchar(128) | 128 | True |
ExpCopies | int | 4 | True |
AccumCopies | int | 4 | True |
AccumCopiesCurrent | int | 4 | True |
PercentCompleteByCopies | decimal(18,0) | 9 | True |
PercentCompleteByDate | decimal(18,0) | 9 | True |
CurrentAndActive | bit | 1 | True |
Active | bit | 1 | True |
BillCode | varchar(30) | 30 | True |
BillCodeDesc | varchar(50) | 50 | True |
PONumber | varchar(50) | 50 | True |
Expired | bit | 1 | True |
EquipStartDate | datetime | 8 | True |
EquipRemoveDate | datetime | 8 | True |
EquipCustomerId | int | 4 | True |
EquipParentCustomerId | int | 4 | True |
Metertype | varchar(50) | 50 | True |
MeterRate | decimal(14,6) | 9 | True |
MeterCoveredCopies | int | 4 | True |
MeterCount | int | 4 | True |
BaseRate | money | 8 | True |
BaseBillingCycle | varchar(15) | 15 | True |
BaseNextBillingDate | datetime | 8 | True |
BaseLastBillingDate | datetime | 8 | True |
BaseSumIndividual | bit | 1 | True |
OvgBillingCycle | varchar(15) | 15 | True |
OvgNextBillingDate | datetime | 8 | True |
OvgLastBillingDate | datetime | 8 | True |
MeterGroupid | int | 4 | True |