ACCNTRCMTX – No description in the Lawson data dictionary

System
AC Billing Revenue (BR)
Prefix
CXM
Primary key
CONTRACT, MAINT-SCHEDULE, OBJ-ID, COMMENT-TYPE, SEQ-NBR
Fields
12
Updated by
8 programs
Referenced by
3 programs

ACCNTRCMTX is a Lawson AC Billing Revenue table (prefix CXM); no description in the lawson data dictionary. It is indexed by CONTRACT, MAINT-SCHEDULE, OBJ-ID, COMMENT-TYPE, SEQ-NBR (CXMSET1); alternate indexes: CXMSET2, CXMSET3 and CXMSET4. It is related 1:1 to ACCMTTYPE, ACCNTRACT, ACMNTHDR, ACMNTSCH, ACPRODDTL and ACPRODHDR. It is updated by BR31.1, BR31.2, BR31.3, BR31.4, BR51.1, BR52.1, BR52.2 and BR570 and referenced by AC09.1, BR251 and BR252. The table has 12 fields, 4 indexes and 6 documented relations.

About ACCNTRCMTX

No description in the Lawson data dictionary.

Fields (12)

Column = COBOL field name without the CXM- 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
#CXM-CONTRACT PK
CONTRACT		Alpha 15Activity Management contract.BR31.1, BR31.2, BR31.3, BR31.4, BR570
#CXM-MAINT-SCHEDULE PK
MAINT_SCHEDULE		Alpha 15—BR31.1, BR31.2, BR31.3, BR31.4, BR570
#CXM-OBJ-ID PK
OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.BR31.1, BR31.2, BR31.3, BR31.4, BR570
#CXM-PRODUCT SET2 SET3
PRODUCT		Alpha 15—BR31.1, BR31.2, BR31.3, BR31.4, BR570
#CXM-PROD-VERSION SET2 SET3
PROD_VERSION		Alpha 10—BR31.1, BR31.2, BR31.3, BR31.4, BR570
#CXM-COMMENT-TYPE PK
COMMENT_TYPE		Alpha 2—BR31.1, BR31.2, BR31.3, BR31.4, BR570
#CXM-SEQ-NBR PK
SEQ_NBR		Numeric 4A unique number assigned to each transaction to be interfaced into the Lawson system.BR31.1, BR31.2, BR31.3, BR31.4, BR570
#CXM-CMT-TEXT
CMT_TEXT		Alpha 60 (Lower Case)The text associated with the sequence number.BR31.1, BR31.2, BR31.3, BR31.4, BR570
#CXM-DATE SET2
DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.BR31.1, BR31.2, BR31.3, BR31.4, BR570
#CXM-OPERATOR
OPERATOR		Alpha 10This field is used to store the login id of the person who entered the record.BR31.1, BR31.2, BR31.3, BR31.4, BR570
#CXM-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.BR31.1, BR31.2, BR31.3, BR31.4, BR570
#CXM-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.BR31.1, BR31.2, BR31.3, BR31.4, BR570

Indexes (4)

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
CXMSET1
  1. CONTRACT
  2. MAINT-SCHEDULE
  3. OBJ-ID
  4. COMMENT-TYPE
  5. SEQ-NBR
PrimaryAC09.1, BR252, BR31.1, BR31.2, BR31.3, BR31.4, BR52.1, BR52.2 +1 more
CXMSET2
  1. CONTRACT
  2. MAINT-SCHEDULE
  3. PRODUCT
  4. PROD-VERSION
  5. OBJ-ID
  6. COMMENT-TYPE
  7. DATE ↓
  8. SEQ-NBR
KeyChangeBR251, BR31.1, BR31.2, BR31.3, BR31.4
CXMSET3
  1. CONTRACT
  2. MAINT-SCHEDULE
  3. PRODUCT
  4. PROD-VERSION
  5. OBJ-ID
  6. COMMENT-TYPE
  7. SEQ-NBR
KeyChangeBR252, BR51.1, BR51.2
CXMSET4
  1. CONTRACT
  2. MAINT-SCHEDULE
  3. OBJ-ID
  4. SEQ-NBR ↓
  5. COMMENT-TYPE ↓
KeyChangeBR31.1, BR31.2, BR31.3, BR31.4

Relations

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

One to one (6) — lookups and parents

RelationTableRulesConditionField map
AccmttypeACCMTTYPERequired
CXM-COMMENT-TYPE→CMN-COMMENT-TYPE
AccntractACCNTRACTRequired
CXM-CONTRACT→CNT-CONTRACT
AcmnthdrACMNTHDRNot RequiredValid When (CXM-PRODUCT = Spaces And CXM-PROD-VERSION = Spaces And CXM-MAINT-SCHEDULE != Spaces)
CXM-CONTRACT→MSE-CONTRACT
CXM-MAINT-SCHEDULE→MSE-MAINT-SCHEDULE
AcmntschACMNTSCHRequiredWhen CXM-MAINT-SCHEDULE != Spaces And CXM-PRODUCT != Spaces And CXM-PROD-VERSION != Spaces
CXM-CONTRACT→MSC-CONTRACT
CXM-MAINT-SCHEDULE→MSC-MAINT-SCHEDULE
CXM-PRODUCT→MSC-PRODUCT
CXM-PROD-VERSION→MSC-PROD-VERSION
CXM-OBJ-ID→MSC-OBJ-ID
AcproddtlACPRODDTLRequiredWhen CXM-MAINT-SCHEDULE = Spaces
CXM-CONTRACT→AHD-CONTRACT
CXM-PRODUCT→AHD-PRODUCT
CXM-PROD-VERSION→AHD-PROD-VERSION
CXM-OBJ-ID→AHD-OBJ-ID
AcprodhdrACPRODHDRNot RequiredValid When (CXM-MAINT-SCHEDULE = Spaces And CXM-PRODUCT = Spaces And CXM-PROD-VERSION = Spaces)
CXM-CONTRACT→AHR-CONTRACT

Programs

Updated by (8)

Referenced by (3)