GMCNTRFND – Multi Funded Contract

System
GM (GM)
Prefix
GCF
Primary key
CONTRACT, GRANT
Fields
24
Updated by
0 programs
Referenced by
0 programs

GMCNTRFND is the Multi Funded Contract table in Lawson GM (prefix GCF). It is indexed by CONTRACT, GRANT (GCFSET1); alternate indexes: GCFSET2 and GCFSET3. It is related 1:1 to ACCNTRACT, ACACTIVITY, ACACCTCAT, ACGLCODE, GMGRANT, ARCUSTOMER and ACCUSTOMER and 1:M to ACHISTHDR and GMFNDACT. The table has 24 fields, 3 indexes and 13 documented relations.

About GMCNTRFND

No description in the Lawson data dictionary.

Fields (24)

Column = COBOL field name without the GCF- 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
#GCF-CONTRACT PK
CONTRACT		Alpha 15The contract number or identifier. The GMCNTRFND file contains funding source records for Multi-Funded Contracts defined as "F" Revenue Method contracts created via GM20 (Multi-Funded Contract).—
#GCF-GRANT PK
GRANT		Alpha 30Grant or non-grant fund code or identifier. Grants are funds disbursed by one party (grantor) often a government department or agency to a recipient (grantee). Most grants are made to fund a specific project and require some level of compliance and reporting. Non-grant funds are internal or local funding the grantee contributes towards the project.—
#GCF-PRIORITY-ORDER SET3
PRIORITY_ORDER		Numeric 2Funding priority order. Grant Expenditure Allocation (GM120) will use the priority order to determine expenditure allocation. Funding is processed in priority order.—
#GCF-FUND-PERCENT
FUND_PERCENT		Signed 7.3Enter the funding percentage. If a contract is only funded by a single funding source, enter 100%. If a grant funds a project and requires match enter the grant, funding percent and the match fund(s) and match percent.—
#GCF-FUND-AMOUNT
FUND_AMOUNT		Signed 18.2Funded amount for the funding source. Fund amount is entered in the fund currency and is exchanged and stored in contract currency.—
#GCF-FUND-CURRENCY
FUND_CURRENCY		Alpha 5——
#GCF-CURR-ND
CURR_ND		Numeric 1——
#GCF-CNTR-CURR-AMT
CNTR_CURR_AMT		Signed 18.2——
#GCF-MATCH-FUND
MATCH_FUND		Alpha 30If a funding source is a match fund this field contains the grant the fund matches.—
#GCF-EXPENDITURES
EXPENDITURES		Signed 18.2——
#GCF-RECEIVABLE
RECEIVABLE		Signed 18.2——
#GCF-RECEIPTS
RECEIPTS		Signed 18.2——
#GCF-REMAINING
REMAINING		Signed 18.2——
#GCF-AMT-TO-CLAIM
AMT_TO_CLAIM		Signed 18.2——
#GCF-FUND-GL-CODE
FUND_GL_CODE		Alpha 4——
#GCF-REVENUE-GL-CD
REVENUE_GL_CD		Alpha 4——
#GCF-REV-ACCT-CAT
REV_ACCT_CAT		Alpha 5——
#GCF-DFR-REV-GL-CD
DFR_REV_GL_CD		Alpha 4——
#GCF-DFR-ACCT-CAT
DFR_ACCT_CAT		Alpha 5——
#GCF-CNTR-EXPEND
CNTR_EXPEND		Signed 18.2——
#GCF-CNTR-RECEIVE
CNTR_RECEIVE		Signed 18.2——
#GCF-CNTR-RECEIPTS
CNTR_RECEIPTS		Signed 18.2——
#GCF-CNTR-REMAINING
CNTR_REMAINING		Signed 18.2——
#GCF-CNTR-CLAIM-AMT
CNTR_CLAIM_AMT		Signed 18.2——

Indexes (3)

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
GCFSET1
  1. CONTRACT
  2. GRANT
PrimaryAC04.1, AC10.1, AC120
GCFSET2
  1. GRANT
  2. CONTRACT
—
GCFSET3
  1. CONTRACT
  2. PRIORITY-ORDER
  3. GRANT
KeyChange—

Relations

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

One to one (11) — lookups and parents

RelationTableRulesConditionField map
AccntractACCNTRACTRequired
GCF-CONTRACT→CNT-CONTRACT (CNTSET1)
Cntr ActivityACACTIVITYRequired
CNT-ACTIVITY→ACV-ACTIVITY
DfrrevacctcatACACCTCATNot Required
GCF-DFR-ACCT-CAT→AAX-ACCT-CATEGORY
DfrrevenueglcdACGLCODENot Required
GCF-DFR-REV-GL-CD→AGC-AC-GL-CODE
FundglcodeACGLCODERequiredWhen GRN-FUND-TYPE = "F"
GCF-FUND-GL-CODE→AGC-AC-GL-CODE
GmgrantGMGRANTRequired
GCF-GRANT→GRN-GRANT
GrantorARCUSTOMERNot Required
GRN-GRANTOR-CO→ACM-COMPANY
GRN-GRANTOR→ACM-CUSTOMER
InvoiceoptionACCUSTOMERNot Required
GRN-GRANTOR-CO→CMR-COMPANY
GRN-GRANTOR→CMR-CUSTOMER
GRN-INVOICE-OPTION→CMR-AC-CUSTOMER-ID
MatchgrantGMGRANTRequired
GCF-MATCH-FUND→GRN-GRANT
RevacctcatACACCTCATRequired
GCF-REV-ACCT-CAT→AAX-ACCT-CATEGORY
RevenueglcodeACGLCODERequired
GCF-REVENUE-GL-CD→AGC-AC-GL-CODE

One to many (2) — child tables

RelationTableRulesConditionField map
AchisthdrACHISTHDR
GCF-CONTRACT→HIH-CONTRACT
—→HIH-OBJ-ID
GmfndactGMFNDACT
GCF-CONTRACT→GFC-CONTRACT
GCF-GRANT→GFC-GRANT
—→GFC-ACTIVITY

Programs

No Lawson programs are documented as updating or referencing this table.