| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
INDEXNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Search Index Name
|
| 4 |
DOSET_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Data Object Set Name
Prompt Table:
SAC_IDX_DOS_HDR
|
| 5 |
EOEW_SRCDONAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Source Data Object
Prompt Table:
SAC_IDX_DO_VW
Set Control Field: DOSET_NAME
|
| 6 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 7 |
RECORDNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record Name
01=MASTER_ITEM_EC
02=INV_ITEMS_EC
03=BU_ITM_INV_EC
04=BU_ITM_WTVL_EC
05=ITEM_SUPPLIER_EC
06=ITM_SUPP_LOC_EC
07=ITM_VNDR_UOM_EC
08=ITM_VND_UMPR_EC
09=INV_ITM_UOM_EC
10=PUR_ITM_ATTR_EC
13=EN_REVISION_EC
14=ITEM_MFG_GPO_EC
15=ITEM_MFG_EC
16=ITEM_CAT_EC
Prompt Table:
SAC_IDX_DORECVW
Set Control Field: EOEW_SRCDONAME
|
| 8 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
SAC_IDX_SFLD_VW
Set Control Field: EOEW_SRCDONAME
|
| 9 |
SAC_FROM_VALUE |
Character(80) |
VARCHAR2(80) NOT NULL |
From Value
|
| 10 |
PV_SEARCH_OPERATOR |
Character(3) |
VARCHAR2(3) NOT NULL |
Search Operator
10=Between
14=Like
2=Equals
3=Not Equal To
4=Greater Than
5=Less Than or Equal To
6=Less Than
7=Greater Than or Equal To
|
| 11 |
SAC_TO_VALUE |
Character(80) |
VARCHAR2(80) NOT NULL |
To Value
|
| 12 |
WHERE_LONG |
Long Character |
CLOB |
Where Clause
|