BANK_RULE_SEQ

(SQL Table)
 Index Back

Bank Override for Pymnt Select

This table specifies how to override one bank on a payment selection with another bank.

  • Parent record: BANK_RULE_VW5

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

    Prompt Table: SP_SETID_NONVW

    2 BANK_RPL_RULE_ID Character(10) VARCHAR2(10) NOT NULL Rule Name

    Prompt Table: BANK_RPL_RULE

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 BANK_RULE_OPTION Character(3) VARCHAR2(3) NOT NULL Option
    1=Paycycle Replacement
    2=Bank Account Replacement
    3=Currency Replacement
    4=Single Pymnt Limit Replacement
    5=Bank Account Limit
    5 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

    Prompt Table: BANK_SETID_VW

    6 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

    Prompt Table: BANK_CD_VW2

    7 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank

    Prompt Table: BANK_ACCT_VW

    8 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
    ACH=Automated Clearing House
    BEF=Draft - Customer EFT
    BOO=Draft - Customer Initiated
    CHK=System Check
    D=Deposit
    DD=Direct Debit
    DFT=Draft - Supplier Initiated
    DRA=Draft
    EFT=Electronic Funds Transfer
    GE=Giro - EFT
    GM=Giro - Manual
    LC=Letter of Credit
    MAN=Manual Check
    TRW=Treasury Wire
    WIR=Wire Transfer

    Prompt Table: BANK_MTHD_VW1

    9 PYMNT_CURRENCY Character(3) VARCHAR2(3) NOT NULL Payment Currency

    Prompt Table: CURR_CD_AP_VW

    10 BANK_SETID_NEW Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

    Prompt Table: SP_BNKSET_NONVW

    11 BANK_CD_NEW Character(5) VARCHAR2(5) NOT NULL A unique key identifier that represents a new bank or counterparty to the system.

    Prompt Table: BANK_NEW_CD_VW

    12 BANK_ACCT_KEY_NEW Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a new account in the system w

    Prompt Table: BANK_NEW_ACT_VW

    13 PRIORITY Number(3,0) SMALLINT NOT NULL Priority