sql=[sp_help "tServiceID"
]
tServiceID|dbo|user table|May 10 2005 02:25:10:607PM|
 
 
ID|int|no|4|10|0|no|(n/a)|(n/a)||
ServiceID|varchar|no|50| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Service|varchar|no|50| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
ServiceTypeID|int|no|4|10|0|yes|(n/a)|(n/a)||
SACCnumber|varchar|no|50| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Description|varchar|no|70| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
SupplierAccountID|int|no|4|10|0|yes|(n/a)|(n/a)||
CustomerCentreID|int|no|4|10|0|yes|(n/a)|(n/a)||
CustomerActivityID|int|no|4|10|0|yes|(n/a)|(n/a)||
CustomerElementID|int|no|4|10|0|yes|(n/a)|(n/a)||
CustomerSubLedgerID|int|no|4|10|0|yes|(n/a)|(n/a)||
CentreID|int|no|4|10|0|yes|(n/a)|(n/a)||
ActivityID|int|no|4|10|0|yes|(n/a)|(n/a)||
ElementID|int|no|4|10|0|yes|(n/a)|(n/a)||
SubledgerID|int|no|4|10|0|yes|(n/a)|(n/a)||
LocationID|int|no|4|10|0|yes|(n/a)|(n/a)||
CurrentRent|money|no|8|19|4|yes|(n/a)|(n/a)||
CurrentCalls|money|no|8|19|4|yes|(n/a)|(n/a)||
PreviousRent|money|no|8|19|4|yes|(n/a)|(n/a)||
PreviousCalls|money|no|8|19|4|yes|(n/a)|(n/a)||
InstallationDate|datetime|no|8| | |yes|(n/a)|(n/a)||
TerminationDate|datetime|no|8| | |yes|(n/a)|(n/a)||
PersonID|int|no|4|10|0|yes|(n/a)|(n/a)||
UpEnd|varchar|no|23| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
UpFrameID|int|no|4|10|0|yes|(n/a)|(n/a)||
UpMDF|varchar|no|6| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
DownEnd|varchar|no|23| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
DnFrameID|int|no|4|10|0|yes|(n/a)|(n/a)||
DownMDF|varchar|no|6| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Length|float|no|8|53||yes|(n/a)|(n/a)||
No|varchar|no|7| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Part|varchar|no|2| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
ServiceCode|nvarchar|no|120| | |yes|(n/a)|(n/a)|SQL_Latin1_General_CP1_CI_AS|
JobNo|varchar|no|10| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
BearerID|int|no|4|10|0|yes|(n/a)|(n/a)||
SpeedID|int|no|4|10|0|yes|(n/a)|(n/a)||
Drawing|varchar|no|10| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
ModemTypeID|int|no|4|10|0|yes|(n/a)|(n/a)||
Cost|float|no|8|53||yes|(n/a)|(n/a)||
Cost100|float|no|8|53||yes|(n/a)|(n/a)||
Make|varchar|no|12| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Ch|float|no|8|53||yes|(n/a)|(n/a)||
Mux|varchar|no|7| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
LineID|int|no|4|10|0|yes|(n/a)|(n/a)||
StartTerminalID|int|no|4|10|0|yes|(n/a)|(n/a)||
StatusID|int|no|4|10|0|yes|(n/a)|(n/a)||
Active|bit|no|1| | |yes|(n/a)|(n/a)||
PayType|varchar|no|2| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
DateEntered|datetime|no|8| | |yes|(n/a)|(n/a)||
DateLastChanged|datetime|no|8| | |yes|(n/a)|(n/a)||
LastUpdatedBy|varchar|no|50| | |yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Invoiced|float|no|8|53||yes|(n/a)|(n/a)||
TelcoID|int|no|4|10|0|yes|(n/a)|(n/a)||
ApplicationID|int|no|4|10|0|yes|(n/a)|(n/a)||
AuthorityID|int|no|4|10|0|yes|(n/a)|(n/a)||
VirtualCableID|int|no|4|10|0|yes|(n/a)|(n/a)||
MUXLink|nvarchar|no|30| | |yes|(n/a)|(n/a)|SQL_Latin1_General_CP1_CI_AS|
ServiceLink|nvarchar|no|20| | |yes|(n/a)|(n/a)|SQL_Latin1_General_CP1_CI_AS|
ServiceMnemonicID|int|no|4|10|0|yes|(n/a)|(n/a)||
ServiceKpiID|int|no|4|10|0|yes|(n/a)|(n/a)||
 
ID|            1.000000|            1.000000|0|
 
No rowguidcol column defined.|
 
PRIMARY|
 
IX_tServiceID|nonclustered located on PRIMARY|ServiceTypeID|
IX_tServiceID_1|nonclustered located on PRIMARY|CustomerElementID|
IXtServiceID_ServiceID|nonclustered located on PRIMARY|ServiceID|
PK_tServiceID|clustered, unique, primary key located on PRIMARY|ID|
 
PRIMARY KEY (clustered)|PK_tServiceID|(n/a)|(n/a)|(n/a)|(n/a)|ID|
 
No foreign keys reference table 'tServiceID', or you do not have permissions on
referencing tables.
No views with schema binding reference table 'tServiceID'.