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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
CTG-COMPANY PKCOMPANY | Numeric 4 | The company number. Must be a valid record in the Accounts Payable Company file. | EE05.1 |
CTG-CATEGORY PKCATEGORY | Alpha 9 | A user-defined representing a general ledger expense distribution account for a specific type of expense. | EE05.1 |
CTG-CATEGORY-DESCCATEGORY_DESC | Alpha 30 (Lower Case) | This field displays the description. | EE05.1 |
CTG-CATEGORY-TYPECATEGORY_TYPE | Alpha 1 | Indicates the type of expense category. Valid values are:
| EE05.1 |
CTG-DIS-ACCT-UNITDIS_ACCT_UNIT | Alpha 15 | The 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-ACCOUNTDIS_ACCOUNT | Numeric 6 | 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. | EE05.1 |
CTG-DIS-SUB-ACCTDIS_SUB_ACCT | Numeric 4 | The default general ledger distribution subaccount number. Must be a valid record in the General Ledger Account Master file. | EE05.1 |
CTG-TAX-CODETAX_CODE | Alpha 10 | 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. | EE05.1 |
CTG-ACCR-CODEACCR_CODE | Alpha 4 | The 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-REFERENCEDST_REFERENCE | Alpha 10 | The default distribution reference value. | EE05.1 |
CTG-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | The default description. | EE05.1 |
CTG-ACTIVITY-FLAGACTIVITY_FLAG | Alpha 1 | 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:
| EE05.1, EE11.1, EE20.3 |
CTG-REQ-COMMENTSREQ_COMMENTS | Alpha 1 | This field is not currently used. | EE05.1 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
CTGSET1 | COMPANY, CATEGORY | Primary | EE05.1, EE11.1, EE20.3, EE20.4, EE275, EE520, EE90.3 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |
One to many (2) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |