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