Primary Key Field Type
 ID int

Field Field Type Null Notes Description
 Name nvarchar(100)
 Active bit  
 BBPSID uniqueidentifier  
 XMLTransactionInfo xml

Foreign Key Field Type Null Notes Description
 ClientsID int Clients.ID
 ClientSitesID int ClientSites.ID

Index Name Field(s) Unique Primary Clustered
 PK_ClientMerchantAccounts ID  
 UIX_ClientMerchantAccounts_BBPSID BBPSID    

Referenced by Field
 ClientDonations MerchantAccount
 ClientEvents MerchantAccount
 ClientMemberships MerchantAccount
 ShoppingCartPart MerchantAccountID

Entity-Relationship diagram of this table