Lawson Insight Technical Documentation |
|
ACMNTHDR
ACMNTHDR FILE
The ACMNTHDR file contains the header level information for a maintenance
schedule. Records in this file are maintained primarily on New Maintenance
Schedule (BR52.2). The ACMNTHDR file has relationships with the following
files: ACMNTSCH, ACMNTSCHX, ACPRODLST, ACPRODHDR, ACCNTRACT, ACCNTRCMT,
ACCNTRCMTX, ACACTIVITY, ACSRVCLOC.
REFERENCED BY
BR124 BR15.1 BR152 BR154 BR156 BR157
BR252 BR31.3 BR31.4 BR50.3 BRPI.1
UPDATED BY
BR155 BR51.1 BR52.2 BR52.4 BR52.5
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MSE-CONTRACT Alpha 10 BR155 BR51.1
Element: Contract BR52.2 BR52.4
BR52.5
MSE-MAINT-SCHEDULE Alpha 15 BR155 BR51.1
Element: Maint Schedule BR52.2 BR52.4
BR52.5
MSE-DESCRIPTION Alpha 30 (Lower Case) BR155 BR51.1
Element: Description This field displays the description. BR52.2 BR52.4
BR52.5
MSE-BEGIN-DATE Numeric 8 (yyyymmdd) BR155 BR51.1
Element: Begin Date The beginning date in a range of dates. BR52.2 BR52.4
BR52.5
MSE-END-DATE Numeric 8 (yyyymmdd) BR155 BR51.1
Element: Ending Date The ending date in a range of dates. BR52.2 BR52.4
BR52.5
MSE-STATUS Numeric 1 BR155 BR51.1
Element: Status This field displays the status of the BR52.2 BR52.4
transaction. BR52.5
1 = Free ISP
2 = Billable ISP
3 = Renewal
4 = Cancelled
MSE-PRODUCT-LIST Alpha 10 BR155 BR51.1
Element: Product List BR52.2 BR52.4
BR52.5
MSE-REV-ACTIVITY Alpha 15 BR155 BR51.1
Element: Activity BR52.2 BR52.4
BR52.5
MSE-MAINT-RENEW-DT Numeric 8 (yyyymmdd) BR155 BR51.1
Element: Date BR52.2 BR52.4
BR52.5
MSE-DFLT-COMPANY Numeric 4 BR155 BR51.1
Element: Company BR52.2 BR52.4
BR52.5
MSE-DFLT-ACCT-UNIT Alpha 15 BR155 BR51.1
Element: Accounting Unit BR52.2 BR52.4
BR52.5
MSE-SERVICE-LOC Numeric 4 BR155 BR51.1
Element: Service Loc BR52.2 BR52.4
BR52.5
MSE-CUST-NAME Derived
Element: Cust Name
ACMNTHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MSESET1 CONTRACT BR124 BR15.1
MAINT-SCHEDULE BR152 BR154
BR155 BR156
BR157 BR252
BR31.3 BR31.4
BR50.3 BR51.1
BR52.1 BR52.2
BR52.3 BR52.4
BR52.5 BRPI.1
ACMNTHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Not Required
MSE-REV-ACTIVITY -> ACV-ACTIVITY
Accntract ACCNTRACT Required
MSE-CONTRACT -> CNT-CONTRACT
Accntrpcd ACCNTRPCD Not Required
MSE-CONTRACT -> CNP-CONTRACT
Accustdtl ACCUSTDTL Not Required
CNT-COMPANY -> CMA-COMPANY
CNT-CUSTOMER -> CMA-CUSTOMER
Acprodhdr ACPRODHDR Not Required
MSE-CONTRACT -> AHR-CONTRACT
Acprodlst ACPRODLST Required
MSE-PRODUCT-LIST -> BRP-PRODUCT-LIST
Acsrvcloc ACSRVCLOC Not Required
CNT-COMPANY -> ASV-COMPANY
CNT-CUSTOMER -> ASV-CUSTOMER
MSE-SERVICE-LOC -> ASV-SERVICE-LOC
Arcomp ARCOMP Required
CNT-COMPANY -> ACO-COMPANY
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
CNT-CUSTOMER -> CUD-CUSTOMER
ACMNTHDR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accntrcmtx ACCNTRCMTX
MSE-CONTRACT -> CXM-CONTRACT
MSE-MAINT-SCHEDULE -> CXM-MAINT-SCHEDULE
Spaces -> CXM-PRODUCT
Spaces -> CXM-PROD-VERSION
CXM-OBJ-ID
CXM-COMMENT-TYPE
CXM-DATE
CXM-SEQ-NBR
Acmntsch ACMNTSCH
MSE-CONTRACT -> MSC-CONTRACT
MSE-MAINT-SCHEDULE -> MSC-MAINT-SCHEDULE
MSC-PRODUCT
MSC-PROD-VERSION
MSC-OBJ-ID
Acmntschx ACMNTSCHX
MSE-CONTRACT -> MSD-CONTRACT
MSE-MAINT-SCHEDULE -> MSD-MAINT-SCHEDULE
MSD-PRODUCT
MSD-PROD-VERSION
MSD-OBJ-ID
MSD-TRAN-DATE
|