GLHISTCOM – No description in the Lawson data dictionary
- System
- General Ledger (GL)
- Prefix
GHT- Primary key
COMPANY,ACCT-UNIT,ACCOUNT,SUB-ACCOUNT,YEAR,SYSTEM,UNIQUE-I-D- Fields
- 15
- Updated by
- 1 program
- Referenced by
- 1 program
GLHISTCOM is a Lawson General Ledger table (prefix GHT); no description in the lawson data dictionary. It is indexed by COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, YEAR, SYSTEM, UNIQUE-I-D (GHTSET1); alternate indexes: GHTSET2, GHTSET3, GHTSET4 and GHTUID. It is related 1:1 to GLCOMMIT and GLMASTER and 1:M to FBDETAIL. It is updated by GL192 and referenced by GLRV.1. The table has 15 fields, 5 indexes and 3 documented relations.
About GLHISTCOM
No description in the Lawson data dictionary.
Fields (15)
Column = COBOL field name without the GHT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
GHT-UNIQUE-I-D PKUNIQUE_I_D | Bad Type 36 | — | — |
GHT-COMPANY PKCOMPANY | Numeric 4 | — | GL192 |
GHT-ACCT-UNIT PKACCT_UNIT | Alpha 15 | — | GL192 |
GHT-ACCOUNT PKACCOUNT | Numeric 6 | — | GL192 |
GHT-SUB-ACCOUNT PKSUB_ACCOUNT | Numeric 4 | — | GL192 |
GHT-YEAR PKYEAR | Numeric 4 | — | GL192 |
GHT-VAR-LEVELSVAR_LEVELS | Alpha 30 | — | GL192 |
GHT-SYSTEM PKSYSTEM | Alpha 2 | — | GL192 |
GHT-DB-AMOUNTDB_AMOUNT | Signed 18.2 Occurs 13 Times ×13 | — | GL192 |
GHT-CR-AMOUNTCR_AMOUNT | Signed 18.2 Occurs 13 Times ×13 | — | GL192 |
GHT-DB-UNITSDB_UNITS | Signed 15.2 Occurs 13 Times ×13 | — | GL192 |
GHT-CR-UNITSCR_UNITS | Signed 15.2 Occurs 13 Times ×13 | — | GL192 |
GHT-MAINT-DATEMAINT_DATE | Numeric 8 (yyyymmdd) | — | GL192 |
GHT-MAINT-TIMEMAINT_TIME | Numeric 6 (hhmmss) | — | GL192 |
GHT-FUND-GROUPFUND_GROUP | Alpha 15 | — | GL192 |
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 |
|---|---|---|---|---|
GHTSET1 | COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, YEAR, SYSTEM, UNIQUE-I-D | Primary, KeyChange | GL192 | |
GHTSET2 | COMPANY, VAR-LEVELS, ACCOUNT, SUB-ACCOUNT, ACCT-UNIT, YEAR, SYSTEM, UNIQUE-I-D | KeyChange | GLRV.1 | |
GHTSET3 | COMPANY, ACCOUNT, SUB-ACCOUNT, ACCT-UNIT, YEAR, SYSTEM, UNIQUE-I-D | KeyChange | GL192 | |
GHTSET4 | COMPANY, FUND-GROUP, YEAR, SYSTEM, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, UNIQUE-I-D | KeyChange, Subset | Where FUND-GROUP != Spaces | — |
GHTUID | UNIQUE-I-D | — |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Glcommit | GLCOMMIT | Not Required | GHT-COMPANY → GOT-COMPANY (GOTSET1), GHT-ACCT-UNIT → GOT-ACCT-UNIT, GHT-ACCOUNT → GOT-ACCOUNT, GHT-SUB-ACCOUNT → GOT-SUB-ACCOUNT, GHT-YEAR → GOT-FISCAL-YEAR, GHT-SYSTEM → GOT-SYSTEM | |
| Glmaster | GLMASTER | Required | GHT-COMPANY → GLM-COMPANY, GHT-ACCT-UNIT → GLM-ACCT-UNIT, GHT-ACCOUNT → GLM-ACCOUNT, GHT-SUB-ACCOUNT → GLM-SUB-ACCOUNT |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Fbdetail | FBDETAIL | GHT-COMPANY → FBD-COMPANY, GHT-ACCT-UNIT → FBD-ACCT-UNIT, GHT-ACCOUNT → FBD-ACCOUNT, GHT-SUB-ACCOUNT → FBD-SUB-ACCOUNT, FBD-BUDGET-NBR, FBD-FISCAL-YEAR |
Programs
Updated by (1)
- GL192 Commitment History Update
Referenced by (1)
- GLRV.1 General Ledger Report