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.

Field / column	Type	Description & values	Updated by
`GCF-CONTRACT` PK CONTRACT	Alpha 15	The 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 30	Grant 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` PRIORITY_ORDER	Numeric 2	Funding 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.3	Enter 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.2	Funded 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 30	If 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`GCFSET1`	`CONTRACT`, `GRANT`	Primary	AC04.1, AC10.1, AC120
`GCFSET2`	`GRANT`, `CONTRACT`		—
`GCFSET3`	`CONTRACT`, `PRIORITY-ORDER`, `GRANT`	KeyChange	—

Relations

One to one (11) — lookups and parents

Relation	Table	Rules	Condition	Field map
Accntract	ACCNTRACT	Required		`GCF-CONTRACT` → `CNT-CONTRACT (CNTSET1)`
Cntr Activity	ACACTIVITY	Required		`CNT-ACTIVITY` → `ACV-ACTIVITY`
Dfrrevacctcat	ACACCTCAT	Not Required		`GCF-DFR-ACCT-CAT` → `AAX-ACCT-CATEGORY`
Dfrrevenueglcd	ACGLCODE	Not Required		`GCF-DFR-REV-GL-CD` → `AGC-AC-GL-CODE`
Fundglcode	ACGLCODE	Required	When GRN-FUND-TYPE = "F"	`GCF-FUND-GL-CODE` → `AGC-AC-GL-CODE`
Gmgrant	GMGRANT	Required		`GCF-GRANT` → `GRN-GRANT`
Grantor	ARCUSTOMER	Not Required		`GRN-GRANTOR-CO` → `ACM-COMPANY`, `GRN-GRANTOR` → `ACM-CUSTOMER`
Invoiceoption	ACCUSTOMER	Not Required		`GRN-GRANTOR-CO` → `CMR-COMPANY`, `GRN-GRANTOR` → `CMR-CUSTOMER`, `GRN-INVOICE-OPTION` → `CMR-AC-CUSTOMER-ID`
Matchgrant	GMGRANT	Required		`GCF-MATCH-FUND` → `GRN-GRANT`
Revacctcat	ACACCTCAT	Required		`GCF-REV-ACCT-CAT` → `AAX-ACCT-CATEGORY`
Revenueglcode	ACGLCODE	Required		`GCF-REVENUE-GL-CD` → `AGC-AC-GL-CODE`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Achisthdr	ACHISTHDR			`GCF-CONTRACT` → `HIH-CONTRACT`, → `HIH-OBJ-ID`
Gmfndact	GMFNDACT			`GCF-CONTRACT` → `GFC-CONTRACT`, `GCF-GRANT` → `GFC-GRANT`, → `GFC-ACTIVITY`

Programs

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