BANK_RECON_AGG

(SQL Table)
 Index Back

Bank Recon Aggregate

Bank Recon Aggregate - Statement & Transaction field aggregate

  • Parent record: BANK_RECON_RULE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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
    2 RULE_ID_RECON Character(20) VARCHAR2(20) NOT NULL Reconciliation Rules Id
    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    4 RCN_FIELD_ALIAS Character(30) VARCHAR2(30) NOT NULL Reconciliation field/record alias name -- user or system defined
    5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    6 RCN_RECORD_TYPE Character(1) VARCHAR2(1) NOT NULL For reconciliation, this is either a transaction or a statement line
    0=Statement
    1=Transaction
    2=Event Record
    3=App Engine Temporary Record
    4=Event Record
    5=AE Temporary Table