Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CBCATEGORY


                            CBCATEGORY FILE

                         Cash Receipt Category

The Cash Receipt Category file contains all valid cash receipt categories. A
cash receipt category represents a type of product or service and is used to
itemize cash deposits.

UPDATED BY

CB03.2    CB10.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CBG-COMPANY            Numeric 4                                 CB03.2
Element: Company       The company number. Must be a valid
                       record in the General Ledger Company
                       file.

CBG-PROC-LEVEL         Alpha 5                                   CB03.2
Element: Process Level The cash deposit process level
                       associated with the cash receipt
                       category. Used only by general ledger
                       companies that use cash deposit process
                       levels to make cash deposits. Must be a
                       valid record in the Cash Deposit Process
                       Level file.

CBG-PROD-TAX-CAT       Alpha 15                                  CB03.2
Element: Category      A user-defined code representing a cash
                       receipt category. Used to itemize cash
                       deposits.

CBG-DESCRIPTION        Alpha 30  (Lower Case)                    CB03.2
Element: Description   The description of the cash receipt
                       category.

CBG-REV-ACCT-UNIT      Alpha 15                                  CB03.2
Revenue Accounting     The general ledger revenue accounting
Unit                   unit for the cash receipt category. Must
                       be a valid record in the General Ledger
                       Names file.

CBG-REV-ACCOUNT        Numeric 6                                 CB03.2
Revenue Account        The general ledger revenue account
Number                 number for the cash receipt category.
                       Must be a valid record in the General
                       Ledger Account Master file.

CBG-REV-SUB-ACCT       Numeric 4                                 CB03.2
Revenue Subaccount     The general ledger revenue subaccount
Number                 number for the cash receipt category.
                       Must be a valid record in the General
                       Ledger Account Master file.

CBG-TAX-CODE           Alpha 10                                  CB03.2
Element: Tax Code      The tax code to be applied to deposits
                       for the cash receipt category.
                       Represents a tax liability for a
                       category distribution amount and is used
                       to calculate tax information for a
                       category distribution. Must be a valid
                       record in the Tax Code file.

CBG-USED-FLAG          Alpha 1                                   CB10.3
Element: Used          Indicates whether the category has been
                       used. Valid values are:

                       Y = Yes.
                       N = No.

CBG-ACTIVITY           Alpha 15                                  CB03.2
Element: Activity      The default activity assigned to the
                       cash receipt category. Must be a valid
                       record in the Activity file.

                       Activities are the tasks that make up an
                       activity group. Activities identify
                       work being done, such as work orders,
                       phases, products, and so on. A variety
                       of costs, revenues, or both make up an
                       activity.

CBG-ACCT-CATEGORY      Alpha 5                                   CB03.2
Element: Account CategoThe default account category assigned to
                       the cash receipt category. Must be a
                       valid record in the Activity Account
                       Category file.

                       Account categories are the Activity
                       Management accounts by which activity
                       transactions are grouped for budgeting
                       and reporting.

                         CBCATEGORY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CBGSET1   COMPANY       This is the primary index used to keep   CB03.2  CB10.1
          PROC-LEVEL    cash receipt category records unique by  CB10.3
          PROD-TAX-CAT  company and cash receipt process level.

                         CBCATEGORY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cbproclev      CBPROCLEV    Required

                            CBG-COMPANY       -> CBV-COMPANY
                            CBG-PROC-LEVEL    -> CBV-PROC-LEVEL