Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EECATEGORY


                            EECATEGORY FILE

                     Expense-Advance Category Code

The Category Code file contains expense category code records. Category codes
are used to link general ledger distribution and accrual accounts to an
employee expense. They can also be used to default a tax code, invoice accrual
code, expense type, reference value, and description on the detail lines of an
employee expense.

REFERENCED BY

EE275     EE520     EE90.3

UPDATED BY

EE05.1    EE20.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CTG-COMPANY            Numeric 4                                 EE05.1
Element: Company       The company number. Must be a valid
                       record in the Accounts Payable Company
                       file.

CTG-CATEGORY           Alpha 9                                   EE05.1
Element: Category      A user-defined representing a general
                       ledger expense distribution account for
                       a specific type of expense.

CTG-CATEGORY-DESC      Alpha 30  (Lower Case)                    EE05.1
Element: Description

CTG-CATEGORY-TYPE      Alpha 1                                   EE05.1
Element: Category Type Indicates the type of expense category.
                       Valid values are:

                       E = Employee Paid Expense.
                       C = Company Paid Expense.
                       P = Cash Payment (Payback).
                       U = Units

CTG-DIS-ACCT-UNIT      Alpha 15                                  EE05.1
Element: Accounting UniThe default general ledger distribution
                       accounting unit. Select a valid
                       accounting unit if you want the
                       interface program to create general
                       ledger transactions for transactions
                       with a record status of 1 and 2 only. A
                       transaction will be created to this
                       account and an offset transaction to the
                       cash account. Must be a valid record in
                       the General Ledger Names file.

CTG-DIS-ACCOUNT        Numeric 6                                 EE05.1
Element: Account       Required if the distribution accounting
                       unit field is not blank. The default
                       general ledger distribution account
                       number. Must be a valid record in the
                       General Ledger Account Master file.

CTG-DIS-SUB-ACCT       Numeric 4                                 EE05.1
Element: Subaccount    The default general ledger distribution
                       subaccount number. Must be a valid
                       record in the General Ledger Account
                       Master file.

CTG-TAX-CODE           Alpha 10                                  EE05.1
Element: Tax Code      The tax code associated with the
                       expense category. Used to calculate tax
                       information for an expense distribution.
                       Must be a valid record in the Tax Code
                       file.

CTG-ACCR-CODE          Alpha 4                                   EE05.1
Element: Invoice AccruaThe invoice accrual code associated
                       with the expense category. Represents a
                       general ledger accrual account. Must be
                       a valid record in the Invoice Accrual
                       Code file.

CTG-DST-REFERENCE      Alpha 10                                  EE05.1
Element: Cross Ref     The default distribution reference
                       value.

CTG-DESCRIPTION        Alpha 30  (Lower Case)                    EE05.1
Element: Description   The default description.

CTG-ACTIVITY-FLAG      Alpha 1                                   EE05.1  EE20.3
Element: Activity Flag Indicates whether this category code is
                       used. This flag is set to "Y" once the
                       category code is assigned to an employee
                       expense payback. Valid values are:

                       N = No.
                       Y = Yes.

CTG-REQ-COMMENTS       Alpha 1                                   EE05.1
Element: Required CommeThis field is not currently used.

                         EECATEGORY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CTGSET1   COMPANY       This index is used to validate a         EE05.1  EE20.3
          CATEGORY      category code for a specific company.    EE20.4  EE275
                                                                 EE520   EE90.3

                         EECATEGORY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glmaster Full  GLMASTER     Not Required
                            Valid When CTG-DIS-ACCT-UNIT != Spaces
                                  And  CTG-DIS-ACCOUNT   != Zeroes
                                  And  CTG-DIS-SUB-ACCT  != Zeroes

                            CTG-COMPANY          -> GLM-COMPANY
                            CTG-DIS-ACCT-UNIT    -> GLM-ACCT-UNIT
                            CTG-DIS-ACCOUNT      -> GLM-ACCOUNT
                            CTG-DIS-SUB-ACCT     -> GLM-SUB-ACCOUNT

Txtaxcode      TXTAXCODE    Not Required

                            CTG-COMPANY          -> TAC-COMPANY
                            CTG-TAX-CODE         -> TAC-TAX-CODE

                         EECATEGORY FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glmaster Acct  GLMASTER     Required
                            When CTG-DIS-ACCOUNT   != Zeroes
                            And  CTG-DIS-ACCT-UNIT =  Spaces

                            CTG-COMPANY          -> GLM-COMPANY
                            CTG-DIS-ACCOUNT      -> GLM-ACCOUNT
                            CTG-DIS-SUB-ACCT     -> GLM-SUB-ACCOUNT
                                                    GLM-ACCT-UNIT

Glmaster Au    GLMASTER     Required
                            When CTG-DIS-ACCT-UNIT != Spaces
                            And  CTG-DIS-ACCOUNT   =  Zeroes
                            And  CTG-DIS-SUB-ACCT  =  Zeroes

                            CTG-COMPANY          -> GLM-COMPANY
                            CTG-DIS-ACCT-UNIT    -> GLM-ACCT-UNIT
                                                    GLM-ACCOUNT
                                                    GLM-SUB-ACCOUNT