Tuesday, 17 September 2019

Bank Statement report

SELECT c.bank_account_num,
  a.statement_number,
  a.statement_date,
  a.creation_date,
  a.GL_Date,
  b.TRX_Date,
  b.trx_type,
  b.Amount,
  b.Status,
  b.Bank_trx_number,
  b.trx_text,
  b.customer_text,
  b.bank_account_text,
  b.Invoice_text,
  b.Original_amount,
  b.charges_Amount,
  b.trx_code
FROM apps.CE_STATEMENT_HEADERS a ,
            apps.CE_STATEMENT_LINES b ,
            apps.ce_bank_accounts c
WHERE c.bank_account_id  IN (XXXX)
AND a.statement_header_id = b.statement_header_id
AND a.bank_account_id     = c.bank_account_id
ORDER BY a.statement_number

3 comments: