AR_UNPYT_SUM_VW (SQL View)	Index Back
Summary Outstanding Payments Summary of Outstanding Payments

AR_UNPYT_SUM_VW

(SQL View)

Summary Outstanding Payments

Summary of Outstanding Payments

SELECT B.OPRID , A.DEPOSIT_BU ,A.PAYMENT_METHOD ,A.PAYMENT_STATUS ,A.TRANS_CURRENCY ,A.PAYMENT_CNT ,A.TRANSACTION_AMT ,B.DISPLAY_CURRENCY ,%Round(%DecMult(%DecDiv(A.TRANSACTION_AMT, R.RATE_DIV), R.RATE_MULT), CUR.DECIMAL_POSITIONS) FROM PS_AR_UNPYT_SUM_V1 A ,PS_ARFO_PRF_OUTPYT B , PS_RT_RATE_TBL R ,PS_OPI_CURR_EFF_MV CUR WHERE R.FROM_CUR=A.TRANS_CURRENCY AND R.TO_CUR=B.DISPLAY_CURRENCY AND R.RT_TYPE=B.DSP_RT_TYPE AND R.RT_RATE_INDEX=B.RATE_INDEX AND R.EFFDT=( SELECT MAX(C2.EFFDT) FROM PS_RT_RATE_TBL C2 WHERE R.FROM_CUR=C2.FROM_CUR AND R.TO_CUR=C2.TO_CUR AND R.RT_TYPE=C2.RT_TYPE AND R.RT_RATE_INDEX=C2.RT_RATE_INDEX AND C2.EFFDT <= %CurrentDateIn) AND CUR.CURRENCY_CD = B.DISPLAY_CURRENCY AND %CurrentDateIn BETWEEN CUR.EFFDT_FROM AND CUR.EFFDT_TO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.
Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU
Prompt Table: SP_BUARDE_NONVW

3 PAYMENT_METHOD 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. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report

4 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

5 PAYMENT_CURRENCY Character(3) VARCHAR2(3) NOT NULL Identifies the currency of a customer payment. This is generally the same as the currency specified for the deposit but it can be different.
Prompt Table: AR_PAY_CUR_VW

6 PAYMENT_CNT Number(5,0) INTEGER NOT NULL Payment count

7 PAY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Amount

8 DISPLAY_CURRENCY Character(3) VARCHAR2(3) NOT NULL Display Currency
Prompt Table: AR_PAY_CUR_VW

9 DISPLAY_BAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Display Balance

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted. Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU Prompt Table: SP_BUARDE_NONVW
3	PAYMENT_METHOD	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. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats. ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report
4	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
5	PAYMENT_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Identifies the currency of a customer payment. This is generally the same as the currency specified for the deposit but it can be different. Prompt Table: AR_PAY_CUR_VW
6	PAYMENT_CNT	Number(5,0)	INTEGER NOT NULL	Payment count
7	PAY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Amount
8	DISPLAY_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Display Currency Prompt Table: AR_PAY_CUR_VW
9	DISPLAY_BAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Display Balance