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

AR_WC_CCDIDF_VW

(SQL View)

CC Pymt to Post - Dep ID View

SELECT DISTINCT a.DEPOSIT_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 DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.