VCHRPYW_DIAG_VW(SQL View) |
Index Back |
|---|
| SELECT X.BUSINESS_UNIT , X.VOUCHER_ID , X.PYMNT_CNT , X.PYMNT_ID , X.PYMNT_TYPE , X.PAID_AMT , X.POST_STATUS_WTHD , X.REMIT_SETID , X.REMIT_VENDOR , V.WTHD_SETID , V.WTHD_SW , P.PYMNT_ID_REF , P.PYMNT_DT FROM PS_PYMNT_VCHR_XREF X , PS_PAYMENT_TBL P , PS_VOUCHER_LINE V WHERE X.BUSINESS_UNIT = V.BUSINESS_UNIT AND X.VOUCHER_ID = V.VOUCHER_ID AND X.REMIT_SETID = P.REMIT_SETID AND X.REMIT_VENDOR = P.REMIT_VENDOR AND X.BANK_SETID = P.BANK_SETID AND X.BANK_CD = P.BANK_CD AND X.BANK_ACCT_KEY = P.BANK_ACCT_KEY AND X.PYMNT_ID = P.PYMNT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL |
Voucher ID
Default Value: NEXT |
| 3 | PYMNT_CNT |
Number(5,0) | INTEGER NOT NULL |
Payments
Default Value: 1 |
| 4 | PYMNT_ID | Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
| 5 | 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 |
| 6 | PAID_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Paid Amount |
| 7 | POST_STATUS_WTHD | Character(1) | VARCHAR2(1) NOT NULL |
Post Withholding Status
N=Not Postable P=Posted U=Unposted X=Cancelled Withholding Default Value: U |
| 8 | REMIT_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Remit SetID
Prompt Table: REMIT_SETID_VW |
| 9 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL |
Remit Vendor
Prompt Table: VNDR_RMT_VW |
| 10 | WTHD_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Setid for the Withholding Code
Prompt Table: SP_SETID_NONVW |
| 11 | WTHD_SW | Character(1) | VARCHAR2(1) NOT NULL |
Withholding Applicable Flag
B=Global and 1099 G=Global T=1099 Y/N Table Edit Default Value: VENDOR.WTHD_SW |
| 12 | PYMNT_ID_REF | Character(20) | VARCHAR2(20) NOT NULL | Payment Reference |
| 13 | PYMNT_DT | Date(10) | DATE |
Payment Date
Default Value: %date |