STL_INST_OTHID

(SQL Table)
Index Back

Other ID - Settlement Parties

Stores Other Identification for various settlement parties

  • Parent record: STL_INSTRUCTION
  • # 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 ISSR Character(35) VARCHAR2(35) NOT NULL Issuer
    6 OTHER_ID 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