AP_MAPR_FLTR_VW

(SQL View)
 Index Back

Mass Approval for WorkCenter

Used as filter view for Mass Approval for AP WorkCenter

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.INVOICE_ID , A.VENDOR_SETID , A.VENDOR_ID , B.VENDOR_NAME_SHORT , B.NAME1 , A.VOUCHER_STYLE , A.VCHR_SRC , A.APPR_STATUS FROM PS_VOUCHER A , PS_VENDOR B WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID

  • Related Language Record: AP_MAPR_FLTR_LV

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

    Prompt Table: SP_BUS_AP_NONVW

    2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

    Prompt Table: VCHR_AF_MASS_V2

    3 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

    Prompt Table: SP_SETID_NONVW

    5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VNDR_ACT_VW

    6 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    7 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    8 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
    9 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source
    10 APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval status flag used on appr_inst_log and derived records to track virtual approver status
    A=Approved
    D=Denied
    P=Pending