| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SRCH_QRY_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Search Query Id
|
| 2 |
INDEXNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Name of Index for Collection
Prompt Table:
SAC_IDX_TBL
|
| 3 |
INDEXFIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Index Field Name
Prompt Table:
SAC_IDX_FLDS_VW
Set Control Field: INDEXNAME
|
| 4 |
SEARCH_FIELDTYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Field Type
D=Date
N=Numeric
SD=String - Description
SI=String - ID or Code
|
| 5 |
PACKAGEROOT |
Character(30) |
VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table:
PTAFPACKAGE_VW
|
| 6 |
APPCLASS_PATH |
Character(254) |
VARCHAR2(254) NOT NULL |
Application Class Full Path
Prompt Table:
APPCLASSPATH_VW
|
| 7 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 8 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 9 |
RANGE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Range Flag
Y/N Table Edit
|
| 10 |
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:
PV_RECDEFN_VW
|
| 11 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
SAC_RECFIELD_VW
Set Control Field: RECORDNAME
|
| 12 |
FIELDNAME_TO |
Character(18) |
VARCHAR2(18) NOT NULL |
Destination Field
Prompt Table:
SAC_RECFIELD_VW
Set Control Field: RECORDNAME
|
| 13 |
CONSTANT_VALUE |
Character(50) |
VARCHAR2(50) NOT NULL |
Constant Value
|
| 14 |
DISPLAY_FIELDS |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Fields
Y/N Table Edit
|
| 15 |
SEARCH_IN |
Long Character |
CLOB |
Search Also In
|