GPMY_EFT_MAY_HD

(SQL Table)
Index Back

EFT File - Hdr

Header Record of the EFT file

  • Related Language Record: GPMY_EFT_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 GPMY_DATE_6 Date(10) DATE Date 6
    3 GPMY_BLANKS_37 Character(37) VARCHAR2(37) NOT NULL Filler of size 37.
    4 GPMY_BLANKS_45 Character(45) VARCHAR2(45) NOT NULL Filler of size 42.
    5 GPMY_BANK_CD Character(4) VARCHAR2(4) NOT NULL Bank Code
    6 GPMY_BRANCH_CD Character(17) VARCHAR2(17) NOT NULL Branch Code
    7 GPMY_ACCOUNT_CD Character(11) VARCHAR2(11) NOT NULL Bank Account Number
    8 GPMY_BLANKS_2 Character(2) VARCHAR2(2) NOT NULL Filler of size 2.
    9 GPMY_BLANKS_4 Character(4) VARCHAR2(4) NOT NULL Filler of size 4.
    10 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description
    11 SEQ_NUM5 Number(5,0) INTEGER NOT NULL Sequence Number
    12 GPMY_BNKTRF_ID Character(8) VARCHAR2(8) NOT NULL Bank Transfer ID
    13 GPMY_BLANKS_9 Character(9) VARCHAR2(9) NOT NULL Filler of size 9
    14 GPMY_EFT_RECTYPE Character(1) VARCHAR2(1) NOT NULL EFT Record Type
    15 GPMY_USER_NAME Character(5) VARCHAR2(5) NOT NULL User Name
    16 GPMY_CO_NAME Character(35) VARCHAR2(35) NOT NULL Company Name
    17 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
    18 GPMY_BLANKS_51 Character(51) VARCHAR2(51) NOT NULL Filler of size 51.
    19 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID
    20 GPMY_BNK_USRNO Character(12) VARCHAR2(12) NOT NULL Bank User Number