EM_BUYPMTINQ_LG

(SQL View)
 Index Back

Payments keyed by Supplier -La

Related language view of EM_BUYPMTINQ_VW

SELECT A.REMIT_SETID , A.REMIT_VENDOR , A.EMPLID , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.PYMNT_METHOD , A.PYMNT_ID_REF , A.PYMNT_ID , VL.LANGUAGE_CD , VL.NAME1 , BL.DESCR FROM PS_PAYMENT_TBL A , PS_BANK_CD_VW BNK , PS_BANK_CD_LNG BL , PS_EM_PYMNT_SEC_VW SEC , PS_VENDOR_LANG VL , PS_VENDOR VEN WHERE A.BANK_SETID = SEC.BANK_SETID AND A.BANK_CD = SEC.BANK_CD AND A.BANK_ACCT_KEY = SEC.BANK_ACCT_KEY AND A.PYMNT_ID = SEC.PYMNT_ID AND A.PYMNT_STATUS <> 'X' AND BNK.SETID = A.BANK_SETID AND BNK.BANK_CD = A.BANK_CD AND A.REMIT_SETID = VL.SETID AND A.REMIT_VENDOR = VL.VENDOR_ID AND VL.SETID = VEN.SETID AND VL.VENDOR_ID = VEN.VENDOR_ID AND BNK.SETID = BL.SETID AND BNK.BANK_CD = BL.BANK_CD

  • Related Language Record for EM_BUYPMTINQ_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
    2 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 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

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

    Prompt Table: BANK_CD_TBL

    6 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
    7 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
    ACH=Automated Clearing House
    BEF=Draft - Customer EFT
    BOO=Draft - Customer Initiated
    CHK=System Check
    D=Deposit
    DD=Direct Debit
    DFT=Draft - Supplier Initiated
    DRA=Draft
    EFT=Electronic Funds Transfer
    GE=Giro - EFT
    GM=Giro - Manual
    LC=Letter of Credit
    MAN=Manual Check
    TRW=Treasury Wire
    WIR=Wire Transfer
    8 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference
    9 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
    10 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    11 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

    Default Value: VENDOR_ADDR.NAME1

    12 DESCR Character(30) VARCHAR2(30) NOT NULL Description