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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
GMQ-ACTIVITY PKACTIVITY | Alpha 15 | Identifies the contract activity to which program income activities are being mapped. | — |
GMQ-PI-ACTIVITY PKPI_ACTIVITY | Alpha 15 | Identifies program income activity; must be posting level. | — |
GMQ-RECORD-TYPERECORD_TYPE | Alpha 1 | Identifies type of program income. A - Additive D - Deductive
| — |
GMQ-PRINT-INV-FLPRINT_INV_FL | Alpha 1 | — | — |
GMQ-LAST-INV-NBRLAST_INV_NBR | Alpha 22 | Used to identify the invoice. | BR122, BR140, BRIP.1 |
GMQ-LAST-INV-DATELAST_INV_DATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | BR122, BR140, BRIP.1 |
GMQ-INV-PI-AMTINV_PI_AMT | Signed 18.2 | — | BR122, BR140, BRIP.1 |
GMQ-LTD-PI-AMTLTD_PI_AMT | Signed 18.2 | — | BR122, BR140, BRIP.1 |
GMQ-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | BRIP.1 |
Indexes (2)
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 |
|---|---|---|---|---|
GMQSET1 | ACTIVITY, PI-ACTIVITY | Primary | AC10.1, AC300, BR122, BR140, BRIP.1 | |
GMQSET2 | PI-ACTIVITY, ACTIVITY | KeyChange | AC10.1 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Acactivity | ACACTIVITY | Required | GMQ-ACTIVITY → ACV-ACTIVITY | |
| Acactivity Pi | ACACTIVITY | Required | GMQ-PI-ACTIVITY → ACV-ACTIVITY |