Lawson Insight Technical Documentation |
|
ACMNTSCH
ACMNTSCH FILE
Maintenance Schedule
The ACMNTSCH file stores maintenance schedule data such as amounts and terms
of each purchased product. Records in this file are updated by Product
Contract (BR51) and Maintenance Schedule (BR52). After a product is added to
this file, detailed revenue processing can be added in the ACMNTSCHX file. The
ACMNTSCH file also has relationships with the following files: ACCNTRCMT,
ACCNTRCMTX, ACCNTRACT, ACGLCODE, ACPRODLSTX, ACPRODHDR, ACMNTHDR, ACPRODDTL,
ACPMHSTHDR, ACPRODUSER, ACREASONCD.
REFERENCED BY
BR124 BR15.1 BR154 BR31.4 BR252
UPDATED BY
BR123 BR152 BR155 BR156 BR157 BR51.1
BR52.1 BR52.4 BR52.5 BRPI.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MSC-CONTRACT Alpha 10 BR155 BR51.1
Element: Contract BR52.1 BR52.4
BR52.5
MSC-MAINT-SCHEDULE Alpha 15 BR155 BR51.1
Element: Maint Schedule BR52.1 BR52.4
BR52.5
MSC-OBJ-ID Numeric 12 BR155 BR51.1
Object This is the object identifier. It is BR52.1 BR52.4
Identification used to relate commitments or posted BR52.5
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.
MSC-PRODUCT Alpha 15 BR155 BR51.1
Element: Product BR52.1 BR52.4
BR52.5
MSC-PROD-VERSION Alpha 10 BR155 BR51.1
Element: Prod Version BR52.1 BR52.4
BR52.5
MSC-BEGIN-DATE Numeric 8 (yyyymmdd) BR155 BR51.1
Element: Begin Date The beginning date in a range of dates. BR52.1 BR52.4
BR52.5
MSC-END-DATE Numeric 8 (yyyymmdd) BR155 BR51.1
Element: Ending Date The ending date in a range of dates. BR52.1 BR52.4
BR52.5
MSC-STATUS Numeric 1 BR123 BR152
Element: Status This field displays the status of the BR156 BR157
transaction. BR51.1 BR52.1
0 = Unreleased BR52.4 BR52.5
1 = Pro Forma BRPI.1
2 = Accepted
3 = Invoiced
4 = Free Maintenance
5 = Invoice Cancelled
6 = Maint Cancelled
MSC-EFFECTIVE-DT Numeric 8 (yyyymmdd) BR155 BR51.1
Element: Effective Date BR52.1 BR52.4
BR52.5
MSC-USERS Numeric 12 BR155 BR51.1
Element: Users BR52.1 BR52.4
BR52.5
MSC-MAINT-PERCENT Signed 7.3 BR155 BR51.1
Element: Percent BR52.1 BR52.4
BR52.5
MSC-LIST-NET-FLAG Alpha 1 BR155 BR51.1
Element: List Net Flag 1 = List BR52.1 BR52.4
2 = Net BR52.5
3 = Open
MSC-PROD-LIST-AMT Signed 15.2 BR155 BR51.1
Element: Adj Amt BR52.1 BR52.4
BR52.5
MSC-PROD-NET-AMT Signed 15.2 BR155 BR51.1
Element: Adj Amt BR52.1 BR52.4
BR52.5
MSC-PROD-MAINT-AMT Signed 15.2 BR155 BR51.1
Element: Adj Amt BR52.1 BR52.4
BR52.5
MSC-INVOICE Alpha 22 BR52.1 BR52.4
Element: Invoice NumberUsed to identify the invoice. BR52.5
MSC-PMH-OBJ-ID Numeric 12
Object
Identification
MSC-BILL-ACCT-CAT Alpha 5 BR155 BR51.1
Element: Account Category BR52.1 BR52.4
BR52.5
MSC-BILL-GL-CD Alpha 4 BR155 BR51.1
Element: Ac Gl Code BR52.1 BR52.4
BR52.5
MSC-BILL-ACCOUNT Numeric 6 BR155 BR51.1
Element: Account BR52.1 BR52.4
BR52.5
MSC-BILL-SUB-ACCT Numeric 4 BR155 BR51.1
Element: Subaccount BR52.1 BR52.4
BR52.5
MSC-UNBL-ACCT-CAT Alpha 5 BR155 BR51.1
Element: Account Category BR52.1 BR52.4
BR52.5
MSC-UNBL-GL-CD Alpha 4 BR155 BR51.1
Element: Ac Gl Code BR52.1 BR52.4
BR52.5
MSC-UNBL-ACCOUNT Numeric 6 BR155 BR51.1
Element: Account BR52.1 BR52.4
BR52.5
MSC-UNBL-SUB-ACCT Numeric 4 BR155 BR51.1
Element: Subaccount BR52.1 BR52.4
BR52.5
MSC-REV-ACCT-CAT Alpha 5 BR155 BR51.1
Element: Account Category BR52.1 BR52.4
BR52.5
MSC-REV-GL-CD Alpha 4 BR155 BR51.1
Element: Ac Gl Code BR52.1 BR52.4
BR52.5
MSC-REV-ACCOUNT Numeric 6 BR155 BR51.1
Element: Account BR52.1 BR52.4
BR52.5
MSC-REV-SUB-ACCT Numeric 4 BR155 BR51.1
Element: Subaccount BR52.1 BR52.4
BR52.5
MSC-OPERATOR Alpha 10 BR155 BR51.1
Element: Operator Code This field is used to store the login BR52.1 BR52.4
id of the person who entered the record. BR52.5
MSC-DATE-STAMP Numeric 8 (yyyymmdd) BR155 BR51.1
Element: Date Stamp This field contains the server date BR52.1 BR52.4
(month, date, and year) of the last BR52.5
change to this record.
MSC-TIME-STAMP Numeric 6 (hhmmss) BR155 BR51.1
Element: Time Stamp Contains the server time (hour, minute, BR52.1 BR52.4
and second) when the record was last BR52.5
changed.
MSC-PROD-USER-AMT Signed 15.2 BR155 BR52.1
Element: Adj Amt BR52.4 BR52.5
MSC-PROD-BASE-AMT Signed 15.2 BR155 BR52.1
Element: Adj Amt BR52.4 BR52.5
MSC-USER-FIELD1 Alpha 15 (Lower Case) BR155 BR51.1
Element: User Defined FThis is the first user definable field. BR52.1 BR52.4
It can be used to capture any data that BR52.5
the user wants. The title of the field
is setup in IC00.
MSC-USER-FIELD2 Alpha 15 (Lower Case) BR155 BR51.1
Element: User Defined FThis is the second user definable BR52.1 BR52.4
field. This field can be used to enter BR52.5
any data that the user wants to capture
for this item. The title of the field
is setup in IC00.
MSC-USER-FIELD3 Alpha 15 (Lower Case) BR155 BR51.1
Element: User Defined Field 3 BR52.1 BR52.4
BR52.5
MSC-PROFORMA-FL Alpha 1 BR152 BR156
Tax Distrib. Flag - Y = Yes BR52.1 BR52.4
Tax Code 1 N = No BR52.5 BRPI.1
MSC-SITE-LOCATION Numeric 2 BR155 BR51.1
Element: Site Location BR52.1 BR52.4
BR52.5
MSC-REASON-CODE Alpha 4 BR155 BR157
Element: Reason Code This field contains the reason code, BR52.1 BR52.4
which indicates the cause for credit BR52.5
memos.
MSC-SUITE Alpha 6 BR155 BR51.1
Element: Prod Suite BR52.1 BR52.4
BR52.5
MSC-ORIG-CONTRACT Alpha 10 BR155 BR51.1
Element: Contract BR52.1 BR52.4
BR52.5
MSC-DELIV-METHOD Alpha 1 BR155 BR51.1
Element: Deliv Method S = Shipped BR52.1 BR52.4
H = Hosted at BR52.5
E = Electronic
L = Loaded
1 = Method 1
2 = Method 2
3 = Method 3
ACMNTSCH FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MSCSET1 CONTRACT BR123 BR124
MAINT-SCHEDULE BR15.1 BR152
OBJ-ID BR154 BR155
BR31.4 BR51.1
BR52.1 BR52.2
BR52.3 BR52.4
BR52.5 BR52.7
BRPI.1
MSCSET2 CONTRACT KeyChange BR124 BR152
MAINT-SCHEDULE BR154 BR156
PRODUCT BR157 BR252
PROD-VERSION BR31.4 BR51.1
OBJ-ID BR52.1
MSCSET3 PMH-OBJ-ID KeyChange
CONTRACT
MAINT-SCHEDULE
PRODUCT
PROD-VERSION
OBJ-ID
ACMNTSCH FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accntract ACCNTRACT Required
MSC-CONTRACT -> CNT-CONTRACT (CNTSET1)
Accntract Orig ACCNTRACT Not Required
MSC-ORIG-CONTRACT -> CNT-CONTRACT
Accntrpcd ACCNTRPCD Not Required
MSC-CONTRACT -> CNP-CONTRACT
Acglcode Bill ACGLCODE Not Required
MSC-BILL-GL-CD -> AGC-AC-GL-CODE
Acglcode Rev ACGLCODE Not Required
MSC-REV-GL-CD -> AGC-AC-GL-CODE
Acglcode Unbl ACGLCODE Not Required
MSC-UNBL-GL-CD -> AGC-AC-GL-CODE
Acmnthdr ACMNTHDR Required
MSC-CONTRACT -> MSE-CONTRACT
MSC-MAINT-SCHEDULE -> MSE-MAINT-SCHEDULE
Acpmhsthdr ACPMHSTHDR Not Required
MSC-PMH-OBJ-ID -> PMH-OBJ-ID
Acproddtl ACPRODDTL Required
MSC-CONTRACT -> AHD-CONTRACT
MSC-PRODUCT -> AHD-PRODUCT
MSC-PROD-VERSION -> AHD-PROD-VERSION
MSC-OBJ-ID -> AHD-OBJ-ID
Acprodhdr ACPRODHDR Not Required
MSC-CONTRACT -> AHR-CONTRACT
Acprodhdr Orig ACPRODHDR Not Required
MSC-ORIG-CONTRACT -> AHR-CONTRACT
Acprodlstx ACPRODLSTX Required
MSE-PRODUCT-LIST -> BRQ-PRODUCT-LIST
MSC-PRODUCT -> BRQ-PRODUCT
MSC-PROD-VERSION -> BRQ-PROD-VERSION
Acreasoncd ACREASONCD Not Required
MSC-REASON-CODE -> CDE-REASON-CODE
ACMNTSCH FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accntrcmtx ACCNTRCMTX
MSC-CONTRACT -> CXM-CONTRACT
MSC-MAINT-SCHEDULE -> CXM-MAINT-SCHEDULE
MSC-PRODUCT -> CXM-PRODUCT
MSC-PROD-VERSION -> CXM-PROD-VERSION
MSC-OBJ-ID -> CXM-OBJ-ID
CXM-COMMENT-TYPE
CXM-DATE
CXM-SEQ-NBR
Acmntschx ACMNTSCHX
MSC-CONTRACT -> MSD-CONTRACT
MSC-MAINT-SCHEDULE -> MSD-MAINT-SCHEDULE
MSC-PRODUCT -> MSD-PRODUCT
MSC-PROD-VERSION -> MSD-PROD-VERSION
MSC-OBJ-ID -> MSD-OBJ-ID
MSD-TRAN-DATE
Acprodtax ACPRODTAX
MSC-REV-ACCT-CAT -> BTX-TAX-ACCT-CAT
MSC-DELIV-METHOD -> BTX-DELIV-METHOD
BTX-EFFECTIVE-DATE
Acproduser ACPRODUSER
MSE-PRODUCT-LIST -> BRU-PRODUCT-LIST
MSC-PRODUCT -> BRU-PRODUCT
MSC-PROD-VERSION -> BRU-PROD-VERSION
MSC-EFFECTIVE-DT -> BRU-EFFECTIVE-DT
BRU-RECORD-TYPE
BRU-MAX-USERS
Acproforma ACPROFORMA
MSC-CONTRACT -> ATI-CONTRACT
MSC-MAINT-SCHEDULE -> ATI-MAINT-SCHEDULE
ATI-INVOICE-TYPE
ATI-DUE-DATE
|