STL_INSTRUCT_VW

(SQL View)
 Index Back

Our Settlement Instructions Vw

BNK_ID_NBR1 was used instead of BNK_ID_NBR to force Bank_Edits to look up the hierarchy for Bank #.

SELECT H.SETID ,D.CURRENCY_CD ,H.SETTLEMENT_ID ,H.DESCR ,D.BNK_ID_NBR ,D.BRANCH_ID ,D.BANK_ACCT_TYPE ,D.BANK_ACCOUNT_NUM ,D.CHECK_DIGIT ,D.DFI_ID_QUAL ,D.DFI_ID_NUM ,D.IBAN_CHECK_DIGIT FROM PS_STL_INSTRUCT_H H ,PS_STL_INSTRUCTION D WHERE H.SETTLEMENT_TYPE='R' AND H.SETID=D.SETID AND H.SETTLEMENT_ID=D.SETTLEMENT_ID

  • Related Language Record: STL_INSTR_LNG_V

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    3 SETTLEMENT_ID Character(5) VARCHAR2(5) NOT NULL A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc

    Prompt Table: STL_INSTRUCTION

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 BNK_ID_NBR1 Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given internal counterparty.
    6 BRANCH_ID Character(10) VARCHAR2(10) NOT NULL The local branch office identifier associated with a given bank/counterparty.
    7 BANK_ACCT_TYPE Character(2) VARCHAR2(2) NOT NULL An account attribute that describes the ostensible purposes of a given bank/counterparty account.
    01=Time Deposit
    03=Checking Account
    05=Stock
    06=Bond
    07=Life Insurance Value
    08=Retirement Account
    10=Business Account
    11=Trust Fund Account
    12=Stock & Bond Account
    13=Life Insurance Acct
    CA=Current Account
    CH=Charges Account
    DA=Demand Deposit
    LN=Loan
    RD=Return Items on DDA
    RS=Return Items-Savings
    SA=Settlement Account
    SV=Savings Account
    Z=Mutually Defined
    8 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
    9 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit
    10 DFI_ID_QUAL Character(2) VARCHAR2(2) NOT NULL A banking industry convention identifier utilized to drive data validation for a given bank/counterparty.
    01=Transit Number
    02=Swift ID/BIC
    03=CHIPS Participant ID
    04=Canadian Bank Branch/Institute
    05=CHIPS Universal ID
    ZZ=Mutually Defined
    11 DFI_ID_NUM Character(12) VARCHAR2(12) NOT NULL A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun
    12 IBAN_CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL IBAN Check Digit