Re: File Record Layouts: Some good, some not...

Hi,

I am not sure whether it helps you, there is a AS/400 command called 
DSPFFD (Display File Field Description), you can use this command to 
output the result into a file (*OUTFILE), and then query the outfile to 
list the file name, field name, and description. A sample of this command 
is given below. Q1 is the outfile having the field description of ITEMASA.

DSPFFD FILE(AMFLIB/ITEMASA) OUTPUT(*OUTFILE) OUTFILE(QTEMP/Q1)

Regards, Selva





"Dan Bale" <dbale@xxxxxxxxxxxxx> 
Sent by: mapics-l-bounces@xxxxxxxxxxxx
08/11/2004 11:51 PM
Please respond to
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>


To
<mapics-l@xxxxxxxxxxxx>
cc

Subject
File Record Layouts: Some good, some not...






A few weeks back, someone pointed me to the File Record Layout option on 
CAS
(DB Mod 4).  This has been a great help for most files, using the Print
Characteristics option.  However, not all files have extended "definition
text".  I am somewhat disappointed to look at a file like CUSINV and see 
20+
amount due fields, all with the same field text, "TOTAL AMOUNT DUE ON
INVOICE", and no "definition text".

So, where does one go to find out what all of these amount fields really
mean?

tia,
db

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.