Explanation of Field

The DPTLVL field in the FILEREL table means that there is a dependent field defined in the relationship. If you go to dbdef and to table to look at the relationships, there are some defined that are based on tables related to the table you're working with.

For example, ACACTIVITY has related table ACACTGRP. In terms of currency codes relationships, the values in the ACACTGRP are used rather than values in ACACTIVITY.

This will show in the table as a value of "1" if the table is using a dependent relationship and a "0" if it is not. If you dump out the FILEREL table from GEN, you can see the differences in the relationship definition from a relationship that has a 0 or a 1 and it will make a little more sense.

Hope this helps.

Thank you very much Randall - the information your provided is very helpful.