Hello,
There is a virtual table called Field that shows you at least DataType, and a bit more information about each field. I have copied a sample page which just shows fields from the table. However the table does not know if any relatoinships have been set either conditionally (for example "No." on a Sales Line which relates to different tables, depending on Type), and it also does not know of any relations done by code. But datatype is pretty static. I hope you can use this.
Page:
page 50105 FieldList
{
PageType = List;
ApplicationArea = All;
UsageCategory = Lists;
SourceTable = Field;
layout
{
area(Content)
{
repeater(GroupName)
{
field(TableNo; rec.TableNo) { }
field(TableName; rec.TableName) { }
field(FieldNo; rec."No.") { }
field(FieldName; rec.FieldName) { }
field(Obsolete; rec.ObsoleteState) { }
field(Type; rec.Type) { }
field(TypeName; rec."Type Name") { }
field(SQLDatatype; rec.SQLDataType) { }
field(TableRelation; rec.RelationTableNo) { }
field(MyField; rec.RelationFieldNo) { }
}
}
}
}
