AP_WC_VCHPST_V1

(SQL View)
 Index Back

Vouchers Eligible for Posting


SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.VENDOR_SETID , A.VENDOR_ID , B.VENDOR_NAME_SHORT , B.NAME1 , A.INVOICE_ID , A.INVOICE_DT , A.ORIGIN , A.GRP_AP_ID , A.OPRID , A.OPRID_LAST_UPDT , A.ENTERED_DT FROM PS_VOUCHER A , PS_VENDOR B , PS_BUS_UNIT_TBL_AP C WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.ENTRY_STATUS = 'P' AND A.IN_PROCESS_FLG = 'N' AND A.BUDGET_HDR_STATUS = 'V' AND A.BUDGET_MISC_STATUS = 'V' AND A.DOC_TOL_HDR_STATUS = 'V' AND (A.PROCESS_MAN_CLOSE = 'Y' OR A.POST_STATUS_AP = 'U') AND A.VCHR_LINE_APPR IN ('0', '1') AND A.POST_VOUCHER IN ('D', 'P') AND (A.APPR_STATUS = 'A' OR (A.APPR_STATUS <> 'A' AND C.POST_UNAPPRV_FLG = 'Y')) AND ((C.POST_UNMATCH_FLG = 'Y') OR (C.POST_UNMATCH_FLG = 'N' AND (A.MATCH_STATUS_VCHR = 'N' OR A.MATCH_STATUS_VCHR = 'M')))

  • Related Language Record: AP_WC_VCHPST_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
    3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    5 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    7 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    8 INVOICE_DT Date(10) DATE Invoice Date
    9 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
    10 GRP_AP_ID Character(10) VARCHAR2(10) NOT NULL Control Group ID
    11 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    12 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update
    13 ENTERED_DT Date(10) DATE Entered on