# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
|
2 |
BRANCH_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
The local branch office identifier associated with a given bank/counterparty.
|
3 |
BENEFICIARY_BNK_AC |
Character(30) |
VARCHAR2(30) NOT NULL |
Alternate Character Set field for BENEFICIARY_BANK
|
4 |
BENEFICIARY_BANK |
Character(30) |
VARCHAR2(30) NOT NULL |
The bank/counterparty associated with a given beneficiary.
|
5 |
BENEF_BRANCH_AC |
Character(30) |
VARCHAR2(30) NOT NULL |
Branch Alternate Char
|
6 |
BENEF_BRANCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Beneficiary Branch field
|
7 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
8 |
ADDRESS_CC |
Character(110) |
VARCHAR2(110) NOT NULL |
Field to Store CC Address
|
9 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
10 |
CLEARING_NUMBER |
Character(8) |
VARCHAR2(8) NOT NULL |
Clearing number field
|
11 |
ADDITIONAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional
|