Property | Value |
---|---|
Collation | SQL_Latin1_General_CP1_CI_AS |
Heap | True |
Row Count (~) | 0 |
Created | 12:57:26 AM Thursday, March 21, 2019 |
Last Modified | 12:57:26 AM Thursday, March 21, 2019 |
Name | Data Type | Max Length (Bytes) | Allow Nulls | Identity |
---|---|---|---|---|
ConfigQuoteDetailsID | int | 4 | False | 1 - 1 |
ConfigQuoteID | int | 4 | False | |
comments | varchar(256) | 256 | True | |
requesteddeliverdate | datetime | 8 | True | |
submitdate | datetime | 8 | True | |
businesstype | int | 4 | True | |
ShipVia | varchar(50) | 50 | True | |
installtype | varchar(50) | 50 | True | |
ShipToAddress | varchar(64) | 64 | True | |
ShipToCity | varchar(32) | 32 | True | |
ShipToState | varchar(16) | 16 | True | |
ShipToZip | varchar(16) | 16 | True | |
ShipToCountry | varchar(16) | 16 | True | |
BillToAddress | varchar(64) | 64 | True | |
BillToCity | varchar(32) | 32 | True | |
BillToState | varchar(16) | 16 | True | |
BillToZip | varchar(16) | 16 | True | |
BillToCountry | varchar(16) | 16 | True | |
DeliveryContact | varchar(64) | 64 | True | |
DeliveryPhone | varchar(30) | 30 | True | |
DeliveryEMail | varchar(50) | 50 | True | |
MeterContact | varchar(64) | 64 | True | |
MeterPhone | varchar(30) | 30 | True | |
MeterEMail | varchar(50) | 50 | True | |
ConnectedContact | varchar(64) | 64 | True | |
ConnectedPhone | varchar(30) | 30 | True | |
ConnectedEMail | varchar(50) | 50 | True | |
DocMGTContact | varchar(64) | 64 | True | |
DocMGTPhone | varchar(30) | 30 | True | |
DocMGTEMail | varchar(50) | 50 | True | |
ISStairs | bit | 1 | True | |
ISPower | bit | 1 | True | |
ISResidential | bit | 1 | True | |
NodeExpirationDate | datetime | 8 | True | |
CreateDate | datetime | 8 | True | |
CreateUser | char(8) | 8 | True | |
LastUpdate | datetime | 8 | True | |
UpdatorID | char(8) | 8 | True | |
CustomerID | int | 4 | True | |
LocationID | int | 4 | True | |
BilltoID | int | 4 | True |