BANK_RECON_RULE

(SQL Table)
 Index Back

Bank Recon Rule

Bank Recon Rules

  • Related Language Record: BANK_RCN_RL_LNG

  • Parent Record Of BANK_RECON_AGG BANK_RECON_FLTR BANK_RECON_FSQL BANK_RECON_MAT BANK_RECON_MSQL

    • # 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 RULE_NAME_ALIAS Character(30) VARCHAR2(30) NOT NULL Reconciliation Rule Alias
    4 RCN_RULE_STATUS Character(1) VARCHAR2(1) NOT NULL Recon Rule Status - Active/Inactive
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    6 RECON_RULE_TYPE Character(1) VARCHAR2(1) NOT NULL Reconciliation Rule Type
    1=One to One
    2=One to Many
    3=Many to One
    4=Many to Many

    Default Value: 1

    7 LAST_MAINT_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a transaction was last modified

    Default Value: %Datetime

    8 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID