VCHR_UNPST_SRCH

(SQL View)
 Index Back

Search view for Vchr Unpost


SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.INVOICE_ID , A.INVOICE_DT , A.VENDOR_SETID , B.VENDOR_NAME_SHORT , A.VENDOR_ID , B.NAME1 , A.VOUCHER_STYLE FROM PS_VOUCHER A , PS_VENDOR B , PS_BUS_UNIT_INTFC E WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.POST_STATUS_AP = 'P' AND A.IN_PROCESS_FLG = 'N' AND A.PROCESS_MAN_CLOSE = 'N' AND A.VOUCHER_STYLE NOT IN ('CLBK' , 'AMR') AND E.BUSINESS_UNIT = A.BUSINESS_UNIT_GL AND NOT EXISTS ( SELECT 'X' FROM PS_VCHR_PPAY_XREF C WHERE A.VOUCHER_STYLE = 'PPAY' AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.VOUCHER_ID = C.VOUCHER_ID AND C.PREPAID_STATUS IN ('A','F')) AND ((E.UNPOST_PAID_VCHR = 'N' AND NOT EXISTS ( SELECT 'X' FROM PS_PYMNT_VCHR_XREF D WHERE A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.VOUCHER_ID = D.VOUCHER_ID AND D.PYMNT_SELCT_STATUS IN('P', 'S'))) OR (E.UNPOST_PAID_VCHR = 'Y' AND NOT EXISTS ( SELECT 'X' FROM PS_VCHR_LINE_WTHD WTHD WHERE A.BUSINESS_UNIT = WTHD.BUSINESS_UNIT AND A.VOUCHER_ID = WTHD.VOUCHER_ID AND WTHD.WTHD_APPL_FLG = 'V' AND EXISTS( SELECT 'X' FROM PS_PYMNT_VCHR_XREF XREF WHERE WTHD.BUSINESS_UNIT = XREF.BUSINESS_UNIT AND WTHD.VOUCHER_ID = XREF.VOUCHER_ID AND XREF.PYMNT_SELCT_STATUS IN('P', 'S') AND XREF.PYMNT_ACTION <> 'P'))))

  • Related Language Record: VCHR_UNPST_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_AP_NONVW

    2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
    3 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    4 INVOICE_DT Date(10) DATE NOT NULL Invoice Date
    5 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    6 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR_PRIM_VW

    8 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    9 VOUCHER_STYLE Character(4) VARCHAR2(4) NOT NULL Voucher Style
    ADJ=Adjustments
    AMR=Amortization Voucher
    CLBK=Claim Voucher
    CORR=Reversal Voucher
    JRNL=Journal Voucher
    PPAY=Prepaid Voucher
    REG=Regular Voucher
    RGTR=Register Voucher
    SGLP=Single Payment Voucher
    THRD=Third Party Voucher
    TMPL=Template Voucher