ACCOMITDTL – No description in the Lawson data dictionary

System
Activity Management (AC)
Prefix
ECD
Primary key
MAINT-DATE, MAINT-TIME, ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, FISCAL-YEAR, PERIOD, SYSTEM, COMPANY, CURRENCY-CODE, ATN-OBJ-ID
Fields
31
Updated by
1 program
Referenced by
3 programs

ACCOMITDTL is a Lawson Activity Management table (prefix ECD); 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, ATN-OBJ-ID (ECDSET1). It is related 1:1 to ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACCOMITBAL, APCOMPANY, COLINE, COMISC and 9 more and 1:M to AMTRANS, APAPDHIST, APDISTRIB, CBDISTRIB, EEDISTRIB, MMDIST, POVACOMMIT, POVAGRMTHD and 1 more. It is updated by AC147 and referenced by AC247, AC47.1 and AC47.2. The table has 31 fields, 1 index and 33 documented relations.

About ACCOMITDTL

No description in the Lawson data dictionary.

Fields (31)

Column = COBOL field name without the ECD- 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
#ECD-ACTIVITY-GRP PK
ACTIVITY_GRP		Alpha 15—AC147
#ECD-ACTIVITY PK
ACTIVITY		Alpha 15—AC147
#ECD-ACCT-CATEGORY PK
ACCT_CATEGORY		Alpha 5—AC147
#ECD-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4—AC147, AC247
#ECD-PERIOD PK
PERIOD		Numeric 2—AC147, AC247
#ECD-SYSTEM PK
SYSTEM		Alpha 2—AC147
#ECD-COMPANY PK
COMPANY		Numeric 4—AC147
#ECD-CURRENCY-CODE PK
CURRENCY_CODE		Alpha 5—AC147
#ECD-ATN-OBJ-ID PK
ATN_OBJ_ID		Numeric 12—AC147
#ECD-ACCT-UNIT
ACCT_UNIT		Alpha 15—AC147
#ECD-ACCOUNT
ACCOUNT		Numeric 6—AC147
#ECD-SUB-ACCOUNT
SUB_ACCOUNT		Numeric 4—AC147
#ECD-TRAN-AMOUNT
TRAN_AMOUNT		Signed 18.2—AC147
#ECD-UNIT
UNIT		Signed 15.2—AC147
#ECD-BURDEN-AMT
BURDEN_AMT		Signed 18.2—AC147
#ECD-ACCT-CAT-TYPE
ACCT_CAT_TYPE		Derived——
#ECD-INVOICE
INVOICE		Alpha 22—AC147
#ECD-ITEM
ITEM		Alpha 32—AC147
#ECD-RESOURCE-CODE
RESOURCE_CODE		Alpha 10—AC147
#ECD-RESOURCE-TYPE
RESOURCE_TYPE		Alpha 1—AC147
#ECD-RESOURCE-DESC
RESOURCE_DESC		Alpha 30 (Lower Case)—AC147
#ECD-GLT-OBJ-ID
GLT_OBJ_ID		Numeric 12—AC147
#ECD-RESOURCE-COMP
RESOURCE_COMP		Numeric 4—AC147
#ECD-TRANS-DATE
TRANS_DATE		Numeric 8 (yyyymmdd)—AC147
#ECD-END-DATE
END_DATE		Numeric 8 (yyyymmdd)—AC147
#ECD-USER-ID
USER_ID		Alpha 10 (Lower Case)—AC147
#ECD-SOURCE-CODE
SOURCE_CODE		Alpha 2—AC147
#ECD-GMA-OBJ-ID
GMA_OBJ_ID		Numeric 12—AC147
#ECD-GM-SALARY-PCT
GM_SALARY_PCT		Signed 13.6—AC147
#ECD-MAINT-DATE PK
MAINT_DATE		Numeric 8 (yyyymmdd)—AC147
#ECD-MAINT-TIME PK
MAINT_TIME		Numeric 6 (hhmmss)—AC147

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
ECDSET1
  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
  11. ATN-OBJ-ID
PrimaryAC247, AC47.1, AC47.2

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACCTCATACACCTCATXACACTGRPACACTIVITYACCOMITBALAPCOMPANYCOLINECOMISCGLTRANSGMLABDISTXICCOMPANYITEMMASTOEINVCLINEOEINVCMISC+3 more belowAMTRANSAPAPDHISTAPDISTRIBCBDISTRIBEEDISTRIBMMDISTPOVACOMMITPOVAGRMTHDTIMERECORDACCOMITDTL

One to one (21) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATRequired
ECD-ACCT-CATEGORY→-ACCT-CATEGORY
AcacctcatxACACCTCATXRequired
ECD-ACTIVITY-GRP→AXX-ACTIVITY-GRP
ECD-ACTIVITY→AXX-ACTIVITY
ECD-ACCT-CATEGORY→AXX-ACCT-CATEGORY
AcactgrpACACTGRPRequired
ECD-ACTIVITY-GRP→AGP-ACTIVITY-GRP
AcactivityACACTIVITYRequired
ECD-ACTIVITY→ACV-ACTIVITY
AccomitbalACCOMITBALRequired
ECD-MAINT-DATE→ECB-MAINT-DATE
ECD-MAINT-TIME→ECB-MAINT-TIME
ECD-ACTIVITY-GRP→ECB-ACTIVITY-GRP
ECD-ACTIVITY→ECB-ACTIVITY
ECD-ACCT-CATEGORY→ECB-ACCT-CATEGORY
ECD-FISCAL-YEAR→ECB-FISCAL-YEAR
ECD-PERIOD→ECB-PERIOD
ECD-SYSTEM→ECB-SYSTEM
ECD-COMPANY→ECB-COMPANY
ECD-CURRENCY-CODE→ECB-CURRENCY-CODE
ApcompanyAPCOMPANYRequired
ECD-COMPANY→CPY-COMPANY
ColineCOLINERequired
ECD-ATN-OBJ-ID→COL-ATN-OBJ-ID
Coline CostCOLINERequired
ECD-ATN-OBJ-ID→COL-ATN-OBJ-ID-C
ComiscCOMISCRequired
ECD-ATN-OBJ-ID→CMC-ATN-OBJ-ID
Comisc CosrCOMISCRequired
ECD-ATN-OBJ-ID→CMC-ATN-OBJ-ID-C
GltransGLTRANSRequired
ECD-GLT-OBJ-ID→GLT-OBJ-ID
GmlabdistxGMLABDISTXRequired
ECD-GMA-OBJ-ID→GMA-OBJ-ID
IccompanyICCOMPANYRequired
ECD-COMPANY→ICC-COMPANY
ItemmastITEMMASTRequired
ICC-ITEM-GROUP→ITE-ITEM-GROUP
ECD-ITEM→ITE-ITEM
OeinvclineOEINVCLINERequired
ECD-ATN-OBJ-ID→OIL-ATN-OBJ-ID
Oeinvcline CstOEINVCLINERequired
ECD-ATN-OBJ-ID→OIL-ATN-OBJ-ID-C
OeinvcmiscOEINVCMISCRequired
ECD-ATN-OBJ-ID→OIM-ATN-OBJ-ID
Oeinvcmisc CstOEINVCMISCRequired
ECD-ATN-OBJ-ID→OIM-ATN-OBJ-ID-C
PaencumberPAENCUMBERRequired
ECD-ATN-OBJ-ID→PEN-ATN-OBJ-ID
PovadistPOVADISTRequiredWhen ECD-SYSTEM = "PO"
ECD-ATN-OBJ-ID→PVD-ATN-OBJ-ID
SystemcodeSYSTEMCODERequired
ECD-SYSTEM→SYS-SYSTEM

One to many (12) — child tables

RelationTableRulesConditionField map
AmtransAMTRANS
ECD-ATN-OBJ-ID→AMT-ATN-OBJ-ID
—→AMT-ASSET
—→AMT-SEQ-NUMBER
—→AMT-COMPANY
ApapdhistAPAPDHIST
ECD-ATN-OBJ-ID→AH2-ATN-OBJ-ID
—→AH2-COMPANY
—→AH2-VENDOR
—→AH2-INVOICE
—→AH2-SUFFIX
—→AH2-CANCEL-SEQ
—→AH2-DIST-SEQ-NBR
ApdistribAPDISTRIB
ECD-ATN-OBJ-ID→APD-ATN-OBJ-ID
—→APD-COMPANY
—→APD-VENDOR
—→APD-INVOICE
—→APD-SUFFIX
—→APD-CANCEL-SEQ
—→APD-DIST-SEQ-NBR
CbdistribCBDISTRIB
ECD-ATN-OBJ-ID→CBD-ACT-OBJ-ID
—→CBD-CASH-CODE
—→CBD-BANK-INST-CODE
—→CBD-TRANS-IDENT
—→CBD-DIST-TYPE
—→CBD-SEQ-NBR
EedistribEEDISTRIB
ECD-ATN-OBJ-ID→EED-ACT-OBJ-ID
—→EED-COMPANY
—→EED-VENDOR
—→EED-EXPENSE-NBR
—→EED-SEQ-NBR
IcmmdistMMDISTValid When ECD-SYSTEM = "IC"
ECD-ATN-OBJ-ID→MMD-ATN-OBJ-ID
—→MMD-COMPANY
—→MMD-SYSTEM-CD
—→MMD-LOCATION
—→MMD-DOC-TYPE
—→MMD-DOC-NUMBER
—→MMD-DOC-NBR-NUM
—→MMD-LINE-NBR
—→MMD-COMPONENT-SEQ
—→MMD-LINE-SEQ
MmdistMMDIST
ECD-ATN-OBJ-ID→MMD-ATN-OBJ-ID
—→MMD-COMPANY
—→MMD-SYSTEM-CD
—→MMD-LOCATION
—→MMD-DOC-TYPE
—→MMD-DOC-NUMBER
—→MMD-DOC-NBR-NUM
—→MMD-LINE-NBR
—→MMD-COMPONENT-SEQ
—→MMD-LINE-SEQ
PommdistMMDISTValid When ECD-SYSTEM = "PO"
ECD-ATN-OBJ-ID→MMD-ATN-OBJ-ID
—→MMD-COMPANY
—→MMD-SYSTEM-CD
—→MMD-LOCATION
—→MMD-DOC-TYPE
—→MMD-DOC-NUMBER
—→MMD-DOC-NBR-NUM
—→MMD-LINE-NBR
—→MMD-COMPONENT-SEQ
—→MMD-LINE-SEQ
PovacommitPOVACOMMITValid When ECD-SYSTEM = "PO"
ECD-ATN-OBJ-ID→PVC-ATN-OBJ-ID
—→PVC-PROCURE-GROUP
—→PVC-VEN-AGRMT-REF
—→PVC-LINE-NBR
—→PVC-SYSTEM
—→PVC-LINE-SEQ
—→PVC-COMMIT-DATE
PovagrmthdPOVAGRMTHDValid When ECD-SYSTEM = "PO"
ECD-ATN-OBJ-ID→PVH-ATN-OBJ-ID
—→PVH-PROCURE-GROUP
—→PVH-VEN-AGRMT-REF
RqmmdistMMDISTValid When ECD-SYSTEM = "RQ"
ECD-ATN-OBJ-ID→MMD-ATN-OBJ-ID
—→MMD-COMPANY
—→MMD-SYSTEM-CD
—→MMD-LOCATION
—→MMD-DOC-TYPE
—→MMD-DOC-NUMBER
—→MMD-DOC-NBR-NUM
—→MMD-LINE-NBR
—→MMD-COMPONENT-SEQ
—→MMD-LINE-SEQ
TimerecordTIMERECORD
ECD-COMPANY→TRD-COMPANY
ECD-ATN-OBJ-ID→TRD-ATN-OBJ-ID
—→TRD-TIME-SEQ

Programs

Updated by (1)

Referenced by (3)