Need an item rule syntax that will get and set values from custom table in application composer.
SummaryNeed the syntax for get and set values from the custom tables using item rules.
Context:Customer has a set of MSPN codes sent by legacy system (say 1-1000). These values are loaded onto a custom object in application composer under ERP & SCM Application.
A column called Active created which will should be updated to inactive once a code is used for an item.
The Non-Michelin tires for North America will be created in the FPH UI
During the creation process the MSPNCODE need to be read/used and marked as inactive.
How to achieve this using item rules ?