ACMNTSCHX

REFERENCED BY
BR252


UPDATED BY
BR02.3 BR120 BR121 BR122 BR123 BR140
BR151 BR152 BR154 BR156 BR157 BR20.1
BR20.2 BR20.3 BR20.4 BR20.5 BR420 BR51.1
BR52.1 BR52.3 BR52.7 BR521 BRIP.1

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 11:10:57 2016

Home
Contact Us



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