sql=[sp_help "tFinalisedTransaction201201"
]
tFinalisedTransaction201201|dbo|user table|Jan 19 2012 02:13PM|
 
 
ID|int|no|4|10|0|no|(n/a)|(n/a)||
BatchID|int|no|4|10|0|yes|(n/a)|(n/a)||
ServiceID|int|no|4|10|0|yes|(n/a)|(n/a)||
ServiceTypeID|int|no|4|10|0|yes|(n/a)|(n/a)||
DataRefID|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)||
DepartmentID|int|no|4|10|0|yes|(n/a)|(n/a)||
GroupID|int|no|4|10|0|yes|(n/a)|(n/a)||
LocationID|int|no|4|10|0|yes|(n/a)|(n/a)||
RevenueElementID|int|no|4|10|0|yes|(n/a)|(n/a)||
ExpenditureElementID|int|no|4|10|0|yes|(n/a)|(n/a)||
StatusID|int|no|4|10|0|yes|(n/a)|(n/a)||
ErrorID|int|no|4|10|0|yes|(n/a)|(n/a)||
PersonID|int|no|4|10|0|yes|(n/a)|(n/a)||
Length|float|no|8|53||yes|(n/a)|(n/a)||
TxnDate|datetime|no|8|||yes|(n/a)|(n/a)||
OriginID|int|no|4|10|0|yes|(n/a)|(n/a)||
DestinationID|int|no|4|10|0|yes|(n/a)|(n/a)||
Duration|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
CallCode|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
DialledNumberID|int|no|4|10|0|yes|(n/a)|(n/a)||
GSTFlag|bit|no|1|||no|(n/a)|(n/a)||
AmountExGST|money|no|8|19|4|yes|(n/a)|(n/a)||
GSTAmount|money|no|8|19|4|yes|(n/a)|(n/a)||
AmountIncGST|money|no|8|19|4|yes|(n/a)|(n/a)||
FromDate|datetime|no|8|||yes|(n/a)|(n/a)||
ToDate|datetime|no|8|||yes|(n/a)|(n/a)||
CustomerID|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)||
TransactionTypeID|int|no|4|10|0|yes|(n/a)|(n/a)||
TransactionRef|int|no|4|10|0|yes|(n/a)|(n/a)||
TransactionGroup|int|no|4|10|0|yes|(n/a)|(n/a)||
RevenueFlag|bit|no|1|||no|(n/a)|(n/a)||
Var01|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Var02|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Var03|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Var04|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Var05|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Var06|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Var07|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Var08|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Var09|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Var10|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Var11|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Var12|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Var13|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Var14|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Var15|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
InvoiceDetailID|int|no|4|10|0|yes|(n/a)|(n/a)||
PayableDetailID|int|no|4|10|0|yes|(n/a)|(n/a)||
RateDescriptionID|int|no|4|10|0|yes|(n/a)|(n/a)||
Peak|bit|no|1|||yes|(n/a)|(n/a)||
PayType|varchar|no|2|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
SupplierServiceCodeID|int|no|4|10|0|yes|(n/a)|(n/a)||
 
ID|            1.000000|            1.000000|0|
 
No rowguidcol column defined.|
 
PRIMARY|
 
IX_tFinalisedTransaction201201_Batch|nonclustered located on PRIMARY|BatchID|
IX_tFinalisedTransaction201201_CustomerID|nonclustered located on PRIMARY|CustomerID|
IX_tFinalisedTransaction201201_Element|nonclustered located on PRIMARY|ElementID|
IX_tFinalisedTransaction201201_Invoice|nonclustered located on PRIMARY|InvoiceDetailID|
IX_tFinalisedTransaction201201_Payable|nonclustered located on PRIMARY|PayableDetailID|
IX_tFinalisedTransaction201201_Service|nonclustered located on PRIMARY|ServiceID|
PK_tFinalisedTransaction201201|clustered, unique, primary key located on PRIMARY|ID|
 
DEFAULT on column AmountExGST|DF_tFinalisedTransaction201201_AmountExGST|(n/a)|(n/a)|(n/a)|(n/a)|((0))|
DEFAULT on column AmountIncGST|DF_tFinalisedTransaction201201_AmountIncGST|(n/a)|(n/a)|(n/a)|(n/a)|((0))|
DEFAULT on column GSTAmount|DF_tFinalisedTransaction201201_GSTAmount|(n/a)|(n/a)|(n/a)|(n/a)|((0))|
PRIMARY KEY (clustered)|PK_tFinalisedTransaction201201|(n/a)|(n/a)|(n/a)|(n/a)|ID|
 
No foreign keys reference table 'tFinalisedTransaction201201', or you do not
have permissions on referencing tables.
No views with schema binding reference table 'tFinalisedTransaction201201'.