Identify Payment transactions in ap_credit_card_trxns_all table for AMEX
Hello,
Background:
By looking at AMEX credit card statements, it was identified that credit card Payments done by employees to AMEX are showing up in ERP iExpense,
when users prepare their exp reports, amex payments trx are visible under credit card transactions tab.
Hence we need to delete those Payment transactions of AMEX credit cards.
So can you pls help on which criteria or Columns of ap_credit_card_trxns_all table , the query should be written so that it ONLY returns the AMEX Payment transactions ??
For sample payment trx , i found below column values in the table :
table :: ap_credit_card_trxns_all