ACMNTSCHX FILE
REFERENCED BY
BR252
UPDATED BY
BR154 BR51.1 BR52.1 BR52.3 BRIP.1 BR02.3
BR120 BR121 BR122 BR123 BR140 BR151
BR152 BR156 BR157 BR20.1 BR20.2 BR20.3
BR20.4 BR20.5 BR420 BR521
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MSD-CONTRACT Alpha 15 BR51.1 BR52.1
Element: Contract Activity Management contract. BR52.3 BRIP.1
MSD-MAINT-SCHEDULE Alpha 15 BR51.1 BR52.1
Element: Maint Schedule BR52.3 BRIP.1
MSD-OBJ-ID Numeric 12 BR51.1 BR52.1
Element: Obj Id This is the object identifier. It is BR52.3 BRIP.1
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.
MSD-PRODUCT Alpha 15 BR51.1 BR52.1
Element: Product BR52.3 BRIP.1
MSD-PROD-VERSION Alpha 10 BR51.1 BR52.1
Element: Prod Version BR52.3 BRIP.1
MSD-TRAN-DATE Numeric 8 (yyyymmdd) BR51.1 BR52.1
Element: Tran Date BR52.3 BRIP.1
MSD-GLT-OBJ-ID Numeric 12 BR154 BR51.1
Element: Obj Id This is the object identifier. It is BR52.1 BRIP.1
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.
MSD-ATN-OBJ-ID Numeric 12 BR154 BR51.1
Element: Obj Id This is the object identifier. It is BR52.1 BRIP.1
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.
MSD-REVENUE-AMT Signed 18.2 BR51.1 BR52.1
Element: Intl Amt BR52.3 BRIP.1
MSD-STATUS Numeric 1 BR154 BR51.1
Element: Status This field displays the status of the BR52.1 BR52.3
transaction. BRIP.1
1 = To Process
2 = Processed
3 = Hold
MSD-SITE-LOCATION Numeric 2 BR51.1 BR52.1
Element: Site Location BR52.3 BRIP.1
ACMNTSCHX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MSDSET1 CONTRACT BR02.3 BR120
MAINT-SCHEDULE BR121 BR122
OBJ-ID BR123 BR140
TRAN-DATE BR151 BR152
BR156 BR157
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR252
BR420 BR51.1
BR52.1 BR52.3
BR52.7 BR521
BRIP.1
MSDSET2 GLT-OBJ-ID KeyChange
ATN-OBJ-ID
CONTRACT
MAINT-SCHEDULE
PRODUCT
PROD-VERSION
OBJ-ID
TRAN-DATE
MSDSET3 CONTRACT KeyChange BR154 BR52.3
MAINT-SCHEDULE
PRODUCT
PROD-VERSION
OBJ-ID
TRAN-DATE
ACMNTSCHX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accntract ACCNTRACT Required
MSD-CONTRACT -> CNT-CONTRACT
Acmnthdr ACMNTHDR Required
MSD-CONTRACT -> MSE-CONTRACT
MSD-MAINT-SCHEDULE -> MSE-MAINT-SCHEDULE
Acmntsch ACMNTSCH Required
MSD-CONTRACT -> MSC-CONTRACT
MSD-MAINT-SCHEDULE -> MSC-MAINT-SCHEDULE
MSD-PRODUCT -> MSC-PRODUCT
MSD-PROD-VERSION -> MSC-PROD-VERSION
MSD-OBJ-ID -> MSC-OBJ-ID
Acproddtl ACPRODDTL Required
MSD-CONTRACT -> AHD-CONTRACT
MSD-PRODUCT -> AHD-PRODUCT
MSD-PROD-VERSION -> AHD-PROD-VERSION
MSD-OBJ-ID -> AHD-OBJ-ID
Actrans ACTRANS Not Required
MSD-ATN-OBJ-ID -> ATN-OBJ-ID
Gltrans GLTRANS Not Required
MSD-GLT-OBJ-ID -> GLT-OBJ-ID
ACMNTSCHX FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acproduser ACPRODUSER
MSE-PRODUCT-LIST -> BRU-PRODUCT-LIST
MSD-PRODUCT -> BRU-PRODUCT
MSD-PROD-VERSION -> BRU-PROD-VERSION
MSC-EFFECTIVE-DT -> BRU-EFFECTIVE-DT
BRU-RECORD-TYPE
BRU-MAX-USERS
|