BNK_ID_NBRPrompt Table: EBK_BANK_MAIN
BRANCH_IDPrompt Table: EBK_BANK_BRANCH
A=Active
I=Inactive
P=Pending
EBK_BANK_BRANCH(SQL Table) |
Index Back |
|---|---|
Supplier / Employee Bank Branc |
| # | 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.
Prompt Table: EBK_BANK_MAIN |
| 2 | BRANCH_ID |
Character(10) | VARCHAR2(10) NOT NULL |
The local branch office identifier associated with a given bank/counterparty.
Prompt Table: EBK_BANK_BRANCH |
| 3 | BENEF_BRANCH | Character(30) | VARCHAR2(30) NOT NULL | Beneficiary Branch field |
| 4 | BENEF_BRANCH_AC | Character(30) | VARCHAR2(30) NOT NULL | Branch Alternate Char |
| 5 | BRANCH_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Branch Status - Active/Inactive
A=Active I=Inactive P=Pending |
| 6 | ADDRESS_CC | Character(110) | VARCHAR2(110) NOT NULL | Field to Store CC Address |
| 7 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 8 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 9 | CLEARING_NUMBER | Character(8) | VARCHAR2(8) NOT NULL | Clearing number field |
| 10 | ADDITIONAL | Character(1) | VARCHAR2(1) NOT NULL | Additional |