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