Connect Access to Transaction Credit and Debit Amounts

Credit and debit amounts are not exposed as columns in the Transactions or Transaction Lines tables. However, you can obtain transaction credit and debit amounts from the Transaction Lines table with queries like the following:

To obtain the credit amount for a transaction:

          SELECT TRANSACTION_ID, NULLIF(GREATEST(-1*TRANSACTION_LINES.AMOUNT,0),0) "CREDITAMOUNT" FROM TRANSACTION_LINES WHERE COMPANY_ID = YOUR_ID 

        

To obtain the debit amount for a transaction:

          SELECT TRANSACTION_ID, NULLIF(GREATEST(TRANSACTION_LINES.AMOUNT,0),0) "DEBITAMOUNT" FROM TRANSACTION_LINES WHERE COMPANY_ID = YOUR_ID 

        

These results can be useful for financial reporting purposes.

General Notices