ODBC guide

Read account charges

Gets charges for accounts. Use the AccountCharges table. Optionally filter by Email, CustomKey, OrderID, OrderReference, SubscriptionId, Products, Refunds, SubscriptionStatus in the WITH clause.

SELECT * FROM AccountCharges 

--search by one or more parameters below
/*
WITH (
	  Email='X'
	, CustomKey='X'
	, GlobalKey='X'
	, OrderID='X'
	, OrderReference='X'
	, SubscriptionId='X'
	, Products='PROD-1,PROD-2,PROD-3'
	, Refunds='true'
	, SubscriptionStatus='active'
)
*/