GMGRANT – Grant

System: GM (GM)
Prefix: GRN
Primary key: GRANT
Fields: 54
Updated by: 0 programs
Referenced by: 0 programs

GMGRANT is the Grant table in Lawson GM (prefix GRN). It is indexed by GRANT (GRNSET1); alternate indexes: GRNSET2, GRNSET3, GRNSET4, GRNSET5 and GRNSET6. It is related 1:1 to ACCUSTOMER, ACACCTCAT, ACGLCODE, ARCUSTOMER, EMPLOYEE and OBJID and 1:M to ACHISTHDR, GMCCTMPDTL, GMCNTRFND, GMGRTMXVAL, GMGRTMXVDT, MXLISTHDR and MXLISTMBR. The table has 54 fields, 6 indexes and 19 documented relations.

About GMGRANT

No description in the Lawson data dictionary.

Fields (54)

Column = COBOL field name without the GRN- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`GRN-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.	—
`GRN-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	Description for the grant or non-grant fund.	—
`GRN-LONG-DESC` LONG_DESC	Alpha 60 (Lower Case)	—	—
`GRN-BEGIN-DATE` BEGIN_DATE	Numeric 8 (yyyymmdd)	—	—
`GRN-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	Grant end date.	—
`GRN-AMOUNT` AMOUNT	Signed 18.2	Grant awarded amount.	—
`GRN-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	Currency code for the grant award amount.	—
`GRN-FUND-TYPE` FUND_TYPE	Alpha 1	— `G` Grant `F` Non-Grant Fund	—
`GRN-FUND-SOURCE` FUND_SOURCE	Alpha 15	—	—
`GRN-FUND-GL-CODE` FUND_GL_CODE	Alpha 4	—	—
`GRN-REVENUE-GL-CD` REVENUE_GL_CD	Alpha 4	A GL code is a short cut code which represents a general ledger account for posting to the General Ledger system. This field maintains the default revenue account for the grant or non-grant fund. This account will be credited when project expenditures are invoiced. The offset entry for grants is a debit to AR. The offsetting entry for non-grant funds is revenue offset.	—
`GRN-REV-ACCT-CAT` REV_ACCT_CAT	Alpha 5	Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. Select a revenue type account category for posting grant and non-grant fund revenue to activities.	—
`GRN-DFR-REV-GL-CD` DFR_REV_GL_CD	Alpha 4	Deferred Revenue GL Code. This field is not currently used.	—
`GRN-DFR-ACCT-CAT` DFR_ACCT_CAT	Alpha 5	Deferred Revenue Account Category. This field is not currently used.	—
`GRN-STATUS` STATUS	Numeric 1	— `1` Active `2` Inactive	—
`GRN-GRANTOR-CO` GRANTOR_CO	Numeric 4	—	—
`GRN-GRANTOR` GRANTOR	Alpha 9 (Right Justified)	—	—
`GRN-PRIME-CO` PRIME_CO	Numeric 4	—	—
`GRN-PRIME-GRANTOR` PRIME_GRANTOR	Alpha 9 (Right Justified)	—	—
`GRN-PRIME-GRNT-NO` PRIME_GRNT_NO	Alpha 30	—	—
`GRN-CFDA-NUMBER` CFDA_NUMBER	Alpha 30	—	—
`GRN-SUBMIT-DATE` SUBMIT_DATE	Numeric 8 (yyyymmdd)	—	—
`GRN-NOTICE-DATE` NOTICE_DATE	Numeric 8 (yyyymmdd)	—	—
`GRN-RECEIVE-DATE` RECEIVE_DATE	Numeric 8 (yyyymmdd)	—	—
`GRN-EST-CLOSE-DATE` EST_CLOSE_DATE	Numeric 8 (yyyymmdd)	—	—
`GRN-ACT-CLOSE-DATE` ACT_CLOSE_DATE	Numeric 8 (yyyymmdd)	—	—
`GRN-ARRA-FLAG` ARRA_FLAG	Alpha 1	— `Y` Yes `N` No	—
`GRN-INVOICE-OPTION` INVOICE_OPTION	Alpha 5	—	—
`GRN-PO-NUMBER` PO_NUMBER	Alpha 22	—	—
`GRN-LETTER-CREDIT` LETTER_CREDIT	Alpha 20	—	—
`GRN-DOCUMENT-NBR` DOCUMENT_NBR	Alpha 27	—	—
`GRN-PROGRAM-TITLE` PROGRAM_TITLE	Alpha 60 (Lower Case)	—	—
`GRN-MANAGER-COMP` MANAGER_COMP	Numeric 4	—	—
`GRN-MANAGER` MANAGER	Numeric 9	The manager of the project. The selections are limited to HR resources (HR company and employee) set up in the HR system.	—
`GRN-MANAGER-EMAIL` MANAGER_EMAIL	Alpha 60 (Lower Case)	—	—
`GRN-FUND-AMOUNT` FUND_AMOUNT	Signed 18.2	—	—
`GRN-EXPENDITURES` EXPENDITURES	Signed 18.2	Grant Eligible Expenditures is updated by Grant Expenditure Allocation (GM120). This amount represents the sum of eligible expenditures for all contracts the grant funds. The amount is stored in grant fund currency. Sum of eligible expenditures from GMCNTRFND records for the grant.	—
`GRN-RECEIVABLE` RECEIVABLE	Signed 18.2	—	—
`GRN-RECEIPTS` RECEIPTS	Signed 18.2	—	—
`GRN-REMAINING` REMAINING	Signed 18.2	—	—
`GRN-AMT-TO-CLAIM` AMT_TO_CLAIM	Signed 18.2	—	—
`GRN-ADMIN-COMP` ADMIN_COMP	Numeric 4	—	—
`GRN-ADMINISTRATOR` ADMINISTRATOR	Numeric 9	—	—
`GRN-ADMIN-EMAIL` ADMIN_EMAIL	Alpha 60 (Lower Case)	—	—
`GRN-MATCH` MATCH	Alpha 1	— `Y` Yes `N` No	—
`GRN-MATCH-INELIG` MATCH_INELIG	Alpha 1	— `Y` Yes `N` No	—
`GRN-CSTCL-TEMPLATE` CSTCL_TEMPLATE	Alpha 15	—	—
`GRN-GRANT-BUD-AMT` GRANT_BUD_AMT	Signed 18.2	—	—
`GRN-MATCH-BUD-AMT` MATCH_BUD_AMT	Signed 18.2	—	—
`GRN-MATCH-PERC` MATCH_PERC	Signed 7.3	—	—
`GRN-DUE-TO-GL-CODE` DUE_TO_GL_CODE	Alpha 4	—	—
`GRN-DUE-FR-GL-CODE` DUE_FR_GL_CODE	Alpha 4	—	—
`GRN-OBJ-ID` OBJ_ID	Numeric 12	—	—
`GRN-PRE-AWARD` PRE_AWARD	Alpha 1	— `Y` Yes `N` No	—

Indexes (6)

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
`GRNSET1`	`GRANT`	Primary		AC04.1, AC10.1, AC10.3, AC120, AC135, AC210, MX123, MX500
`GRNSET2`	`FUND-TYPE`, `GRANT`			AC135
`GRNSET3`	`FUND-SOURCE`, `GRANT`	KeyChange		—
`GRNSET4`	`GRANTOR-CO`, `GRANTOR`, `GRANT`	KeyChange		—
`GRNSET5`	`MANAGER-COMP`, `MANAGER`, `GRANT`	KeyChange		—
`GRNSET6`	`OBJ-ID`	Subset	Where OBJ-ID != Zeroes	AC135, MX123, MX202, MX500

Relations

One to one (12) — lookups and parents

Relation	Table	Rules	Condition	Field map
Accustomer	ACCUSTOMER	Not Required		`GRN-GRANTOR-CO` → `CMR-COMPANY`, `GRN-GRANTOR` → `CMR-CUSTOMER`, `GRN-INVOICE-OPTION` → `CMR-AC-CUSTOMER-ID`
Dfrrevacctcat	ACACCTCAT	Not Required		`GRN-DFR-ACCT-CAT` → `AAX-ACCT-CATEGORY`
Dfrrevenueglcd	ACGLCODE	Not Required		`GRN-DFR-REV-GL-CD` → `AGC-AC-GL-CODE`
Duefrglcode	ACGLCODE	Required		`GRN-DUE-FR-GL-CODE` → `AGC-AC-GL-CODE`
Duetoglcode	ACGLCODE	Required		`GRN-DUE-TO-GL-CODE` → `AGC-AC-GL-CODE`
Fundglcode	ACGLCODE	Required	When GRN-FUND-TYPE = "F"	`GRN-FUND-GL-CODE` → `AGC-AC-GL-CODE`
Grantor	ARCUSTOMER	Not Required		`GRN-GRANTOR-CO` → `ACM-COMPANY`, `GRN-GRANTOR` → `ACM-CUSTOMER`
Manager	EMPLOYEE	Not Required		`GRN-MANAGER-COMP` → `EMP-COMPANY`, `GRN-MANAGER` → `EMP-EMPLOYEE`
Objid	OBJID	Required		`"GMGRT"` → `OBI-OBJ-TYPE`
Prime	ARCUSTOMER	Not Required		`GRN-PRIME-CO` → `ACM-COMPANY`, `GRN-PRIME-GRANTOR` → `ACM-CUSTOMER`
Revacctcat	ACACCTCAT	Required		`GRN-REV-ACCT-CAT` → `AAX-ACCT-CATEGORY`
Revenueglcode	ACGLCODE	Required		`GRN-REVENUE-GL-CD` → `AGC-AC-GL-CODE`

One to many (7) — child tables

Relation	Table	Field map
Achisthdr	ACHISTHDR	`GRN-GRANT` → `HIH-GRANT`, → `HIH-CONTRACT`, → `HIH-OBJ-ID`
Gmcctmpdtl	GMCCTMPDTL	`GRN-CSTCL-TEMPLATE` → `GTD-TEMPLATE`, → `GTD-COST-CLASS`, → `GTD-ACCT-CAT`
Gmcntrfnd	GMCNTRFND	`GRN-GRANT` → `GCF-GRANT`, → `GCF-CONTRACT`
Gmgrtmxval	GMGRTMXVAL	`GRN-OBJ-ID` → `GAB-OBJ-ID`, → `GAB-MATRIX-CAT`
Gmgrtmxvdt	GMGRTMXVDT	`GRN-OBJ-ID` → `GAE-OBJ-ID`, → `GAE-MATRIX-CAT`, → `GAE-EFFECTIVE-DATE`
Mxlisthdr	MXLISTHDR	`"GMGRT"` → `MLH-OBJ-TYPE`, → `MLH-MATRIX-LIST`
Mxlistmbr	MXLISTMBR	`"GMGRT"` → `MLM-OBJ-TYPE`, `GRN-OBJ-ID` → `MLM-OBJ-ID`, → `MLM-MATRIX-LIST`

Programs

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