BS_CYCLEHDR_EC

(SQL Table)
Index Back

Bank Statement Header

  • Parent Record Of BS_BACT_PD_EC_C BS_BACT_PD_EC_E BS_BACT_PD_EC_S BS_BKACT_PD_EC BS_BKACT_SD_EC
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STATEMENT_ID Number(10,0) DECIMAL(10) NOT NULL Statement ID for bank statements, key on Bank Statement Header
    2 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
    3 RESPONSE Character(2) VARCHAR2(2) NOT NULL Response Code
    4 SENDER Character(20) VARCHAR2(20) NOT NULL Sender will be used in bank statements
    5 RECEIVER Character(20) VARCHAR2(20) NOT NULL Receiver is used in bank reconciliation
    6 BSP_PRCS_DT Date(10) DATE Bank Statement Process Date
    7 BNK_LOAD_DTTM DateTime(26) TIMESTAMP The time and date a bank statement is loaded into the system.
    8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: OPR_DEF_TBL_FS.OPRID

    9 FILE_CREATE_DT Date(10) DATE File Creation Date
    10 FILE_CREATE_TIME Time(15) TIMESTAMP File Creation Time
    11 FILE_ID Character(30) VARCHAR2(30) NOT NULL File Identifier
    12 DESCRLONG Long Character CLOB Long Description