CDR_ONHOLD_VW (SQL View)	Index Back
Used to obtain totals Used to obtain totals such as total payments, total paid out, non-cash/check payments, non-cash/check paid bout

CDR_ONHOLD_VW

(SQL View)

Used to obtain totals

Used to obtain totals such as total payments, total paid out, non-cash/check payments, non-cash/check paid bout

SELECT RECPT.BUS_UNIT_TYPE , RECPT.BUSINESS_UNIT , RECPT.DRAWER_ID , RECPT.DEPOSIT_BU , RECPT.RECEIPT_NBR , RECPT.ADD_DTTM FROM PS_CDR_RECEIPT RECPT WHERE RECPT.RECEIPT_STATUS = 'HLD'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUS_UNIT_TYPE Character(4) VARCHAR2(4) NOT NULL Business Unit Type
AR=Accounts Receivable
OM=Order Management

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 DRAWER_ID Character(5) VARCHAR2(5) NOT NULL Drawer Identificaion

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

5 RECEIPT_NBR Character(15) VARCHAR2(15) NOT NULL Receipt Number

6 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUS_UNIT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Business Unit Type AR=Accounts Receivable OM=Order Management
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	DRAWER_ID	Character(5)	VARCHAR2(5) NOT NULL	Drawer Identificaion
4	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted.
5	RECEIPT_NBR	Character(15)	VARCHAR2(15) NOT NULL	Receipt Number
6	ADD_DTTM	DateTime(26)	TIMESTAMP	Date Time Added