EFT_PAY_INST_VW

(SQL View)
 Index Back

Pr view for EFT Pay Inst Codes

This is a prompt view used for all four EFT payment instruction code fields, EFT_PAY_INST_CD(1 - 4). The view is built over the XLATTABLE. All of the values are stored as xlat values for the field EFT_PAY_INST_CD1.

SELECT %Substring(a.FIELDVALUE,1,3) , XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'EFT_PAY_INST_CD1' AND A.EFF_STATUS <> 'I' AND A.EFFDT <= %CurrentDateIn

  • Related Language Record: EFT_PY_INST_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EFT_PAY_INST_CD1 Character(3) VARCHAR2(3) NOT NULL Payment Instruction 1
    ACC=/ACC/
    BEN=/BENONLY/
    CHK=/CHECK/
    COR=/CORPTRAD/
    HLD=/HOLD/
    INT=/INT/
    IRR=PAYMENT IRREVOCABLE
    PHB=/PHONEBEN/
    PHI=/PHONIBK/
    PHN=/PHON/
    RC1=ADV BEN W/CHARGES
    RC2=ADV BEN W/O CHARGES
    RCB=/RCB/
    REC=/REC/
    REJ=/REJT/
    RET=BEN UNKNOWN RETURN
    TEB=/TELEBEN/
    TEI=/TELEIBK/
    TEL=/TELE/
    XFR=INTERCOMPANY TRANSFER
    2 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name