Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            CBCASHCODE FILE

                               Cash Code

The Cash Code file contains all valid cash codes. A cash code represents a
bank account at a financial institution location.

REFERENCED BY

AR01.1    AR02.1    AR29.2    AR48.2    AR700     CB05.1
CB11.1    CB211

UPDATED BY

AP00.3    AP00.4    AP00.5    AP01.1    AP10.1    AP10.2
AP10.5    AP10.6    AP110     AP115     AP125     AP126
AP150     AP151     AP155     AP156     AP160     AP161
AP166     AP167     AP170     AP180     AP181     AP190
AP195     AP20.1    AP20.2    AP20.3    AP20.4    AP20.5
AP20.6    AP20.7    AP20.8    AP200     AP23.1    AP230
AP25.1    AP25.2    AP250     AP255     AP26.1    AP265
AP266     AP27.1    AP270     AP28.1    AP28.2    AP30.3
AP510     AP520     AP55.1    AP55.2    AP56.1    AP56.2
AP80.1    AP80.2    AP81.1    AP90.5    AP91.1    API1.1
API2.1    API3.1    API4.1    AR115     AR124     AR14.1
AR20.1    AR21.1    AR21.2    AR21.3    AR24.1    AR27.1
AR28.9    AR30.1    AR30.2    AR30.4    AR42.1    AR42.2
AR42.6    AR42.7    AR43.1    AR44.3    AR502     AR560
AR570     AR575     AR580     AR82.1    CB00.2    CB00.3
CB00.5    CB02.1    CB06.1    CB06.2    CB10.1    CB10.3
CB15.1    CB15.2    CB175     CB180     CB185     CB190
CB191     CB195     CB20.1    CB210     CB215     CB220
CB221     CB25.1    CB260     CB30.1    CB300     CB500
CB80.1    CB90.1    CB90.2    CB90.3    CB90.4    CB99.1
DT150     DT155     DT160     DT161     DT165     DT166
DT170     DT180     DT181     DT185     DT270     DT30.1
DT30.2    DT40.1    DT45.1    DT520     DT60.1    DT60.2
DT70.1    DT70.3    DT80.1    DT80.4    DT85.1    DT85.2
DT90.1    DT90.2    DT90.3    DT92.1    EE135     EE20.1
EE20.2    EE20.4    EE35.1    EE35.2    EE520     IC840
MA41.2    MA43.2    MA61.1    MAI1.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CBC-CASH-CODE        Alpha 4                                     CB00.2  CB99.1
Cash Code            A user-defined code representing a bank
                     account at a bank location.

CBC-BANK-ACCT-NBR    Alpha 17                                    CB00.2
Bank Account Number  The bank-assigned account number
                     identification to be used for the cash
                     code.


CBC-CURRENCY-CODE    Alpha 5                                     CB00.2
Bank Account         The currency of the bank account. Must
Currency             be a valid record in the Currency Code
                     file.

CBC-BANK-ENTITY      Alpha 15                                    CB00.2
Bank Identification  The bank location where the bank
                     account is located. Must be a valid
                     record in the Bank file.

CBC-SEND-BANK-ENT    Alpha 15                                    CB00.2
Electronic Transfer  If the bank for the cash code does not
Bank                 process electronic payments, this field
                     contains the bank that processes the
                     electronic payment media, if applicable.
                     Must be a valid record in the Bank file.
                     If left blank, the Bank Identification
                     defaults.

CBC-ACTIVE-STATUS    Alpha 1                                     CB00.2
Status               The status of the of the bank account.
                     If the bank account is Inactive, new
                     bank transactions cannot be entered for
                     the bank account, but bank transactions
                     already entered in the system can be
                     processed and reconciled. Valid values
                     are:

                     A = Active.
                     I = Inactive.

CBC-REC-BALANCE      Signed 15.2                                 AP170   AP180
Reconciled Balance   The current reconciled balance of the       AP181   AP190
                     bank account.                               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
                                                                 CB00.2  CB06.2
                                                                 CB10.1  CB15.1
                                                                 CB15.2  CB180
                                                                 CB185   CB190
                                                                 CB191   CB20.1
                                                                 CB25.1  CB30.1
                                                                 CB500   CB80.1
                                                                 CB99.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBC-OPEN-BALANCE     Signed 15.2                                 AP170   AP180
Open Balance         The current outstanding, or                 AP181   AP190
                     unreconciled, balance of the bank           AP255   AP265
                     account.                                    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
                                                                 CB00.2  CB06.2
                                                                 CB10.1  CB15.1
                                                                 CB15.2  CB180
                                                                 CB185   CB190
                                                                 CB191   CB20.1
                                                                 CB25.1  CB30.1
                                                                 CB500   CB80.1
                                                                 CB99.1  DT180
                                                                 DT181   DT185
                                                                 DT92.1

CBC-AP-DRAFTS        Signed 15.2                                 CB00.2
AP Bill of Exchange  Represents the amount of bills of
Future Amt           exchange that are scheduled to be
                     honored against this bank account.
                     THIS FIELD IS NOT USED AT THIS TIME.

CBC-AR-DRAFTS        Signed 15.2                                 CB00.2
AR Bill of Exchange  The amount of bills of exchange that
Future Amt           will be cashed against the bank account
                     in the future.
                     THIS FIELD IS NOT USED AT THIS TIME.

CBC-USED-FLAG        Alpha 1                                     AP00.3  AP00.4
Used                 Indicates whether the cash code has         AP00.5  AP01.1
                     been used. Valid values are:                AP10.1  AP10.2
                                                                 AP10.5  AP10.6
                     Y = Yes.                                    AP110   AP115
                     N = No.                                     AP125   AP126
                                                                 AP150   AP151
                                                                 AP155   AP156
                                                                 AP160   AP161
                                                                 AP166   AP167
                                                                 AP170   AP180
                                                                 AP181   AP190
                                                                 AP195   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP200
                                                                 AP23.1  AP230
                                                                 AP25.1  AP25.2
                                                                 AP250   AP255
                                                                 AP26.1  AP265
                                                                 AP266   AP27.1
                                                                 AP270   AP28.1
                                                                 AP28.2  AP30.3
                                                                 AP510   AP520
                                                                 AP55.1  AP55.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  AP80.2
                                                                 AP81.1  AP90.5
                                                                 AP91.1  API1.1
                                                                 ...

CBC-CURR-ND          Numeric 1                                   CB00.2
Currency Number of   The number of decimal places defined
Decimals             for the bank account currency.

CBC-ROI-RATE         Signed 5.3                                  CB00.2
Return on            The return on investment rate granted
Investment Rate      by the bank. For example, the interest
                     rate.

CBC-SERIAL-NUM       Numeric 8                                   CB00.2
Payment Run Serial   The serial number of the last payment
Number               tape created for the bank.

CBC-USER-CLASS       Alpha 12                                    CB00.2
User Class           The user class assigned to the cash
                     code. Used to restrict access and use of
                     the cash code to a specific group of
                     users. If left blank, no access
                     restrictions apply.

CBC-RECON-STMT-REQ   Alpha 1                                     CB00.2
Reconciliation       Indicates whether statements must be
Statement Req        reconciled for the cash code. Valid
                     values are:

                     N = No. Default.
                     Y = Yes.

CBC-RECON-JRNL-BK    Alpha 12
Reconciliation       The reconciliation journal book
Journal Book         associated with the cash code. Used only
                     if the Reconciliation Statement Required
                     field = Yes.

CBC-NET-BALANCE      Derived
Net Balance          The Reconciled Balance plus the Open
                     Balance for the bank account.

CBC-RECON-STMT-NBR   Numeric 12                                  CB00.2  CB06.1
Reconciliation       The bank-assigned reconciliation
Statement            statement number. Used only for cash
                     codes that require reconciliation
                     statements.


CBC-LAST-END-BAL     Signed 15.2                                 CB00.2  CB191
Last End Bal

CBC-SGLSTMT-USR-FL   Alpha 1                                     CB00.2
Sglstmt Usr Fl

CBC-DESCRIPTION      Alpha 30  (Lower Case)
Description          This field contains the description used
                     in the GoFinancials product.

                         CBCASHCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CBCSET1   CASH-CODE     This index is used to validate a cash    AP00.3  AP00.4
                        code.                                    AP00.5  AP01.1
                                                                 AP10.1  AP10.2
                                                                 AP10.5  AP10.6
                                                                 AP110   AP115
                                                                 AP125   AP126
                                                                 AP150   AP151
                                                                 AP155   AP156
                                                                 AP160   AP161
                                                                 AP166   AP167
                                                                 AP170   AP180
                                                                 AP181   AP190
                                                                 AP195   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 ...

CBCSET2   BANK-ENTITY   This index is used to access a cash      CB00.2
          CASH-CODE     code for a specific bank.
                        KeyChange

CBCSET3   BANK-ENTITY   This index is used to access a cash      CB00.2  CB185
          BANK-ACCT-NBR code record when bank identification and
          CASH-CODE     account number are provided.
                        KeyChange

                         CBCASHCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cbbankent      CBBANKENT    Required

                            CBC-BANK-ENTITY      -> CBE-BANK-ENTITY

Cbcashcode     CBCASHCODE   Required

                            CBC-CASH-CODE        -> CBC-CASH-CODE

Cbsend Bankent CBBANKENT    Required

                            CBC-SEND-BANK-ENT    -> CBE-BANK-ENTITY

Cucodes        CUCODES      Required

                            CBC-CURRENCY-CODE    -> CUC-CURRENCY-CODE

                         CBCASHCODE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cbadjust       CBADJUST

                            CBC-CASH-CODE        -> CBJ-CASH-CODE
                                                    CBJ-REC-STATUS
                                                    CBJ-BANK-INST-CODE
                                                    CBJ-TRANS-NBR
                                                    CBJ-SUFFIX
                                                    CBJ-TRANS-IDENT

Cbadjust Unrel CBADJUST

                            CBC-CASH-CODE        -> CBJ-CASH-CODE
                            Zeroes               -> CBJ-REC-STATUS
                                                    CBJ-BANK-INST-CODE
                                                    CBJ-TRANS-NBR
                                                    CBJ-SUFFIX
                                                    CBJ-TRANS-IDENT

Cbbalance      CBBALANCE    Delete Restricted

                            CBC-CASH-CODE        -> CBB-CASH-CODE
                                                    CBB-PER-END-DATE

Cbcashform     CBCASHFORM

                            CBC-CASH-CODE        -> CCF-CASH-CODE
                                                    CCF-BANK-INST-CODE

Cbcheck        CBCHECK

                            CBC-CASH-CODE        -> CHK-CASH-CODE
                                                    CHK-BANK-INST-CODE
                                                    CHK-TRANS-IDENT

Cbcpycash      CBCPYCASH

                            CBC-CASH-CODE        -> CBY-CASH-CODE
                                                    CBY-COMPANY

Cbgrpcc        CBGRPCC

                            CBC-CASH-CODE        -> CCD-CASH-CODE
                                                    CCD-CASH-CODE-GRP

Cbtrans        CBTRANS

                            CBC-CASH-CODE        -> CBT-CASH-CODE
                                                    CBT-BANK-INST-CODE
                                                    CBT-TRANS-NBR
                                                    CBT-SUFFIX
                                                    CBT-TRANS-IDENT

Cbtrans Date   CBTRANS

                            CBC-CASH-CODE        -> CBT-CASH-CODE
                                                    CBT-ISSUE-DATE
                                                    CBT-BANK-INST-CODE
                                                    CBT-SOURCE-CODE
                                                    CBT-TRANS-NBR
                                                    CBT-SUFFIX
                                                    CBT-TRANS-IDENT

Cbtrfhdr       CBTRFHDR

                            CBC-CASH-CODE        -> CBH-CASH-CODE
                                                    CBH-TRANSFER-NBR

Recpthdr Unrel CBRECPTHDR

                            CBC-CASH-CODE        -> CBP-CASH-CODE
                                                    CBP-BANK-INST-CODE
                                                    CBP-TRANS-NBR

Trfhdr Unrel   CBTRFHDR

                            CBC-CASH-CODE        -> CBH-CASH-CODE
                                                    CBH-TRANSFER-NBR

Unrel Trfhdr   CBTRFHDR

                            CBC-CASH-CODE        -> CBH-CASH-CODE
                                                    CBH-TRANSFER-NBR