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.

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
PRODUCT		Alpha 15—BR31.1, BR31.2, BR31.3, BR31.4, BR570
CXM-PROD-VERSION
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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CXMSET1CONTRACT, MAINT-SCHEDULE, OBJ-ID, COMMENT-TYPE, SEQ-NBRPrimaryAC09.1, BR252, BR31.1, BR31.2, BR31.3, BR31.4, BR52.1, BR52.2 +1 more
CXMSET2CONTRACT, MAINT-SCHEDULE, PRODUCT, PROD-VERSION, OBJ-ID, COMMENT-TYPE, DATE*, SEQ-NBRKeyChangeBR251, BR31.1, BR31.2, BR31.3, BR31.4
CXMSET3CONTRACT, MAINT-SCHEDULE, PRODUCT, PROD-VERSION, OBJ-ID, COMMENT-TYPE, SEQ-NBRKeyChangeBR252, BR51.1, BR51.2
CXMSET4CONTRACT, MAINT-SCHEDULE, OBJ-ID, SEQ-NBR*, COMMENT-TYPE*KeyChangeBR31.1, BR31.2, BR31.3, BR31.4

Relations

One to one (6) — lookups and parents

RelationTableRulesConditionField map
AccmttypeACCMTTYPERequiredCXM-COMMENT-TYPE → CMN-COMMENT-TYPE
AccntractACCNTRACTRequiredCXM-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 != SpacesCXM-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 = SpacesCXM-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)