APPL_VENDOR_SETIDAPPL_VENDOR_IDPYMNT_IDPYMNT_ID_REFBUSINESS_UNITVOUCHER_IDPYMNT_CNTWTHD_ENTITYWTHD_TYPEWTHD_JUR_CDWTHD_RULEWTHD_CLASSE=Express Payment
M=Manual Payment
R=Regular payment
W=Withholding Payment
Z=Zero Payment Check
WTHD_PYMNT_VW2(SQL View) |
Index Back |
|---|
| SELECT W.APPL_VENDOR_SETID , W.APPL_VENDOR_ID , P.PYMNT_ID , P.PYMNT_ID_REF , W.BUSINESS_UNIT , W.VOUCHER_ID , W.PYMNT_CNT , W.WTHD_ENTITY , W.WTHD_TYPE , W.WTHD_JUR_CD , W.WTHD_RULE , W.WTHD_CLASS , SUM(W.WTHD_BASIS_AMT ) , SUM(W.WTHD_AMT) , P.BANK_SETID , P.BANK_CD , P.BANK_ACCT_KEY , P.PYMNT_DT , P.SCHEDULE_ID , X.PYMNT_GROSS_AMT , W.TXN_CURRENCY_CD , X.PYMNT_TYPE , X.REMIT_SETID , X.REMIT_VENDOR , VNDR.VENDOR_NAME_SHORT FROM PS_PYMNT_VCHR_WTHD W , PS_PYMNT_VCHR_XREF X , PS_PAYMENT_TBL P , PS_VENDOR VNDR WHERE W.BUSINESS_UNIT = X.BUSINESS_UNIT AND W.VOUCHER_ID = X.VOUCHER_ID AND ((W.PYMNT_CNT = X.PYMNT_CNT AND X.PYMNT_TYPE <> 'W' ) OR (W.PYMNT_CNT = X.ORIG_PYMNT_CNT AND X.PYMNT_TYPE = 'W') OR W.PYMNT_CNT = 0) AND X.PYMNT_SELCT_STATUS = 'P' AND P.PYMNT_STATUS <> 'X' 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 VNDR.SETID = X.REMIT_SETID AND VNDR.VENDOR_ID = X.REMIT_VENDOR GROUP BY W.APPL_VENDOR_SETID , W.APPL_VENDOR_ID , P.PYMNT_ID , P.PYMNT_ID_REF , W.BUSINESS_UNIT , W.VOUCHER_ID , W.PYMNT_CNT , W.WTHD_ENTITY, W.WTHD_TYPE, W.WTHD_JUR_CD, W.WTHD_RULE, W.WTHD_CLASS, P.BANK_SETID , P.BANK_CD , P.BANK_ACCT_KEY , P.PYMNT_DT , P.SCHEDULE_ID , X.PYMNT_GROSS_AMT , W.TXN_CURRENCY_CD, X.PYMNT_TYPE, X.REMIT_SETID , X.REMIT_VENDOR, VNDR.VENDOR_NAME_SHORT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | APPL_VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Wthd Applicable Supplier 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_ID_REF |
Character(20) | VARCHAR2(20) NOT NULL | Payment Reference |
| 5 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 7 | PYMNT_CNT |
Number(5,0) | INTEGER NOT NULL | Payments |
| 8 | WTHD_ENTITY |
Character(5) | VARCHAR2(5) NOT NULL | Withholding Entity |
| 9 | WTHD_TYPE |
Character(5) | VARCHAR2(5) NOT NULL | Withholding Type |
| 10 | WTHD_JUR_CD |
Character(5) | VARCHAR2(5) NOT NULL | Withholding Jurisdiction |
| 11 | WTHD_RULE |
Character(5) | VARCHAR2(5) NOT NULL | Withholding Rule |
| 12 | WTHD_CLASS |
Character(5) | VARCHAR2(5) NOT NULL | Withholding Class |
| 13 | WTHD_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Basis Amount |
| 14 | WTHD_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 15 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 16 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 17 | 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 |
| 18 | PYMNT_DT | Date(10) | DATE | Payment Date |
| 19 | SCHEDULE_ID | Character(10) | VARCHAR2(10) NOT NULL | Schedule ID |
| 20 | PYMNT_GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Payment Amount |
| 21 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 22 | PYMNT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Document Type
E=Express Payment M=Manual Payment R=Regular payment W=Withholding Payment Z=Zero Payment Check |
| 23 | REMIT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Remit SetID |
| 24 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
| 25 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |