ACMNTSCHX

Activity Maintenance Sched Dtl
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 BR252 BR420 BR521

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MSD-CONTRACT
Element: Contract		Alpha 15
Activity Management contract.
BR51.1 BR52.1
BR52.3 BRIP.1
MSD-MAINT-SCHEDULE
Element: Maint Schedule		Alpha 15
BR51.1 BR52.1
BR52.3 BRIP.1
MSD-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.
BR51.1 BR52.1
BR52.3 BRIP.1
MSD-PRODUCT
Element: Product		Alpha 15
BR51.1 BR52.1
BR52.3 BRIP.1
MSD-PROD-VERSION
Element: Prod Version		Alpha 10
BR51.1 BR52.1
BR52.3 BRIP.1
MSD-TRAN-DATE
Element: Tran Date		Numeric 8 (yyyymmdd)
BR51.1 BR52.1
BR52.3 BRIP.1
MSD-GLT-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.
BR154 BR51.1
BR52.1 BRIP.1
MSD-ATN-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.
BR154 BR51.1
BR52.1 BRIP.1
MSD-REVENUE-AMT
Element: Intl Amt		Signed 18.2
BR51.1 BR52.1
BR52.3 BRIP.1
MSD-STATUS
Element: Status		Numeric 1
This field displays the status of the transaction.
1 = To Process
2 = Processed
3 = Hold
BR154 BR51.1
BR52.1 BR52.3
BRIP.1
MSD-SITE-LOCATION
Element: Site Location		Numeric 2
BR51.1 BR52.1
BR52.3 BRIP.1


ACMNTSCHX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MSDSET1 CONTRACT
MAINT-SCHEDULE
OBJ-ID
TRAN-DATE
BR02.3 BR120
BR121 BR122
BR123 BR140
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
ATN-OBJ-ID
CONTRACT
MAINT-SCHEDULE
PRODUCT
PROD-VERSION
OBJ-ID
TRAN-DATE
KeyChange
MSDSET3 CONTRACT
MAINT-SCHEDULE
PRODUCT
PROD-VERSION
OBJ-ID
TRAN-DATE
KeyChange
BR154 BR52.3


ACMNTSCHX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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

File created: Thu Jun 09 02:11:08 2016

Home
Contact Us



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