GP_BNK_FILE_HDR

(SQL Table)
Index Back

Bank File Header

Header Record for Bank File

  • Related Language Record: GP_BNK_FHDR_LNG
  • Parent Record Of GP_BNK_FILE_DTL GP_BNK_FILE_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID

    Prompt Table: GP_BNK_CD_VW
    Set Control Field: SRC_BANK_ID

    2 ACCOUNT_EC_ID Character(35) VARCHAR2(35) NOT NULL Account Number used in banking.

    Prompt Table: GP_BNK_EC_ID_VW

    3 BNK_FILE_ID Number(10,0) DECIMAL(10) NOT NULL Auto generated number when Bank File is loaded

    Prompt Table: GP_BNK_FL_ID_VW

    4 BNK_RUN_STAT Character(2) VARCHAR2(2) NOT NULL Bank File Reconciliation Status
    10=Ready
    20=In Progress
    30=Complete

    Default Value: 10

    5 ASOFDATE Date(10) DATE As of Date

    Default Value: %date

    6 BNK_LOAD_DTTM DateTime(26) TIMESTAMP BNK_LOAD_DTTM

    Default Value: %Datetime

    7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPRID_VW

    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description