PY_BNKACCT_IDPY_BNKACCT_WRK(SQL Table) |
Index Back |
|---|---|
Bank Account XRef fileThis record is to map the Bank Account ID to Transit Number and Bank Account Number. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PY_BNKACCT_ID |
Character(7) | VARCHAR2(7) NOT NULL | Identification Number to identify transit number and account number |
| 2 | TRANSIT_NUM | Character(9) | VARCHAR2(9) NOT NULL | Bank Transit # |
| 3 | ACCOUNT_NUM | Character(17) | VARCHAR2(17) NOT NULL | Account Number |
| 4 | PY_MASK_ACCTNUM | Character(17) | VARCHAR2(17) NOT NULL | Masked Account Number |
| 5 | PY_BANKACCCRYPT | Character(100) | VARCHAR2(100) NOT NULL | Encrypted Bank Account |
| 6 | PY_NEW_BANKID | Character(1) | VARCHAR2(1) NOT NULL | New Transit and Account Number |