CFG_RPRICE_VW1 (SQL View)	Index Back
Configurator Prompts use this table to allow user to select the objects and expressions for recurring price calculation

CFG_RPRICE_VW1

(SQL View)

Configurator

Prompts use this table to allow user to select the objects and expressions for recurring price calculation

SELECT X.FIELDVALUE , X.XLATSHORTNAME , X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'CFG_MAPTO_ID' AND X.EFF_STATUS = 'A' AND X.FIELDVALUE LIKE '06%' AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn)

Related Language Record: CFG_RPRICE_VW1L

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CFG_MAPTO_ID Character(4) VARCHAR2(4) NOT NULL Database field for mapping ids to recurring price fields
0101=Package Components
0201=Manufactured Components
0301=Purchased Components
0401=Product Selector
0501=Routing Operations
0601=Recurring Price
0602=Recurring Frequency
0603=Frequency Description
Default Value: 0601

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

3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CFG_MAPTO_ID	Character(4)	VARCHAR2(4) NOT NULL	Database field for mapping ids to recurring price fields 0101=Package Components 0201=Manufactured Components 0301=Purchased Components 0401=Product Selector 0501=Routing Operations 0601=Recurring Price 0602=Recurring Frequency 0603=Frequency Description Default Value: 0601
2	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name
3	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name