BSP_IMPORT_PROP

(SQL Table)
Index Back

Bank Statement Import

  • Parent record: BSP_IMPORT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPR_DEF_TBL_FS

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number
    4 FORMAT_ID Character(10) VARCHAR2(10) NOT NULL Format ID

    Prompt Table: PMT_FORMAT_VW

    5 PROP_CODE Character(15) VARCHAR2(15) NOT NULL Property code

    Prompt Table: PMT_FORMAT_PROP

    6 VALUE_TR Character(254) VARCHAR2(254) NOT NULL VALUE_TR field for Treausry sub-system. We have used this field to replace VALUE filed.