|
ACCNTRCMTX FILE
REFERENCED BY
AC09.1 BR252 BR251
UPDATED BY
BR31.1 BR31.2 BR31.3 BR31.4 BR570 BR52.1
BR52.2 BR51.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CXM-CONTRACT Alpha 15 BR31.1 BR31.2
Element: Contract Activity Management contract. BR31.3 BR31.4
BR570
CXM-MAINT-SCHEDULE Alpha 15 BR31.1 BR31.2
Element: Maint Schedule BR31.3 BR31.4
BR570
CXM-OBJ-ID Numeric 12 BR31.1 BR31.2
Element: Obj Id This is the object identifier. It is BR31.3 BR31.4
used to relate commitments or posted BR570
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.
CXM-PRODUCT Alpha 15 BR31.1 BR31.2
Element: Product BR31.3 BR31.4
BR570
CXM-PROD-VERSION Alpha 10 BR31.1 BR31.2
Element: Prod Version BR31.3 BR31.4
BR570
CXM-COMMENT-TYPE Alpha 2 BR31.1 BR31.2
Element: Comment Type BR31.3 BR31.4
BR570
CXM-SEQ-NBR Numeric 6 BR31.1 BR31.2
Element: Seq Number A unique number assigned to each BR31.3 BR31.4
transaction to be interfaced into the BR570
Lawson system.
CXM-CMT-TEXT Alpha 60 (Lower Case) BR31.1 BR31.2
Element: Cmt Text The text associated with the sequence BR31.3 BR31.4
number. BR570
CXM-DATE Numeric 8 (yyyymmdd) BR31.1 BR31.2
Element: Date This field displays the system date BR31.3 BR31.4
when this was created. BR570
CXM-OPERATOR Alpha 10 BR31.1 BR31.2
Element: Operator This field is used to store the login BR31.3 BR31.4
id of the person who entered the record. BR570
CXM-DATE-STAMP Numeric 8 (yyyymmdd) BR31.1 BR31.2
Element: Date Stamp This field contains the server date BR31.3 BR31.4
(month, date, and year) of the last BR570
change to this record.
CXM-TIME-STAMP Numeric 6 (hhmmss) BR31.1 BR31.2
Element: Time Stamp Contains the server time (hour, minute, BR31.3 BR31.4
and second) when the record was last BR570
changed.
ACCNTRCMTX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CXMSET1 CONTRACT AC09.1 BR252
MAINT-SCHEDULE BR31.1 BR31.2
OBJ-ID BR31.3 BR31.4
COMMENT-TYPE BR52.1 BR52.2
SEQ-NBR BR570
CXMSET2 CONTRACT KeyChange BR251 BR31.1
MAINT-SCHEDULE BR31.2 BR31.3
PRODUCT BR31.4
PROD-VERSION
OBJ-ID
COMMENT-TYPE
DATE*
SEQ-NBR
CXMSET3 CONTRACT KeyChange BR252 BR51.1
MAINT-SCHEDULE BR51.2
PRODUCT
PROD-VERSION
OBJ-ID
COMMENT-TYPE
SEQ-NBR
CXMSET4 CONTRACT KeyChange BR31.1 BR31.2
MAINT-SCHEDULE BR31.3 BR31.4
OBJ-ID
SEQ-NBR*
COMMENT-TYPE*
ACCNTRCMTX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
And CXM-PROD-VERSION = Spaces
And CXM-MAINT-SCHEDULE != Spaces )
CXM-CONTRACT -> MSE-CONTRACT
CXM-MAINT-SCHEDULE -> MSE-MAINT-SCHEDULE
Acmntsch ACMNTSCH Required
When 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
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
And CXM-PRODUCT = Spaces
And CXM-PROD-VERSION = Spaces )
CXM-CONTRACT -> AHR-CONTRACT
|