CS_AUC_CUR_H_VW (SQL View)	Index Back
RFX EventCurCode Details - hdr View used in RFX Events Bind Mapping to get the currency code details from the header record.

CS_AUC_CUR_H_VW

(SQL View)

RFX EventCurCode Details - hdr

View used in RFX Events Bind Mapping to get the currency code details from the header record.

SELECT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.CURRENCY_CD , B.DESCR FROM PS_AUC_HDR A , PS_CURRENCY_CD_TBL B WHERE A.CURRENCY_CD = B.CURRENCY_CD AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_CURRENCY_CD_TBL B2 WHERE B.CURRENCY_CD = B2.CURRENCY_CD AND B2.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_AUC_BU_NONVW

2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
Default Value: NEXT

3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
Default Value: 1

4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
Default Value: 1

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: CNTRCT_CONTROL.CURRENCY_CD
Prompt Table: CURRENCY_CD_TBL

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_AUC_BU_NONVW
2	AUC_ID	Character(10)	VARCHAR2(10) NOT NULL	Event ID Default Value: NEXT
3	AUC_ROUND	Number(5,0)	INTEGER NOT NULL	Event Round Default Value: 1
4	AUC_VERSION	Number(5,0)	INTEGER NOT NULL	Event Version Default Value: 1
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: CNTRCT_CONTROL.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description