Voucher -> Payment detail for Pcard
Hi AP experts.
I'm having problems coming up with SQL that will find payment information(ex. payment date) for PROCARD vouchers paid to JPM. I tried to join the PYMNT_VCHR_XREF to the PAYMENT_TBL, but I'm coming up with nothing. I think this is because the PYMNT_ID is blank on the XREF table. I notice that non-PROCARD(ex. employee reimbursements) have a PYMNT_ID on the XREF and thus the join to the PAYMENT_TBL works to get the payment date. How is this payment verse to JPM(PCard) handled differently? Is there a table I'm missing that links PCard vouchers to the payment table? Note. I can find