sql=[sp_help "tInvoice"
]
tInvoice|dbo|user table|May 10 2005 02:25PM|
 
 
ID|int|no|4|10|0|no|(n/a)|(n/a)||
CustomerID|int|no|4|10|0|yes|(n/a)|(n/a)||
InvoiceDate|datetime|no|8|||yes|(n/a)|(n/a)||
PlatinumFileName|varchar|no|255|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
PlatinumInvoiceNo|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
AuditControl|varchar|no|20|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
CreditNoteFlag|tinyint|no|1|3|0|yes|(n/a)|(n/a)||
CreditNoteInvID|int|no|4|10|0|yes|(n/a)|(n/a)||
ReportedFlag|bit|no|1|||yes|(n/a)|(n/a)||
UserName|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
GSTAmount|money|no|8|19|4|yes|(n/a)|(n/a)||
Comment|varchar|no|255|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
StatusID|int|no|4|10|0|yes|(n/a)|(n/a)||
PaymentReceivedDate|datetime|no|8|||yes|(n/a)|(n/a)||
PaymentReceivedAmount|money|no|8|19|4|yes|(n/a)|(n/a)||
PlatinumInvoiceAmount|money|no|8|19|4|yes|(n/a)|(n/a)||
 
ID|            1.000000|            1.000000|0|
 
No rowguidcol column defined.|
 
PRIMARY|
 
IX_tInvoice|nonclustered located on PRIMARY|CustomerID|
IX_tInvoice_1|nonclustered located on PRIMARY|PlatinumInvoiceNo|
PK_tInvoice|clustered, unique, primary key located on PRIMARY|ID|
 
DEFAULT on column CreditNoteFlag|DF_tInvoice_CreditNoteFlag|(n/a)|(n/a)|(n/a)|(n/a)|(0)|
DEFAULT on column PaymentReceivedAmount|DF_tInvoice_PaymentReceivedAmount|(n/a)|(n/a)|(n/a)|(n/a)|(0)|
DEFAULT on column ReportedFlag|DF_tInvoice_ReportedFlag|(n/a)|(n/a)|(n/a)|(n/a)|(0)|
DEFAULT on column StatusID|DF_tInvoice_StatusID|(n/a)|(n/a)|(n/a)|(n/a)|(10)|
PRIMARY KEY (clustered)|PK_tInvoice|(n/a)|(n/a)|(n/a)|(n/a)|ID|
 
No foreign keys reference table 'tInvoice', or you do not have permissions on
referencing tables.
No views with schema binding reference table 'tInvoice'.