AR_DISP_SUM_VW4 (SQL View)	Index Back
Dispute Resolution Cycle Time Dispute Resolution Cycle Time grid summarized view

AR_DISP_SUM_VW4

(SQL View)

Dispute Resolution Cycle Time

Dispute Resolution Cycle Time grid summarized view

SELECT A.OPRID , A.BUSINESS_UNIT , A.SETID , A.RESP_PART , A.AR_TPERIOD_NAME , A.DISPLAY_ORDER , A.DAYS_AVRG , A.ITEM_COUNT , A.BAL_AMT , A.TRANSACT_CURRENCY , A.DISPLAY_CURRENCY , A.DSP_RT_TYPE , A.RATE_INDEX , A.DISP_RESOLUTION_DT , %Round(%DecMult(%DecDiv(A.DISPUTE_AMOUNT, R.RATE_DIV), R.RATE_MULT), CUR.DECIMAL_POSITIONS) FROM PS_AR_DISP_SUM_VW2 A , PS_RT_RATE_TBL R , PS_OPI_CURR_EFF_MV CUR WHERE R.FROM_CUR = A.TRANSACT_CURRENCY AND R.TO_CUR = A.DISPLAY_CURRENCY AND R.RT_TYPE = A.DSP_RT_TYPE AND R.RT_RATE_INDEX = A.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 = A.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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUARDS_NONVW

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

4 RESP_PART Character(15) VARCHAR2(15) NOT NULL Responsible Party

5 AR_TPERIOD_NAME Character(10) VARCHAR2(10) NOT NULL Period Name

6 DISPLAY_ORDER Number(3,0) SMALLINT NOT NULL Display order for ordering items in a list - web style

7 DAYS_AVRG Number(6,0) INTEGER NOT NULL DAYS_AVRG

8 ITEM_COUNT Number(5,0) INTEGER NOT NULL Item Count

9 BAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Item Balance

10 TRANSACT_CURRENCY Character(3) VARCHAR2(3) NOT NULL "The nominal

11 DISPLAY_CURRENCY Character(3) VARCHAR2(3) NOT NULL Display Currency
Prompt Table: CURRENCY_CD_TBL

12 DSP_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Rate Type
Prompt Table: RT_TYPE_TBL

13 RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Rate index

14 DISP_RESOLUTION_DT Date(10) DATE Resolution Date

15 DISPUTE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of an item in dispute. This may represent only a portion of the full amount of an item.

#	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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUARDS_NONVW
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	RESP_PART	Character(15)	VARCHAR2(15) NOT NULL	Responsible Party
5	AR_TPERIOD_NAME	Character(10)	VARCHAR2(10) NOT NULL	Period Name
6	DISPLAY_ORDER	Number(3,0)	SMALLINT NOT NULL	Display order for ordering items in a list - web style
7	DAYS_AVRG	Number(6,0)	INTEGER NOT NULL	DAYS_AVRG
8	ITEM_COUNT	Number(5,0)	INTEGER NOT NULL	Item Count
9	BAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Item Balance
10	TRANSACT_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"The nominal
11	DISPLAY_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Display Currency Prompt Table: CURRENCY_CD_TBL
12	DSP_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Rate Type Prompt Table: RT_TYPE_TBL
13	RATE_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Rate index
14	DISP_RESOLUTION_DT	Date(10)	DATE	Resolution Date
15	DISPUTE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of an item in dispute. This may represent only a portion of the full amount of an item.