2 Items on this laundry list.
1) Rexx script needs to be adjusted to allow for additional designators.
On the "Arctic" "Vendor 2" the indicator on the string was only a "C" or a "D" Now the vendor added a few more designations that will need to be figured in as well.
"C" is Active Available
"D" is Discontinued Not Available anymore
Now all the indicators are
A = Active = Active Available
D = Discontinued = Discontinued if no stock and no alternate Semi Available
R = Replaced = Active if updated part number is active Semi Available
S = Sold Out = Discontinued if no stock and no alternate
T = Third Party = Active Available
Need to make the new designations fall through the logic. Again this is only on Arctic or vendor 2.
Indicators are at 98 on the strings.
3307-514 A PIPE COMP EXHAUST-BLACK 1 000000828500000000000000014995AXUPA884646676160000400
0702-807 TUBE,OIL LEVEL-ASSY 1 000000148900000000000000002695DXSPS886224223698000030
0100-089 R/B 0100-117 1 000000000000000000000000000000RXSPS 000000
0100-092 BELT,DRIVE 1 000000386500000000000000006995SXSPS886224166513000050
0770-125 TANK,GAS 2UP 11GAL 156TRK 1 000001624100000000000000029395TXSPS886224253183001950
2) Need a software program to allow me to adjust a mysql table "weight" depending on a price matrix and the weights current value. Program needs to be able to apply to any selected table in our database. All schemas are almost exact and very simple. Any additional info I can provide via chat.