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

CB01.4    CB01.5    CB01.6    CB01.7    CB195     CB90.2

UPDATED BY

AP00.4    AP00.5    AP01.1    AP125     AP126     AP150
AP151     AP156     AP170     AP180     AP181     AP190
AP200     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    AR34.1    AR48.2
AR570     AR575     AR580     AR82.1    CB00.2    CB00.3
CB06.1    CB06.2    CB10.1    CB15.1    CB15.2    CB175
CB180     CB185     CB190     CB191     CB20.1    CB25.1
CB30.1    CB500     CB80.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     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.                                  AP200   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
                                                                 AR34.1  AR48.2
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB00.3  CB06.1
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB175   CB180
                                                                 ...

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 reconciliation journal book
Book                   associated with the cash code.

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
Object                 This is the object identifier. It is
Identification         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
Element: Accounting Unit

CBY-PMT-ACCOUNT        Numeric 6
Element: Account

CBY-PMT-SUB-ACCT       Numeric 4
Element: Subaccount

CBY-EFT-ACCT-UNIT      Alpha 15
Element: Accounting Unit

CBY-EFT-ACCOUNT        Numeric 6
Element: Account

CBY-EFT-SUB-ACCT       Numeric 4
Element: Subaccount

                         CBCPYCASH FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CBYSET1   COMPANY       This is the primary index used to        AP00.4  AP00.5
          CASH-CODE     access and keep company-cash code        AP01.1  AP125
                        relationship records unique.             AP126   AP150
                                                                 AP151   AP156
                                                                 AP170   AP180
                                                                 AP181   AP190
                                                                 AP200   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
                                                                 ...

CBYSET2   CASH-CODE     This index is used to access companies   CB00.2  CB01.5
          COMPANY       that have relationship records with a
                        specific cash code.

CBYSET3   OBJ-ID        Subset                                   CB01.6  CB01.7
                        Where OBJ-ID != Zeroes

                         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

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