by aksales » Tue Aug 21, 2012 7:52 pm
Second post for now is how to pull down a list of the DICT items from a FILE.
This example is for Parts (since it seems 90% of the posts on DE are parts). Run the following under your -I logon.
1. Function: RXR
2. At the ? prompt type in: SORT PARTS DICT 3 9 10
3. Hit ENTER twice.
4. When it pops up the File Format Selection window select Microsoft Excel Worksheet (XLS)
5. Give it a name and it save.
6. This should save and then open the file on your computer which will show all the DICT items for the parts file PARTS with the DICT item name(column), The Description, Justification, and then field length.
I just learned this bad boy late last week and this has really helped with fleshing out which files to pull data from and where the data is located. Your milage may vary and this is posted AS IS NO WARRANTY OR GUARANTEE, I AM NOT RESPONSIBLE FOR ANY GOOD BAD OR OTHER!!
Hope it helps though!