ADP field names
Posted:
Tue Apr 18, 2006 4:35 pmby warren
I'm new to ADP and I'm trying to write an english statement to produce inventory for use on our website. Can anyone tell me how to get a complete list of the available fields for inventory?
------------------
ADP field names
Posted:
Tue Apr 18, 2006 5:26 pmby ctvolvo
I am sure there is a list out there somewhere, but I was never able to get my hands on one when we had ADP.
What I would suggest is to use RPG. I was able to get many reports out of there. There is also a feature in RPG that allows you to see what the english statement looks like. From that you will be able to build your own dictionary.
Good Luck.
ADP field names
Posted:
Tue Apr 18, 2006 7:47 pmby jazdale
If you know your file name, you can run an english statement to find the list of fields.
In your case, Warren, I'm assuming your using the CAR-INV file.
From ENG
?SORT CAR-INV DICT S/NAME
If you want to send it to the lineprinter, just add LPTR to the end of the statement.
When the report displays, the first column is the field you use when building the English statement, the second column is how it looks on the report.