ACTSTRUC – Account Structure

System
General Ledger Setup (IF)
Prefix
ATD
Primary key
USER-DIM-NAME
Fields
9
Updated by
1 program
Referenced by
5 programs

ACTSTRUC is the Account Structure table in Lawson General Ledger Setup (prefix ATD). It is indexed by USER-DIM-NAME (ATDSET1). It is updated by IFAS.1 and referenced by GLDM.1, GLDM.3, GLDX.1, GLOP.1 and IFBA.1. The table has 9 fields, 1 index and 0 documented relations.

About ACTSTRUC

No description in the Lawson data dictionary.

Fields (9)

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

Field / columnTypeDescription & valuesUpdated by
ATD-USER-DIM-NAME PK
USER_DIM_NAME
Alpha 50 (Lower Case)The User Dimension Name is the name associated with the dimension in the data mart outline. This user-defined name can contain up to 50 alphanumeric characters. For example, you might name a dimension Fiscal Year or Organization.IFAS.1
ATD-ACT-PREFIX
ACT_PREFIX
Alpha 5 (Lower Case)The Type Prefix field contains a unique prefix name that differentiates the members in the Type dimension with similar members in other dimensions. This prefix can contain up to five characters of any kind.IFAS.1
ATD-ACT-ALIAS-OPT
ACT_ALIAS_OPT
Alpha 1The Accounts Alias Option field contains the value that represents the alias name for the members of this dimension. Value values are: description of subaccount; Default value.
  • 1 Account, subaccount, and
  • 2 Account and subaccount
  • 3 Description of subaccount
IFAS.1
ATD-BAL-MBR-NAME
BAL_MBR_NAME
Alpha 30 (Lower Case)The Member Name field contains the user-defined member name for the income statement member. This name can contain up to 30 characters of any kind.IFAS.1
ATD-INC-MBR-NAME
INC_MBR_NAME
Alpha 30 (Lower Case)The Member Name field contains the user-defined member name for the income statement member. This name can contain up to 30 characters of any kind.IFAS.1
ATD-ACCT-ROLLUP
ACCT_ROLLUP
Alpha 1IFAS.1
ATD-CHART-NAME
CHART_NAME
Alpha 12This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system.IFAS.1
ATD-CHART-SECTION
CHART_SECTION
Alpha 1The chart section.IFAS.1
ATD-ACT-SIGN-OPT
ACT_SIGN_OPT
Alpha 1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
ATDSET1USER-DIM-NAMEPrimaryGLDM.1, GLDM.3, GLDX.1, GLOP.1, IFAS.1, IFBA.1

Programs

Updated by (1)

Referenced by (5)