EECATEGORY – Expense Advance Category Code

System
Accounts Payable (AP)
Prefix
CTG
Primary key
COMPANY, CATEGORY
Fields
13
Updated by
3 programs
Referenced by
3 programs

EECATEGORY is the Expense Advance Category Code table in Lawson Accounts Payable (prefix CTG). It is indexed by COMPANY, CATEGORY (CTGSET1). It is related 1:1 to GLMASTER and TXTAXCODE and 1:M to GLMASTER. It is updated by EE05.1, EE11.1 and EE20.3 and referenced by EE275, EE520 and EE90.3. The table has 13 fields, 1 index and 4 documented relations.

About EECATEGORY

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.

Fields (13)

Column = COBOL field name without the CTG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#CTG-COMPANY PK
COMPANY		Numeric 4The company number. Must be a valid record in the Accounts Payable Company file.EE05.1
#CTG-CATEGORY PK
CATEGORY		Alpha 9A user-defined representing a general ledger expense distribution account for a specific type of expense.EE05.1
#CTG-CATEGORY-DESC
CATEGORY_DESC		Alpha 30 (Lower Case)This field displays the description.EE05.1
#CTG-CATEGORY-TYPE
CATEGORY_TYPE		Alpha 1Indicates the type of expense category. Valid values are:
  • E Employee Paid Expense.
  • C Company Paid Expense.
  • P Cash Payment (Payback).
  • U Units
EE05.1
#CTG-DIS-ACCT-UNIT
DIS_ACCT_UNIT		Alpha 15The 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.EE05.1
#CTG-DIS-ACCOUNT
DIS_ACCOUNT		Numeric 6Required 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.EE05.1
#CTG-DIS-SUB-ACCT
DIS_SUB_ACCT		Numeric 4The default general ledger distribution subaccount number. Must be a valid record in the General Ledger Account Master file.EE05.1
#CTG-TAX-CODE
TAX_CODE		Alpha 10The 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.EE05.1
#CTG-ACCR-CODE
ACCR_CODE		Alpha 4The 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.EE05.1
#CTG-DST-REFERENCE
DST_REFERENCE		Alpha 10The default distribution reference value.EE05.1
#CTG-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The default description.EE05.1
#CTG-ACTIVITY-FLAG
ACTIVITY_FLAG		Alpha 1Indicates 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.
EE05.1, EE11.1, EE20.3
#CTG-REQ-COMMENTS
REQ_COMMENTS		Alpha 1This field is not currently used.EE05.1

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CTGSET1
  1. COMPANY
  2. CATEGORY
PrimaryEE05.1, EE11.1, EE20.3, EE20.4, EE275, EE520, EE90.3

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLMASTERTXTAXCODEGLMASTEREECATEGORY

One to one (2) — lookups and parents

RelationTableRulesConditionField map
Glmaster FullGLMASTERNot RequiredValid 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
TxtaxcodeTXTAXCODENot Required
CTG-COMPANY→TAC-COMPANY
CTG-TAX-CODE→TAC-TAX-CODE

One to many (2) — child tables

RelationTableRulesConditionField map
Glmaster AcctGLMASTERRequiredWhen 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 AuGLMASTERRequiredWhen 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

Programs

Updated by (3)

Referenced by (3)