ACIACATMBR – No description in the Lawson data dictionary

System
Activity Management (AC)
Prefix
CMY
Primary key
CAT-DIMENSION, SEQUENCE-NBR
Fields
5
Updated by
1 program
Referenced by
2 programs

ACIACATMBR is a Lawson Activity Management table (prefix CMY); no description in the lawson data dictionary. It is indexed by CAT-DIMENSION, SEQUENCE-NBR (CMYSET1); alternate indexes: CMYSET2 and CMYSET3. It is updated by ACDM.7 and referenced by ACBC.1 and ACDL.1. The table has 5 fields, 3 indexes and 0 documented relations.

About ACIACATMBR

No description in the Lawson data dictionary.

Fields (5)

Column = COBOL field name without the CMY- 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
#CMY-CAT-DIMENSION PK
CAT_DIMENSION		Alpha 50 (Lower Case)The Organization Dimension Name field contains the user-defined name for the Organization dimension. This name can contain up to 30 characters of any kind.ACDM.7
#CMY-FR-ACCT-CAT SET3
FR_ACCT_CAT		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 thruACDM.7
#CMY-TH-ACCT-CAT SET3
TH_ACCT_CAT		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 thruACDM.7
#CMY-SELECT-OMIT
SELECT_OMIT		Alpha 1—
  • I Include
  • E Exclude
ACDM.7
#CMY-SEQUENCE-NBR PK
SEQUENCE_NBR		Numeric 4The user-assigned sequence number to keep the records unique and to determine order.ACDM.7

Indexes (3)

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
CMYSET1
  1. CAT-DIMENSION
  2. SEQUENCE-NBR
PrimaryACBC.1, ACDL.1, ACDM.3, ACDM.7
CMYSET2
  1. CAT-DIMENSION
  2. SEQUENCE-NBR ↓
ACDM.7
CMYSET3
  1. CAT-DIMENSION
  2. FR-ACCT-CAT
  3. TH-ACCT-CAT
  4. SEQUENCE-NBR
KeyChangeACDM.7

Programs

Updated by (1)

Referenced by (2)