BNK_ACCT_RCN_LN

(SQL Table)
 Index Back

Acct Recon Attributes

12/12/2005 cmh Removed fields RECON_ACCT_TYPE and TRANSACTION_TBL

  • Related Language Record for BNK_ACCT_RCN_SC

  • Parent record: BANK_CD_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

    Prompt Table: BANK_CD_TBL

    3 BANK_CD_CPTY Character(5) VARCHAR2(5) NOT NULL An internal key field convention that facilitates the system distinction between banks and counterparties.

    Prompt Table: BANK_CD_TBL

    4 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank

    Prompt Table: BANK_ACCT_DEFN

    5 RECON_SOURCE Character(2) VARCHAR2(2) NOT NULL Represents the source system table(s) for reconciling items.
    00=Bank Statement
    01=Receivables Deposits
    02=Payables
    03=Treasury
    04=Receivables Drafts
    05=External Transactions
    06=Receivables Payments
    07=Direct Debits
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description