ACIFCAT – No description in the Lawson data dictionary

System
Activity Management (AC)
Prefix
CIF
Primary key
STRUCTURE, SUM-ACCT-CAT
Fields
10
Updated by
4 programs
Referenced by
0 programs

ACIFCAT is a Lawson Activity Management table (prefix CIF); no description in the lawson data dictionary. It is indexed by STRUCTURE, SUM-ACCT-CAT (CIFSET1); alternate indexes: CIFSET2. It is related 1:M to ACIFCATX. It is updated by AC558, AC58.1, AC58.2 and AC58.3. The table has 10 fields, 2 indexes and 2 documented relations.

About ACIFCAT

No description in the Lawson data dictionary.

Fields (10)

Column = COBOL field name without the CIF- 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
#CIF-STRUCTURE PK
STRUCTURE		Alpha 15The name of the category structure.AC58.1
#CIF-SUM-ACCT-CAT PK
SUM_ACCT_CAT		Alpha 5The name of the summary account category.AC58.1
#CIF-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.AC58.1
#CIF-DEPTH
DEPTH		Numeric 2The level depth of the summary account category.AC58.1
#CIF-SEQ-NUMBER SET2
SEQ_NUMBER		Numeric 6A unique number assigned to each transaction to be interfaced into the Lawson system.AC58.1
#CIF-PARENT-SUM-CAT
PARENT_SUM_CAT		Alpha 5Identifies the parent summary account category of summary account categories at a depth > 1. If a summary category is located at level 1, there will be no parent.AC58.1
#CIF-CATEGORY-TYPE SET2
CATEGORY_TYPE		Alpha 1This Field is used to set up the default category type for the Distribution File. (EEDISTRIB)
  • R Revenue
  • C Cost
  • P Pass Thru
  • A Accrual
AC58.1
#CIF-BUD-FLAG
BUD_FLAG		Alpha 1Budget edit flag for summary account categories.
  • D Detail
  • N No Edit
  • S Summary
AC58.1
#CIF-MATRIX-CAT
MATRIX_CAT		Alpha 12 Occurs 11 Times ×11Attribute name assigned to an object (like accounting unit) to track additional information. Attribute values may then be used in selection and sorting for report and analysis.AC58.3
#CIF-MX-VALUE
MX_VALUE		Alpha 32 Occurs 11 Times ×11The attribute value.AC58.3

Indexes (2)

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
CIFSET1
  1. STRUCTURE
  2. SUM-ACCT-CAT
PrimaryAC558, AC58.1, AC58.2, AC58.3
CIFSET2
  1. STRUCTURE
  2. CATEGORY-TYPE
  3. SEQ-NUMBER
  4. SUM-ACCT-CAT
KeyChangeAC558, AC58.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACIFCATXACIFCAT

One to many (2) — child tables

RelationTableRulesConditionField map
AcifcatxACIFCATX
CIF-STRUCTURE→CIX-STRUCTURE
CIF-SUM-ACCT-CAT→CIX-SUM-ACCT-CAT
—→CIX-ACCT-CATEGORY
AcifcatxallACIFCATX
CIF-STRUCTURE→CIX-STRUCTURE
—→CIX-ACCT-CATEGORY

Programs

Updated by (4)