Something like:
Table:
table 50100 MyTable
{
DataClassification = ToBeClassified;
fields
{
field(1;"Account Category Code"; Code[20])
{
DataClassification = CustomerContent;
TableRelation = "G/L Account Category";
}
field(2;"Bill Code"; Code[20])
{
DataClassification = CustomerContent;
}
field(3;"Control Account"; Code[20])
{
DataClassification = CustomerContent;
}
field(4;"Percentage"; Decimal)
{
DataClassification = CustomerContent;
}
}
keys
{
key(PK; "Account Category Code")
{
Clustered = true;
}
}
}
LIST PAGE:
page 50100 MyList
{
PageType = List;
ApplicationArea = All;
UsageCategory = Lists;
SourceTable = MyTable;
layout
{
area(Content)
{
repeater(Group)
{
field("Account Category Code"; "Account Category Code")
{
ApplicationArea = All;
}
field("Bill Code"; "Bill Code")
{
ApplicationArea = All;
}
field("Control Account"; "Control Account")
{
ApplicationArea = All;
}
field(Percentage; Percentage)
{
ApplicationArea = All;
}
}
}
}
}
A list pag has automatically the features to edit record and to export it in an Excel file.
