# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
EIP_CTL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Enterprise Components EIP (enterprise integration point) control field
|
2 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
3 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
4 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
5 |
MESSAGE_TEXT |
Character(100) |
VARCHAR2(100) NOT NULL |
Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
|
6 |
MESSAGE_PARM |
Character(254) |
VARCHAR2(254) NOT NULL |
Message Parameter Text
|
7 |
MESSAGE_PARM2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Message Parameter 2
|
8 |
MESSAGE_PARM3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Message Parameter 3
|
9 |
MFG_ITM_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer's Item ID
|
10 |
MFG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer ID
|
11 |
GPO_CNTRCT_NBR |
Character(25) |
VARCHAR2(25) NOT NULL |
GPO Contract Number
|