GMCCTMPDTL – Cost Class Acct Cat Relation
- System
- GM (GM)
- Prefix
GTD- Primary key
TEMPLATE,COST-CLASS,ACCT-CAT- Fields
- 3
- Updated by
- 0 programs
- Referenced by
- 0 programs
GMCCTMPDTL is the Cost Class Acct Cat Relation table in Lawson GM (prefix GTD). It is indexed by TEMPLATE, COST-CLASS, ACCT-CAT (GTDSET1); alternate indexes: GTDSET2. It is related 1:1 to ACACCTCAT. The table has 3 fields, 2 indexes and 1 documented relation.
About GMCCTMPDTL
No description in the Lawson data dictionary.
Fields (3)
Column = COBOL field name without the GTD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
GTD-TEMPLATE PKTEMPLATE | Alpha 15 | — | — |
GTD-COST-CLASS PKCOST_CLASS | Alpha 15 | — | — |
GTD-ACCT-CAT PKACCT_CAT | Alpha 5 | — | — |
Indexes (2)
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 |
|---|---|---|---|---|
GTDSET1 | TEMPLATE, COST-CLASS, ACCT-CAT | Primary | — | |
GTDSET2 | TEMPLATE, ACCT-CAT | AC10.1, AC120 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Acacctcat | ACACCTCAT | Required | GTD-ACCT-CAT → AAX-ACCT-CATEGORY |
Programs
No Lawson programs are documented as updating or referencing this table.