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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#GMH-HR-COMPANY SET5HR_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-EMPLOYEE SET5EMPLOYEE | 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-CODE SET5JOB_CODE | Alpha 9 | Optional, not permitted if position is used. | — |
#GMH-PAY-CODE SET5PAY_CODE | Alpha 4 | Contains the pay code. A pay code is a user-defined code that identifies a kind of pay. | — |
#GMH-POSITION SET5POSITION | Alpha 12 | Optional, not permitted if job code is populated. | — |
#GMH-START-DATE SET5START_DATE | Numeric 8 (yyyymmdd) | — | — |
#GMH-END-DATE SET5END_DATE | Numeric 8 (yyyymmdd) | The end date for this effort period. | — |
#GMH-GMI-SEQ-NBR SET5GMI_SEQ_NBR | Numeric 4 | The user-assigned sequence number to keep the records unique and to determine order. | — |
#GMH-ACTIVITY SET3 SET4ACTIVITY | Alpha 15 | Posting level activity that identifies the grant to which costs should be transferred. | — |
#GMH-ACCT-CATEGORY SET3 SET4ACCT_CATEGORY | Alpha 5 | Identifies account category to which labor costs should be transferred. Must be a detail account category. | — |
#GMH-COMPANY SET3 SET4COMPANY | Numeric 4 | Required, identifies the GL company to which labor costs should be transferred. | — |
#GMH-ACCT-UNIT SET3 SET4ACCT_UNIT | Alpha 15 | Required, identifies the GL posting level accounting unit to which labor costs should be transferred. | — |
#GMH-ACCOUNT SET3 SET4ACCOUNT | Numeric 6 | Required, identifies the GL account to which labor costs should be transferred. | — |
#GMH-SUB-ACCOUNT SET3 SET4SUB_ACCOUNT | Numeric 4 | Optional, identifies the GL sub account to which labor costs should be transferred. | — |
#GMH-SEQUENCE-NBR SET2 SET5SEQUENCE_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-ID SET2 SET3 SET4GMI_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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
GMHSET1 |
| Primary | — | |
GMHSET2 |
| KeyChange | — | |
GMHSET3 |
| KeyChange | — | |
GMHSET4 |
| KeyChange | AC10.1, AC300 | |
GMHSET5 |
| KeyChange | — |
Relations
One to one (8) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Acacctcat | ACACCTCAT | Not Required |
| |||||||
| Acactivity | ACACTIVITY | Not Required |
| |||||||
| Employee | EMPLOYEE | Required |
| |||||||
| Glnames | GLNAMES | Not Required |
| |||||||
| Glsystem | GLSYSTEM | Not Required |
| |||||||
| Gmgmhseg | GMGMHSEG | Not Required |
| |||||||
| Gmretdist | GMRETDIST | Required |
| |||||||
| Prsystem Comp | PRSYSTEM | Required |
|