CFG_OP_PRICE_VW (SQL View)	Index Back
Configurator This View of pricing operator symbols and text is used in configurator

CFG_OP_PRICE_VW

(SQL View)

Configurator

This View of pricing operator symbols and text is used in configurator

SELECT X.FIELDVALUE , X.XLATSHORTNAME , X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'OPER_INTL_CD' AND X.EFF_STATUS = 'A' AND X.FIELDVALUE IN ('20','21','22','23') AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPER_INTL_CD Character(2) VARCHAR2(2) NOT NULL International Operand Code
01=Equal to
02=Less than
03=Less than or Equal to
04=Greater than
05=Greater than or Equal to
06=If
07=Or
08=And
09=Not Equal To
10=Concate
11=Substring After
12=Substring Before
13=Exist on Multiple Option
14=Exist on Value List
15=Sin
16=Cosine
17=Tangent
18=Power
19=Mod
20=Add
21=Subtract
22=Multiply
23=Divide
24=Round Down
25=Round Up
26=Calculate Date
27=Exist on Component Array
28=Calculate Price

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	OPER_INTL_CD	Character(2)	VARCHAR2(2) NOT NULL	International Operand Code 01=Equal to 02=Less than 03=Less than or Equal to 04=Greater than 05=Greater than or Equal to 06=If 07=Or 08=And 09=Not Equal To 10=Concate 11=Substring After 12=Substring Before 13=Exist on Multiple Option 14=Exist on Value List 15=Sin 16=Cosine 17=Tangent 18=Power 19=Mod 20=Add 21=Subtract 22=Multiply 23=Divide 24=Round Down 25=Round Up 26=Calculate Date 27=Exist on Component Array 28=Calculate Price
2	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name
3	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name