|
|
ACCNTRCMTX FILE
The ACCNTRCMTX file stores comments for a contract at both the product header
and product detail levels. The data in this file is primarily updated by
Contract Comments (BR31.1) and Product Comments (BR31.2). The ACCNTRCMTX file
has relationships with the ACPRODHDR, ACPRODDTL, ACCNTRACT, ACMNTHDR,
ACMNTSCH, ACCNTRCMT, and ACCMTTYPE files.
REFERENCED BY
AC09.1 BR252 BR251
UPDATED BY
BR31.1 BR31.2 BR31.3 BR31.4 BR52.1 BR52.2
BR51.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CXM-CONTRACT Alpha 10 BR31.1 BR31.2
Element: Contract BR31.3 BR31.4
CXM-MAINT-SCHEDULE Alpha 15 BR31.1 BR31.2
Element: Maint Schedule BR31.3 BR31.4
CXM-OBJ-ID Numeric 12 BR31.1 BR31.2
Object This is the object identifier. It is BR31.3 BR31.4
Identification 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.
CXM-PRODUCT Alpha 15 BR31.1 BR31.2
Element: Product BR31.3 BR31.4
CXM-PROD-VERSION Alpha 10 BR31.1 BR31.2
Element: Prod Version BR31.3 BR31.4
CXM-COMMENT-TYPE Alpha 2 BR31.1 BR31.2
Element: Comment Type BR31.3 BR31.4
CXM-SEQ-NBR Numeric 4 BR31.1 BR31.2
Element: Sequence NumbeAn automatically assigned sequence BR31.3 BR31.4
number.
CXM-CMT-TEXT Alpha 60 (Lower Case) BR31.1 BR31.2
Element: Comment Text The text associated with the sequence BR31.3 BR31.4
number.
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.
CXM-OPERATOR Alpha 10 BR31.1 BR31.2
Element: Operator Code This field is used to store the login BR31.3 BR31.4
id of the person who entered the record.
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
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
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
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 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
|
