I am trying to report on Receipt history but I cannot query or export this information. Is it possible to pull receipt history from SQL tables?
There is receipt information stored in the GIFTRECEIPTHISTORY table. This can be joined back to the GIFT table on the GIFTRECEIPTHISTORY.GIFTID = GIFT.ID column. Details of the table can be found in the screen shot below taken from the database schema.
For additional details and information on the various SQL tables available in The Raiser's Edge, please review the article linked below.