PYCYCL_MTHD

(SQL Table)
 Index Back

Pymnt Methods for Pymnt Select

  • Parent record: PYCYCL_BNK

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle
    2 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
    3 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    4 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
    5 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

    Default Value: CHK

    Prompt Table: PYCYCL_MTHD_VW

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

    Y/N Table Edit

    Default Value: Y

    7 VALUE_DT Date(10) DATE Equivalent to a deal transaction's settlement date.