| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EIP_PROGRAM |
Character(10) |
VARCHAR2(10) NOT NULL |
Enterprise Components EIP (enterprise integration point) program field
601=Consumer Sync
701=BOM Sync
801=Item Revision
901=Item Bus Unit Sync
902=Item Sync
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
EIP_GRID_BTN |
Character(3) |
VARCHAR2(3) NOT NULL |
EIP Grid Button
001=Stage Table
002=Queue Based
003=Select Trans
Default Value: 002
|
| 4 |
EIP_BU_SETID_SEL |
Character(3) |
VARCHAR2(3) NOT NULL |
BU/SETID Control
001=Business Unit
002=Set ID
Default Value: 001
|
| 5 |
PNLGRPNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Component Name
Default Value: EIP_DTA_CTL
Prompt Table:
PSPNLGRPDFN_VW1
|
| 6 |
PROMPT_TBL |
Character(15) |
VARCHAR2(15) NOT NULL |
Prompt Table
Default Value: EO_EIP_ROW_VW1
Prompt Table:
PSRECDEFN
|
| 7 |
PNLNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Page Name (see PSPNLDEFN).
Prompt Table:
PSPNLGROUP_VW
|
| 8 |
ROLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table:
PSROLEDEFN
|
| 9 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
PSOPRDEFN
|
| 10 |
MENUNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Menu Name (see PSMENUDEFN).
Prompt Table:
PSMENUDEFN
|
| 11 |
BARNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Menu Bar Name
Prompt Table:
PSMENUITEM_VW1
|
| 12 |
ITEMNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Item Name
Prompt Table:
PSMENUITEM_VW2
|
| 13 |
PANELITEMNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Panel Item Name
Prompt Table:
PSMENUITEM_VW3
|
| 14 |
EIP_XFERCODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Panel Transfer Type - DoModaPanelGroupl Transfer, Transfer Panel(Next Panel), Non Modal Transfer to a Different Panel Group.
1=Modal Transfer
2=Transfer Panel(Next Panel)
3=Transfer to a Diff Panel Group
Default Value: 1
|
| 15 |
EIP_ACTION_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Action Mode for PnlGrp Launch
A=Add
C=Correction
E=Data Entry
L=Update/Display all
U=Update
Default Value: C
|
| 16 |
FLAG1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag1
Y/N Table Edit
Default Value: N
|
| 17 |
FLAG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag2
Y/N Table Edit
Default Value: N
|
| 18 |
FLAG3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag3
Y/N Table Edit
Default Value: N
|
| 19 |
FLAG4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag4
Y/N Table Edit
Default Value: N
|
| 20 |
FLAG5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag5
Y/N Table Edit
Default Value: N
|