CDR_UNMTRCPT_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

SELECT RECPT.BUS_UNIT_TYPE , RECPT.BUSINESS_UNIT , RECPT.DRAWER_ID , RECPT.CURRENCY_CD , RECPT.ADD_DTTM , RECPT.DEPOSIT_BU , RECPT.RECEIPT_NBR , PMT.RECEIPT_NBR_SEQ , PMT.PAYMENT_AMT , PMT.CHECK_NBR FROM PS_CDR_RECEIPT RECPT , PS_CDR_RECEIPT_PMT PMT WHERE RECPT.DEPOSIT_BU = PMT.DEPOSIT_BU AND RECPT.RECEIPT_NBR = PMT.RECEIPT_NBR AND PMT.PAYMENT_METHOD_CDR = 'CHK' AND RECPT.RECEIPT_STATUS = 'PRT'

# 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 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
5 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
6 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.
7 RECEIPT_NBR Character(15) VARCHAR2(15) NOT NULL Receipt Number
8 RECEIPT_NBR_SEQ Number(3,0) SMALLINT NOT NULL Receipt Number Sequence
9 PAYMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a customer payment.
10 CHECK_NBR Character(30) VARCHAR2(30) NOT NULL Check Number