GPES_BANK_FILE

(SQL Table)
Index Back

Bank File Definition

Bank File Definition

  • Related Language Record: GPES_BNKFIL_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPES_FILE_ID Character(5) VARCHAR2(5) NOT NULL Bank file definition ID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 GPES_FILETYPE_ID Character(1) VARCHAR2(1) NOT NULL File type ID for Spain
    C=CSB34-14
    I=CSB34-1 (IBAN)
    S=SEPA
    4 GPES_GROUP_PAY Character(1) VARCHAR2(1) NOT NULL Group Payments in EFT File?

    Y/N Table Edit

    Default Value: N

    5 GPES_MAX_AMOUNT Number(17,2) DECIMAL(16,2) NOT NULL Maximum amount by EFT for bank file
    6 GPES_OPER_CODE Character(3) VARCHAR2(3) NOT NULL Header operation Code for EFT File

    Default Value: 62

    7 GPES_MAX_AMT_NAT Number(17,2) DECIMAL(16,2) NOT NULL Max Amount for National Transfers in EFT file
    8 GPES_OPER_CODE_1 Character(3) VARCHAR2(3) NOT NULL National operation Code for EFT File

    Default Value: 56

    9 GPES_MAX_AMT_TRANS Number(17,2) DECIMAL(16,2) NOT NULL Max Amount for International Transfers in EFT file
    10 GPES_ACTION_1 Character(1) VARCHAR2(1) NOT NULL Action to split or exclude national transfers in EFT File when bigger than GPES_MAX_AMT_NAT
    E=Exclude
    S=Split

    Default Value: E

    11 GPES_OPER_CODE_2 Character(3) VARCHAR2(3) NOT NULL International operation Code for EFT File

    Default Value: 60

    12 GPES_MAX_AMT_SP Number(17,2) DECIMAL(16,2) NOT NULL Max Amount for Special Transfers in EFT file
    13 GPES_INCLUDE_SP Character(1) VARCHAR2(1) NOT NULL Include or Exclude Special Payments in EFT File
    E=Exclude
    I=Include

    Default Value: I

    14 GPES_ACTION_2 Character(1) VARCHAR2(1) NOT NULL Action to split or exclude international transfers in EFT File when bigger than GPES_MAX_AMT_TRANS
    E=Exclude
    S=Split

    Default Value: E

    15 GPES_SUFFIX Character(3) VARCHAR2(3) NOT NULL Suffix code for EFT file

    Default Value: 999

    16 GPES_SEPA_VERSION Character(5) VARCHAR2(5) NOT NULL SEPA Version
    17 GPES_OPER_CODE_3 Character(3) VARCHAR2(3) NOT NULL Special operation Code for EFT File

    Default Value: 61