AP_INV_PMT_STAT(SQL View) |
Index Back |
|---|
| SELECT A.INVOICE_ID , B.PYMNT_ID , B.PYMNT_SELCT_STATUS , B.PYMNT_GROSS_AMT , A.TXN_CURRENCY_CD , B.PAID_AMT , B.CURRENCY_PYMNT FROM PS_VOUCHER A , PS_PYMNT_VCHR_XREF B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.VOUCHER_ID = A.VOUCHER_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 2 | PYMNT_ID | Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
| 3 | 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 Default Value: N |
| 4 | PYMNT_GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Payment Amount |
| 5 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 6 | PAID_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Paid Amount |
| 7 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL |
Payment Currency
Prompt Table: BANK_CURR_AP_VW |