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'.