BANK_ACT_TYPE

(SQL Table)
 Index Back

Statement Activity Type Tbl

Table containing data for bank statement statement activity types and how to account for them. Note that this table should not be SETID'd because of the nature of bank statement processing.

  • Related Language Record: BNK_ACT_TYP_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STMT_ACTIVITY_TYPE Character(5) VARCHAR2(5) NOT NULL Represents a series of values that provide a more granular definition of a given reconcil

    Prompt Table: BANK_ACT_TYPE

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 ALLOW_FORCE_RECON Character(1) VARCHAR2(1) NOT NULL "Allows a user to designate whether reconciling items can be 'forced reconciled'

    Y/N Table Edit

    Default Value: Y

    5 ACCTG_TMPL_ID Character(15) VARCHAR2(15) NOT NULL A unique key identifier that represents a predefined accounting template, that is a set of rules used to generate debits and credits.

    Prompt Table: BSP_TMPL_NS_VW

    6 TRANSACTION_TBL Character(18) VARCHAR2(18) NOT NULL Represents the database table(s) that contain system source transaction data for reconciliation pu

    Prompt Table: BNK_RCN_TBL_VW