V_QUERY_DISBURSEMENT_FINANCIALTRANSACTION
Query for disbursement financial transactions.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| TRANSACTIONNUMBER | int | Number | |
| NAME | nvarchar(154) | yes | Bank name |
| ACCOUNTNAME | nvarchar(100) | Bank account name | |
| ACCOUNTNUMBER | nvarchar(4000) | Bank account number | |
| AMOUNT | money | Amount | |
| DATE | datetimeoffset | Date | |
| POSTDATE | date | yes | Post date |
| POSTSTATUS | nvarchar(11) | yes | Post status |
| CONSTITUENTID | uniqueidentifier | yes | Constituent ID |
| CONSTITUENTNAME | nvarchar(154) | yes | Payee name |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | Added by application |
| ADDEDBY_USERNAME | nvarchar(128) | yes | Added by user name |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | Changed by application |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | Changed by user name |
| DATEADDED | datetime | Date added | |
| DATECHANGED | datetime | Date changed | |
| TSLONG | bigint | yes | Timestamp value |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:17:55 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_DISBURSEMENT_FINANCIALTRANSACTION AS
select
BAT.ID
,BAT.TRANSACTIONNUMBER
,CBANK.NAME
,BA.ACCOUNTNAME
,BA.ACCOUNTNUMBER
,FT.TRANSACTIONAMOUNT as AMOUNT
,FT.DATE
,FT.POSTDATE
,FT.POSTSTATUS
,FT.CONSTITUENTID
,C.NAME [CONSTITUENTNAME]
,ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION
,ADDEDBY.USERNAME as ADDEDBY_USERNAME
,CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION
,CHANGEDBY.USERNAME as CHANGEDBY_USERNAME
,FT.DATEADDED
,FT.DATECHANGED
,FT.TSLONG
from dbo.FINANCIALTRANSACTION FT
inner join dbo.BANKACCOUNTTRANSACTION BAT on BAT.ID = FT.ID
inner join dbo.BANKACCOUNT as BA on BAT.BANKACCOUNTID = BA.ID
inner join dbo.CONSTITUENT as CBANK on CBANK.ID = BA.BANKID
left join dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = FT.ADDEDBYID
left join dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = FT.CHANGEDBYID
left join dbo.CONSTITUENT as C on C.ID = FT.CONSTITUENTID
where BAT.DELETED = 0 and BAT.PROCESSING = 0