ACCOMITBAL – No description in the Lawson data dictionary

System
Activity Management (AC)
Prefix
ECB
Primary key
MAINT-DATE, MAINT-TIME, ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, FISCAL-YEAR, PERIOD, SYSTEM, COMPANY, CURRENCY-CODE
Fields
17
Updated by
1 program
Referenced by
1 program

ACCOMITBAL is a Lawson Activity Management table (prefix ECB); no description in the lawson data dictionary. It is indexed by MAINT-DATE, MAINT-TIME, ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, FISCAL-YEAR, PERIOD, SYSTEM, COMPANY, CURRENCY-CODE (ECBSET1). It is related 1:1 to ACACCTCAT, ACACTGRP, ACACTIVITY and SYSTEMCODE and 1:M to ACCOMITDTL. It is updated by AC147 and referenced by AC47.1. The table has 17 fields, 1 index and 5 documented relations.

About ACCOMITBAL

No description in the Lawson data dictionary.

Fields (17)

Column = COBOL field name without the ECB- 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
#ECB-ACTIVITY-GRP PK
ACTIVITY_GRP		Alpha 15—AC147
#ECB-ACTIVITY PK
ACTIVITY		Alpha 15—AC147
#ECB-ACCT-CATEGORY PK
ACCT_CATEGORY		Alpha 5—AC147
#ECB-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4—AC147
#ECB-PERIOD PK
PERIOD		Numeric 2—AC147
#ECB-SYSTEM PK
SYSTEM		Alpha 2—AC147
#ECB-COMPANY PK
COMPANY		Numeric 4—AC147
#ECB-CURRENCY-CODE PK
CURRENCY_CODE		Alpha 5—AC147
#ECB-VAR-LEVELS
VAR_LEVELS		Alpha 30—AC147
#ECB-TRAN-ND
TRAN_ND		Numeric 1—AC147
#ECB-BALANCE-AMOUNT
BALANCE_AMOUNT		Signed 18.2—AC147
#ECB-BALANCE-UNIT
BALANCE_UNIT		Signed 17.2—AC147
#ECB-BURDEN-AMT
BURDEN_AMT		Signed 18.2—AC147
#ECB-MAINT-DATE PK
MAINT_DATE		Numeric 8 (yyyymmdd)—AC147
#ECB-MAINT-TIME PK
MAINT_TIME		Numeric 6 (hhmmss)—AC147
#ECB-SUM-ACCT-CAT
SUM_ACCT_CAT		Alpha 5—AC147
#ECB-ACCT-CAT-TYPE
ACCT_CAT_TYPE		Derived——

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
ECBSET1
  1. MAINT-DATE
  2. MAINT-TIME
  3. ACTIVITY-GRP
  4. ACTIVITY
  5. ACCT-CATEGORY
  6. FISCAL-YEAR
  7. PERIOD
  8. SYSTEM
  9. COMPANY
  10. CURRENCY-CODE
PrimaryAC147, AC47.1

Relations

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

One to one (4) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATRequired
ECB-ACCT-CATEGORY→AAX-ACCT-CATEGORY
AcactgrpACACTGRPRequired
ECB-ACTIVITY-GRP→AGP-ACTIVITY-GRP
AcactivityACACTIVITYRequired
ECB-ACTIVITY→ACV-ACTIVITY
SystemcodeSYSTEMCODERequired
ECB-SYSTEM→SYS-SYSTEM

One to many (1) — child tables

RelationTableRulesConditionField map
AccomitdtlACCOMITDTL
ECB-MAINT-DATE→ECD-MAINT-DATE
ECB-MAINT-TIME→ECD-MAINT-TIME
ECB-ACTIVITY-GRP→ECD-ACTIVITY-GRP
ECB-ACTIVITY→ECD-ACTIVITY
ECB-ACCT-CATEGORY→ECD-ACCT-CATEGORY
ECB-FISCAL-YEAR→ECD-FISCAL-YEAR
ECB-PERIOD→ECD-PERIOD
ECB-SYSTEM→ECD-SYSTEM
ECB-COMPANY→ECD-COMPANY
ECB-CURRENCY-CODE→ECD-CURRENCY-CODE
—→ECD-ATN-OBJ-ID

Programs

Updated by (1)

Referenced by (1)