[Home] [Help]
View: FV_TREAS_CONFIRM_CHECKS_V
View Text
SELECT ACA.ORG_ID
, ACA.PAYMENT_ID
, ACA.CHECK_ID
, ACA.CHECK_NUMBER
, ACA.VENDOR_NAME
, ACA.AMOUNT
, ACA.VOID_DATE
, IPA.PAYMENT_INSTRUCTION_ID
, IPA.PAYMENT_REFERENCE_NUMBER
FROM AP_CHECKS_ALL ACA
, IBY_PAYMENTS_ALL IPA
WHERE ACA.PAYMENT_ID=IPA.PAYMENT_ID
Columns
Name |
ORG_ID |
PAYMENT_ID |
CHECK_ID |
CHECK_NUMBER |
VENDOR_NAME |
AMOUNT |
VOID_DATE |
PAYMENT_INSTRUCTION_ID |
PAYMENT_REFERENCE_NUMBER |