|
|
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
|
