AR_WC_DJCMVW (SQL View)	Index Back
DJ Accnt Deposit ID View

AR_WC_DJCMVW

(SQL View)

DJ Accnt Deposit ID View

SELECT DISTINCT A.DEPOSIT_BU ,A.DEPOSIT_ID FROM PS_PAYMENT A , PS_DEPOSIT_CONTROL B , PS_PAY_MISC_DST C WHERE A.DEPOSIT_BU = B.DEPOSIT_BU AND A.DEPOSIT_ID = B.DEPOSIT_ID AND A.DEPOSIT_BU = C.DEPOSIT_BU AND A.DEPOSIT_ID = C.DEPOSIT_ID AND A.PAYMENT_SEQ_NUM = C.PAYMENT_SEQ_NUM AND B.BAL_STATUS='I' AND A.MISC_PAYMENT = 'Y' AND A.MISC_DST_BAL = 'I' AND C.GL_DISTRIB_STATUS = 'I'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.

2 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted.
2	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.