GLCONDRILL – GL Drill Around
- System
- General Ledger (GL)
- Prefix
GLD- Primary key
GLT-OBJ-ID- Fields
- 6
- Updated by
- 2 programs
- Referenced by
- 0 programs
GLCONDRILL is the GL Drill Around table in Lawson General Ledger (prefix GLD). It is indexed by GLT-OBJ-ID (GLDSET1). It is related 1:M to GLAMOUNTS. It is updated by GL195 and GL500. The table has 6 fields, 1 index and 2 documented relations.
About GLCONDRILL
No description in the Lawson data dictionary.
Fields (6)
Column = COBOL field name without the GLD- 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 |
|---|---|---|---|
#GLD-GLT-OBJ-ID PKGLT_OBJ_ID | Numeric 12 | This is a unique internal GL transaction identification number that is used for Drill Around purposes. | GL195 |
#GLD-ORIG-COMPANYORIG_COMPANY | Numeric 4 | This field contains the name of the source company that originated the transaction posted to the consolidation company. | GL195 |
#GLD-COMPANYCOMPANY | Numeric 4 | This field contains the name of the consolidation company. | GL195 |
#GLD-ACCOUNTACCOUNT | Numeric 6 | This field contains the account number containing the amounts being queried. | GL195 |
#GLD-SUB-ACCOUNTSUB_ACCOUNT | Numeric 4 | This field contains the sub-account containing the amounts being queried. | GL195 |
#GLD-FISCAL-YEARFISCAL_YEAR | Numeric 4 | Tis field contains the fiscal year of the transaction being queried. | GL195, GL500 |
Indexes (1)
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 |
|---|---|---|---|---|
GLDSET1 |
| Primary | GL195, GL500 |
Relations
One to many (2) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Glamacct | GLAMOUNTS |
| ||||||||||||||||||||
| Glamounts | GLAMOUNTS |
|