AP_SCHD_INQ_LVW

(SQL View)
 Index Back

Voucher Scheduled Payment


SELECT V.BUSINESS_UNIT , V.VOUCHER_ID , VEN.LANGUAGE_CD , VEN.VENDOR_NAME_SHORT , VEN.NAME1 FROM PS_VOUCHER V , PS_PYMNT_VCHR_XREF A , PS_BANK_ACCT_DEFN B , PS_VENDOR_LANG VEN WHERE A.BUSINESS_UNIT = V.BUSINESS_UNIT AND A.VOUCHER_ID = V.VOUCHER_ID AND B.SETID = A.BANK_SETID AND B.BANK_CD = A.BANK_CD AND B.BANK_CD_CPTY = A.BANK_CD AND B.BANK_ACCT_KEY = A.BANK_ACCT_KEY AND VEN.SETID = V.VENDOR_SETID AND VEN.VENDOR_ID = V.VENDOR_ID AND V.VOUCHER_STYLE NOT IN ('TMPL', 'SGLP') AND (V.PROCESS_MAN_CLOSE = 'N' OR V.CLOSE_STATUS <> 'C') AND V.ENTRY_STATUS <> 'X' AND A.PYMNT_SELCT_STATUS NOT IN ('P','X','S') AND (A.NET_SELCT_STATUS <> 'S' OR A.NET_TXN_STATUS <> 'N') AND EXISTS ( SELECT 'X' FROM PS_BUS_UNIT_TBL_FS WHERE BUSINESS_UNIT = V.BUSINESS_UNIT )

  • Related Language Record for AP_SCHD_INQ_VW

  • Parent record: VOUCHER

    • # 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

    Prompt Table: VCHR_ID_VW

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1