STL_INST_BEI(SQL Table) |
Index Back |
---|---|
Name1 - BEIStores BEI/BIC for NAME1 |
# | 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 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
4 | STL_PARTY_IND | Character(1) | VARCHAR2(1) NOT NULL |
Party Indicator for Settlement Parties
1=Receiver 2=Agent 3=Account |
5 | STD_ID_NUM_QUAL | 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 |