PYMNT_FORM_VW3

(SQL View)
Index Back

Payment Forms for Wires


select form_id, form_type, descr from PS_PYMNT_FORM where form_type='ADV'

  • Related Language Record: PYMNT_FORM_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification
    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 DESCR Character(30) VARCHAR2(30) NOT NULL Description