AR_WC_CSHCTLFVW (SQL View)	Index Back
Cash ControlDeposit ID View

AR_WC_CSHCTLFVW

(SQL View)

Cash ControlDeposit 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 ( ((A.CC_AFFECTED = 'Y' AND A.BUDGET_HDR_STATUS IN ('V', 'W')) OR (A.CC_AFFECTED <> 'Y'))) AND (A.CASH_CNTRL_USE = 'Y' AND A.CASH_CNTRL_DONE IN('Y', 'T')) AND C.GL_DISTRIB_STATUS = 'N'

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