PSCPQFIELD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	CPQNAME	Character(30)	VARCHAR2(30) NOT NULL	Composite Query
3	SELNUM	Number(2,0)	SMALLINT NOT NULL	Select Number
4	CPQQRYALIAS	Character(30)	VARCHAR2(30) NOT NULL	Child Query Alias
5	QRYFLDNAME	Character(30)	VARCHAR2(30) NOT NULL	Source Field
6	CPQUNIQUEFLDNAME	Character(62)	VARCHAR2(62) NOT NULL	Unique Name
7	COLUMNNUM	Number(3,0)	SMALLINT NOT NULL	Column Number
8	ORDERBYNUM	Number(3,0)	SMALLINT NOT NULL	Order-By Number
9	ORDERBYDIR	Character(1)	VARCHAR2(1) NOT NULL	Order-By Direction A=Ascending D=Descending
10	GROUPBYNUM	Number(3,0)	SMALLINT NOT NULL	Group-By Number
11	CPQAGGREGATETYPE	Number(1,0)	SMALLINT NOT NULL	Aggregate Type
12	FLDEXPNUM	Number(3,0)	SMALLINT NOT NULL	Field Expression Number
13	HEADING	Character(30)	VARCHAR2(30) NOT NULL	Field Heading
14	CPQURLNUM	Number(3,0)	SMALLINT NOT NULL	Field URL Number
15	CPQURLMAPNUM	Number(3,0)	SMALLINT NOT NULL	Map to URL