ACTWLAYOUT – Activity Trans Writer Layout

System
Activity Management (AC)
Prefix
AWL
Primary key
TW-NAME, LINE, COLM-NBR
Fields
14
Updated by
2 programs
Referenced by
2 programs

ACTWLAYOUT is the Activity Trans Writer Layout table in Lawson Activity Management (prefix AWL). It is indexed by TW-NAME, LINE, COLM-NBR (AWLSET1). It is updated by AC55.1 and AC55.2 and referenced by AC255 and AC256. The table has 14 fields, 1 index and 0 documented relations.

About ACTWLAYOUT

The Activity Management Transaction Writer Layout file stores transaction writer layout information defined in the Layout form tab in AC55.1 (Transaction Writer).

Fields (14)

Column = COBOL field name without the AWL- 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
#AWL-MATRIX-CAT
MATRIX_CAT		Alpha 12Attribute name assigned to Activity Management Transaction-type objects (object type ACTVY). Attributes are used in selection and sorting for the Transaction Writer report.AC55.1
#AWL-TW-NAME PK
TW_NAME		Alpha 12The name that identifies the Transaction Writer report.AC55.1, AC55.2
#AWL-COLM-NBR PK
COLM_NBR		Numeric 2The column number within the line number.AC55.1
#AWL-LINE PK
LINE		Numeric 2The Line Number determines whether the columns being maintained are on line 1 or line 2.AC55.1
#AWL-FIELD-SIZE
FIELD_SIZE		Numeric 2The size of the column. Date fields are 8, Numeric fields are maximum of 18, alpha fields are maximum of 20.AC55.1
#AWL-DECIMALS
DECIMALS		Numeric 1The decimal values for the column are 0-6. Zero is the default. Decimals are only used with amount and currency rate-type fields.AC55.1
#AWL-COLM-SPACING
COLM_SPACING		Numeric 2The number of blank spaces preceding the column.AC55.1
#AWL-COUNT-TOT-OPT
COUNT_TOT_OPT		Alpha 1Counts either the number of records in an alpha or date field or totals the value in a numeric field.
  • Y Yes
  • N No
AC55.1
#AWL-TOTAL-BREAK
TOTAL_BREAK		Alpha 1Determines if totals print when the value in this field changes. No is the default.
  • Y Yes
  • N No
AC55.1
#AWL-PAGE-BREAK
PAGE_BREAK		Alpha 1Determines if a page break occurs when the value in this field changes. No is the default.
  • Y Yes
  • N No
AC55.1
#AWL-DESC-OF
DESC_OF		Alpha 1Determines if the description of the field will print. No is the default.
  • Y Yes
  • N No
AC55.1
#AWL-SUPR-COLM-DUPS
SUPR_COLM_DUPS		Alpha 1Determines if the field value will print if it equals the previous transaction. No is the default.
  • Y Yes
  • N No
AC55.1
#AWL-SUPR-LINE-DUPS
SUPR_LINE_DUPS		Alpha 1Determines if the entire line will print if it equals the previous transaction field value. No is the default.
  • Y Yes
  • N No
AC55.1
#AWL-ALIGN-HEADING
ALIGN_HEADING		Alpha 1Determines how the heading aligns over the field values. Left align defaults for alpha fields. Right align defaults for all other fields. The heading is aligned based on the entire column size.
  • L Left
  • R Right
  • C Center
  • N None
AC55.1

Indexes (1)

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
AWLSET1
  1. TW-NAME
  2. LINE
  3. COLM-NBR
PrimaryAC255, AC256, AC55.1, AC55.2

Programs

Updated by (2)

Referenced by (2)