AP_AGE_PPAY_VW2

(SQL View)
 Index Back

AP Aging Prepaid Vw2


SELECT X.TXN_CURRENCY_CD , V.VENDOR_ID , VEN.VENDOR_NAME_SHORT , V.VENDOR_SETID , V.BUSINESS_UNIT , V.VOUCHER_ID , X.PYMNT_CNT , P.AVAILABLE_AMT , X.SCHEDULED_PAY_DT , X.PYMNT_HOLD FROM PS_VOUCHER V , PS_VCHR_PPAY_XREF P , PS_VENDOR VEN , PS_PYMNT_VCHR_XREF X , PS_BUS_UNIT_TBL_FS BU WHERE V.VOUCHER_STYLE = 'PPAY' AND (V.PROCESS_MAN_CLOSE = 'N' OR V.CLOSE_STATUS <> 'C') AND V.ENTRY_STATUS = 'P' AND V.APPR_STATUS = 'A' AND V.VENDOR_SETID = VEN.SETID AND V.VENDOR_ID = VEN.VENDOR_ID AND V.BUSINESS_UNIT = P.BUSINESS_UNIT AND V.VOUCHER_ID = P.VOUCHER_ID AND P.PREPAID_STATUS = 'P' AND X.SCHEDULED_PAY_DT IS NOT NULL AND V.BUSINESS_UNIT = X.BUSINESS_UNIT AND V.VOUCHER_ID = X.VOUCHER_ID AND X.PYMNT_TYPE = 'R' AND X.PYMNT_SELCT_STATUS = 'P' AND BU.BUSINESS_UNIT = V.BUSINESS_UNIT AND BU.BUSINESS_UNIT = V.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
7 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
8 AVAILABLE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Prepayment Available Amount
9 SCHEDULED_PAY_DT Date(10) DATE Scheduled to Pay
10 PYMNT_HOLD Character(1) VARCHAR2(1) NOT NULL Hold Payment
N=No
Y=Yes