GMFNDACTX – Grant Eligible Acct Categories
- System
- GM (GM)
- Prefix
GFX- Primary key
CONTRACT,GRANT,ACTIVITY,ACCT-CATEGORY- Fields
- 9
- Updated by
- 2 programs
- Referenced by
- 0 programs
GMFNDACTX is the Grant Eligible Acct Categories table in Lawson GM (prefix GFX). It is indexed by CONTRACT, GRANT, ACTIVITY, ACCT-CATEGORY (GFXSET1); alternate indexes: GFXSET2, GFXSET3 and GFXSET4. It is related 1:1 to ACACCTCAT, ACACTIVITY, ACCNTRACT, GMFNDACT and GMGRANT. It is updated by AC10.1 and AC120. The table has 9 fields, 4 indexes and 5 documented relations.
About GMFNDACTX
No description in the Lawson data dictionary.
Fields (9)
Column = COBOL field name without the GFX- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
GFX-CONTRACT PKCONTRACT | Alpha 15 | — | AC10.1, AC120 |
GFX-GRANT PKGRANT | Alpha 30 | — | AC10.1, AC120 |
GFX-ACTIVITY PKACTIVITY | Alpha 15 | — | AC10.1, AC120 |
GFX-ACCT-CATEGORY PKACCT_CATEGORY | Alpha 5 | Cost account categories for the contract. The GMFNDACTX file contains records for all of the activities valid cost account categories. Cost account categories flagged as eligible "Y" are eligible for grant reimbursement. Account categories flagged as eligible "N" will not be allocated or reimbursed by the grant. GMFNDACTX records only exist for "G" Grant Type funds. | AC10.1, AC120 |
GFX-COST-CLASSCOST_CLASS | Alpha 15 | A cost classification represents a summarization for grant budgeting and pay request summarization. | AC10.1, AC120 |
GFX-INVOICE-AMTINVOICE_AMT | Signed 18.2 | — | — |
GFX-ELIGIBLEELIGIBLE | Alpha 1 | —
| AC10.1, AC120 |
GFX-FUND-AMOUNTFUND_AMOUNT | Signed 18.2 | — | — |
GFX-FUND-PERCENTFUND_PERCENT | Signed 7.3 | — | — |
Indexes (4)
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 |
|---|---|---|---|---|
GFXSET1 | CONTRACT, GRANT, ACTIVITY, ACCT-CATEGORY | Primary | AC10.1, AC120 | |
GFXSET2 | GRANT, COST-CLASS, CONTRACT, ACTIVITY, ACCT-CATEGORY | KeyChange | — | |
GFXSET3 | ACTIVITY, ACCT-CATEGORY, CONTRACT, GRANT | AC10.1, AC120 | ||
GFXSET4 | ELIGIBLE, ACTIVITY, ACCT-CATEGORY, CONTRACT, GRANT | KeyChange | — |
Relations
One to one (5) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Acacctcat | ACACCTCAT | Required | GFX-ACCT-CATEGORY → AAX-ACCT-CATEGORY (AAXSET1) | |
| Acactivity | ACACTIVITY | Required | GFX-ACTIVITY → ACV-ACTIVITY | |
| Accntract | ACCNTRACT | Required | GFX-CONTRACT → CNT-CONTRACT | |
| Gmfndact | GMFNDACT | Required | GFX-CONTRACT → GFC-CONTRACT, GFX-GRANT → GFC-GRANT, GFX-ACTIVITY → GFC-ACTIVITY | |
| Gmgrant | GMGRANT | Required | GFX-GRANT → GRN-GRANT |