ACIFCATX – No description in the Lawson data dictionary

System
Activity Management (AC)
Prefix
CIX
Primary key
STRUCTURE, ACCT-CATEGORY
Fields
13
Updated by
4 programs
Referenced by
0 programs

ACIFCATX is a Lawson Activity Management table (prefix CIX); no description in the lawson data dictionary. It is indexed by STRUCTURE, ACCT-CATEGORY (CIXSET1); alternate indexes: CIXSET2. It is related 1:1 to ACACCTCAT and 1:M to ACIFCAT. It is updated by AC558, AC58.1, AC58.2 and AC58.4. The table has 13 fields, 2 indexes and 2 documented relations.

About ACIFCATX

No description in the Lawson data dictionary.

Fields (13)

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

Field / columnTypeDescription & valuesUpdated by
CIX-STRUCTURE PK
STRUCTURE		Alpha 15The name of the category structure.AC58.2
CIX-SUM-ACCT-CAT
SUM_ACCT_CAT		Alpha 5The name of the summary account category.AC58.2
CIX-ACCT-CATEGORY PK
ACCT_CATEGORY		Alpha 5Account 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. Valid account category types are: cost revenue accrual pass thruAC58.2
CIX-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.AC58.2
CIX-CATEGORY-TYPE
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
—
CIX-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1The status of the account. If Inactive, no posting can be done to the account.
  • A Active
  • I Inactive
AC58.2
CIX-BILLABLE-FLAG
BILLABLE_FLAG		Alpha 1—
  • Y Yes
  • N No
AC58.2
CIX-CAPITAL-FLAG
CAPITAL_FLAG		Alpha 1This field indicates whether an activity/account category is to be capitalized.
  • Y Yes
  • N No
AC58.2
CIX-REVENUE-FLAG
REVENUE_FLAG		Alpha 1This flag identifies whether an activity/account category is eligible for revenue recognition.
  • Y Yes
  • N No
AC58.2
CIX-TM-FLAG
TM_FLAG		Alpha 1This flag indicates whether this account category represents time (labor) or materials for T&M processing.
  • M Materials
  • T Time
AC58.2
CIX-MARK-UP-PCT
MARK_UP_PCT		Signed 5.2This field indicates the percentage of markup for billing. If an account category is billable, a markup percentage can be established. A rate scheudled is for labor transactions only. Markup percentages will increase teh cost amount by the percentage entered.AC58.2
CIX-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.4
CIX-MX-VALUE
MX_VALUE		Alpha 32 Occurs 11 Times ×11The attribute value.AC58.4

Indexes (2)

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

IndexKeysFlagsConditionUsed in
CIXSET1STRUCTURE, ACCT-CATEGORYPrimaryAC558, AC58.1, AC58.2, AC58.4
CIXSET2STRUCTURE, SUM-ACCT-CAT, ACCT-CATEGORYKeyChangeAC558, AC58.1, AC58.2

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATRequiredCIX-ACCT-CATEGORY → AAX-ACCT-CATEGORY

One to many (1) — child tables

RelationTableRulesConditionField map
AcifcatACIFCATCIX-STRUCTURE → CIF-STRUCTURE, → CIF-SUM-ACCT-CAT

Programs

Updated by (4)