Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CBCPYCASH


                             CBCPYCASH FILE

                     Company-Cash Code Relationship

The Company-Cash Code Relationship file contains relationship records between
a general ledger company and a cash code (bank account).

REFERENCED BY

AP155     AP160     AP161     CB01.4    CB01.5    CB01.6
CB01.7    CB162     CB170     CB195     CB210     CB215
CB220     CB221     CB260     CB286     CB62.1    CB90.2
MX123     MX500     CBBC.1    CBOP.1    MX223

UPDATED BY

AP00.4    AP00.5    AP01.1    AP125     AP126     AP150
AP151     AP156     AP170     AP180     AP181     AP190
AP20.1    AP20.2    AP20.3    AP20.4    AP20.5    AP20.6
AP20.7    AP20.8    AP200     AP21.1    AP23.1    AP25.1
AP25.2    AP255     AP26.1    AP265     AP27.1    AP28.1
AP28.2    AP30.3    AP520     AP55.1    AP55.2    AP56.1
AP56.2    AP80.1    AP81.1    AP90.5    API1.1    API2.1
AR01.1    AR02.1    AR115     AR124     AR14.1    AR20.1
AR21.1    AR21.2    AR21.3    AR24.1    AR28.2    AR28.5
AR29.2    AR30.1    AR32.1    AR34.1    AR48.2    AR570
AR575     AR580     AR82.1    CB00.2    CB00.3    CB06.1
CB06.2    CB10.1    CB145     CB15.1    CB15.2    CB150
CB175     CB180     CB185     CB186     CB187     CB190
CB191     CB20.1    CB25.1    CB30.1    CB43.1    CB44.1
CB45.1    CB46.1    CB50.1    CB500     CB54.1    CB543
CB544     CB55.1    CB554     CB80.1    CB82.1    DT160
DT161     DT170     DT180     DT181     DT185     DT270
DT60.1    DT60.2    DT70.1    DT70.3    DT80.1    DT80.4
DT90.3    DT92.1    EE20.1    EE20.2    EE20.4    EE520
ET09.2    MA41.1    MA41.2    MA41.4    MA41.7    MA43.2
MA61.1    MAI1.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CBY-COMPANY            Numeric 4                                 CB00.3
Element: Company       The company number. Must be a valid
                       record in the General Ledger Company
                       file.

CBY-CASH-CODE          Alpha 4                                   CB00.3
Element: Cash Code     The cash code. Represents a bank
                       account. Must be a valid record in the
                       Cash Code file.

CBY-CSH-COMPANY        Numeric 4                                 CB00.3
Element: Cash Company  The general ledger company a cash
                       transaction will be made against. THIS
                       FIELD IS NOT USED AT THIS TIME.

CBY-CSH-ACCT-UNIT      Alpha 15                                  CB00.3
GL Cash Accounting     The general ledger cash accounting unit
Unit                   for the company-cash code relationship.
                       Must be a valid record in the General
                       Ledger Names file.

CBY-CSH-ACCOUNT        Numeric 6                                 CB00.3
GL Cash Account        The general ledger cash account number
Number                 for the company-cash code relationship.
                       Must be a valid record in the General
                       Ledger Account Master file.

CBY-CSH-SUB-ACCT       Numeric 4                                 CB00.3
GL Cash Subaccount     The general ledger cash subaccount
Number                 number for the company-cash code
                       relationship. Must be a valid record in
                       the General Ledger Account Master file.

CBY-CLR-ACCT-UNIT      Alpha 15                                  CB00.3
Transfer Clearing      The general ledger bank transfer
Acct Unit              clearing accounting unit used for bank
                       fund transfers to or from the
                       company-cash code relationship. Must be
                       a valid record in the General Ledger
                       Names file.

CBY-CLR-ACCOUNT        Numeric 6                                 CB00.3
Transfer Clearing      The general ledger bank transfer
Account Nbr            clearing account number used for bank
                       fund transfers to or from the
                       company-cash code relationship. Must be
                       a valid record in the General Ledger
                       Account Master file.

CBY-CLR-SUB-ACCT       Numeric 4                                 CB00.3
Transfer Clearing      The general ledger bank transfer
Subacct Nbr            clearing subaccount number used for bank
                       fund transfers to or from the
                       company-cash code relationship. Must be
                       a valid record in the General Ledger
                       Account Master file.

CBY-REC-OVER-TOL       Signed 18.2                               CB00.3
Over Reconcile         Indicates by what amount, if any, the
Tolerance              reconciled amount can exceed the issued
                       amount of a transaction.

                       If defined and the reconciled amount
                       exceeds the issued amount within the
                       defined tolerance, the difference is
                       posted to the GL Variance Account
                       selected for the company-cash code
                       relationship. If the difference exceeds
                       the defined tolerance, the
                       reconciliation must be approved in
                       CB30.1 (Reconciliation Variance
                       Adjustment). If left blank, zero
                       defaults, which means the reconciled
                       amount must equal the issued amount.

CBY-REC-UNDER-TOL      Signed 18.2                               CB00.3
Under Reconcile        Indicates by what amount, if any, the
Tolerance              reconciled amount can be less than the
                       issued amount of a transaction.

                       If defined and the reconciled amount is
                       less than the issued amount within the
                       defined tolerance, the difference is
                       posted to the GL Variance Account
                       selected for the company-cash code
                       relationship. If the difference exceeds
                       the defined tolerance, the
                       reconciliation must be approved in
                       CB30.1 (Reconciliation Variance
                       Adjustment). If left blank, zero
                       defaults, which means the reconciled
                       amount must equal the issued amount.

CBY-VAR-COMPANY        Numeric 4                                 CB00.3
Element: GL Variance CoThe general ledger company a
                       reconciliation variance transaction will
                       be made against. THIS FIELD IS NOT USED
                       AT THIS TIME.

CBY-VAR-ACCT-UNIT      Alpha 15                                  CB00.3
GL Variance            The general ledger variance accounting
Accounting Unit        unit for the company-cash code
                       relationship. Must be a valid record in
                       the General Ledger Names file.

CBY-VAR-ACCOUNT        Numeric 6                                 CB00.3
GL Variance Account    The general ledger variance account
Number                 number for the company-cash code
                       relationship. Must be a valid record in
                       the General Ledger Account Master file.

CBY-VAR-SUB-ACCT       Numeric 4                                 CB00.3
GL Variance            The general ledger variance subaccount
Subaccount Number      number for the company-cash code
                       relationship. Must be a valid record in
                       the General Ledger Account Master file.

CBY-REC-GL-ENTRY       Alpha 1                                   CB00.3
Element: GL Reconcile EIndicates whether a general ledger
                       entry is created from the GL Cash
                       Account to a GL Reconcile Account when
                       the company reconciles a transaction for
                       the cash code. If this field = Yes, a
                       general ledger entry is created from the
                       GL Cash Account to the GL Reconcile
                       Account. The difference between the
                       reconciled amount and the issued amount,
                       within the defined tolerances, posts to
                       the GL Variance Account. Valid values
                       are:

                       N = No.
                       Y = Yes.

CBY-REC-COMPANY        Numeric 4                                 CB00.3
Element: Reconcile CompThe general ledger company a reconciled
                       transaction will be made against. THIS
                       FIELD IS NOT USED AT THIS TIME.

CBY-REC-ACCT-UNIT      Alpha 15                                  CB00.3
GL Reconcile           If the GL Reconcile Entry field = Yes,
Accounting Unit        this field contains the general ledger
                       reconcile accounting unit for the
                       company-cash code relationship. Must be
                       a valid record in the General Ledger
                       Names file.

CBY-REC-ACCOUNT        Numeric 6                                 CB00.3
GL Reconcile           If the GL Reconcile Entry field = Yes,
Account Number         this field contains the general ledger
                       reconcile account number for the
                       company-cash code relationship. Must be
                       a valid record in the General Ledger
                       Account Master file.

CBY-REC-SUB-ACCT       Numeric 4                                 CB00.3
GL Reconcile           If the GL Reconcile Entry field = Yes,
Subaccount Number      this field contains the general ledger
                       reconcile subaccount number for the
                       company-cash code relationship. Must be
                       a valid record in the General Ledger
                       Account Master file.

CBY-ENCS-ACCT-UNIT     Alpha 15                                  CB00.3
Encashed Remittance    The general ledger encashed remittance
Acct Unit              accounting unit used for bill of
                       exchange processing. Required if company
                       uses the cash code to process bills of
                       exchange. Must be a valid record in the
                       General Ledger Names file.

CBY-ENCS-ACCOUNT       Numeric 6                                 CB00.3
Encashed Remittance    The general ledger encashed remittance
Account                account number used for bill of exchange
                       processing. Required if company uses the
                       cash code to process bills of exchange.
                       Must be a valid record in the General
                       Ledger Account Master file.

CBY-ENCS-SUB-ACCT      Numeric 4                                 CB00.3
Encashed Remittance    The general ledger encashed remittance
Subaccount             subaccount number used for bill of
                       exchange processing. Required if company
                       uses the cash code to process bills of
                       exchange. Must be a valid record in the
                       General Ledger Account Master file.

CBY-DISC-ACCT-UNIT     Alpha 15                                  CB00.3
Discounted Remit       The general ledger discounted
Acct Unit              remittance accounting unit used for bill
                       of exchange processing. Required if
                       company uses the cash code to process
                       bills of exchange. Must be a valid
                       record in the General Ledger Names file.

CBY-DISC-ACCOUNT       Numeric 6                                 CB00.3
Discounted             The general ledger discounted
Remittance Account     remittance account number used for bill
                       of exchange processing. Required if
                       company uses the cash code to process
                       bills of exchange. Must be a valid
                       record in the General Ledger Account
                       Master file.

CBY-DISC-SUB-ACCT      Numeric 4                                 CB00.3
Discounted             The general ledger discounted
Remittance Subacct     remittance subaccount number used for
                       bill of exchange processing. Required if
                       company uses the cash code to process
                       bills of exchange. Must be a valid
                       record in the General Ledger Account
                       Master file.

CBY-RISK-ACCT-UNIT     Alpha 15                                  CB00.3
Bank Risk              The general ledger bank risk accounting
Accounting Unit        unit used for discounted bill of
                       exchange risk processing. Required if
                       company uses the cash code to process
                       bills of exchange. Must be a valid
                       record in the General Ledger Names file.

CBY-RISK-ACCOUNT       Numeric 6                                 CB00.3
Bank Risk Account      The general ledger bank risk account
Number                 number used for discounted bill of
                       exchange risk processing. Required if
                       company uses the cash code to process
                       bills of exchange. Must be a valid
                       record in the General Ledger Account
                       Master file.

CBY-RISK-SUB-ACCT      Numeric 4                                 CB00.3
Bank Risk              The general ledger bank risk subaccount
Subaccount Number      number used for discounted bill of
                       exchange risk processing. Required if
                       company uses the cash code to process
                       bills of exchange. Must be a valid
                       record in the General Ledger Account
                       Master file.

CBY-BEXP-ACCT-UNIT     Alpha 15                                  CB00.3
Bank Expense           The general ledger bank expense
Accounting Unit        accounting unit used for bill of
                       exchange cashing expenses. Required if
                       company uses the cash code to process
                       bills of exchange. Must be a valid
                       record in the General Ledger Names file.

CBY-BEXP-ACCOUNT       Numeric 6                                 CB00.3
Bank Expense           The general ledger bank expense account
Account Number         number used for bill of exchange cashing
                       expenses. Required if company uses the
                       cash code to process bills of exchange.
                       Must be a valid record in the General
                       Ledger Account Master file.

CBY-BEXP-SUB-ACCT      Numeric 4                                 CB00.3
Bank Expense           The general ledger bank expense
Subaccount Number      subaccount number used for bill of
                       exchange cashing expenses. Required if
                       company uses the cash code to process
                       bills of exchange. Must be a valid
                       record in the General Ledger Account
                       Master file.

CBY-FIN-ACCT-UNIT      Alpha 15                                  CB00.3
Financial Expense      The general ledger financial expense
Acct Unit              accounting unit used for financial
                       expenses associated with bill of
                       exchange processing. Required if company
                       uses the cash code to process bills of
                       exchange. Must be a valid record in the
                       General Ledger Names file. THIS FIELD IS
                       NOT CURRENTLY USED.

CBY-FIN-ACCOUNT        Numeric 6                                 CB00.3
Financial Expense      The general ledger financial expense
Account                account number used for financial
                       expenses associated with bill of
                       exchange processing. Required if company
                       uses the cash code to process bills of
                       exchange. Must be a valid record in the
                       General Ledger Account Master file. THIS
                       FIELD IS NOT CURRENTLY USED.

CBY-FIN-SUB-ACCT       Numeric 4                                 CB00.3
Financial Expense      The general ledger financial expense
Subaccount             subaccount number used for financial
                       expenses associated with bill of
                       exchange processing. Required if company
                       uses the cash code to process bills of
                       exchange. Must be a valid record in the
                       General Ledger Account Master file. THIS
                       FIELD IS NOT CURRENTLY USED.

CBY-ADMN-ACCT-UNIT     Alpha 15                                  CB00.3
Admin Expense          The general ledger administration
Accounting Unit        expense accounting unit used for
                       administration expenses associated with
                       bill of exchange processing. Required if
                       company uses the cash code to process
                       bills of exchange. Must be a valid
                       record in the General Ledger Names file.

CBY-ADMN-ACCOUNT       Numeric 6                                 CB00.3
Admin Expense          The general ledger administration
Account Number         expense account number used for
                       administration expenses associated with
                       bill of exchange processing. Required if
                       company uses the cash code to process
                       bills of exchange. Must be a valid
                       record in the General Ledger Account
                       Master file.

CBY-ADMN-SUB-ACCT      Numeric 4                                 CB00.3
Admin Expense          The general ledger administration
Subaccount             expense subaccount number used for
                       administration expenses associated with
                       bill of exchange processing. Required if
                       company uses the cash code to process
                       bills of exchange. Must be a valid
                       record in the General Ledger Account
                       Master file.

CBY-USED-FLAG          Alpha 1                                   AP00.4  AP00.5
Element: Used Flag     Indicates whether the company-cash code   AP01.1  AP125
                       relationship has been used. Valid values  AP126   AP150
                       are:                                      AP151   AP156
                                                                 AP170   AP180
                       N = No.                                   AP181   AP190
                       Y = Yes.                                  AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 AP200   AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP255
                                                                 AP26.1  AP265
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.3
                                                                 AP520   AP55.1
                                                                 AP55.2  AP56.1
                                                                 AP56.2  AP80.1
                                                                 AP81.1  AP90.5
                                                                 API1.1  API2.1
                                                                 AR01.1  AR02.1
                                                                 AR115   AR124
                                                                 AR14.1  AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.2  AR28.5
                                                                 AR29.2  AR30.1
                                                                 AR32.1  AR34.1
                                                                 AR48.2  AR570
                                                                 ...

CBY-SEL-BANK-NAME      Derived
Element: Bank Name     The name of the bank associated with
                       the cash code.

CBY-SEL-BANK-ACCT      Derived
Element: Bank Account NThe bank account number defined for the
                       cash code.

CBY-RECON-JRNL-BK      Alpha 12                                  CB00.3
Reconcile Journal      The journal book assigned to the
Book                   transaction.

CBY-DEP-INST-CODE      Alpha 3                                   CB00.3
Customer Bank
Instrument Code

CBY-CHK-INST-CODE      Alpha 3                                   CB00.3
Vendor Bank
Instrument Code

CBY-BANK-INST-CODE     Alpha 3                                   CB00.3
GL Bank Instrument     A transaction code represents a type of
Code                   cash payment, bill of exchange payment,
                       or bank service transaction.

CBY-RECN-INST-CODE     Alpha 3                                   CB00.3
Reconcile Bank
Instrument Code

CBY-OBJ-ID             Numeric 12                                CB00.3
Element: Obj Id        This is the object identifier. It is
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

CBY-PMT-ACCT-UNIT      Alpha 15                                  CB00.3
Element: Acct Unit     The accounting unit is a shorthand
                       notation representing the variable level
                       number. When used in the General Ledger
                       Account Master file, the accounting unit
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.


CBY-PMT-ACCOUNT        Numeric 6                                 CB00.3
Element: Account       This field along with the accounting
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

CBY-PMT-SUB-ACCT       Numeric 4                                 CB00.3
Element: Sub Acct      This field contains the subaccount from
                       your general ledger chart of accounts
                       that was charged with the amount carried
                       on this record.

CBY-EFT-ACCT-UNIT      Alpha 15                                  CB00.3
Element: Acct Unit     The accounting unit is a shorthand
                       notation representing the variable level
                       number. When used in the General Ledger
                       Account Master file, the accounting unit
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.


CBY-EFT-ACCOUNT        Numeric 6                                 CB00.3
Element: Account       This field along with the accounting
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

CBY-EFT-SUB-ACCT       Numeric 4                                 CB00.3
Element: Sub Acct      This field contains the subaccount from
                       your general ledger chart of accounts
                       that was charged with the amount carried
                       on this record.

                         CBCPYCASH FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CBYSET1   COMPANY                                                AP00.4  AP00.5
          CASH-CODE                                              AP01.1  AP125
                                                                 AP126   AP150
                                                                 AP151   AP155
                                                                 AP156   AP160
                                                                 AP161   AP170
                                                                 AP180   AP181
                                                                 AP190   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP200
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP255   AP26.1
                                                                 ...

CBYSET2   CASH-CODE                                              CB00.2  CB01.5
          COMPANY                                                CBBC.1  CBOP.1

CBYSET3   OBJ-ID        Subset                                   AP150   AP155
                        Where OBJ-ID != Zeroes                   AP160   AP161
                                                                 AP265   CB01.6
                                                                 CB01.7  CB145
                                                                 CB170   CB175
                                                                 CB180   CB186
                                                                 CB187   CB210
                                                                 CB215   CB220
                                                                 CB221   CB260
                                                                 CB286   MX123
                                                                 MX223   MX500

                         CBCPYCASH 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

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

Glsystem       GLSYSTEM     Required

                            CBY-COMPANY        -> GLS-COMPANY

Glsystem Cash  GLSYSTEM     Required

                            CBY-CSH-COMPANY    -> GLS-COMPANY

Glsystem Recon GLSYSTEM     Required

                            CBY-REC-COMPANY    -> GLS-COMPANY

Glsystem Var   GLSYSTEM     Required

                            CBY-VAR-COMPANY    -> GLS-COMPANY

                         CBCPYCASH FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cbmxconv       CBMXCONV

                            CBY-COMPANY        -> CBN-COMPANY
                            CBY-CASH-CODE      -> CBN-CASH-CODE
                                                  CBN-RUN-GROUP
                                                  CBN-MATRIX-CAT

Cbmxvalue      CBMXVALUE    Delete Cascades

                            CBY-OBJ-ID         -> CMV-OBJ-ID
                                                  CMV-MATRIX-CAT

Member In List MXLISTMBR    Delete Cascades

                            "CSHCD"            -> MLM-OBJ-TYPE
                            CBY-OBJ-ID         -> MLM-OBJ-ID
                                                  MLM-MATRIX-LIST

Mxlistmbr      MXLISTMBR

                            "CSHCD"            -> MLM-OBJ-TYPE
                            CBY-OBJ-ID         -> MLM-OBJ-ID
                                                  MLM-MATRIX-LIST