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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#GFX-CONTRACT PK
CONTRACT		Alpha 15—AC10.1, AC120
#GFX-GRANT PK
GRANT		Alpha 30—AC10.1, AC120
#GFX-ACTIVITY PK
ACTIVITY		Alpha 15—AC10.1, AC120
#GFX-ACCT-CATEGORY PK
ACCT_CATEGORY		Alpha 5Cost 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-CLASS SET2
COST_CLASS		Alpha 15A cost classification represents a summarization for grant budgeting and pay request summarization.AC10.1, AC120
#GFX-INVOICE-AMT
INVOICE_AMT		Signed 18.2——
#GFX-ELIGIBLE SET4
ELIGIBLE		Alpha 1—
  • Y Eligible
  • N Ineligible
AC10.1, AC120
#GFX-FUND-AMOUNT
FUND_AMOUNT		Signed 18.2——
#GFX-FUND-PERCENT
FUND_PERCENT		Signed 7.3——

Indexes (4)

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
GFXSET1
  1. CONTRACT
  2. GRANT
  3. ACTIVITY
  4. ACCT-CATEGORY
PrimaryAC10.1, AC120
GFXSET2
  1. GRANT
  2. COST-CLASS
  3. CONTRACT
  4. ACTIVITY
  5. ACCT-CATEGORY
KeyChange—
GFXSET3
  1. ACTIVITY
  2. ACCT-CATEGORY
  3. CONTRACT
  4. GRANT
AC10.1, AC120
GFXSET4
  1. ELIGIBLE
  2. ACTIVITY
  3. ACCT-CATEGORY
  4. CONTRACT
  5. GRANT
KeyChange—

Relations

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

One to one (5) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATRequired
GFX-ACCT-CATEGORY→AAX-ACCT-CATEGORY (AAXSET1)
AcactivityACACTIVITYRequired
GFX-ACTIVITY→ACV-ACTIVITY
AccntractACCNTRACTRequired
GFX-CONTRACT→CNT-CONTRACT
GmfndactGMFNDACTRequired
GFX-CONTRACT→GFC-CONTRACT
GFX-GRANT→GFC-GRANT
GFX-ACTIVITY→GFC-ACTIVITY
GmgrantGMGRANTRequired
GFX-GRANT→GRN-GRANT

Programs

Updated by (2)