STL_INST_OTHID(SQL Table) |
Index Back |
|---|---|
Other ID - Settlement PartiesStores Other Identification for various settlement parties |
| # | 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(35) | VARCHAR2(35) NOT NULL | Issuer | |
| 6 | Character(35) | VARCHAR2(35) NOT NULL | Other Identification | |
| 7 | CD | Character(30) | VARCHAR2(30) NOT NULL |
Code
Prompt Table: %EDITTABLE |
| 8 | PRTRY | Character(30) | VARCHAR2(30) NOT NULL | Proprietary |
| 9 | DEFAULT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Default Flag
Y/N Table Edit Default Value: N |