GMRETDISTX – Grant Retro Labor Dist Detail
- System
- GM (GM)
- Prefix
GMH- Primary key
OBJ-ID- Fields
- 41
- Updated by
- 2 programs
- Referenced by
- 0 programs
GMRETDISTX is the Grant Retro Labor Dist Detail table in Lawson GM (prefix GMH). It is indexed by OBJ-ID (GMHSET1); alternate indexes: GMHSET2, GMHSET3, GMHSET4 and GMHSET5. It is related 1:1 to ACACCTCAT, ACACTIVITY, EMPLOYEE, GLNAMES, GLSYSTEM, GMGMHSEG, GMRETDIST and PRSYSTEM. It is updated by AC10.1 and AC300. The table has 41 fields, 5 indexes and 8 documented relations.
About GMRETDISTX
No description in the Lawson data dictionary.
Fields (41)
Column = COBOL field name without the GMH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
GMH-HR-COMPANYHR_COMPANY | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | — |
GMH-EMPLOYEEEMPLOYEE | Numeric 9 | Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person. | — |
GMH-JOB-CODEJOB_CODE | Alpha 9 | Optional, not permitted if position is used. | — |
GMH-PAY-CODEPAY_CODE | Alpha 4 | Contains the pay code. A pay code is a user-defined code that identifies a kind of pay. | — |
GMH-POSITIONPOSITION | Alpha 12 | Optional, not permitted if job code is populated. | — |
GMH-START-DATESTART_DATE | Numeric 8 (yyyymmdd) | — | — |
GMH-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | The end date for this effort period. | — |
GMH-GMI-SEQ-NBRGMI_SEQ_NBR | Numeric 4 | The user-assigned sequence number to keep the records unique and to determine order. | — |
GMH-ACTIVITYACTIVITY | Alpha 15 | Posting level activity that identifies the grant to which costs should be transferred. | — |
GMH-ACCT-CATEGORYACCT_CATEGORY | Alpha 5 | Identifies account category to which labor costs should be transferred. Must be a detail account category. | — |
GMH-COMPANYCOMPANY | Numeric 4 | Required, identifies the GL company to which labor costs should be transferred. | — |
GMH-ACCT-UNITACCT_UNIT | Alpha 15 | Required, identifies the GL posting level accounting unit to which labor costs should be transferred. | — |
GMH-ACCOUNTACCOUNT | Numeric 6 | Required, identifies the GL account to which labor costs should be transferred. | — |
GMH-SUB-ACCOUNTSUB_ACCOUNT | Numeric 4 | Optional, identifies the GL sub account to which labor costs should be transferred. | — |
GMH-SEQUENCE-NBRSEQUENCE_NBR | Numeric 4 | The user-assigned sequence number to keep the records unique and to determine order. | — |
GMH-SALARY-PCTSALARY_PCT | Signed 13.6 | Percentage of gross earnings to be transferred to the activity and GL account specified; negatives are not permitted. | — |
GMH-EFFORT-PCTEFFORT_PCT | Signed 13.6 | Percentage of planned effort to be transferred to the activity and GL account specified; negatives are not permitted. | — |
GMH-SEGMENT-FLAGSEGMENT_FLAG | Alpha 1 | Indicates whether user analysis values (SL segment) have been populated for the distribution line. | — |
GMH-OBJ-ID PKOBJ_ID | Numeric 12 | Object ID for the GMRETDISTX record. | — |
GMH-GMI-OBJ-IDGMI_OBJ_ID | Numeric 12 | Object identifier number for GM detail record's header GMRETDIST. | — |
GMH-LN-STATUSLN_STATUS | Alpha 1 | Identifies line approval status for the template distribution line. Valid values include: U - Unreleased R - Released A - Approved H - Hold
| — |
GMH-LN-APPR-LEVELLN_APPR_LEVEL | Alpha 20 | Identifies current level or approval when multiple approvals are used. | — |
GMH-LN-STATUS-USERLN_STATUS_USER | Alpha 10 (Lower Case) | Captured automatically; identifies user who initiated current status. | — |
GMH-LN-STATUS-DATELN_STATUS_DATE | Numeric 8 (yyyymmdd) | Captured automatically; identifies system date on which current status occurred. | — |
GMH-LN-STATUS-TIMELN_STATUS_TIME | Numeric 6 (hhmmss) | Captured automatically; identifies system time when current status occurred. | — |
GMH-FRNG-ACCOUNTFRNG_ACCOUNT | Numeric 6 | A default post-to fringe account that can be used by the GM110 program to create commitments for fringe amounts. There is a parameter choice on the GM110 program that allows the user to default the fringe rate, post-to account and account category information from the activity or employee. | — |
GMH-FRNG-SUB-ACCTFRNG_SUB_ACCT | Numeric 4 | A default post-to fringe sub account that can be used by the GM110 program to create commitments for fringe amounts. There is a parameter choice on the GM110 program that allows the user to default the fringe rate, post-to account and account category information from the activity or employee. | — |
GMH-FRNG-ACCT-CATFRNG_ACCT_CAT | Alpha 5 | A default post-to fringe account category that can be used by GM110 program to create commitments for fringe amounts. There is a parameter choice on the GM110 program that allows the user to default the rate, post-to account and account category information from the activity or employee. | — |
GMH-EST-MONTH-AMTEST_MONTH_AMT | Signed 18.2 | — | — |
GMH-EST-TOTAL-AMTEST_TOTAL_AMT | Signed 18.2 | — | — |
GMH-EST-GRANT-AMTEST_GRANT_AMT | Signed 18.2 | — | — |
GMH-CAP-APPLIEDCAP_APPLIED | Alpha 1 | — | — |
GMH-CAP-EMPL-SALCAP_EMPL_SAL | Signed 18.2 | — | — |
GMH-CAP-ALLOW-SALCAP_ALLOW_SAL | Signed 18.2 | — | — |
GMH-CAP-SAL-OVERCAP_SAL_OVER | Signed 18.2 | — | — |
GMH-CAP-ORIG-PCTCAP_ORIG_PCT | Signed 13.6 | — | — |
GMH-CAP-OVER-PCTCAP_OVER_PCT | Signed 13.6 | — | — |
GMH-CAP-PCTCAP_PCT | Signed 13.6 | — | — |
GMH-ORIG-EMP-SALORIG_EMP_SAL | Signed 18.2 | — | — |
GMH-ORIG-SAL-CAPORIG_SAL_CAP | Signed 18.2 | — | — |
GMH-OVERAGE-OBJ-IDOVERAGE_OBJ_ID | Numeric 12 | — | — |
Indexes (5)
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 |
|---|---|---|---|---|
GMHSET1 | OBJ-ID | Primary | — | |
GMHSET2 | GMI-OBJ-ID, SEQUENCE-NBR, OBJ-ID | KeyChange | — | |
GMHSET3 | GMI-OBJ-ID, ACTIVITY, ACCT-CATEGORY, COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, OBJ-ID | KeyChange | — | |
GMHSET4 | ACTIVITY, ACCT-CATEGORY, COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, GMI-OBJ-ID, OBJ-ID | KeyChange | AC10.1, AC300 | |
GMHSET5 | HR-COMPANY, EMPLOYEE, JOB-CODE, POSITION, PAY-CODE, START-DATE, END-DATE, GMI-SEQ-NBR, SEQUENCE-NBR, OBJ-ID | KeyChange | — |
Relations
One to one (8) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Acacctcat | ACACCTCAT | Not Required | GMH-ACCT-CATEGORY → AAX-ACCT-CATEGORY (AAXSET1) | |
| Acactivity | ACACTIVITY | Not Required | GMH-ACTIVITY → ACV-ACTIVITY | |
| Employee | EMPLOYEE | Required | GMH-HR-COMPANY → EMP-COMPANY, GMH-EMPLOYEE → EMP-EMPLOYEE | |
| Glnames | GLNAMES | Not Required | GMH-COMPANY → GLN-COMPANY, GMH-ACCT-UNIT → GLN-ACCT-UNIT | |
| Glsystem | GLSYSTEM | Not Required | GMH-COMPANY → GLS-COMPANY | |
| Gmgmhseg | GMGMHSEG | Not Required | GMH-OBJ-ID → GSG-GMH-OBJ-ID | |
| Gmretdist | GMRETDIST | Required | GMH-GMI-OBJ-ID → GMI-OBJ-ID | |
| Prsystem Comp | PRSYSTEM | Required | GMH-HR-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL |