MX160 – Attribute Valid Value Interface

System
General Ledger Setup (IF)
Type
Batch program
Updates
4 tables
References
2 tables

MX160 (Attribute Valid Value Interface) is a Lawson General Ledger Setup batch program. It updates CKPOINT, MXCATDEF, MXVALIDATE and MXVALREL and references MXELEMENT and WFSETUP.

About MX160

Run Attribute Valid Value Interface (MX160) to load attribute values or ranges of values imported from a non-Lawson file into the Attribute Matrix application. A non-Lawson file must have been imported into the interface file MXVALREL (UNIX/Windows) or DBIFMVR (System i), and you should have reviewed and edited the contents of MXVALREL (UNIX/Windows) or DBIFMVR (System i) using Attribute Valid Value Adjustment (MX60.1) before running this program.

More information: If you leave the Run Group field blank, the load will include all run groups. If you select an attribute in the Attribute field, only the values for that attribute Will be loaded. If you select R (Report only) in the Update Option field, the program does not update any records and produces an error report. If you select L (Load) in the Update Option field, the program deletes and replaces all existing values, and adds new values. If you select A (Append) in the Update Option field, the program appends new values to the existing values. If you Select U (Update) in the Update Option field, the program ignores existing values that do not overlap, replaces overlapping values, and adds new values. If you select Y (Yes) in the Update Type field, the program will load only the valid records. MX60.1 will then display only those records that are in error. If you select N (No) in the Update Type field, the program will not load any values until all errors are corrected. No is the default. The Update Type field is significant only if you select L (Load), A (Append) or U (Update) in the Update Option field. Run Attribute Valid Value Listing (MX260) to list the attribute values contained in the Attribute Valid Values Interface file (MXVALREL) (UNIX/Windows) or (DBIFMVR) (System i).

Updated files (4)

TableDescriptionSystem
CKPOINTNo description in the Lawson data dictionary
MXCATDEFAttribute DefinitionIF
MXVALIDATEAttribute ValidationIF
MXVALRELAttribute Value InterfaceIF

Referenced files (2)

TableDescriptionSystem
MXELEMENTAttribute ElementIF
WFSETUPNo description in the Lawson data dictionaryWF