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