|
|
ACMNTSCHX FILE
Maintenance Schedule Detail
The ACMNTSCHX file stores detail distributions for revenue recognition
processes for each product in a maintenance schedule. The Maintenance Revenue
Calculation (BR154) program processes revenue type records in this file to
amortize the maintenance amont over the maintenance term. The records in this
file are primarily updated by Product Maintenance Revenue Schedule (BR52.3).
The ACMNTSCHX file has relationships with the ACMNTSCH, ACCNTRACT, ACMNTHDR,
ACPRODDTL, ACPRODUSER, ACTRANS and GLTRANS files.
REFERENCED BY
BR252
UPDATED BY
BR154 BR51.1 BR52.1 BR52.3 BRPI.1 BR152
BR156 BR157
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MSD-CONTRACT Alpha 10 BR51.1 BR52.1
Element: Contract BR52.3 BRPI.1
MSD-MAINT-SCHEDULE Alpha 15 BR51.1 BR52.1
Element: Maint Schedule BR52.3 BRPI.1
MSD-OBJ-ID Numeric 12 BR51.1 BR52.1
Object This is the object identifier. It is BR52.3 BRPI.1
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.
MSD-PRODUCT Alpha 15 BR51.1 BR52.1
Element: Product BR52.3 BRPI.1
MSD-PROD-VERSION Alpha 10 BR51.1 BR52.1
Element: Prod Version BR52.3 BRPI.1
MSD-TRAN-DATE Numeric 8 (yyyymmdd) BR51.1 BR52.1
Element: Transaction Date BR52.3 BRPI.1
MSD-GLT-OBJ-ID Numeric 12 BR154 BR51.1
Object BR52.1 BRPI.1
Identification
MSD-ATN-OBJ-ID Numeric 12 BR154 BR51.1
Object BR52.1 BRPI.1
Identification
MSD-REVENUE-AMT Signed 15.2 BR51.1 BR52.1
Element: Adj Amt BR52.3 BRPI.1
MSD-STATUS Numeric 1 BR154 BR51.1
Element: Status This field displays the status of the BR52.1 BR52.3
transaction. BRPI.1
1 = To Process
2 = Processed
3 = Hold
MSD-SITE-LOCATION Numeric 2 BR51.1 BR52.1
Element: Site Location BR52.3 BRPI.1
ACMNTSCHX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MSDSET1 CONTRACT BR152 BR156
MAINT-SCHEDULE BR157 BR252
OBJ-ID BR51.1 BR52.1
TRAN-DATE BR52.3 BR52.7
BRPI.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
|
