PSVAITEM
(SQL Table) | 
Index Back | 
Bus proc item table
  | 
Related Language Record: PSVAITEMLANG
| # | 
PeopleSoft Field Name | 
PeopleSoft Field Type | 
Database Column Type | 
Description | 
| 1 | 
 OBJNAME | 
Character(30) | 
VARCHAR2(30) NOT NULL | 
Object Name
 | 
| 2 | 
 OBJNAME2 | 
Character(30) | 
VARCHAR2(30) NOT NULL | 
Object Name2
 | 
| 3 | 
 OBJTYPE | 
Number(2,0) | 
SMALLINT NOT NULL | 
Object Type
 | 
| 4 | 
 COMPNAME | 
Character(30) | 
VARCHAR2(30) NOT NULL | 
Component Name
 | 
| 5 | 
 COMPTYPE | 
Number(2,0) | 
SMALLINT NOT NULL | 
Component Type
 | 
| 6 | 
SRCNAME | 
Character(30) | 
VARCHAR2(30) NOT NULL | 
Source Name
 | 
| 7 | 
SRCTYPE | 
Number(5,0) | 
INTEGER NOT NULL | 
Source Type
 | 
| 8 | 
DESTNAME | 
Character(30) | 
VARCHAR2(30) NOT NULL | 
Destination Name
 | 
| 9 | 
DESTTYPE | 
Number(2,0) | 
SMALLINT NOT NULL | 
Object Type
 | 
| 10 | 
LOC_X | 
Number(3,0) | 
SMALLINT NOT NULL | 
Object Location X
 | 
| 11 | 
LOC_Y | 
Number(3,0) | 
SMALLINT NOT NULL | 
Object Location Y
 | 
| 12 | 
DESCR60 | 
Character(60) | 
VARCHAR2(60) NOT NULL | 
Description
 | 
| 13 | 
DESCR_X | 
Number(3,0) | 
SMALLINT NOT NULL | 
Description Location X
 | 
| 14 | 
DESCR_Y | 
Number(3,0) | 
SMALLINT NOT NULL | 
Description Location Y
 | 
| 15 | 
ORDERNO | 
Number(5,0) | 
INTEGER NOT NULL | 
Sort Order
 | 
| 16 | 
DEFAULT_FONT | 
Number(2,0) | 
SMALLINT NOT NULL | 
using Default Font flag
 | 
| 17 | 
FONT | 
Character(80) | 
VARCHAR2(80) NOT NULL | 
Font Name
 | 
| 18 | 
VERTICES | 
Character(254) | 
VARCHAR2(254) NOT NULL | 
Vertices of a line
 | 
| 19 | 
PROPERTIES | 
Character(254) | 
VARCHAR2(254) NOT NULL | 
Properties of an object
 | 
| 20 | 
CONTNAME | 
Character(30) | 
VARCHAR2(30) NOT NULL | 
Content Name
 | 
| 21 | 
DESCRLONG | 
Long Character | 
CLOB | 
Long Description
 |