STL_INST_BEI(SQL Table) |
Index Back |
|---|---|
Name1 - BEIStores BEI/BIC for NAME1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | SetID | |
| 2 | Character(5) | VARCHAR2(5) NOT NULL | A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc | |
| 3 | Character(3) | VARCHAR2(3) NOT NULL | Currency Code | |
| 4 | Character(1) | VARCHAR2(1) NOT NULL |
Party Indicator for Settlement Parties
1=Receiver 2=Agent 3=Account |
|
| 5 | Character(3) | VARCHAR2(3) NOT NULL | Standard ID Number | |
| 6 | STD_ID_NUM | Character(35) | VARCHAR2(35) NOT NULL | ID Number |
| 7 | STD_ID_SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 8 | CREDIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Credit Flag
N=No Y=Yes Y/N Table Edit Default Value: N |