AP_WIRLYT_VW

(SQL View)
 Index Back

WIR layout VW

FG WIRlayouts

SELECT A.FORMAT_ID , '01' , A.FORMAT_NAME FROM PS_PMT_FORMAT_DEFN A , PS_PMT_FORMAT_MTHD B WHERE A.FORMAT_ID = B.FORMAT_ID AND B.PYMNT_METHOD = 'WIR'

  • Related Language Record: AP_WIRLYT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EFT_LAYOUT_CD Character(10) VARCHAR2(10) NOT NULL EFT Layout Code
    2 STL_THROUGH Character(2) VARCHAR2(2) NOT NULL Settle through
    01=Financial Gateway
    02=Pay Cycle
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description