BANK_RECON_MAT

(SQL Table)
 Index Back

Bank Recon Match

Bank Recon Matching - Statement & Transaction matching

  • 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 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    4 RECNAME_RECON1 Character(15) VARCHAR2(15) NOT NULL Source 1 Record

    Prompt Table: RCN_STMT_REC_V

    5 RCN_FIELD1_ALIAS Character(30) VARCHAR2(30) NOT NULL Reconciliation field/record alias name -- user or system defined

    Prompt Table: RCN_FLD_MTCH1_V

    6 FIELD_NAME1 Character(30) VARCHAR2(30) NOT NULL Field Name
    7 RECNAME_RECON2 Character(15) VARCHAR2(15) NOT NULL Source 2 Record

    Prompt Table: RCN_TRAN_REC_V

    8 RCN_FIELD2_ALIAS Character(30) VARCHAR2(30) NOT NULL Reconciliation field/record alias name -- user or system defined

    Prompt Table: RCN_FLD_MTCH2_V

    9 FIELD_NAME2 Character(30) VARCHAR2(30) NOT NULL Field Name
    10 CASE_SENSITIVE Character(1) VARCHAR2(1) NOT NULL Case Sensitive

    Y/N Table Edit

    Default Value: Y