EXPLODE_BNKACCT(SQL Table) |
Index Back |
---|---|
Explosion Join TableExplosion Join Table - with bank account keys as additional fields. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OLD_VAL_TO_SEQ | Character(50) | VARCHAR2(50) NOT NULL | OLD VALUE |
2 | NEW_VAL_TO_SEQ | Character(50) | VARCHAR2(50) NOT NULL | NEW VALUE |
3 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |
4 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |