ClientMerchantAccounts
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| Name | nvarchar(100) | yes | ||
| Active | bit | |||
| BBPSID | uniqueidentifier | |||
| XMLTransactionInfo | xml | yes |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ClientsID | int | yes | Clients.ID | |
| ClientSitesID | int | yes | ClientSites.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| PK_ClientMerchantAccounts | ID | yes | yes | |
| UIX_ClientMerchantAccounts_BBPSID | BBPSID | yes |
Referenced by
| Referenced by | Field |
|---|---|
| ClientDonations | MerchantAccount |
| ClientEvents | MerchantAccount |
| ClientMemberships | MerchantAccount |
| ShoppingCartPart | MerchantAccountID |