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 Used to identify the invoice. BRIP.1
GMQ-LAST-INV-DATE Numeric 8 (yyyymmdd) BR122 BR140
Element: Date This field displays the system date BRIP.1
when this was created.
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
|
