BUSINESS_UNIT_RECVRECEIVER_IDMTCH_RECV_SRCH(SQL View) |
Index Back |
|---|---|
Receiver ID Search |
| SELECT DISTINCT B.BUSINESS_UNIT_RECV , B.RECEIVER_ID FROM PS_AP_MTCH_EXCPTN A , PS_VCHR_MTCH_DETLS B WHERE A.PROCESS_INSTANCE = B.PROCESS_INSTANCE AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.VOUCHER_LINE_NUM = B.VOUCHER_LINE_NUM AND B.BUSINESS_UNIT_RECV <> ' ' AND (A.MATCH_RULE_ID LIKE 'ERULE%' OR A.MATCH_RULE_ID LIKE 'ESYS%') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_RECV |
Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit |
| 2 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Receiver number |