GLAUTMPCNV – GL AU Template Interface

System: General Ledger (GL)
Prefix: GTC
Primary key: RUN-GROUP, COMPANY, TEMPLATE-NAME, ACCT-UNIT, VAR-LEVEL-DISP
Fields: 26
Updated by: 4 programs
Referenced by: 1 program

GLAUTMPCNV is the GL AU Template Interface table in Lawson General Ledger (prefix GTC). It is indexed by RUN-GROUP, COMPANY, TEMPLATE-NAME, ACCT-UNIT, VAR-LEVEL-DISP (GTCSET1); alternate indexes: GTCSET2. It is related 1:1 to GLAUTMPHDR and 1:M to GLAUTMPMST, GLAUTMPMXV and GLAUTMPVLD. It is updated by GL123, GL124, GL23.1 and GL23.3 and referenced by GL223. The table has 26 fields, 2 indexes and 4 documented relations.

About GLAUTMPCNV

This file contains accounting unit template data loaded by Template Conversion Load (GL123),

Fields (26)

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

Field / column	Type	Description & values	Updated by
`GTC-RUN-GROUP` PK RUN_GROUP	Alpha 15	This field contains the run group identifier, used to group records together for interfacing.	GL123, GL23.1
`GTC-COMPANY` PK COMPANY	Numeric 4	This field contains the company to which accunting unit records are added.	GL123, GL23.1
`GTC-TEMPLATE-NAME` PK TEMPLATE_NAME	Alpha 12	This field contains the name of the acciunting unit template used to add accounting units.	GL123, GL23.1
`GTC-SUMMARY-AU` SUMMARY_AU	Alpha 15	This field contains the name of the company summary accounting unit to which the template is attached. If this field is blank the the template starts at level 1.	GL123, GL23.1
`GTC-ACCT-UNIT` PK ACCT_UNIT	Alpha 15	This field contains the accounting unit name. It can be entered by the operator or generated automatically. It defualts from the template accounting unit.	GL123, GL23.1
`GTC-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This field contains the description of the accounting unit..	GL123, GL23.1
`GTC-PARENT-AU` PARENT_AU	Alpha 15	This field contains the name of the parent accounting unit to which the accounting unit reports.	GL123
`GTC-TMPL-ACCT-UNIT` TMPL_ACCT_UNIT	Alpha 15	This field contains the name of the accounting unit from the tempate. If no accounting unit is entered by the operator, or generated automatically, this name defaults.	GL123, GL23.1
`GTC-LEVEL-DETAIL` LEVEL_DETAIL	Numeric 15	This field contains the address to be assigned at the level depth defined for the accounting unit. This value can be entered by the operator or automatically generated. Defaults to the template level detail.	GL123, GL23.1
`GTC-VAR-LEVEL-DISP` PK VAR_LEVEL_DISP	Alpha 34	This field displays the variable level.	GL123, GL23.1
`GTC-NBR-DIGITS` NBR_DIGITS	Numeric 2	This field contains the size at the level depth if the company.	GL123, GL23.1
`GTC-LEVEL-DEPTH` LEVEL_DEPTH	Numeric 1	This field contains the depth of the accounting unit within the company.	GL123, GL23.1
`GTC-PERSON-RESP` PERSON_RESP	Alpha 15 (Lower Case)	This is the name of the person responsible for this record.	GL123, GL23.1, GL23.3
`GTC-MX-TMPLT-NAME` MX_TMPLT_NAME	Alpha 12	This field contains the name of the Matrix (MX) attribute template. Defaults from the template attribute template.	GL23.1, GL23.3
`GTC-ADDR-CONTACT` ADDR_CONTACT	Alpha 30 (Lower Case)	This field contains the name of the main contact.	GL23.1, GL23.3
`GTC-PHONE-COUNTRY` PHONE_COUNTRY	Alpha 6	This field contains the prefix of the telephone number. For example, the country or city code.	GL23.1, GL23.3
`GTC-PHONE-NUMBER` PHONE_NUMBER	Alpha 15	Phone number.	GL23.1
`GTC-PHONE-EXT` PHONE_EXT	Alpha 5	This field contains the telephone extension number.	GL23.1
`GTC-FAX-COUNTRY` FAX_COUNTRY	Alpha 6	This field contains the prefix of the telephone number. For example, the country or city code.	GL23.1, GL23.3
`GTC-FAX-NUMBER` FAX_NUMBER	Alpha 15	Phone number.	GL23.1
`GTC-FAX-EXT` FAX_EXT	Alpha 5	This field contains the telephone extension number.	GL23.1
`GTC-TELEX-NUMBER` TELEX_NUMBER	Alpha 15	This field contains the telex number.	GL23.1, GL23.3
`GTC-OPT-FIELD1` OPT_FIELD1	Alpha 15 (Lower Case)	This field lets you enter any additional information you would like to appear on the address.	GL23.1, GL23.3
`GTC-OPT-FIELD2` OPT_FIELD2	Alpha 15 (Lower Case)	This field lets you enter any additional information you would like to appear on the address.	GL23.1, GL23.3
`GTC-OPT-FIELD3` OPT_FIELD3	Alpha 30 (Lower Case)	This field lets you enter any additional information you would like to appear on the address.	GL23.1, GL23.3
`GTC-ADDR-CODE` ADDR_CODE	Alpha 20	This is a code representing the address for the institution or the institution location. The address is stored in the ADDRDATA file.	GL23.1, GL23.3

Indexes (2)

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
`GTCSET1`	`RUN-GROUP`, `COMPANY`, `TEMPLATE-NAME`, `ACCT-UNIT`, `VAR-LEVEL-DISP`	Primary		GL123, GL124, GL223, GL23.1, GL23.3
`GTCSET2`	`RUN-GROUP`, `COMPANY`, `TEMPLATE-NAME`, `VAR-LEVEL-DISP`, `ACCT-UNIT`			GL123, GL124, GL223, GL23.1

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Glautmphdr	GLAUTMPHDR	Required		`GTC-TEMPLATE-NAME` → `GAH-TEMPLATE-NAME`

One to many (3) — child tables

Relation	Table	Field map
Glautmpmst	GLAUTMPMST	`GTC-TEMPLATE-NAME` → `GTM-TEMPLATE-NAME`, `GTC-ACCT-UNIT` → `GTM-ACCT-UNIT`, → `GTM-ACCOUNT`, → `GTM-SUB-ACCOUNT`
Glautmpmxv	GLAUTMPMXV	`GTC-TEMPLATE-NAME` → `GXV-TEMPLATE-NAME`, `GTC-ACCT-UNIT` → `GXV-ACCT-UNIT`, → `GXV-MATRIX-CAT`
Glautmpvld	GLAUTMPVLD	`GTC-TEMPLATE-NAME` → `GAV-TEMPLATE-NAME`, `GTC-ACCT-UNIT` → `GAV-ACCT-UNIT`, → `GAV-ACCOUNT`, → `GAV-SUB-ACCOUNT`, → `GAV-SYSTEM`

GLAUTMPCNV – GL AU Template Interface

About GLAUTMPCNV

Fields (26)

Indexes (2)

Relations

One to one (1) — lookups and parents

One to many (3) — child tables

Programs

Updated by (4)

Referenced by (1)