RF_AG_PURCH_LVW (SQL View)	Index Back
Agreement Purchase Prompt Agreement Purchase Option prompt view

RF_AG_PURCH_LVW

(SQL View)

Agreement Purchase Prompt

Agreement Purchase Option prompt view

SELECT DISTINCT A.SETID , A.PURCHASE_OPTN , B.LANGUAGE_CD , B.XLATSHORTNAME FROM PS_RF_SVC_PRICE A , PS_RF_XLAT_VW_LANG B WHERE B.FIELDVALUE = A.PURCHASE_OPTN AND B.FIELDNAME = 'PURCHASE_OPTN' AND A.RATE_APPLIES_TO IN ('AGRT')

Related Language Record for RF_AG_PURCH2_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Prompt Table: SP_SETID_NONVW

2 PURCHASE_OPTN Character(4) VARCHAR2(4) NOT NULL This field is used to represent the purchase option (used in agreement pricing)
FLAT=Flat Rate
PRPD=Prepaid Cases/Services
TM=Time & Material

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Prompt Table: SP_SETID_NONVW
2	PURCHASE_OPTN	Character(4)	VARCHAR2(4) NOT NULL	This field is used to represent the purchase option (used in agreement pricing) FLAT=Flat Rate PRPD=Prepaid Cases/Services TM=Time & Material
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name