STL_INST_BEI

(SQL Table)
Index Back

Name1 - BEI

Stores BEI/BIC for NAME1

  • 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 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