We have developed yet a php application in our server interfaced with AS400 through ODBC driver that gets and reorder data from AS400. Now we need to get out some other kind of data from AS400.
The new data are the green ones that you can find in attached files
The other data are yet get listed from our application
The main database resides on AS400 that's not on our server but is managed by another company. They've added some other fields (or table I don't know but if needed we can talk with this company to know about it). This new data are extracted from the jpg you've seen and are the green marked ones. Our php script running on our server gets out the not green fields and puts them in the table you can see in 03.gif attached file. As you can see the fields code circled in red are the same code you can see in the other attached files (the not green ones). We need to extract and put them in the table on 03.gif