SETIDSETTLEMENT_IDBANK_SETTLE_VW2(SQL View) |
Index Back |
|---|---|
Settlement instr view for pmts |
| select SETID, SETTLEMENT_ID, STL_THRU_BANK, STL_THRU_ACCT from PS_BANK_SETTLEMENT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | SETTLEMENT_ID |
Character(5) | VARCHAR2(5) NOT NULL | A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc |
| 3 | STL_THRU_BANK | Character(5) | VARCHAR2(5) NOT NULL | The intermediary transit bank/counterparty utilized for settlement purposes. |
| 4 | STL_THRU_ACCT | Character(4) | VARCHAR2(4) NOT NULL | The intermediary transit bank account utilized for settlement purposes. |