Lawson Insight Technical Documentation |
|
ACMNTHDR
ACMNTHDR FILE
REFERENCED BY
BR02.3 BR10.9 BR120 BR121 BR122 BR123
BR124 BR140 BR151 BR152 BR154 BR156
BR157 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5
BR252 BR31.3 BR31.4 BR420 BR50.3 BR521
BRIP.1
UPDATED BY
BR155 BR51.1 BR52.2 BR52.4 BR52.5
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MSE-CONTRACT Alpha 15 BR155 BR51.1
Element: Contract Activity Management 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 begin date for this effort period. BR52.2 BR52.4
BR52.5
MSE-END-DATE Numeric 8 (yyyymmdd) BR155 BR51.1
Element: End Date The end date for this effort period. 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 Activities are the processes or BR52.2 BR52.4
procedures that produce work. Cost BR52.5
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
MSE-MAINT-RENEW-DT Numeric 8 (yyyymmdd) BR155 BR51.1
Element: Date This field displays the system date BR52.2 BR52.4
when this was created. BR52.5
MSE-DFLT-COMPANY Numeric 4 BR155 BR51.1
Element: Company Identifies the AP company if the BR52.2 BR52.4
resource type = V. Identifies the HR BR52.5
company if the resource type = E. It is
blank for type A, P or Q resources.
MSE-DFLT-ACCT-UNIT Alpha 15 BR155 BR51.1
Element: Acct Unit The accounting unit is a shorthand BR52.2 BR52.4
notation representing the variable level BR52.5
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.
MSE-SERVICE-LOC Numeric 4 BR155 BR51.1
Element: Service Loc A user defined code identifying a BR52.2 BR52.4
customer's service location. BR52.5
MSE-CUST-NAME Derived
Element: Cust Name
ACMNTHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MSESET1 CONTRACT BR02.3 BR10.9
MAINT-SCHEDULE 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 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 -> 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 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
|