EFT_PY_INST_LNG

(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) , C.LANGUAGE_CD , C.XLATLONGNAME FROM PSXLATITEM A , PSXLATITEMLANG C WHERE A.FIELDNAME = 'EFT_PAY_INST_CD1' AND A.EFF_STATUS <> 'I' AND A.EFFDT <= %CurrentDateIn AND A.FIELDNAME = C.FIELDNAME AND A.FIELDVALUE = C.FIELDVALUE AND A.EFFDT = C.EFFDT

  • Related Language Record for EFT_PAY_INST_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name