OM_RCPT_PAPL_VW

(SQL View)
Index Back

Cash Drawer Receipt Payments

Cash Drawer Receipt Payments

SELECT DISTINCT S.BUSINESS_UNIT , S.ORDER_NO , S.DOC_REFNUM , R.DEPOSIT_BU , R.RECEIPT_NBR , R.RECEIPT_NBR_SEQ , R.CURRENCY_CD , ' ' , R.PAYMENT_METHOD_CDR , R.PAYMENT_AMT , R.CHECK_NBR , R.LICENSE_NBR , R.PAYMENT_SEQ_NUM , R.CR_CARD_TYPE , R.CR_CARD_EXPMO , R.CR_CARD_EXPYR , R.CR_CARD_DIGITS FROM %Table(ORD_SCHEDULE) S , %Table(CDR_RECEIPT_PMT) R WHERE S.DEPOSIT_BU = R.DEPOSIT_BU AND S.RECEIPT_NBR = R.RECEIPT_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
3 DOC_REFNUM Character(20) VARCHAR2(20) NOT NULL Counter sale document reference number
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 RECEIPT_NBR_SEQ Number(3,0) SMALLINT NOT NULL Receipt Number Sequence
7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 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
10 PAYMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a customer payment.
11 CHECK_NBR Character(30) VARCHAR2(30) NOT NULL Check Number
12 LICENSE_NBR Character(15) VARCHAR2(15) NOT NULL License/Certification Number
13 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.
14 CR_CARD_TYPE Character(3) VARCHAR2(3) NOT NULL "See OM
01=Visa
02=MasterCard
03=Diners Club/Carte Blanche
04=AMEX
05=Discover
06=EnRoute
15 CR_CARD_EXPMO Character(2) VARCHAR2(2) NOT NULL Card Expiration Month
01=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December
16 CR_CARD_EXPYR Character(4) VARCHAR2(4) NOT NULL Card Expiration Year
2011=2011
2012=2012
2013=2013
2014=2014
2015=2015
2016=2016
2017=2017
2018=2018
2019=2019
2020=2020
17 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits