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' |
# | 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 |