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