ACMNTHDR

REFERENCED BY
BR124 BRIP.1 BR31.3 BR31.4 BR50.3


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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MSE-CONTRACT
Element: Contract
Alpha 15
Activity Management contract.
BR155 BR51.1
BR52.2 BR52.4
BR52.5
MSE-MAINT-SCHEDULE
Element: Maint Schedule
Alpha 15
BR155 BR51.1
BR52.2 BR52.4
BR52.5
MSE-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
BR155 BR51.1
BR52.2 BR52.4
BR52.5
MSE-BEGIN-DATE
Element: Begin Date
Numeric 8 (yyyymmdd)
The begin date for this effort period.
BR155 BR51.1
BR52.2 BR52.4
BR52.5
MSE-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
The end date for this effort period.
BR155 BR51.1
BR52.2 BR52.4
BR52.5
MSE-STATUS
Element: Status
Numeric 1
This field displays the status of the transaction.
1 = Free ISP
2 = Billable ISP
3 = Renewal
4 = Cancelled
BR155 BR51.1
BR52.2 BR52.4
BR52.5
MSE-PRODUCT-LIST
Element: Product List
Alpha 10
BR155 BR51.1
BR52.2 BR52.4
BR52.5
MSE-REV-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
BR155 BR51.1
BR52.2 BR52.4
BR52.5
MSE-MAINT-RENEW-DT
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
BR155 BR51.1
BR52.2 BR52.4
BR52.5
MSE-DFLT-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
BR155 BR51.1
BR52.2 BR52.4
BR52.5
MSE-DFLT-ACCT-UNIT
Element: Acct Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
BR155 BR51.1
BR52.2 BR52.4
BR52.5
MSE-SERVICE-LOC
Element: Service Loc
Numeric 4
A user defined code identifying a customer's service location.
BR155 BR51.1
BR52.2 BR52.4
BR52.5
MSE-CUST-NAME
Element: Cust Name
Derived


ACMNTHDR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MSESET1 CONTRACT
MAINT-SCHEDULE
...
BR02.3 BR10.9
BR120 BR121
BR122 BR123
BR124 BR140
BR151 BR152
BR154 BR155
BR156 BR157
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR252
BR31.3 BR31.4
BR420 BR50.3
BR51.1 BR52.1
BR52.2 BR52.3
BR52.4 BR52.5


ACMNTHDR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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->CMB-COMPANY
CNT-CUSTOMER->CMB-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
NAME
RELATED 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


File created: Thu Jun 09 11:10:57 2016

Home
Contact Us



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