EM_SELPMTINQ_LN

(SQL View)
 Index Back

Last 10 Payments - Lang View

EBPP-Created 2000/10/22-Last Mod 2000/10/22 by Matthias Davet This view selects the last 10 payments

SELECT A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , LN.LANGUAGE_CD , LN.NAME1 , BULN.DESCRSHORT FROM PS_PYMNT_VCHR_XREF A , PS_VOUCHER B , PS_PAYMENT_TBL C , PS_VENDOR_USER D , PS_VNDR_BANK_ACCT RMT , PS_VENDOR VEN , PS_VENDOR_LANG LN , PS_BUS_UNIT_TBL_FS FS , PS_BUS_UNIT_LANG BULN WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.DUE_DT IS NOT NULL AND C.BANK_SETID = A.BANK_SETID AND C.BANK_CD = A.BANK_CD AND C.BANK_ACCT_KEY = A.BANK_ACCT_KEY AND C.PYMNT_ID = A.PYMNT_ID AND D.SETID = B.VENDOR_SETID AND D.VENDOR_ID = B.VENDOR_ID AND C.PYMNT_STATUS IN ('P','S','V') AND RMT.SETID = A.REMIT_SETID AND RMT.VENDOR_ID = A.REMIT_VENDOR AND RMT.VNDR_LOC = A.VNDR_LOC AND RMT.BANK_ACCT_SEQ_NBR = A.BANK_ACCT_SEQ_NBR AND RMT.EFFDT = ( SELECT MAX(EFFDT) FROM PS_VNDR_BANK_ACCT RMT1 WHERE RMT1.SETID = RMT.SETID AND RMT1.VENDOR_ID = RMT.VENDOR_ID AND RMT1.VNDR_LOC = RMT.VNDR_LOC AND RMT1.BANK_ACCT_SEQ_NBR = RMT.BANK_ACCT_SEQ_NBR AND RMT1.EFFDT <= B.ENTERED_DT) AND VEN.SETID = A.REMIT_SETID AND VEN.VENDOR_ID = A.REMIT_VENDOR AND FS.BUSINESS_UNIT = A.BUSINESS_UNIT AND FS.BUSINESS_UNIT = BULN.BUSINESS_UNIT AND VEN.SETID = LN.SETID AND VEN.VENDOR_ID = LN.VENDOR_ID

  • Related Language Record for EM_SELPMTINQ_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

    Default Value: OPR_BANK_VW_AP.BANK_SETID

    2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

    Prompt Table: BANK_CD_TBL

    3 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

    Prompt Table: EM_RM_VENDOR_VW

    6 EM_BU_NAME_SHORT Character(10) VARCHAR2(10) NOT NULL Buyer Short Name