FO_SETIDINCM_VW(SQL View) |
Index Back |
|---|---|
Potential Income SETIDsView of list of SETIDs used in Potential Income tables associated with order lines |
| SELECT DISTINCT E.SETID FROM PS_SET_CNTRL_REC A , PS_RS_SO_HDR B , PS_CUSTOMER C , PS_POTENTIAL_INCME D ,PS_SET_CNTRL_REC E ,PS_RS_SO_LINE F WHERE B.BUSINESS_UNIT = A.SETCNTRLVALUE AND A.RECNAME = 'CUSTOMER' AND C.SETID = A.SETID AND B.CUST_ID = C.CUST_ID AND B.SYSTEM_SOURCE = 'STF' AND A.SETID = D.SETID AND D.SETID = E.SETID AND E.RECNAME = 'POTENTIAL_INCME' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |