Update PYMNT_VCHR_XREF Bank and Pay Methods

Change the bold fields to fit the next vendor.

UPDATE A
 SET A.BANK_CD = C.BANK_CD
 , A.BANK_ACCT_KEY = C.BANK_ACCT_KEY
 , A.PYMNT_METHOD = C.PYMNT_METHOD
 , A.EFT_PYMNT_FMT_CD = C.EFT_PYMNT_FMT_CD
 , A.EFT_LAYOUT_CD = C.EFT_LAYOUT_CD
 FROM PS_PYMNT_VCHR_XREF A, PS_VOUCHER B, PS_VENDOR_PAY C
 WHERE A.REMIT_VENDOR = '0000012549'
 AND A.PYMNT_SELCT_STATUS = 'N'
 AND A.VOUCHER_ID = B.VOUCHER_ID
 AND B.ENTRY_STATUS <> 'X'
 AND B.VENDOR_ID = C.VENDOR_ID
 AND B.VNDR_LOC = C.VNDR_LOC
 AND C.EFFDT = (SELECT MAX(D.EFFDT) FROM PS_VENDOR_PAY D
                 WHERE D.VENDOR_ID = C.VENDOR_ID
                 AND D.VNDR_LOC = C.VNDR_LOC
                 AND D.EFFDT <= GETDATE())
 AND C.PYMNT_METHOD = 'EFT'