Predefined Search Query Data

Several predefined search query data sets shipped with PeopleSoft Order Management. The tables will include all system data:

Record Name Description Sample Where Clause

SAC_SRCH_RSLT

Search Result

SRCH_RSLT_ID = 'OM_CUST_SOLDTO'

SAC_SRCH_RSLTFDS

Search Result Fields

SRCH_RSLT_ID = 'OM_CUST_SOLDTO'

SAC_SRCH_RLTQRY

Search Result Query Association

SRCH_RSLT_ID = 'OM_CUST_SOLDTO'