MerchantAccountFormUsage
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| FormGUID | uniqueidentifier | ||
| MerchantAccountID | int | ||
| FormTitle | nvarchar(200) | ||
| DataSourceGUID | uniqueidentifier | ||
| MerchantAccountName | nvarchar(100) | yes | |
| FormID | int |
Definition
Copy
CREATE VIEW [dbo].[MerchantAccountFormUsage] as
select S.FormGUID, S.MerchantAccountID, E.Title [FormTitle], D.DataSource [DataSourceGUID], M.Name [MerchantAccountName], E.ID [FormID] from dbo.CustomFormPaymentSetting S
inner join dbo.CustomFormElement E on S.FormGUID = E.Guid
inner join dbo.CustomFormDataSource D on S.FormGUID = D.FormGuid
inner join dbo.ClientMerchantAccounts M on S.MerchantAccountID = M.ID