GLSUBACDTL – GL Subaccount Detail

System
General Ledger (GL)
Prefix
GSD
Primary key
SUB-ACCOUNT, SUB-ACCT-TMPLT
Fields
23
Updated by
3 programs
Referenced by
4 programs

GLSUBACDTL is the GL Subaccount Detail table in Lawson General Ledger (prefix GSD). It is indexed by SUB-ACCOUNT, SUB-ACCT-TMPLT (GSDSET1); alternate indexes: GSDSET2. It is related 1:1 to MXLISTHDR and TRCODES and 1:M to GLSUBACVLD. It is updated by GL13.1, GL13.2 and GL13.4 and referenced by GL02.3, GL160, GL213 and GL60.1. The table has 23 fields, 2 indexes and 3 documented relations.

About GLSUBACDTL

This file maintains the subaccount number and details of each subaccount within a subaccount template.

Fields (23)

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

Field / columnTypeDescription & valuesUpdated by
GSD-SUB-ACCT-TMPLT PK
SUB_ACCT_TMPLT		Alpha 12This field contains name of the subaccont template to which the subaccount belongs.GL13.1
GSD-SUB-ACCOUNT PK
SUB_ACCOUNT		Numeric 4This field contains the subaccount number.GL13.1
GSD-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field contains the subaccount description.GL13.1
GSD-SPACE-CODE
SPACE_CODE		Numeric 1This field indicates the number of spaces to advance after the account appears on a report.
  • 1 Advance One Line
  • 2 Advance Two Lines
  • 3 Advance Three Lines
  • 9 Advance To Next Page
GL13.1
GSD-SIGN-CODE
SIGN_CODE		Alpha 1This field determines if the system prints a negative sign next to a positive amount. Reversing the sign only affects report printing, not account totaling. Valid values are: If you leave this field blank, No defaults and the system prints a negative sign for a negative amount.
  • Y Yes
  • N No
  • N No
GL13.1
GSD-UNITS-CODE
UNITS_CODE		Alpha 1This field determines if units are allowed in the subaccount. Valid values are:
  • Y Yes (Allow both)
  • N No (Allow only amounts)
  • O Only (Allow only units)
  • Y Yes
GL13.1
GSD-ACTIVITY-REQ
ACTIVITY_REQ		Alpha 1This field indicates if an activity is required. Valid values are: Blank means that the field takes on the value assigned for this field to the account that this subaccount is attached to.
  • Y Yes
  • N No
  • B Blank
GL13.1
GSD-POSTING-LEVEL
POSTING_LEVEL		Alpha 1This field determines if transactions are interfaced to the Lawson General Ledger system in summary or detail form. Valid values are:
  • S Summary
  • D Detail
GL13.1
GSD-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code.GL13.1
GSD-CURR-CONTROL
CURR_CONTROL		Alpha 1This field lets you limit all transactions to one currency.
  • 0 No
  • 1 Yes
GL13.1
GSD-TRANSL-CODE
TRANSL_CODE		Alpha 2This field identifies the translation rate applied against the subaccount balance to calculate the translation value.GL13.1
GSD-REVALUE
REVALUE		Alpha 1This field indicates whether to revalue non-base transactions of an account into the company base currency..
  • 0 No
  • 1 Yes
GL13.1
GSD-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1This field determines the status of the account. If Inactive, no posting can be done to the account.
  • A Active
  • I Inactive
GL13.1
GSD-DYNAMIC-LIST
DYNAMIC_LIST		Alpha 12This field defines a list of accounting units to which the account is automatically assigned..GL13.1
GSD-RESTRICT-SYS
RESTRICT_SYS		Alpha 1This field indicates whether account usage is restricted to specified system codes. Valid values are: Blank (inherits the restrictions defined for the summary account it is associated with) " " = Sum Acct Default
  • Y Yes (Restrict to systems specified)
  • N No (no restriction)
GL13.1
GSD-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5This field contains the default account category to be used, if you use the Activity system. Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). 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.GL13.1
GSD-DAILY-BALANCE
DAILY_BALANCE		Alpha 1This field indicates whether transactions can be viewed on a daily basis. Valid values are:
  • Y Yes
  • N No
GL13.1
GSD-RELATION
RELATION		Alpha 15This field defines a user analysis value relation to associate with the subaccount. The relation must exist in User Analysis Value Relation (SL02.1).GL13.1
GSD-UNARY-OPER
UNARY_OPER		Alpha 1This field contains the mathematical operation to consolidate amounts for a natural balance. Valid values are: + = Add % = Percentile ~ = Do nothing The default is Add. Only used by the OLAP environment. " " = Do Nothing
  • - Subtract
  • * Multiply
  • / Divide
GL13.1
GSD-NAT-BALANCE
NAT_BALANCE		Alpha 1This field determines whether the natural balance is a Debit (D) or Credit (C). This field is not required. This is only used by the OLAP environment.
  • D Debit
  • C Credit
GL13.1
GSD-SL-ACCT-FLAG
SL_ACCT_FLAG		Alpha 1This flag determines whether user analysis values can be assigned to a specific account. You can select Yes, No, or use the Summary Account selection. " " = Sum Acct Default
  • Y Yes
  • N No
GL13.1
GSD-LEDGER-GROUP
LEDGER_GROUP		Alpha 15—GL13.1
GSD-GL-BUD-FL
GL_BUD_FL		Alpha 1—GL13.1

Indexes (2)

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

IndexKeysFlagsConditionUsed in
GSDSET1SUB-ACCOUNT, SUB-ACCT-TMPLTPrimary—
GSDSET2SUB-ACCT-TMPLT, SUB-ACCOUNTGL02.3, GL13.1, GL13.2, GL13.4, GL160, GL213, GL60.1

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
MxlisthdrMXLISTHDRNot Required"ACCTU" → MLH-OBJ-TYPE, GSD-DYNAMIC-LIST → MLH-MATRIX-LIST
TrcodesTRCODESNot RequiredGSD-TRANSL-CODE → TRC-TRANSL-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
GlsubacvldGLSUBACVLDGSD-SUB-ACCT-TMPLT → GSV-SUB-ACCT-TMPLT, GSD-SUB-ACCOUNT → GSV-SUB-ACCOUNT, → GSV-SYSTEM

Programs

Updated by (3)

Referenced by (4)