CFG_OBJTYPE_VW2 (SQL View)	Index Back
Configurator View of pricing type for objects in the list price table, second column, Configurator Price tab

CFG_OBJTYPE_VW2

(SQL View)

Configurator

View of pricing type for objects in the list price table, second column, Configurator Price tab

SELECT X.FIELDVALUE , X.XLATSHORTNAME , X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'CFG_OBJECT_TYPE' AND X.EFF_STATUS = 'A' AND X.FIELDVALUE IN ('01','02','03','04') AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CFG_OBJECT_TYPE Character(2) VARCHAR2(2) NOT NULL Configurator
01=Selection
02=Expression
03=Configuration Attribute
04=External Variable
05=Connections
06=Component
07=Connections
08=Selections Filtered List
09=Selections Filter Where
10=Selections Attributes
11=Package Components
12=Manufactured Components
13=Routing Operations
14=Purchased Components
15=Product Selector
Default Value: 01

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_OBJECT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Configurator 01=Selection 02=Expression 03=Configuration Attribute 04=External Variable 05=Connections 06=Component 07=Connections 08=Selections Filtered List 09=Selections Filter Where 10=Selections Attributes 11=Package Components 12=Manufactured Components 13=Routing Operations 14=Purchased Components 15=Product Selector Default Value: 01
2	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name
3	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name