BPM user defined columns

Epicor ERP 10
1

Is there any special reference or using that I need to be able to use the _UD extensions of a table? Trying to get data from the PartLot_UD Table and getting an error:
ERP Context does not contain a definition for PartLot_UD

var ttInvcDtl_Row = ttInvcDtl.FirstOrDefault(r => r.Added());
var lotNum = ttInvcDtl_Row.XPartNum;
var partLot_xRow =(from PartLot_Row in Db.PartLot where PartLot_Row.LotNum == lotNum select PartLot_Row).FirstOrDefault();

var sri = partLot_xRow.SysRowID;

var partLotUD_xRow = (from PartLot_UD_Row in Db.PartLot_UD where PartLot_UD_Row.ForeignSysRowID == sri select PartLot_UD_Row).FirstOrDefault();

2

You should no use the _UD tables directly epicor takes are of this for you. I recommend some through browsing of the Epicor Ice Tools and Customization Guide.

3

I see. I had a typo that was saying the the field was not available for PartLot. After seeing your comment I double checked and it is available without having to go out to the _UD table. I thought that was kinda backwards if I had to use the SysRowID to get data from the UD table.
Thanks

1 Like