PYCYCL_BNK

(SQL Table)
 Index Back

Bank Pymnt Selection Criteria

  • Parent record: PYCYCL

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_BNKSET_NONVW

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

    Prompt Table: BANK_CD_VW9

    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

    Prompt Table: BANK_ACCT_VW16

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

    Y/N Table Edit

    Default Value: Y