RF_SO_BILCUR_VW (SQL View)	Index Back
RF_SO_BILCUR_VW Drop down value for currency which lists Field Service BU currency, Sold To Currency and Billing Currency.

RF_SO_BILCUR_VW

(SQL View)

RF_SO_BILCUR_VW

Drop down value for currency which lists Field Service BU currency, Sold To Currency and Billing Currency.

SELECT A.BUSINESS_UNIT , A.SO_ID , B.CURRENCY_CD , B.DESCR FROM PS_RF_SO_HDR A , PS_CURRENCY_CD_TBL B WHERE ( B.CURRENCY_CD = A.CURRENCY_FSBU OR B.CURRENCY_CD = A.CURRENCY_SOLDTO OR B.CURRENCY_CD = A.CURRENCY_BILLING) AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_CURRENCY_CD_TBL B_ED WHERE B.CURRENCY_CD = B_ED.CURRENCY_CD AND B_ED.EFFDT <= A.SO_DATE AND B_ED.EFF_STATUS = 'A')

# 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_RB.BUSINESS_UNIT
Prompt Table: SP_BU_RF_NONVW

2 SO_ID Character(10) VARCHAR2(10) NOT NULL Service Order ID

3 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

4 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_RB.BUSINESS_UNIT Prompt Table: SP_BU_RF_NONVW
2	SO_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Order ID
3	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description