BANK_RULE_VW1

(SQL View)
 Index Back

Bank Override for Pymnt Select

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

SELECT SETID , BANK_RPL_RULE_ID , EFFDT , BANK_RULE_OPTION , BANK_SETID , BANK_CD , BANK_ACCT_KEY , PYMNT_METHOD , PYMNT_CURRENCY , BANK_SETID_NEW , BANK_CD_NEW , BANK_ACCT_KEY_NEW , PYMNT_METHOD_NEW , PROCESS_FLG FROM PS_BANK_RULE_DEFN WHERE BANK_RULE_OPTION = '1'

  • Parent record: PYCYCL

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

    Default Value: 1

    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: BNK_ACCT_CUR_VW

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

    Prompt Table: BANK_SETID_N_VW

    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 PYMNT_METHOD_NEW Character(3) VARCHAR2(3) NOT NULL Payment Method
    CHK=System Generated Check
    EFT=Electronic Funds Transfer
    WIR=Wire Report

    Prompt Table: BANK_MTHD_VW2

    14 PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Processing Flag

    Y/N Table Edit