Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CBADJUST


                             CBADJUST FILE

                       Reconciliation Adjustment

The Reconciliation Adjustment file contains Cash Ledger transaction
reconciliation adjustment records. The system creates these records when the
reconciled amount of a transaction is higher or lower than the transaction
amount beyond the accepted tolerance. The reconciliation adjustment must be
approved and released before the transaction is considered reconciled.

REFERENCED BY

AP170     AP180     AP181     AP190     AP255     AP265
AP81.1    AP90.5    AR115     AR124     AR20.1    AR21.1
AR21.2    AR21.3    AR24.1    AR30.1    AR30.2    AR30.4
AR570     AR575     AR580     AR82.1    CB06.2    CB10.1
CB15.1    CB15.2    CB180     CB190     CB191     CB20.1
CB25.1    CB500     DT180     DT181     DT185     DT92.1
CB195     CB99.1

UPDATED BY

CB185     CB30.1    CB300     CB80.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CBJ-CASH-CODE          Alpha 4                                   CB185   CB80.1
Accounts Receivable    The cash code. Represents a bank
Code                   account. Must be a valid record in the
                       Cash Code file.

CBJ-TRANS-NBR          Alpha 10  (Right Justified)               CB185   CB80.1
Element: Transaction NuThe transaction number. Represents a
                       unique value used to identify the
                       transaction.

CBJ-SUFFIX             Numeric 3                                 CB185   CB80.1
Element: Transaction SuThe transaction suffix number.
                       Represents the occurrence value of the
                       transaction.

CBJ-BANK-INST-CODE     Alpha 3                                   CB185   CB80.1
Element: Transaction CoThe transaction code. Represents the
                       type of banking transaction. Must be a
                       valid transaction code record in the
                       Bank Transaction Code file.

CBJ-TRANS-IDENT        Numeric 10                                CB185   CB80.1
Element: Transaction IDA unique system-generated
                       identification value assigned to the
                       transaction to make this record unique.

CBJ-COMPANY            Numeric 4                                 CB185   CB80.1
Element: Company       The company responsible for generating
                       the transaction. Must be a valid record
                       in the General Ledger Company file.

CBJ-ISSUE-BNK-AMT      Signed 15.2                               CB185   CB80.1
Acct Currency          The issued amount of the transaction in
Issued Amount          the currency of the bank account.

CBJ-RECON-BNK-AMT      Signed 15.2                               CB185   CB80.1
Acct Currency          The reconciled amount of the
Issued Amount          transaction in the currency of the bank
                       account. This is the amount of the
                       transaction recognized by the bank.

CBJ-ISSUE-BASE-AMT     Signed 15.2                               CB185   CB80.1
Base Currency          The issued amount of the transaction in
Issued Amount          the company base currency.

CBJ-RECON-BASE-AMT     Signed 15.2                               CB185   CB80.1
Base Currency          The reconciled amount of the
Reconciled Amt         transaction in the company base
                       currency.

CBJ-RECON-CNV-RATE     Signed 12.6                               CB185   CB30.1
Reconciliation         The currency exchange rate used to        CB80.1
Exchange Rate          convert the transaction amount from the
                       bank account currency to the company
                       base currency. This is the rate in
                       effect at the time the bank recognized
                       the bank transaction.

CBJ-DIST-APPLIED       Signed 15.2                               CB30.1
Distribution           The amount of general ledger
Applied Amount         distributions that have been applied to
                       the reconciliation adjustment in the
                       currency of the bank account. The
                       reconciliation adjustment can not be
                       released until the reconciliation
                       difference matches this distribution
                       applied amount value.

CBJ-BASE-APPLIED       Signed 15.2                               CB30.1
Base Distribution      The amount of general ledger
Applied Amt            distributions that have been applied to
                       the reconciliation adjustment in the
                       company base currency.

CBJ-RECON-DATE         Numeric 8  (yyyymmdd)                     CB185   CB30.1
Reconciliation or      The reconciliation date of the bank       CB80.1
Void Date              transaction. If left blank, the system
                       date defaults.

CBJ-POST-DATE          Numeric 8  (yyyymmdd)                     CB185   CB30.1
Element: Date          The date used for posting the             CB80.1
                       reconciliation transactions to the
                       general ledger. If left blank, system
                       date defaults.

CBJ-REC-STATUS         Numeric 1                                 CB30.1
Element: Record Status The record status. Valid values are:

                       0 = Unreleased (Unreconciled).
                       1 = Released (Reconciled).

CBJ-JRNL-BOOK-NBR      Alpha 12                                  CB185   CB80.1
Element: Journal Book  The journal book associated with the
                       transaction reconciliation adjustment.

CBJ-RECON-STMT-NBR     Numeric 12                                CB185   CB80.1
Reconciliation         The reconciliation statement number
Statement              associated with the reconciliation
                       adjustment. Used only for cash codes
                       that require reconciliation statements.

                         CBADJUST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CBJSET1   BANK-INST-CODEThis is the primary index used to keep   AP170   AP180
          TRANS-IDENT   reconciliation variance adjustment       AP181   AP190
                        records unique.                          AP255   AP265
                                                                 AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB180   CB185
                                                                 CB190   CB191
                                                                 ...

CBJSET2   CASH-CODE     This index is used to access
          REC-STATUS    reconciliation variance adjustment
          BANK-INST-CODErecords by status.
          TRANS-NBR     KeyChange
          SUFFIX
          TRANS-IDENT

CBJSET3   CASH-CODE     This index is used to find a             CB185   CB195
          BANK-INST-CODEreconciliation variance adjustment       CB30.1  CB80.1
          TRANS-NBR     record for a specific bank transaction.  CB99.1
          SUFFIX        KeyChange
          TRANS-IDENT

                         CBADJUST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Adjust Distrib CBDISTRIB

                            CBJ-CASH-CODE         -> CBD-CASH-CODE
                            CBJ-BANK-INST-CODE    -> CBD-BANK-INST-CODE
                            CBJ-TRANS-IDENT       -> CBD-TRANS-IDENT
                            "R"                   -> CBD-DIST-TYPE
                                                     CBD-SEQ-NBR