I want to export the field value of LegerDimension field on TaxTransGeneralJournalAccountEntry table into our Azure database. I have created an entity and tried to add a virtual field to the entity using postload method. this works for smaller tables but TaxTransGeneralJournalAccountEntry is a 30 million row table. I have used a computed field and a new method (below). this works fine with other tables like GeneralJournalAccountEntry table which is also a large table (30 million rows) but for some reason, this is not working for table TaxTransGeneralJournalAccountEntry.
public class LTG_BI_TaxTransGeneralJournalAccountEntry extends common
{
/// <summary>
///
/// </summary>
private static server str LedgerDimensiona()
{
DataEntityName dataEntityName= tablestr(LTG_BI_TaxTransGeneralJournalAccountEntry);
List fieldList = new List(types::String);
fieldList.addEnd(SysComputedColumn::returnField(DataEntityName, identifierstr(TaxTransGeneralJournalAccountEntry), fieldstr(TaxTransGeneralJournalAccountEntry, LedgerDimension)));
return SysComputedColumn::addList(fieldList);
}
}
