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    CB950

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

CBG-PROC-LEVEL       Alpha 5                                     CB03.2  CB950
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  CB950
Category             A user-defined code representing a cash
                     receipt category. Used to itemize cash
                     deposits.

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

CBG-REV-ACCT-UNIT    Alpha 15                                    CB03.2  CB950
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  CB950
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  CB950
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  CB950
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  CB950
Used                 Indicates whether the category has been
                     used. Valid values are:

                     Y = Yes.
                     N = No.

CBG-ACTIVITY         Alpha 15                                    CB03.2  CB950
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  CB950
Account Category     The 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