AR_WC_CCPIDF_VW (SQL View)	Index Back
CC Pymt to Post - Pymt ID View

AR_WC_CCPIDF_VW

(SQL View)

CC Pymt to Post - Pymt ID View

SELECT DISTINCT a.PAYMENT_ID FROM PS_PAYMENT a , PS_DEPOSIT_CONTROL b WHERE a.deposit_bu=b.deposit_bu AND a.deposit_id=b.deposit_id AND b.PAY_WS_TYPE='C'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PAYMENT_ID Character(15) VARCHAR2(15) NOT NULL Identifies a customer payment. This is usually a check number but may be some other identifying number.