TR_WR_TPL_BEI

(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 STD_ID_NUM_QUAL Character(3) VARCHAR2(3) NOT NULL Standard ID Number
    7 STD_ID_NUM Character(35) VARCHAR2(35) NOT NULL ID Number
    8 STD_ID_SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    9 CREDIT_FLG Character(1) VARCHAR2(1) NOT NULL Credit Flag
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N