sql=[sp_help "tInvoiceDetail"
]
tInvoiceDetail|dbo|user table|May 10 2005 02:25PM|
 
 
ID|int|no|4|10|0|no|(n/a)|(n/a)||
InvoiceID|int|no|4|10|0|yes|(n/a)|(n/a)||
BatchTypeID|int|no|4|10|0|yes|(n/a)|(n/a)||
Period|varchar|no|7|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
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)||
AmountExGST|money|no|8|19|4|yes|(n/a)|(n/a)||
GSTAmount|money|no|8|19|4|yes|(n/a)|(n/a)||
BatchID|int|no|4|10|0|yes|(n/a)|(n/a)||
Description|varchar|no|100|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
CreditNoteInvoiceDetailID|int|no|4|10|0|yes|(n/a)|(n/a)||
CreditNotePeriod|varchar|no|7|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
SubledgerID|int|no|4|10|0|yes|(n/a)|(n/a)||
 
ID|            1.000000|            1.000000|0|
 
No rowguidcol column defined.|
 
PRIMARY|
 
IX_tInvoiceDetail|nonclustered located on PRIMARY|InvoiceID|
IX_tInvoiceDetail_1|nonclustered located on PRIMARY|BatchTypeID|
IX_tInvoiceDetail_2|nonclustered located on PRIMARY|Period|
PK_tInvoiceDetail|clustered, unique, primary key located on PRIMARY|ID|
 
PRIMARY KEY (clustered)|PK_tInvoiceDetail|(n/a)|(n/a)|(n/a)|(n/a)|ID|
 
No foreign keys reference table 'tInvoiceDetail', or you do not have permissions
on referencing tables.
No views with schema binding reference table 'tInvoiceDetail'.