Retrieving Settled Financial Transactions

The following type of query may be used to retrieve the list of transactions that settled (were cleared for payment) within a particular time period:

  select 
    TransactionId, Payment.Amount, Payment.BillingName, Payment.BillingAddress, ... 
  from 
    Donation 
  where 
    Payment.SettlementDate >= 2009-05-01
  and 
    Payment.SettlementDate < 2009-06-01
  and 
    Payment.SettlementStatus = "SETTLED"

This may be useful for reconciling online donations with a bank statement.

Leave a Comment

Nickname
Comment
Enter this word: