GLAUTMPDTL – GL AU Template Detail

System
General Ledger (GL)
Prefix
GAU
Primary key
TEMPLATE-NAME, ACCT-UNIT
Fields
13
Updated by
3 programs
Referenced by
5 programs

GLAUTMPDTL is the GL AU Template Detail table in Lawson General Ledger (prefix GAU). It is indexed by TEMPLATE-NAME, ACCT-UNIT (GAUSET1); alternate indexes: GAUSET3, GAUSET4 and GAUSET5. It is related 1:1 to GLAUTMPHDR and 1:M to GLAUTMPMST and GLAUTMPMXV. It is updated by GL14.1, GL14.6 and GL14.8 and referenced by GL123, GL124, GL214, GL216 and GL23.1. The table has 13 fields, 4 indexes and 3 documented relations.

About GLAUTMPDTL

This file maintains the names and descriptions of the detailed accounting units within an accounting unit template.

Fields (13)

Column = COBOL field name without the GAU- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
GAU-TEMPLATE-NAME PK
TEMPLATE_NAME		Alpha 12This field contains the name of the accounting unit template.GL14.1, GL14.8
GAU-ACCT-UNIT PK
ACCT_UNIT		Alpha 15This file contains the name of an accounting unit within the template..GL14.1, GL14.8
GAU-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field contains the accounting unit description.GL14.1, GL14.8
GAU-PARENT-AU
PARENT_AU		Alpha 15This field contains the name of the accounting unit to which this accounting unit reports.GL14.1
GAU-LEVEL-DEPTH
LEVEL_DEPTH		Numeric 1This field contains the depth within the template of the accounting unit.GL14.1, GL14.8
GAU-LEVEL-DETAIL
LEVEL_DETAIL		Numeric 15This field contains the address to be assigned at the level depth defined for the accounting unit.GL14.1, GL14.8
GAU-PERSON-RESP
PERSON_RESP		Alpha 15 (Lower Case)This field contains the name of the person responsible for the accounting unit.GL14.1, GL14.8
GAU-POSTING-FLAG
POSTING_FLAG		Alpha 1This field indicates whether the posting flag is Posting (P) or Summary (S). Posting accounting units must have a chart of accounts associated with them.
  • P Posting
  • S Summary
GL14.1, GL14.8
GAU-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1This field indicates whether the accounting unit is Active (A) or Inactive (I). If Inactive, no posting can be done to the accounting unit.
  • A Active
  • I Inactive
GL14.1, GL14.8
GAU-CHART-NAME
CHART_NAME		Alpha 12This field contains the name of the chart of accounts associated with the accounting unit.GL14.1, GL14.8
GAU-CHART-SECTION
CHART_SECTION		Alpha 1This field contains the chart of accounts section associated with the accounting unit. Valid values are:
  • Blank All
  • 1 Balance sheet
  • 2 Income statement
GL14.1, GL14.8
GAU-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the currency code assigned to the accounting unit.GL14.1, GL14.8
GAU-VAR-LEVEL-DISP
VAR_LEVEL_DISP		Alpha 34This field displays the varaible level.GL14.1

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GAUSET1TEMPLATE-NAME, ACCT-UNITPrimaryGL123, GL124, GL14.1, GL14.2, GL14.4, GL14.5, GL14.6, GL14.7 +4 more
GAUSET3TEMPLATE-NAME, VAR-LEVEL-DISP, ACCT-UNITKeyChangeGL123, GL14.9, GL214
GAUSET4TEMPLATE-NAME, PARENT-AU, ACCT-UNITKeyChangeGL14.1
GAUSET5TEMPLATE-NAME, LEVEL-DEPTH, ACCT-UNITGL14.1

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
GlautmphdrGLAUTMPHDRRequiredGAU-TEMPLATE-NAME → GAH-TEMPLATE-NAME

One to many (2) — child tables

RelationTableRulesConditionField map
GlautmpmstGLAUTMPMSTGAU-TEMPLATE-NAME → GTM-TEMPLATE-NAME, GAU-ACCT-UNIT → GTM-ACCT-UNIT, → GTM-ACCOUNT, → GTM-SUB-ACCOUNT
GlautmpmxvGLAUTMPMXVGAU-TEMPLATE-NAME → GXV-TEMPLATE-NAME, GAU-ACCT-UNIT → GXV-ACCT-UNIT, → GXV-MATRIX-CAT

Programs

Updated by (3)

Referenced by (5)