GMPGMINC – Grant Program Income

System
GM (GM)
Prefix
GMQ
Primary key
ACTIVITY, PI-ACTIVITY
Fields
9
Updated by
5 programs
Referenced by
0 programs

GMPGMINC is the Grant Program Income table in Lawson GM (prefix GMQ). It is indexed by ACTIVITY, PI-ACTIVITY (GMQSET1); alternate indexes: GMQSET2. It is related 1:1 to ACACTIVITY. It is updated by AC10.1, AC300, BR122, BR140 and BRIP.1. The table has 9 fields, 2 indexes and 2 documented relations.

About GMPGMINC

No description in the Lawson data dictionary.

Fields (9)

Column = COBOL field name without the GMQ- 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
#GMQ-ACTIVITY PK
ACTIVITY		Alpha 15Identifies the contract activity to which program income activities are being mapped.—
#GMQ-PI-ACTIVITY PK
PI_ACTIVITY		Alpha 15Identifies program income activity; must be posting level.—
#GMQ-RECORD-TYPE
RECORD_TYPE		Alpha 1Identifies type of program income. A - Additive D - Deductive
  • A Additive
  • D Deductive
—
#GMQ-PRINT-INV-FL
PRINT_INV_FL		Alpha 1——
#GMQ-LAST-INV-NBR
LAST_INV_NBR		Alpha 22Used to identify the invoice.BR122, BR140, BRIP.1
#GMQ-LAST-INV-DATE
LAST_INV_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.BR122, BR140, BRIP.1
#GMQ-INV-PI-AMT
INV_PI_AMT		Signed 18.2—BR122, BR140, BRIP.1
#GMQ-LTD-PI-AMT
LTD_PI_AMT		Signed 18.2—BR122, BR140, BRIP.1
#GMQ-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).BRIP.1

Indexes (2)

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
GMQSET1
  1. ACTIVITY
  2. PI-ACTIVITY
PrimaryAC10.1, AC300, BR122, BR140, BRIP.1
GMQSET2
  1. PI-ACTIVITY
  2. ACTIVITY
KeyChangeAC10.1

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AcactivityACACTIVITYRequired
GMQ-ACTIVITY→ACV-ACTIVITY
Acactivity PiACACTIVITYRequired
GMQ-PI-ACTIVITY→ACV-ACTIVITY

Programs

Updated by (5)