AP_AGE_NEG_VW

(SQL View)
 Index Back

AP Aging Neg Vchr View


SELECT P.TXN_CURRENCY_CD , V.VENDOR_ID , VEN.VENDOR_NAME_SHORT , V.VENDOR_SETID , V.VNDR_LOC , V.BUSINESS_UNIT , P.SCHEDULED_PAY_DT , P.PYMNT_HOLD , 'C' , VEN.OFAC_STATUS , P.PYMNT_GROSS_AMT FROM PS_VOUCHER V , PS_VENDOR VEN , PS_PYMNT_VCHR_XREF P , PS_BUS_UNIT_TBL_FS BU WHERE V.VOUCHER_STYLE NOT IN ('PPAY','TMPL') AND (V.PROCESS_MAN_CLOSE = 'N' OR V.CLOSE_STATUS <> 'C') AND V.ENTRY_STATUS <> 'X' AND V.APPR_STATUS <> 'D' AND V.VENDOR_SETID = VEN.SETID AND V.VENDOR_ID = VEN.VENDOR_ID AND P.PYMNT_SELCT_STATUS NOT IN ('P', 'X','S') AND P.SCHEDULED_PAY_DT IS NOT NULL AND V.BUSINESS_UNIT = P.BUSINESS_UNIT AND V.VOUCHER_ID = P.VOUCHER_ID AND BU.BUSINESS_UNIT = V.BUSINESS_UNIT AND P.PYMNT_GROSS_AMT < 0

# 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