TR_WR_TPL_OTHID

(SQL Table)
 Index Back

TR Wire Receiving Acct Detail

Treasury Wire - Receiving Account Information

  • Parent record: TR_WR_TEMPLATE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 TR_WR_TEMPLATE_ID Character(12) VARCHAR2(12) NOT NULL Treasury Wires / Treasury Wire Templates This uniquely identifies templates within a Business Unit.
    3 TRANSFER_CLASS Character(3) VARCHAR2(3) NOT NULL Transfer Class to indicate if Transfer is a Bank Transfer (BAX) or EFT Tansfer
    1=Bank Transfer
    2=EFT Transfer

    Default Value: 2

    4 PMT_PARTY_TYPE Character(4) VARCHAR2(4) NOT NULL Field for Identifying Various Party Types
    CDTR=Creditor
    CRAC=Creditor Account
    CRAG=Creditor Agent
    DBTR=Debtor
    DRAC=Debtor Account
    DRAG=Debtor Agent
    INIT=Initiating Party
    UCDT=Ultimate Creditor
    UDBT=Ultimate Debtor
    5 STL_PARTY_IND Character(1) VARCHAR2(1) NOT NULL Party Indicator for Settlement Parties
    1=Receiver
    2=Agent
    3=Account
    6 ISSR Character(35) VARCHAR2(35) NOT NULL Issuer
    7 OTHER_ID Character(35) VARCHAR2(35) NOT NULL Other Identification
    8 CD Character(30) VARCHAR2(30) NOT NULL Code

    Prompt Table: %EDITTABLE

    9 PRTRY Character(30) VARCHAR2(30) NOT NULL Proprietary
    10 DEFAULT_FLG Character(1) VARCHAR2(1) NOT NULL Default Flag

    Y/N Table Edit

    Default Value: N