Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GMPGMINC


                             GMPGMINC FILE

The Program Income file stores a list of program income activities that relate
to the grant/project contract.  Program income is gross income earned by the
recipient that is directly generated by a supported activity or earned as a
result of the award.

Program income must be attached to a contract activity.

UPDATED BY

AC300     AC310     BR122     BR140     BRIP.1    AC10.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GMQ-ACTIVITY           Alpha 15
Element: Activity      Identifies the contract activity to
                       which program income activities are
                       being  mapped.


GMQ-PI-ACTIVITY        Alpha 15
Element: Activity      Identifies program income activity; must
                       be posting level.

GMQ-RECORD-TYPE        Alpha 1
Element: Record Type   Identifies type of program income.
                       A - Additive
                       D - Deductive
                       A = Additive
                       D = Deductive

GMQ-PRINT-INV-FL       Alpha 1
Element: Print Inv Fl

GMQ-LAST-INV-NBR       Alpha 22                                  BR122   BR140
Element: Invoice Number                                          BRIP.1

GMQ-LAST-INV-DATE      Numeric 8  (yyyymmdd)                     BR122   BR140
Element: Date                                                    BRIP.1

GMQ-INV-PI-AMT         Signed 18.2                               BR122   BR140
Element: Intl Amt                                                BRIP.1

GMQ-LTD-PI-AMT         Signed 18.2                               BR122   BR140
Element: Intl Amt                                                BRIP.1

GMQ-CURRENCY-CODE      Alpha 5                                   BRIP.1
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

                         GMPGMINC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GMQSET1   ACTIVITY                                               AC10.1  AC300
          PI-ACTIVITY                                            AC310   BR122
                                                                 BR140   BRIP.1

GMQSET2   PI-ACTIVITY   KeyChange                                AC10.1
          ACTIVITY

                         GMPGMINC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactivity     ACACTIVITY   Required

                            GMQ-ACTIVITY       -> ACV-ACTIVITY

Acactivity Pi  ACACTIVITY   Required

                            GMQ-PI-ACTIVITY    -> ACV-ACTIVITY