sql=[sp_help "tServiceType"
]
tServiceType|dbo|user table|May 10 2005 02:25PM|
 
 
ID|int|no|4|10|0|no|(n/a)|(n/a)|
Code|varchar|no|5|||yes|no|no|
Description|varchar|no|50|||yes|no|no|
SupplierID|int|no|4|10|0|yes|(n/a)|(n/a)|
RevenueElementID|int|no|4|10|0|yes|(n/a)|(n/a)|
ExpenseElementID|int|no|4|10|0|yes|(n/a)|(n/a)|
AdminFee|bit|no|1|||no|(n/a)|(n/a)|
SystemID|int|no|4|10|0|yes|(n/a)|(n/a)|
ExportToTims|bit|no|1|||no|(n/a)|(n/a)|
Active|bit|no|1|||yes|(n/a)|(n/a)|
StartDate|datetime|no|8|||yes|(n/a)|(n/a)|
EndDate|datetime|no|8|||yes|(n/a)|(n/a)|
Userid|int|no|4|10|0|yes|(n/a)|(n/a)|
SplitService|bit|no|1|||no|(n/a)|(n/a)|
VRTServiceType|bit|no|1|||no|(n/a)|(n/a)|
ExpectedRent|money|no|8|19|4|yes|(n/a)|(n/a)|
NoCalls|bit|no|1|||no|(n/a)|(n/a)|
Frequency|int|no|4|10|0|yes|(n/a)|(n/a)|
RateOnly|bit|no|1|||yes|(n/a)|(n/a)|
 
ID|            1.000000|            1.000000|0|
 
No rowguidcol column defined.|
 
PRIMARY|
 
PK_tServiceType|clustered, unique, primary key located on PRIMARY|ID|
_WA_Sys_ID_7E70C1D3|nonclustered, statistics, auto create located on PRIMARY|ID|
_WA_Sys_SupplierID_7E70C1D3|nonclustered, statistics, auto create located on PRIMARY|SupplierID|
_WA_Sys_SystemID_7E70C1D3|nonclustered, statistics, auto create located on PRIMARY|SystemID|
_WA_Sys_RevenueElementID_7E70C1D3|nonclustered, statistics, auto create located on PRIMARY|RevenueElementID|
_WA_Sys_ExpenseElementID_7E70C1D3|nonclustered, statistics, auto create located on PRIMARY|ExpenseElementID|
_WA_Sys_Active_7E70C1D3|nonclustered, statistics, auto create located on PRIMARY|Active|
_WA_Sys_Code_7E70C1D3|nonclustered, statistics, auto create located on PRIMARY|Code|
_WA_Sys_Description_7E70C1D3|nonclustered, statistics, auto create located on PRIMARY|Description|
_WA_Sys_SplitService_7E70C1D3|nonclustered, statistics, auto create located on PRIMARY|SplitService|
_WA_Sys_ExpectedRent_7E70C1D3|nonclustered, statistics, auto create located on PRIMARY|ExpectedRent|
_WA_Sys_NoCalls_7E70C1D3|nonclustered, statistics, auto create located on PRIMARY|NoCalls|
_WA_Sys_Frequency_7E70C1D3|nonclustered, statistics, auto create located on PRIMARY|Frequency|
_WA_Sys_VRTServiceType_7E70C1D3|nonclustered, statistics, auto create located on PRIMARY|VRTServiceType|
 
DEFAULT on column RateOnly|DF_tServiceType_RateOnly|(n/a)|(n/a)|(0)|
PRIMARY KEY (clustered)|PK_tServiceType|(n/a)|(n/a)|ID|
 
No foreign keys reference this table.