V_BASECURRENCYFORFINANCIALTRANSACTION_I
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| FINANCIALTRANSACTIONID | uniqueidentifier | ||
| BASECURRENCYID | uniqueidentifier |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| UIX_V_BASECURRENCYFORFINANCIALTRANSACTION_I_FINANCIALTRANSACTIONID | FINANCIALTRANSACTIONID | yes | yes |
Definition
Copy
CREATE view [dbo].[V_BASECURRENCYFORFINANCIALTRANSACTION_I]
with schemabinding
as
select FINANCIALTRANSACTION.ID as FINANCIALTRANSACTIONID, CURRENCYSET.BASECURRENCYID
from dbo.FINANCIALTRANSACTION inner join dbo.PDACCOUNTSYSTEM on FINANCIALTRANSACTION.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEM.ID
inner join dbo.CURRENCYSET on PDACCOUNTSYSTEM.CURRENCYSETID = CURRENCYSET.ID