| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 FORM_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Form Identification
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
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
Default Value: CSO
|
| 4 |
FORM_ALIGNMENT_CNT |
Number(2,0) |
SMALLINT NOT NULL |
Form Alignment Count
|
| 5 |
BEGIN_REMIT_LINE |
Number(3,0) |
SMALLINT NOT NULL |
First Advice Detail Row
|
| 6 |
PYMNT_LINE_CNT |
Number(3,0) |
SMALLINT NOT NULL |
Total Rows on Check
|
| 7 |
ADVICE_BLOCKS |
Number(2,0) |
SMALLINT NOT NULL |
Advice Blocks/Separate Advice
|
| 8 |
PRINT_PYMNT_FORM |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Formatting
Y/N Table Edit
Default Value: Y
|
| 9 |
PRINT_ADVICE_FORM |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Formatting
Y/N Table Edit
Default Value: Y
|
| 10 |
ADVICE_LINE_CNT |
Number(3,0) |
SMALLINT NOT NULL |
Total Rows on Advice
|
| 11 |
REMIT_MAX_LINES |
Number(3,0) |
SMALLINT NOT NULL |
Advice Lines
Default Value: 30
|
| 12 |
PAGE_SIZE |
Number(3,0) |
SMALLINT NOT NULL |
Page Size
Default Value: 60
|
| 13 |
ADVICE_LOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Advice Location
C=Same report as check
N=No advice
S=Separate advice report
Default Value: C
|
| 14 |
ADVICE_LAYOUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Advice Layout
2=Full page
4=Stub over check
6=Check over stub
8=Giro layout
Default Value: 6
|
| 15 |
OVERFLOW_LOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Overflow Location
C=Same report as check
N=No advice report
S=Separate advice report
Default Value: C
|
| 16 |
FORM_TYPE_NEW |
Character(4) |
VARCHAR2(4) NOT NULL |
Form Type
ADV=Remittance advice only
FILE=ASCII File
PREN=Pre-numbered form
SYST=System-numbered form
Default Value: SYST
|