EOFM_FT_SVW_LNG

(SQL View)
 Index Back

Form Type


SELECT A.FORM_OWNER_ID , A.FORM_TYPE , LG.LANGUAGE_CD , LG.PORTAL_LABEL , LG.DESCR254 FROM PS_FORM_TYPE A , PS_FORM_TYPE_LG LG WHERE A.FORM_TYPE = LG.FORM_TYPE

  • Related Language Record for EOFM_FT_SVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 FORM_TYPE Character(10) VARCHAR2(10) NOT NULL Form and Builder Field
    ADV=Remittance Advice Only
    CAV=Check with Separate Advice
    CRA=Crystal Check w/Advice
    CRW=Crystal Check
    CSA=Check over Stub with Advice
    CSO=Check over Stub with Overflow
    EFA=EFT File with Advice
    EFT=EFT File
    SCA=Stub over Check with Advice
    SCO=Stub over Check with Overflow
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
    5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254