TD_APCHK_REF_VW(SQL View) |
Index Back |
|---|
| SELECT B.VOUCHER_ID , A.PYMNT_ID_REF FROM PS_PAYMENT_TBL A , PS_PYMNT_VCHR_XREF B WHERE A.BANK_SETID = B.BANK_SETID AND A.BANK_CD = B.BANK_CD AND A.BANK_ACCT_KEY = B.BANK_ACCT_KEY AND A.PYMNT_ID = B.PYMNT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 2 | PYMNT_ID_REF | Character(20) | VARCHAR2(20) NOT NULL | Payment Reference |