V_QUERY_BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION
Provides the ability to query for bank account deposit correction GL distribution.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | Bank account deposit correction GL Distribution ID | |
| BANKACCOUNTDEPOSITCORRECTIONID | uniqueidentifier | Bank account deposit correction ID | |
| TRANSACTIONTYPE | nvarchar(6) | yes | Transaction type |
| ACCOUNT | nvarchar(100) | Account | |
| PROJECT | nvarchar(100) | Project | |
| AMOUNT | money | yes | Amount |
| BASECURRENCYID | uniqueidentifier | yes | Base currency ID |
| BASEEXCHANGERATEID | uniqueidentifier | yes | Base exchange rate |
| ORGANIZATIONAMOUNT | money | yes | Amount (organization currency) |
| ORGANIZATIONEXCHANGERATEID | uniqueidentifier | yes | Organization exchange rate |
| TRANSACTIONAMOUNT | money | yes | Amount (transaction currency) |
| TRANSACTIONCURRENCYID | uniqueidentifier | yes | Transaction currency ID |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:18:08 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION AS
select
isnull(JEX.DISTRIBUTIONTABLEID, JEX.ID) as ID
,FINANCIALTRANSACTION.ID as BANKACCOUNTDEPOSITCORRECTIONID
,JE.TRANSACTIONTYPE
,GLACCOUNT.ACCOUNTNUMBER as ACCOUNT
,JEX.PROJECT
,case when JE.TYPECODE <> 0 or JE.TRANSACTIONCURRENCYID = '00000000-0000-0000-0000-000000000000' then nullif(JE.BASEAMOUNT, 0) else JE.BASEAMOUNT end [AMOUNT]
,case CURRENCYSET.BASECURRENCYID
when '00000000-0000-0000-0000-000000000000' then null
else CURRENCYSET.BASECURRENCYID end as BASECURRENCYID
,JEX.PRECALCBASEEXCHANGERATEID as BASEEXCHANGERATEID
,case when JE.TYPECODE <> 0 or JE.TRANSACTIONCURRENCYID = '00000000-0000-0000-0000-000000000000' then nullif(JE.ORGAMOUNT, 0) else JE.ORGAMOUNT end [ORGANIZATIONAMOUNT]
,JEX.PRECALCORGANIZATIONEXCHANGERATEID as ORGANIZATIONEXCHANGERATEID
,case when JE.TYPECODE <> 0 or JE.TRANSACTIONCURRENCYID = '00000000-0000-0000-0000-000000000000' then nullif(JE.TRANSACTIONAMOUNT, 0) else JE.TRANSACTIONAMOUNT end [TRANSACTIONAMOUNT]
,case JE.TYPECODE
when 0 then
case JE.TRANSACTIONCURRENCYID
when '00000000-0000-0000-0000-000000000000' then null
else JE.TRANSACTIONCURRENCYID end
else null
end
as TRANSACTIONCURRENCYID
from dbo.JOURNALENTRY JE
inner join dbo.FINANCIALTRANSACTIONLINEITEM on FINANCIALTRANSACTIONLINEITEM.ID = JE.FINANCIALTRANSACTIONLINEITEMID
inner join dbo.FINANCIALTRANSACTION on FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = FINANCIALTRANSACTION.ID
inner join dbo.JOURNALENTRY_EXT JEX on JE.ID = JEX.ID and JEX.TABLENAMECODE = 3
inner join dbo.GLACCOUNT on JE.GLACCOUNTID = GLACCOUNT.ID
inner join dbo.PDACCOUNTSYSTEM on FINANCIALTRANSACTION.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEM.ID
inner join dbo.CURRENCYSET on PDACCOUNTSYSTEM.CURRENCYSETID = CURRENCYSET.ID