SAC_IDX_DOS_SEL

(SQL Table)
 Index Back

Selection Criteria work record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DOSET_NAME Character(30) VARCHAR2(30) NOT NULL Data Object Set Name

Prompt Table: SAC_IDX_DOS_HDR

2 EOEW_SRCDONAME Character(30) VARCHAR2(30) NOT NULL Source Data Object

Prompt Table: SAC_IDX_DOS_LN
Set Control Field: DOSET_NAME

3 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

4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: SAC_IDX_SFLD_VW
Set Control Field: EOEW_SRCDONAME

5 DATETIME_FLG Character(1) VARCHAR2(1) NOT NULL Datetime Stamp

Y/N Table Edit

6 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
7 SAC_FROM_VALUE Character(80) VARCHAR2(80) NOT NULL From Value
8 SAC_TO_VALUE Character(80) VARCHAR2(80) NOT NULL To Value
9 WHERE_LONG Long Character CLOB Where Clause