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    AR32.1    AR34.1
AR570     AR575     AR580     AR82.1    CB06.2    CB10.1
CB145     CB15.1    CB15.2    CB150     CB180     CB186
CB187     CB190     CB191     CB20.1    CB25.1    CB46.1
CB500     CB543     CB544     DT180     DT181     DT185
DT92.1    CB195     CB99.1

UPDATED BY

CB185     CB30.1    CB300     CB80.1    CB82.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CBJ-CASH-CODE          Alpha 4                                   CB185   CB80.1
Element: Cash Code     The cash code. Represents a bank          CB82.1
                       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      CB82.1
                       unique value used to identify the
                       transaction.

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

CBJ-BANK-INST-CODE     Alpha 3                                   CB185   CB80.1
Element: Transaction CoThe transaction code. Represents the      CB82.1
                       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                 CB82.1
                       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    CB82.1
                       the transaction. Must be a valid record
                       in the General Ledger Company file.

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

CBJ-RECON-BNK-AMT      Signed 18.2                               CB185   CB80.1
Acct Currency          The reconciled amount of the              CB82.1
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 18.2                               CB185   CB80.1
Base Currency          The issued amount of the transaction in   CB82.1
Issued Amount          the company base currency.

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

CBJ-RECON-CNV-RATE     Signed 14.7                               CB185   CB30.1
Reconciliation         The currency exchange rate used to        CB80.1  CB82.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 18.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 18.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
Element: Reconcile DateThe reconciliation date of the bank       CB80.1  CB82.1
                       transaction. If left blank, the system
                       date defaults.

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

CBJ-REC-STATUS         Numeric 1                                 CB30.1
Element: Reconcile StatThe record status. Valid values are:

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

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

CBJ-RECON-STMT-NBR     Numeric 12                                CB185   CB80.1
Reconcile Statement    The reconciliation statement number       CB82.1
Number                 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-CODE                                         AP170   AP180
          TRANS-IDENT                                            AP181   AP190
                                                                 AP255   AP265
                                                                 AP81.1  AP90.5
                                                                 AR115   AR124
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR32.1  AR34.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB06.2  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB150
                                                                 CB180   CB185
                                                                 ...

CBJSET2   CASH-CODE     KeyChange
          REC-STATUS
          BANK-INST-CODE
          TRANS-NBR
          SUFFIX
          TRANS-IDENT

CBJSET3   CASH-CODE     KeyChange                                CB185   CB195
          BANK-INST-CODE                                         CB30.1  CB80.1
          TRANS-NBR                                              CB82.1  CB99.1
          SUFFIX
          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