GLAUTMPMST – GL Post AU Template

System: General Ledger (GL)
Prefix: GTM
Primary key: TEMPLATE-NAME, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT
Fields: 18
Updated by: 5 programs
Referenced by: 4 programs

GLAUTMPMST is the GL Post AU Template table in Lawson General Ledger (prefix GTM). It is indexed by TEMPLATE-NAME, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT (GTMSET1); alternate indexes: GTMSET2. It is related 1:1 to TRCODES and 1:M to GLAUTMPVLD. It is updated by GL14.1, GL14.2, GL14.4, GL14.6 and GL14.8 and referenced by GL00.3, GL123, GL124 and GL216. The table has 18 fields, 2 indexes and 2 documented relations.

About GLAUTMPMST

This file maintains the posting account information for the posting accounting units within the template.

Fields (18)

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

Field / column	Type	Description & values	Updated by
`GTM-TEMPLATE-NAME` PK TEMPLATE_NAME	Alpha 12	This field contains the name of the accounting unit template.	GL14.2, GL14.4, GL14.8
`GTM-ACCT-UNIT` PK ACCT_UNIT	Alpha 15	This is the name of the posting accounting unit.	GL14.2, GL14.4, GL14.8
`GTM-ACCOUNT` PK ACCOUNT	Numeric 6	This is the number of the account attached to the accounting unit.	GL14.2, GL14.4, GL14.8
`GTM-SUB-ACCOUNT` PK SUB_ACCOUNT	Numeric 4	This field contains the number of the subaccount attached to the account and accounting unit.	GL14.2, GL14.4, GL14.8
`GTM-UNITS-CODE` UNITS_CODE	Alpha 1	This field indicates whether units are allowed. Valid values are Default (Value defaulted from the chart of accounts) `Y` Yes (allow both units and accounts) `N` No (Do not allow units) `O` Only (Allow only units)	GL14.2, GL14.8
`GTM-ACTIVITY-REQ` ACTIVITY_REQ	Alpha 1	Indicates whether an activity is required. Valid values are: Default (Value defaulted from the chart of accounts) `Y` Yes (activity is required) `N` No (Activity is optional) `B` Blank (Activity is not allowed)	GL14.2, GL14.8
`GTM-POSTING-LEVEL` POSTING_LEVEL	Alpha 1	This field indicates whether interfaced transactions posted in Summary or Detail form. Valid values are: Default (Defaulted from chart of accounts. `D` Detail (all posted accounts) `S` Summary (summary of posted accounts)	GL14.2, GL14.8
`GTM-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the account currency. It defaults to the company base currency code, but you can select a non-base currency..	GL14.2, GL14.4, GL14.8
`GTM-CURR-CONTROL` CURR_CONTROL	Alpha 1	This field lets you limit all transactions to the account currency. The default is N (No)..	GL14.2, GL14.8
`GTM-TRANSL-CODE` TRANSL_CODE	Alpha 2	This field identifies the translation rate applied against the account balance to calculate the translation value.	GL14.2, GL14.8
`GTM-REVALUE` REVALUE	Alpha 1	This field indicates whether to revalue non-base account balances to accommodate currency rate changes.	GL14.2, GL14.8
`GTM-ACTIVE-STATUS` ACTIVE_STATUS	Alpha 1	This field displays The status of the account. If Inactive, no posting can be done to the account.	GL14.2, GL14.8
`GTM-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	This field contains the default activity account category to be associated with the posting account. Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing.	GL14.2, GL14.8
`GTM-OPTION-FLD-1` OPTION_FLD_1	Alpha 2 (Lower Case)	This a free-form user field used to store any information relevant to an account. This field is used only for reporting purposes.	GL14.2, GL14.8
`GTM-OPTION-FLD-2` OPTION_FLD_2	Alpha 7 (Lower Case)	This is a free-form user field used to store information relevant to an account. This field is used only for reporting purposes.	GL14.2, GL14.8
`GTM-OPTION-FLD-3` OPTION_FLD_3	Alpha 12 (Lower Case)	This is a free-form field user field used to store any information relevant to an account. This field is used only for reporting purposes.	GL14.2, GL14.8
`GTM-CHART-NAME` CHART_NAME	Alpha 12	This fiekd contains the name of the chart of accounts associated with the account.	GL14.2, GL14.4, GL14.8
`GTM-RESTRICT-SYS` RESTRICT_SYS	Alpha 1	This field indicates whether account usage is restricted to specified system codes.	GL14.2, GL14.8

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
`GTMSET1`	`TEMPLATE-NAME`, `ACCT-UNIT`, `ACCOUNT`, `SUB-ACCOUNT`	Primary		GL123, GL124, GL14.1, GL14.2, GL14.4, GL14.6, GL14.8
`GTMSET2`	`TEMPLATE-NAME`, `ACCOUNT`, `SUB-ACCOUNT`, `ACCT-UNIT`			GL00.3, GL216

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Trcodes	TRCODES	Not Required		`GTM-TRANSL-CODE` → `TRC-TRANSL-CODE`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Glautmpvld	GLAUTMPVLD			`GTM-TEMPLATE-NAME` → `GAV-TEMPLATE-NAME`, `GTM-ACCT-UNIT` → `GAV-ACCT-UNIT`, `GTM-ACCOUNT` → `GAV-ACCOUNT`, `GTM-SUB-ACCOUNT` → `GAV-SUB-ACCOUNT`, → `GAV-SYSTEM`

Programs

Updated by (5)

GL14.1 Accounting Unit Template Definition
GL14.2 Posting Accounts
GL14.4 Mass Add Accounts
GL14.6 Define Accounting Unit Template
GL14.8 Copy Accounting Unit Template

Referenced by (4)

GL00.3 Detail Accounts
GL123 Accounting Unit Template Conversion Load
GL124 Mass Accounting Unit Addition
GL216 Accounting Unit - Accounts Template Listing