SAC_SRCH_FLD_WK(SQL Table) |
Index Back |
|---|---|
Search Fields Work TableThis is a DB table because it may be the only table in a grid |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INDEXNAME | Character(30) | VARCHAR2(30) NOT NULL | Name of Index for Collection |
| 2 | INDEXFIELD | Character(18) | VARCHAR2(18) NOT NULL | Index Field Name |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | 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 |
| 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 |
| 6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 7 | FIELDNAME_TO | Character(18) | VARCHAR2(18) NOT NULL | Destination Field |
| 8 | RANGE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Range Flag |
| 9 | SAC_FROM_VALUE | Character(80) | VARCHAR2(80) NOT NULL | From Value |
| 10 | SAC_TO_VALUE | Character(80) | VARCHAR2(80) NOT NULL | To Value |
| 11 | LONGVALUE | Long Character | CLOB | Property Value |