AUC_APPR_TOT_VW (SQL View)	Index Back
Fluid Approval View

AUC_APPR_TOT_VW

(SQL View)

Fluid Approval View

SELECT H.BUSINESS_UNIT ,H.AUC_ID ,H.AUC_ROUND ,H.AUC_VERSION ,H.CURRENCY_CD ,SUM(L.AUC_EXT_PRICE) ,' ' ,H.RATE_DATE ,H.RT_TYPE FROM PS_AUC_HDR H ,PS_AUC_LINE L WHERE H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.AUC_ID = L.AUC_ID AND H.AUC_ROUND = L.AUC_ROUND AND H.AUC_VERSION = L.AUC_VERSION GROUP BY H.BUSINESS_UNIT, H.AUC_ID, H.AUC_ROUND, H.AUC_VERSION,H.CURRENCY_CD,H.RATE_DATE,H.RT_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID

3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round

4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

6 FIELD2 Character(50) VARCHAR2(50) NOT NULL Fieldname 2

7 FIELD3 Character(50) VARCHAR2(50) NOT NULL Fieldname 3

8 RATE_DATE Date(10) DATE Exchange Rate Date

9 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	AUC_ID	Character(10)	VARCHAR2(10) NOT NULL	Event ID
3	AUC_ROUND	Number(5,0)	INTEGER NOT NULL	Event Round
4	AUC_VERSION	Number(5,0)	INTEGER NOT NULL	Event Version
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
6	FIELD2	Character(50)	VARCHAR2(50) NOT NULL	Fieldname 2
7	FIELD3	Character(50)	VARCHAR2(50) NOT NULL	Fieldname 3
8	RATE_DATE	Date(10)	DATE	Exchange Rate Date
9	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.