Sales.CreditCard (table)

From dbscript Online Help
Revision as of 14:33, 3 January 2009 by Bot (talk | contribs) (New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.CreditCard |- |} {| border="1" cellpadding="5" cellspacing="0" style="...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

wikibot

Table Sales.CreditCard


Column Data Type Nullable Default PK Index
CreditCardID int not null PK_CreditCard_CreditCardID
CardType nvarchar(50) not null
CardNumber nvarchar(25) not null AK_CreditCard_CardNumber
ExpMonth tinyint not null
ExpYear smallint not null
ModifiedDate datetime not null (getdate())


Detail Table Column Referencing Column
Sales.ContactCreditCard CreditCardID CreditCardID
Sales.SalesOrderHeader CreditCardID CreditCardID