VUCHR_CLS_AR_VW(SQL View) |
Index Back |
|---|---|
Closed Vouchers for AR |
| SELECT a.business_unit , a.voucher_id , a.bank_cd , a.bank_acct_key , a.pymnt_id , b.pymnt_id_ref , a.pymnt_gross_amt , a.currency_pymnt , a.pymnt_selct_status , a.paid_amt , b.pymnt_amt , b.pymnt_dt , b.pymnt_status , b.remit_setid , b.remit_vendor , b.bank_setid FROM PS_PYMNT_XREF_AR a , ps_payment_ar b WHERE 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 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 3 | BANK_CD |
Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 4 | 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 |
| 5 | PYMNT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
| 6 | PYMNT_ID_REF | Character(20) | VARCHAR2(20) NOT NULL | Payment Reference |
| 7 | PYMNT_GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Payment Amount |
| 8 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL | Payment Currency |
| 9 | PYMNT_SELCT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payment Selection Status
C=Closed D=Negative Voucher Sum E=Externally Paid F=Federal Sanctions Error I=In Process - EFT N=Not Selected for Payment O=Financial Sanctions Review P=Paid R=Requested for Payment S=Settlement Payment V=Convert Error X=Canceled Y=Prepaid |
| 10 | PAID_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Paid Amount |
| 11 | PYMNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Amount |
| 12 | PYMNT_DT | Date(10) | DATE | Payment Date |
| 13 | PYMNT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payment Status
A=Alignment E=ACH/EFT Prenote L=Stale Dated Payment N=Reprinted with same ref number O=Overflow P=Paid R=Replaced S=Stopped T=Undo Escheatment U=Undo Cancel V=Void W=Escheated Check X=Deleted |
| 14 | REMIT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Remit SetID |
| 15 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
| 16 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |