| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PY_BNKREC_SEQ |
Number(9,0) |
DECIMAL(9) NOT NULL |
Bank Transit and Account Number Count
|
| 2 |
TRANSIT_NUM |
Character(9) |
VARCHAR2(9) NOT NULL |
Bank Transit #
|
| 3 |
ACCOUNT_NUM |
Character(17) |
VARCHAR2(17) NOT NULL |
Account Number
|
| 4 |
PY_REMAIN_DATA |
Character(31) |
VARCHAR2(31) NOT NULL |
Bank File information including Check Number, Check Date and Net Pay
|
| 5 |
PY_BNKACCT_ID |
Character(7) |
VARCHAR2(7) NOT NULL |
Identification Number to identify transit number and account number
|