REMIT_SETIDNAME1VNDR_NAME_SP2VW(SQL View) |
Index Back |
|---|---|
Single Pay Name Search ViewSingle Pay Name Search View |
| SELECT DISTINCT B.REMIT_SETID , A.NAME1 FROM PS_VCHR_VNDR_INFO A , PS_PYMNT_VCHR_XREF B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REMIT_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Remit SetID |
| 2 | NAME1 |
Character(40) | VARCHAR2(40) NOT NULL | Name 1 |