AM_LEAPAY_VW(SQL View) |
Index Back |
|---|---|
Voucher Payment |
| SELECT D.BUSINESS_UNIT , D.VOUCHER_ID , D.INVOICE_DT , B.PYMNT_DT , B.PYMNT_AMT , B.CURRENCY_PYMNT , D.POST_STATUS_AP , B.POST_STATUS_AP FROM PS_PYMNT_VCHR_XREF A , PS_PAYMENT_TBL B , PS_VOUCHER D WHERE A.BANK_SETID = B.BANK_SETID AND A.BANK_CD = B.BANK_CD AND A.BANK_ACCT_KEY = B.BANK_ACCT_KEY AND A.PYMNT_ID = B.PYMNT_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.VOUCHER_ID = D.VOUCHER_ID AND ((D.VOUCHER_STYLE = 'PPAY' AND A.PYMNT_CNT = 1) OR (D.VOUCHER_STYLE <> 'PPAY') AND PREPAID_STATUS IN ('U')) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_AP | Character(5) | VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table: SP_BU_AP_NONVW |
| 2 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 3 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 4 | PAYMENT_DT | Date(10) | DATE | Payment Date |
| 5 | PYMNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Amount |
| 6 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL |
Payment Currency
Prompt Table: CURR_PYMNT_VW |
| 7 | POST_STATUS_AP | Character(1) | VARCHAR2(1) NOT NULL |
Post Status
N=Payment Not Applied P=Posted U=Unposted Default Value: U |
| 8 | POST_STATUS_PYMNT | Character(1) | VARCHAR2(1) NOT NULL |
Post Status
N=Payment Not Applied P=Posted U=Unposted |