AP_AGE_DFT_VW(SQL View) |
Index Back |
|---|---|
AP Aging Draft View |
| SELECT P.CURRENCY_PYMNT , P.REMIT_VENDOR , VEN.VENDOR_NAME_SHORT , P.REMIT_SETID , P.VNDR_LOC , MIN(X.BUSINESS_UNIT) , P.PYMNT_DT , 'N' , 'D' , VEN.OFAC_STATUS , P.PYMNT_AMT FROM PS_PAYMENT_TBL P , PS_VENDOR VEN , PS_PYMNT_VCHR_XREF X WHERE P.REMIT_SETID = VEN.SETID AND P.REMIT_VENDOR = VEN.VENDOR_ID AND P.PYMNT_METHOD IN ('BOO','DFT','BEF') AND P.CANCEL_ACTION = 'N' AND P.PYMNT_DT IS NOT NULL AND P.PYMNT_AMT >= 0 AND P.DFT_STATUS IN ('C','A') 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 GROUP BY P.CURRENCY_PYMNT, P.REMIT_VENDOR, VEN.VENDOR_NAME_SHORT, P.REMIT_SETID, P.VNDR_LOC, P.PYMNT_DT, VEN.OFAC_STATUS, P.PYMNT_AMT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL | Payment Currency |
| 2 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
| 4 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 5 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 7 | SCHEDULED_PAY_DT | Date(10) | DATE | Scheduled to Pay |
| 8 | PYMNT_HOLD | Character(1) | VARCHAR2(1) NOT NULL |
Hold Payment
N=No Y=Yes |
| 9 | EM_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Type |
| 10 | OFAC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
OFAC Status
B=Blocked C=Cleared R=Review V=Valid |
| 11 | EM_TOTAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | EBPP-Added 2000/10/01-Last Mod 2000/10/19 by Matthias Davet Total amount |