PAY_CSHCNTL_VW (SQL View)	Index Back
Cash Control needed payments Select payments that need cash control entries. Change to use following SQL when BUS_UNIT_TBL_AR has been modified: SELECT P.DEPOSIT_BU, P.DEPOSIT_ID, P.PAYMENT_SEQ_NUM, P.PAYMENT_ID, P.PAYMENT_STATUS, P.ENTRY_DT, P.ACCOUNTING_DT FROM PS_PAYMENT P, PS_DEPOSIT_CONTROL D, PS_BUS_UNIT_TBL_AR T WHERE P.CASH_CNTRL_USE = 'Y' AND P.CASH_CNTRL_DONE = 'N' AND P.DEPOSIT_BU = D.DEPOSIT_BU AND P.DEPOSIT_ID = D.DEPOSIT_ID AND D.CASH_CNTRL = 'Y' AND D.BAL_STATUS = 'I' AND D.LB_FORMAT_ERROR = 'N' AND P.DEPOSIT_BU = T.BUSINESS_UNIT AND ((P.MISC_PAYMENT = 'N' AND P.RECON_STATUS = 'REC' AND T.CASH_CNTL_METH = 'R') OR (T.CASH_CNTL_METH = 'E'))

PAY_CSHCNTL_VW

(SQL View)

Cash Control needed payments

Select payments that need cash control entries. Change to use following SQL when BUS_UNIT_TBL_AR has been modified: SELECT P.DEPOSIT_BU, P.DEPOSIT_ID, P.PAYMENT_SEQ_NUM, P.PAYMENT_ID, P.PAYMENT_STATUS, P.ENTRY_DT, P.ACCOUNTING_DT FROM PS_PAYMENT P, PS_DEPOSIT_CONTROL D, PS_BUS_UNIT_TBL_AR T WHERE P.CASH_CNTRL_USE = 'Y' AND P.CASH_CNTRL_DONE = 'N' AND P.DEPOSIT_BU = D.DEPOSIT_BU AND P.DEPOSIT_ID = D.DEPOSIT_ID AND D.CASH_CNTRL = 'Y' AND D.BAL_STATUS = 'I' AND D.LB_FORMAT_ERROR = 'N' AND P.DEPOSIT_BU = T.BUSINESS_UNIT AND ((P.MISC_PAYMENT = 'N' AND P.RECON_STATUS = 'REC' AND T.CASH_CNTL_METH = 'R') OR (T.CASH_CNTL_METH = 'E'))

SELECT P.DEPOSIT_BU , P.DEPOSIT_ID , P.PAYMENT_SEQ_NUM , P.PAYMENT_ID , P.PAYMENT_STATUS , P.ENTRY_DT , P.ACCOUNTING_DT FROM PS_PAYMENT P , PS_DEPOSIT_CONTROL D , PS_BUS_UNIT_TBL_AR T WHERE P.CASH_CNTRL_USE = 'Y' AND P.CASH_CNTRL_DONE IN ('N', 'T') AND P.DEPOSIT_BU = D.DEPOSIT_BU AND P.DEPOSIT_ID = D.DEPOSIT_ID AND D.CASH_CNTRL = 'Y' AND D.BAL_STATUS = 'I' AND D.LB_FORMAT_ERROR = 'N' AND P.DEPOSIT_BU = T.BUSINESS_UNIT AND ((T.CASH_CNTL_METH = 'R' AND P.RECON_STATUS = 'REC') OR (T.CASH_CNTL_METH = 'E'))

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

3 PAYMENT_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.

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

5 PAYMENT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Status
A=Applied
B=Bounced
C=Complete
E=Identified - Express
I=Identified
J=Directly Journalled
R=Unposted Direct Journal
U=Unidentified
W=Worksheet

6 ENTRY_DT Date(10) DATE Specifies the date that a group of pending items was entered into the system. This date may be later or the same as the date that the items were received by the organization (See RECEIVED_DT).

7 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

#	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.
3	PAYMENT_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
4	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.
5	PAYMENT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Status A=Applied B=Bounced C=Complete E=Identified - Express I=Identified J=Directly Journalled R=Unposted Direct Journal U=Unidentified W=Worksheet
6	ENTRY_DT	Date(10)	DATE	Specifies the date that a group of pending items was entered into the system. This date may be later or the same as the date that the items were received by the organization (See RECEIVED_DT).
7	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple