CDR_CASH_VW

(SQL View)
Index Back

Cash Drawer Cash/Checks View

Cash Drawer Cash/Checks View

SELECT RECON.BUS_UNIT_TYPE , RECON.BUSINESS_UNIT , RECON.DRAWER_ID , RECON.RECON_ID , RECON.CURRENCY_CD , PMT.PAYMENT_METHOD_CDR , SUM(PMT.PAYMENT_AMT) FROM PS_CDR_RECON_HDR RECON , PS_CDR_RECEIPT RECPT , PS_CDR_RECEIPT_PMT PMT WHERE RECON.BUS_UNIT_TYPE = RECPT.BUS_UNIT_TYPE AND RECON.BUSINESS_UNIT = RECPT.BUSINESS_UNIT AND RECON.DRAWER_ID = RECPT.DRAWER_ID AND RECPT.DEPOSIT_BU = PMT.DEPOSIT_BU AND RECPT.RECEIPT_NBR = PMT.RECEIPT_NBR AND RECPT.RECEIPT_STATUS = 'PRT' AND RECPT.ADD_DTTM <= RECON.RECON_DTTM AND PMT.PAYMENT_METHOD_CDR = 'CSH' GROUP BY RECON.BUS_UNIT_TYPE, RECON.BUSINESS_UNIT, RECON.DRAWER_ID, RECON.RECON_ID, RECON.CURRENCY_CD , PMT.PAYMENT_METHOD_CDR

# 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 RECON_ID Character(15) VARCHAR2(15) NOT NULL Reconciliation ID
5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
6 PAYMENT_METHOD_CDR Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft.
CC=Credit Card
CHK=Check
CSH=Cash
CV=Corporate Voucher
DC=Debit Card
PC=Procurement Card
7 PAYMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a customer payment.