BANK_COLCT_LYT

(SQL Table)
 Index Back

Layout Codes for Collections

Layout Codes for Collections - allows for multiple layout codes per bank account payment method

  • Parent record: BANK_COLCT_MTHD

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    3 BANK_CD_CPTY Character(5) VARCHAR2(5) NOT NULL An internal key field convention that facilitates the system distinction between banks and counterparties.
    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 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
    ACH=ACH
    CC=Credit Card
    CHK=Check
    CSH=Cash
    DD=Direct Debit
    DR=Draft
    EC=Electronic Check
    EFT=Electronic Fund Transfer
    GE=Giro - EFT
    PL=PayPal
    WIR=Wire Report
    6 EFT_LAYOUT_CD Character(10) VARCHAR2(10) NOT NULL EFT Layout Code

    Prompt Table: %EDITTABLE

    7 DEFAULT_FLG Character(1) VARCHAR2(1) NOT NULL Default Flag

    Y/N Table Edit

    Default Value: N

    8 STL_THROUGH Character(2) VARCHAR2(2) NOT NULL Settle through
    01=Financial Gateway
    02=Pay Cycle

    Default Value: 02

    9 LAST_EFT_FILE_ID Character(4) VARCHAR2(4) NOT NULL Last File Number
    10 COMPANY_ID Character(20) VARCHAR2(20) NOT NULL Company ID - Company Tax ID
    11 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254