ACCNTRCMTX

REFERENCED BY
AC09.1


UPDATED BY
BR251 BR252 BR31.1 BR31.2 BR31.3 BR31.4
BR51.1 BR51.2 BR52.1 BR52.2 BR570

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CXM-CONTRACT
Element: Contract		Alpha 15
Activity Management contract.
BR31.1 BR31.2
BR31.3 BR31.4
BR570
CXM-MAINT-SCHEDULE
Element: Maint Schedule		Alpha 15
BR31.1 BR31.2
BR31.3 BR31.4
BR570
CXM-OBJ-ID
Element: Obj Id		Numeric 12
This 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
Element: Product		Alpha 15
BR31.1 BR31.2
BR31.3 BR31.4
BR570
CXM-PROD-VERSION
Element: Prod Version		Alpha 10
BR31.1 BR31.2
BR31.3 BR31.4
BR570
CXM-COMMENT-TYPE
Element: Comment Type		Alpha 2
BR31.1 BR31.2
BR31.3 BR31.4
BR570
CXM-SEQ-NBR
Element: Seq Nbr		Numeric 4
A 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
Element: Cmt Text		Alpha 60 (Lower Case)
The text associated with the sequence number.
BR31.1 BR31.2
BR31.3 BR31.4
BR570
CXM-DATE
Element: 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
Element: Operator		Alpha 10
This 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
Element: 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
Element: 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


ACCNTRCMTX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CXMSET1 CONTRACT
MAINT-SCHEDULE
OBJ-ID
COMMENT-TYPE
SEQ-NBR
AC09.1 BR252
BR31.1 BR31.2
BR31.3 BR31.4
BR52.1 BR52.2
BR570
CXMSET2 CONTRACT
MAINT-SCHEDULE
PRODUCT
PROD-VERSION
OBJ-ID
COMMENT-TYPE
DATE*
SEQ-NBR
KeyChange
BR251 BR31.1
BR31.2 BR31.3
BR31.4
CXMSET3 CONTRACT
MAINT-SCHEDULE
PRODUCT
PROD-VERSION
OBJ-ID
COMMENT-TYPE
SEQ-NBR
KeyChange
BR252 BR51.1
BR51.2
CXMSET4 CONTRACT
MAINT-SCHEDULE
OBJ-ID
SEQ-NBR*
COMMENT-TYPE*
KeyChange
BR31.1 BR31.2
BR31.3 BR31.4


ACCNTRCMTX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Accmttype ACCMTTYPE Required
CXM-COMMENT-TYPE->CMN-COMMENT-TYPE
Accntract ACCNTRACT Required
CXM-CONTRACT->CNT-CONTRACT
Acmnthdr ACMNTHDR Not Required
Valid When (CXM-PRODUCT =Spaces
AndCXM-PROD-VERSION =Spaces
AndCXM-MAINT-SCHEDULE !=Spaces )
CXM-CONTRACT->MSE-CONTRACT
CXM-MAINT-SCHEDULE->MSE-MAINT-SCHEDULE
Acmntsch ACMNTSCH Required
When CXM-MAINT-SCHEDULE !=Spaces
AndCXM-PRODUCT !=Spaces
AndCXM-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
Acproddtl ACPRODDTL Required
When CXM-MAINT-SCHEDULE =Spaces
CXM-CONTRACT->AHD-CONTRACT
CXM-PRODUCT->AHD-PRODUCT
CXM-PROD-VERSION->AHD-PROD-VERSION
CXM-OBJ-ID->AHD-OBJ-ID
Acprodhdr ACPRODHDR Not Required
Valid When (CXM-MAINT-SCHEDULE =Spaces
AndCXM-PRODUCT =Spaces
AndCXM-PROD-VERSION =Spaces )
CXM-CONTRACT->AHR-CONTRACT

File created: Thu Jun 09 11:10:51 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.