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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET4
PARENT_AU		Alpha 15This field contains the name of the accounting unit to which this accounting unit reports.GL14.1
#GAU-LEVEL-DEPTH SET5
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 SET3
VAR_LEVEL_DISP		Alpha 34This field displays the varaible level.GL14.1

Indexes (4)

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.

IndexKeysFlagsConditionUsed in
GAUSET1
  1. TEMPLATE-NAME
  2. ACCT-UNIT
PrimaryGL123, GL124, GL14.1, GL14.2, GL14.4, GL14.5, GL14.6, GL14.7 +4 more
GAUSET3
  1. TEMPLATE-NAME
  2. VAR-LEVEL-DISP
  3. ACCT-UNIT
KeyChangeGL123, GL14.9, GL214
GAUSET4
  1. TEMPLATE-NAME
  2. PARENT-AU
  3. ACCT-UNIT
KeyChangeGL14.1
GAUSET5
  1. TEMPLATE-NAME
  2. LEVEL-DEPTH
  3. ACCT-UNIT
GL14.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLAUTMPHDRGLAUTMPMSTGLAUTMPMXVGLAUTMPDTL

One to one (1) — lookups and parents

RelationTableRulesConditionField map
GlautmphdrGLAUTMPHDRRequired
GAU-TEMPLATE-NAME→GAH-TEMPLATE-NAME

One to many (2) — child tables

RelationTableRulesConditionField map
GlautmpmstGLAUTMPMST
GAU-TEMPLATE-NAME→GTM-TEMPLATE-NAME
GAU-ACCT-UNIT→GTM-ACCT-UNIT
—→GTM-ACCOUNT
—→GTM-SUB-ACCOUNT
GlautmpmxvGLAUTMPMXV
GAU-TEMPLATE-NAME→GXV-TEMPLATE-NAME
GAU-ACCT-UNIT→GXV-ACCT-UNIT
—→GXV-MATRIX-CAT

Programs

Updated by (3)

Referenced by (5)