VNDR_AUDIT_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	TEMPLATE_ID	Character(30)	VARCHAR2(30) NOT NULL	Project Template
3	GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
4	UUID	Character(40)	VARCHAR2(40) NOT NULL	Unique ID
5	PNLNAME	Character(30)	VARCHAR2(30) NOT NULL	Page Name (see PSPNLDEFN).
6	PNLFIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Panel Field Name
7	PID	Character(40)	VARCHAR2(40) NOT NULL	Parent Id
8	LBLTEXT	Character(60)	VARCHAR2(60) NOT NULL	Label Text
9	OCCURSLEVEL	Number(1,0)	SMALLINT NOT NULL	Occurs level
10	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
11	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
12	LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Level
13	AUDIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Supplier Audit Y/N Table Edit
14	REASON_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Reason Flag Y/N Table Edit
15	LEVEL1	Number(5,0)	INTEGER NOT NULL	Level 1
16	LEVEL2	Number(5,0)	INTEGER NOT NULL	Level 2
17	LEVEL3	Number(5,0)	INTEGER NOT NULL	Level 3
18	EXPAND_COLL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Expand Row Default Value: N
19	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
20	PARENT1	Character(30)	VARCHAR2(30) NOT NULL	Parent One
21	PARENT2	Character(30)	VARCHAR2(30) NOT NULL	Parent Two
22	PARENT3	Character(30)	VARCHAR2(30) NOT NULL	Parent Three