PSMSGREC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MSGNAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
2	APMSGVER	Character(30)	VARCHAR2(30) NOT NULL	Message Version
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
4	PRNTRECNAME	Character(15)	VARCHAR2(15) NOT NULL	Parent Record Name
5	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
6	IB_MSGNAME	Character(30)	VARCHAR2(30) NOT NULL	Message Name
7	IB_MSGVERSION	Character(30)	VARCHAR2(30) NOT NULL	Message Version
8	XMLALIAS	Character(30)	VARCHAR2(30) NOT NULL	XML Alias name for a Field or Record in an Application Message.
9	IB_SCHEMAMIN	Signed Number(8,0)	DECIMAL(7) NOT NULL	Minimum Occurs
10	IB_SCHEMAMAX	Signed Number(8,0)	DECIMAL(7) NOT NULL	Maximum Occurs Default Value: -1