GM – Lawson tables and programs

GM in Lawson S3 v10 MSP6 has 23 tables, 0 online screens and 0 batch programs. The source library does not name this system; the folder code is used.

Tables (23)

Table	Prefix	Description	Primary key	Fields
GMAUDIT	`GIT`	The GM audit file tracks when labor distribution record status changes occur and when labor distribution records are…	`HR-COMPANY, EMPLOYEE, DATE-STAMP, TIME-STAMP`	5
GMAWARD	`GMG`	Grant Management Award	`ACTIVITY`	27
GMCCTMPDTL	`GTD`	Cost Class Acct Cat Relation	`TEMPLATE, COST-CLASS, ACCT-CAT`	3
GMCNTRFND	`GCF`	Multi Funded Contract	`CONTRACT, GRANT`	24
GMCONTROL	`GMJ`	No description in the Lawson data dictionary	`COMPANY`	2
GMCOSTSHR	`GMO`	Grant Management Cost Share	`ACTIVITY, CS-ACTIVITY`	13
GMDELIV	`GLV`	Grant Sponsor Deliverables	`ACTIVITY, DELIV-CODE-DE`	7
GMEFFORT	`EFH`	Actual Grant Effort	`HR-COMPANY, EMPLOYEE, BEGIN-DATE, END-DATE, SEQUENCE-NBR`	25
GMFNDACT	`GFC`	Grant Eligible Activities	`CONTRACT, GRANT, ACTIVITY`	6
GMFNDACTX	`GFX`	Grant Eligible Acct Categories	`CONTRACT, GRANT, ACTIVITY, ACCT-CATEGORY`	9
GMGMASEG	`GMS`	No description in the Lawson data dictionary	`GMA-OBJ-ID`	2
GMGMHSEG	`GSG`	No description in the Lawson data dictionary	`GMH-OBJ-ID`	2
GMGRANT	`GRN`	Grant	`GRANT`	54
GMGRTMXVAL	`GAB`	No description in the Lawson data dictionary	`OBJ-ID, MATRIX-CAT`	4
GMGRTMXVDT	`GAE`	No description in the Lawson data dictionary	`OBJ-ID, MATRIX-CAT, EFFECTIVE-DATE`	4
GMLABDIST	`GML`	Grant Labor Distribution	`OBJ-ID`	12
GMLABDISTX	`GMA`	Grant Labor Distribution Dtl	`OBJ-ID`	42
GMPGMINC	`GMQ`	Grant Program Income	`ACTIVITY, PI-ACTIVITY`	9
GMPROTOCOL	`GMM`	Grant Management Protocol	`ACTIVITY, PROT-CODE-PC, PROTOCOL-NBR, EXPIRE-DATE`	7
GMRETDIST	`GMI`	Grant Retro Labor Distribution	`OBJ-ID`	16
GMRETDISTX	`GMH`	Grant Retro Labor Dist Detail	`OBJ-ID`	41
GMSALCAP	`GMC`	Grant Salary Cap Schedule	`SCHEDULE, CURRENCY-CODE`	4
GMTRANEFRT	`GEF`	Grant Effort Transaction	`OBJ-ID`	32