WTHD_PYMNT_VW1(SQL View) |
Index Back |
|---|
| SELECT DISTINCT V.VENDOR_SETID , V.VENDOR_ID , P.PYMNT_ID , P.PYMNT_METHOD , P.BANK_SETID , P.BANK_CD , P.BANK_ACCT_KEY , P.PYMNT_ID_REF , P.PYMNT_DT , P.SCHEDULE_ID , P.PYMNT_AMT , SUM(X.PYMNT_GROSS_AMT) , P.CURRENCY_PYMNT , X.TXN_CURRENCY_CD FROM PS_PYMNT_VCHR_XREF X , PS_PAYMENT_TBL P , PS_VOUCHER V WHERE X.PYMNT_SELCT_STATUS='P' AND P.BANK_SETID = X.BANK_SETID AND P.BANK_CD = X.BANK_CD AND P.BANK_ACCT_KEY = X.BANK_ACCT_KEY AND P.PYMNT_ID = X.PYMNT_ID AND P.PYMNT_STATUS <> 'X' AND V.BUSINESS_UNIT = X.BUSINESS_UNIT AND V.VOUCHER_ID = X.VOUCHER_ID AND EXISTS ( SELECT 'X' FROM PS_PYMNT_VCHR_WTHD W WHERE W.BUSINESS_UNIT = X.BUSINESS_UNIT AND W.VOUCHER_ID = X.VOUCHER_ID AND ((X.PYMNT_TYPE <> 'W' AND W.PYMNT_CNT = X.PYMNT_CNT) OR (X.PYMNT_TYPE = 'W' AND W.PYMNT_CNT = X.ORIG_PYMNT_CNT) OR W.PYMNT_CNT = 0)) GROUP BY V.VENDOR_SETID , V.VENDOR_ID , P.PYMNT_ID , P.PYMNT_METHOD , P.BANK_SETID , P.BANK_CD , P.BANK_ACCT_KEY , P.PYMNT_ID_REF , P.PYMNT_DT , P.SCHEDULE_ID , P.PYMNT_AMT , P.CURRENCY_PYMNT , X.TXN_CURRENCY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | APPL_VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Wthd Applicable Supplier ID |
| 3 | PYMNT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
| 4 | PYMNT_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer |
| 5 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 6 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 7 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |
| 8 | PYMNT_ID_REF | Character(20) | VARCHAR2(20) NOT NULL | Payment Reference |
| 9 | PYMNT_DT | Date(10) | DATE | Payment Date |
| 10 | SCHEDULE_ID | Character(10) | VARCHAR2(10) NOT NULL | Schedule ID |
| 11 | PYMNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Amount |
| 12 | VNDR_LIABILITY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Supplier Liability Amount Paid |
| 13 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL | Payment Currency |
| 14 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |