ACTWHDR – Activity Trans Writer Header

System
Activity Management (AC)
Prefix
AWH
Primary key
TW-NAME
Fields
26
Updated by
3 programs
Referenced by
1 program

ACTWHDR is the Activity Trans Writer Header table in Lawson Activity Management (prefix AWH). It is indexed by TW-NAME (AWHSET1); alternate indexes: AWHSET2. It is updated by AC256, AC55.1 and AC55.2 and referenced by AC255. The table has 26 fields, 2 indexes and 0 documented relations.

About ACTWHDR

The Activity Management Transaction Writer Header file contains report parameters defined in AC55. (Transaction Writer) and inputs the parameters into AC256 (Transaction Writer Report) to process the report.

Fields (26)

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

Field / columnTypeDescription & valuesUpdated by
AWH-TW-NAME PK
TW_NAME
Alpha 12The name that identifies the Transaction Writer report.AC55.1, AC55.2
AWH-COMPLETE-FLAG
COMPLETE_FLAG
Alpha 1Indicates if the record is complete.
  • Y Yes
  • N No
AC55.1
AWH-FOLDER-NAME
FOLDER_NAME
Alpha 12This is the name of a folder. Folders are defined in RW01.1 (Folder).AC55.1, AC55.2
AWH-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)The Transaction Writer report description.AC55.1, AC55.2
AWH-COLM-SPACING
COLM_SPACING
Numeric 2This is the default value used for creating spaces between columns. Valid values are 0-99.AC55.1
AWH-COLM-HEAD-OPT
COLM_HEAD_OPT
Alpha 1This field determines whether the two column heading lines are controlled manually or by the system (automatic).
  • A Automatic
  • M Manual
AC55.1
AWH-CSV-OUTPUT
CSV_OUTPUT
Alpha 1A No value creates a 132-character wide report with up to two lines of detail per transaction. A Yes value creates a CSV file with two lines of detail strung into one line per transaction. The formatted heading will be the first line of the CSV file.
  • Y Yes
  • N No
AC55.1
AWH-SEARCH-METHOD
SEARCH_METHOD
Alpha 1The method used for the transaction record selection.AC55.1
AWH-LAST-RUN-DATE
LAST_RUN_DATE
Numeric 8 (yyyymmdd)This is the last date the record was processed.AC256, AC55.1, AC55.2
AWH-LAST-RUN-TIME
LAST_RUN_TIME
Numeric 6 (hhmmss)This is the last time the record was processed.AC256, AC55.1, AC55.2
AWH-AG-MATRIX-LIST
AG_MATRIX_LIST
Alpha 12Activity Group ListAC55.1
AWH-ACTIVITY-GRP
ACTIVITY_GRP
Alpha 15This is the Activity Group parameter from the Primary Values tab.AC55.1
AWH-ACTIVITY-1
ACTIVITY_1
Alpha 15This is the first Activity parameter from the Primary Values tab.AC55.1
AWH-ACTIVITY-2
ACTIVITY_2
Alpha 15This is the second Activity parameter from the Primary Values tab.AC55.1
AWH-ACTIVITY-3
ACTIVITY_3
Alpha 15This is the third Activity parameter from the Primary Values tab.AC55.1
AWH-ACTIVITY-4
ACTIVITY_4
Alpha 15This is the fourth Activity parameter from the Primary Values tab.AC55.1
AWH-ACTIVITY-5
ACTIVITY_5
Alpha 15This is the fifth Activity parameter from the Primary Values tab.AC55.1
AWH-ACTIVITY-6
ACTIVITY_6
Alpha 15This is the sixth Activity parameter from the Primary Values tab.AC55.1
AWH-LIST-NAME
LIST_NAME
Alpha 14This is the List parameter from the Primary Values tab.AC55.1
AWH-CATEGORY-TYPE
CATEGORY_TYPE
Alpha 1This is the Account Category type parameter from the Primary Values tab.
  • R Revenue
  • C Cost
  • A Accrual
  • L All
  • F Fee
AC55.1
AWH-ACCT-CATEGORY
ACCT_CATEGORY
Alpha 5This is the Account Category parameter from the Primary Values tab.AC55.1
AWH-GROUP
GROUP
Alpha 15This is the Account Category Group parameter from the Primary Values tab.AC55.1
AWH-HEADING-LAYOUT
HEADING_LAYOUT
Alpha 127 Occurs 2 Times ×2This field determines the column headings for transaction detail. The layout can be created by the program or user-maintained. The option is set in the Column Heading Control field.AC55.1
AWH-LAST-SEQ-NBR
LAST_SEQ_NBR
Numeric 6This is the last transaction sequence number.AC55.1
AWH-SORT-MX-CAT
SORT_MX_CAT
Alpha 12 Occurs 8 Times ×8There are up to eight matrix categories to sort the selected objects by. It does not have to be a selection category to be sort category. The sort is in ascending order.AC55.1
AWH-CURRENCY-CODE
CURRENCY_CODE
Alpha 5This field contains the company base currency code established in Company (GL10.1 ).AC55.1

Indexes (2)

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

IndexKeysFlagsConditionUsed in
AWHSET1TW-NAMEPrimaryAC255, AC256, AC55.1, AC55.2
AWHSET2FOLDER-NAME, TW-NAMEKeyChangeAC255, AC256

Programs

Updated by (3)

Referenced by (1)