CNTRCT_EVPAY_VW

(SQL View)
 Index Back

Contract Event Vchr Pay Detail


SELECT a.business_unit , a.voucher_id , a.bank_cd , a.bank_acct_key , a.pymnt_id , b.pymnt_id_ref , a.pymnt_gross_amt , a.currency_pymnt , a.paid_amt , b.pymnt_amt , b.pymnt_dt , b.pymnt_status , b.remit_setid , b.remit_vendor , c.vendor_name_short , c.name1 , b.bank_setid , a.pymnt_selct_status , d.txn_currency_cd , b.pymnt_method FROM ps_pymnt_vchr_xref a , ps_payment_tbl b , ps_vendor c , PS_VOUCHER d WHERE a.bank_setid = b.bank_setid AND a.bank_cd = b.bank_cd AND a.bank_acct_key = b.bank_acct_key AND a.pymnt_id = b.pymnt_id AND b.remit_setid = c.setid AND b.remit_vendor = c.vendor_id AND a.business_unit = d.business_unit AND a.voucher_id = d.voucher_id

  • Related Language Record: CNTRCT_EVP_VWLN

    • # 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 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    4 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
    5 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
    6 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference
    7 PYMNT_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Payment Amount
    8 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
    9 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
    10 PYMNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Amount
    11 PYMNT_DT Date(10) DATE Payment Date
    12 PYMNT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Status
    A=Alignment
    E=ACH/EFT Prenote
    L=Stale Dated Payment
    N=Reprinted with same ref number
    O=Overflow
    P=Paid
    R=Replaced
    S=Stopped
    T=Undo Escheatment
    U=Undo Cancel
    V=Void
    W=Escheated Check
    X=Deleted
    13 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
    14 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
    15 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    16 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    17 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
    18 PYMNT_SELCT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Selection Status
    C=Closed
    D=Negative Voucher Sum
    E=Externally Paid
    F=Federal Sanctions Error
    I=In Process - EFT
    N=Not Selected for Payment
    O=Financial Sanctions Review
    P=Paid
    R=Requested for Payment
    S=Settlement Payment
    V=Convert Error
    X=Canceled
    Y=Prepaid
    19 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
    20 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