| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SRCH_RSLT_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Search Result
|
| 2 |
SRCH_QRY_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Search Query Id
|
| 3 |
INDEXNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Name of Index for Collection
Prompt Table:
SAC_IDX_TBL
|
| 4 |
INDEXFIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Index Field Name
Prompt Table:
SAC_IDX_FLD_FVW
Set Control Field: INDEXNAME
|
| 5 |
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_RECDEFN_VW
|
| 6 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
SAC_RECFIELD_VW
Set Control Field: RECORDNAME
|
| 7 |
SORTBY |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort By
Y/N Table Edit
|
| 8 |
PV_SORT_ORDER |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending/Descending
A=Ascending
D=Descending
Default Value: A
|
| 9 |
SORT_ORDER_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Sort Order
|