When you want a list of all the mandatory field on table X, yould check all the properties on the table fields, or you could be lazy and write a small job that does the trick for you. Just replace TableId with your tablenum.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | static void CheckMandatoryFieldsOnTable(Args _args) { DictTable dictTable; DictField dictField; int i; TableId tableId = tablenum(custtable); ; dictTable = new DictTable(tableId); for (i=1 ; i<=dictTable.fieldCnt() ; i++) { dictField = new DictField(tableId, dictTable.fieldCnt2Id(i)); if (dictField.mandatory()) { info(dictField.name()); } } } |
