BNK_BSAC_HDR

(SQL Table)
 Index Back

Bsac Header record

Bank Statement Accounting Header Record.

  • Related Language Record: BNK_BSAC_HDR_LG

  • Parent Record Of BNK_BSAC_DET

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.

    Prompt Table: BANK_ID_VW

    2 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

    Prompt Table: BANK_ACCTNUM_VW

    3 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

    4 ACTIVE_STATUS Character(1) VARCHAR2(1) NOT NULL Transfer Template Status
    A=Active
    I=Inactive

    Default Value: A

    5 ACT_TYP_DFLT Character(15) VARCHAR2(15) NOT NULL Template Default

    Prompt Table: BNK_BSAC_TMPLVW

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

    Default Value: PS_BNK_RCN_TRAN

    Prompt Table: BNK_RCN_TBL_VW

    7 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: N

    8 DESCRLONG Long Character CLOB Long Description
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description