Search-show showing blank slider

Hi, im creating a new app in application studio. I have a text box which is searchable. The search-show component calls a BAQ. I previewed the app, the slider that opens up when the search icon is clicked is blank. My BAQ uses only one table (Ice.SysUserFile) with 3 fields. I tried testing with a system BAQ and i can get result. Im not sure where im doing it wrong. Been stuck with this for days. Some help would be good.

On search click settings:

search-show settings:

All other fields not shown here are left as default.

When i preview the app, i see this:

You can see that the slider is blank. Any advise pls? Thanks

Try changing the Like property to UserFile.UserID.

1 Like

This is how Epicor has the search setup in the User Account screen. I’m not sure if they have a search defined for SysUserFile, it might just be for UserFile.

4 Likes

Hi, I changed it to UserFile.UserID and it magically works!

I tried SysUserFile before as that was what was stated in the BAQ.

Why does ‘UserFile’ works? How do i find out this from the system?

Thanks so much for your assistance.

Kinetic has a (very well hidden) list of searches that you’re able to use. The easiest way to find out what you need is to reference a stock screen in application studio. If you type “search” in the event panel, eventually you’ll find the event with the search-show widget and copy what they have.

The “actual” list is a lookup into Ice.XXXDef for the files Kinetic needs to show you the search panel UI (it’s just another app :melting_face:).

The reason UserFile works but SysUserFile does not is because Epicor probably didn’t see a need to create a search for SysUserFile. The tables are nearly identical anyways, so it’d be a little redundant to have two search UIs that do the same thing.

These are the available searches as of 2025.2.10, you may find them in the server in /Apps/MetaUI/shared/search, also in Ice.XXXDef under key2 = shared:

AADConfig.DirectoryID
ABCCode.ABCCode
AccessScope.AccessScopeID
ActionMaster.ActionID
ActionPlan.ActionPlanID
ActionPlanMaster.ActionPlanID
ACTType.ACTTypeUID
ActualCostAllocationHead.AllocationNum
ActualCostingCategory.ActualCostingCategoryID
Adjustment1099.AdjustmentNum
AGAFIPCommDocType.AFIPCommDocType
AGAFIPResponsibility.AFIPResponsibilityCode
AGCAEA.Fortnight
AGCustoms.CustomsCode
AGDestination.DestinationCode
AGEmissionPoint.EmissionPointID
AGIDDocType.IDDocTypeCode
AgingCredit.AgingCreditCode
AgingRptFmt.FmtCode
AGInvoicingPoint.InvoicingPointCode
AGLocation.LocationCode
AGProvince.ProvinceCode
AGUserComp.UserID
AGWebServiceConfig.WebServiceConfigCode
AlcBatch.BatchID
AlcHed.AllocID
AlcHist.BatchID
AlertGroup.GroupID
AlertLog.Alertnum
AnalysisCd.AnalysisCode
APAlcHed.AllocID
APChkGrp.GroupID
APChkGrpImport.GroupID
APIKey.KeyID
APInvDtlSearch.InvoiceNum
APInvGrp.GroupID
APInvHed.InvoiceNum
APInvMscSearch.MscNum
APInvoiceLoad.InvoiceNum
APLOC.LCID
APPNHead.APPromNoteID
ARAdjustment.InvoiceNum
ARInvGetDep.HeadNum
ARInvoiceLoad.InvoiceNum
ARLOC.LCID
ARPNHead.ARPromNoteID
ASNHeader.ASNID
AssetImpair.ImpairNum
AttrBin.AttrCode
Attribut.AttrCode
AttrWhseGroup.AttrCode
BankAcct.BankAcctID
BankBatch.BankBatchID
BankBrnch.BankBranchCode
BankFee.BankFeeID
BankFileImportWorkBench
BankGrp.GroupID
BankTransactionTemplate.TranTemplateID
BAQExtDatasource.DatasourceName
BAQExtDBSearch.BAQExtDataTable
BAQExtDsMetadata.DatasourceType
BAQExtDsType.DatasourceType
BAQReport.BAQRptID
BdnCd.BdnCd
BdnSet.BdnSetID
BENonAdmExpense.NAEID
BESalesDomestic.ECSalesReportID
BESalesIntracom.ECSalesReportID
BinSize.SizeID
BOL.BOLNum
BoxNumber.BoxNum
BpHoldType.HoldTypeID
BpMethod.BusinessObject
BudgetCode.BudgetCodeID
BusinessCategory.BusinessCatID
CallType.CallTypeCode
Capability.CapabilityID
Carrier.Carrier
CartonStage.PackNum
CashBHed.BankSlip
CashGrp.GroupID
CashGrpImport.GroupID
CashHead.CheckRef
CashHead.HeadNum
CashHeadImport.HeadNum
CCHdr.CycleDate
CCHdr.WarehouseCode
CCPeriodDefn.PeriodSeq
CCSheet.SheetNum
CCTag.TagNum
CCWhsCtrl.WarehouseCode
CheckDigit.CheckDigitID
CheckHed.CheckNum
CheckHed.HeadNum
CheckList.ListID
CMCustomer.CustID
CNCustomsDeclarationBillDetail.DeclarationBillLine
CNCustomsDeclarationBillHeader.DeclarationBill
CNCustomsHandbookHeader.HandbookCode
CnvProgs.ConversionID
COA.COACode
COAActCat.CategoryID
COAMap.COAMapUID
COASegmentSearch.COACode
COASegValues.SegmentCode
Code1099.Code1099ID
COMagneticMediaReport.ReportID
COMagneticMediaSetup.Description
Company.Company
ConsImport.GenID
ConsTgtDef.ConsDefID
ConsTgtGen.GenID
ConsType.ConsTypeID
ContainerClass.ClassCode
ContainerHeader.ContainerID
ContextMenu.LikeID
ControlID.ControlIDCode
ControlIDExtractHeader.ControlIDExtractCode
COOneTime.COOneTimeID
CORevelation.CommentID
CostGrp.GroupID
Country.CountryNum
Country.Description
Country.ISOrigCountry
Country.IStatCode
Course.CourseID
CourseRevision.CourseID
CourseSch.CourseID
CreditCardType.CardType
CreditTran.CustNum
CRMCall.CallSeqNum
CRMComp.CompID
CrossDock.Search
Currency.CurrencyCode
CurrExRateSearch.EffectiveDate
CurrRateGrp.RateGrpCode
CustBank.BankID
CustBillTo.BTCustID
CustCnt.ConNum
CustCnt.ContactName
CustGrup.GroupCode
Customer.CustID
CustomerPartXRefSvc.PartNum
CustPriceList.ListCode
CustReminderSearchList.CUSTID
CustXPrt.CustID
CustXPrt.XPartNum
DashBoard.DefinitionID
DataCheck.Key1
DataExportDef.DefinitionID
DataFabricEfxFunction.FunctionID
DataFabricEventType.EventType
DataFix.Key1
DEInvInvcHead.InvoiceNum
DeliveryPlan.DeliveryPlan
DeliveryType.DeliveryType
DemandContractDtl.DemandContractLine
DemandContractHdr.DemandContract
DemandHead.DemandContractNum
DemandHead.PONum
DemandPart.PartNum
DemandReconcile.ReconcileNum
DigitalCertificateStore.CertificateID
DmdMassGrp.GroupID
DMRActn.DMRNum
DMRCorAct.ActionID
DMRHead.DMRNum
DmsStorageType.StorageType
DocAssoc.DocExtension
DocType.DocTypeID
Driver.Name
DropShipDtl.PackSlip
DropShipHead.PackSlip
DynamicQuery.QueryID
DynamicQueryDesigner.QueryID
DynAttrClass.AttrClassID
DynAttrMasterDtl.AttributeID
DynAttrValueSet.ShortDescription
ECCUD.MapID
ECOGroup.GroupID
ECORev.PartNum
ECSalesReport.ECSalesReportID
eFakturTran.eFakturNumberReference
EFTHead.EFTHeadUID
EFTHead.Name
EfxLibraryDesigner.LibraryID
EInvOperator.ELIOperatorCode
Element.ElementHeaderID
EmailTemplate.EmailTempID
EmpBasic.EmpID
EmpExpense.EmpExpenseNum
EmpExpenseGroup.ClaimRef
Equip.EquipID
EquipLoc.LocID
EquipStatus.StatusID
EquipType.TypeID
ESConfig.ESServer
ExportPackage.PackageID
ExtCompany.ExtCompanyID
Extension.ExtensionSetID
ExtFinAnlsCd.InternalCode
ExtPlantSearch.ExtPlantID
ExtPREmp.EmpID
ExtPRExportLayout.PayExportLayoutID
ExtPRHoliday.HolidayDate
ExtPRPayClass.PayClassID
ExtPRPayType.PayTypeID
ExtPRProcGrp.ExtPRProcGrp
ExtSystem.ExtSystemID
ExtWarehouseSearch.ExtWarehouseID
FAAddition.AdditionNum
FAClass.ClassCode
FADisposal.DisposalNum
FAGroup.GroupCode
FAMethod.AssetMethod
FAReportCat.CategoryCode
FARevaluation.RevalueNum
FASpread.SpreadCode
FAsset.AssetNum
FAssetMassChange.ReplaceList
FAssetReg.AssetRegID
FileSchema.TableName
FinCharge.ChargeCode
FinRepConfHead.ConfigID
FiscalCal.FiscalCalendarID
FiscalPer.ClosePeriod
FiscalPer.FiscalPeriod
FiscalYr.FiscalYear
FOB.FOB
Form1099.Form1099Num
FormType.FormTypeID
FSAssetClass.FSAssetClassCode
FSAssetCondition.FSAssetConditionCode
FSCallCd.CallCode
FSCallDt.CallLine
FSCallhd.CallNum
FSContCd.ContractCode
FSContDt.ContractNum
FSContHd.ContractNum
FSRenewal.RenewalNbr
FSWarrCd.WarrantyCode
GLAccount.GLAccount
GLAccountMasks.AccountMask
GLAcctDisp.GLAcctDisp
GLAlcHed.AllocID
GlbAlert.Alertnum
GlbCOASegValues.SegmentCode
GlbCustomer.GlbCustID
GLBGLAcctDisp.GLAcctDisp
GlbGLBook.BookID
GlbJrnlCode.JournalCode
GLBook.BookID
GLBookPer.FiscalPeriod
GlbPart.GlbPartNum
GlbPerCon.GlbPerConID
GLBudgetHd.BalanceAcct
GlbVendor.GlbCompany_GlbVendorNum
GLCntrl.GLControlCode
GLCntrl.GLControlCode2
GLCntrlType.GLControlType
GLCOARefType.RefType
GLCTEntity.GLControlType
GLJrnDtl.JournalNum
GLJrnDtl.MatchCode
GLJrnDtlList.JournalNum
GLJrnGrp.GroupID
GLJrnHed.JournalNum
GLPurch.purchCode
GLRecHed.RecurNum
GLRptColSet.ColSetID
GLRptMas.ReportID
GTIInvcHead.GroupNum
GUINumDtl.GroupID
GUINumHed.FiscalYear
GUITaxDeclare.DeclareYear
HDCase.HDCaseNum
HDTopic.TopicID
HXProject.ProjectID
ICCode.ICCode
Ice.Plant.Plant
ICommCode.CommodityCode
ICType.ICTypeID
IDNumCnfg.FormatID
Image.ImageID
ImageCategory.ImageCategoryID
ImageLayerHeader.ImageLayerID
ImageSubCategorySearch.ImageSubCategoryID
ImportGroup.GroupID
ImportGrp.ImportID
Incoterms.IncotermCode
Indirect.IndirectCode
INGSTR1Report.ReportID
INGSTR2ReportExport.ReportID
INLUTBond.BondLUTnumber
INMaterialBurden.MaterialBurdenID
InspAttr.AttributeID
Inspectr.InspectorID
InspPlan.InspPlanNum
InspProcessing.PartNum
IntegrationField.FieldName
IntegrationMap.IntegrationID
IntQueIn.IntQueID
IntraStatReport.ReportID
InvcDtl.InvoiceLine
InvcDtlRASch.InvoiceNum
InvcGrp.GroupID
InvcHead.InvoiceNum
InventoryAdvisor.PartQtyAttr
InventoryAttributeSearch.ShortDescription
IoTConfig.IoTHubName
IoTDevice.DeviceID
IoTDeviceGroup.GroupID
IPAddressSet.IPAddressSetID
IPForm.FormId
IRWarehseSearch.WarehouseCode
IStatTrn.InvoiceNum
JCDept.JCDept
JCShift.Shift
JobAsmbl.AssemblySeq
JobClosingCd.JobClosingCode
JobHead.JobNum
JobMtl.MtlSeq
JobOper.AssemblySeq
JobOper.OprSeq
JobPart.PartNum
JobProdSearch.JobNum
JobSched.Description
JobSched.ScheduleID
JPAPPerBillHead.VendorNum
JPAPPerBillStmtGrp.PerBillStmtGrpID
JPDynCalHead.DynCalID
JPPerBillHead.CustNum
JrnlCode.JournalCode
KanBanType.KBCode
KBConfigSearch.KBConfigID
LabExpCd.ExpenseCode
LaborDtl.LaborDtlSeq
LaborDtl.LaborHedSeq
LaborDtl.LbrPrjRole
LaborHed.LaborHedSeq
LangName.LangNameID
LegalNumCnfg.LegalNumberID
LegalNumHistory.LegalNumber
Lifecycle.Code
Local001.Key2
LocationInventory.LocationNum
LocationInventoryMtlSearch.LocationNum
LockboxGroup.GroupID
LockboxLayoutHead.LayoutID
LogAPInv.InvoiceNum
LogInvAprvVoid.InvoiceNum
LogInvGrp.GroupID
LookupTable.MapUID
Lot.LotNum
LotSeq.LotSeqID
MaintReq.ReqID
MangCust.CustNumCustID
Manufacturer.MfgID
MassIssueToMfg.JobNum
MasterPack.PackNum
MemoCat.Description
Menu.MenuID
Menu.Program
MESMenu.MenuID
MessageTemplate.MessageTemplateID
MfgPart.PartNum
MICRPrinter.MICRPrinterID
MiscChrg.MiscCode
MktgAct.ActivityType
MktgAdv.AdvertisementCode
MktgCamp.MktgCampaignID
MktgEnvt.MktgEvntSeq
MktgList.MktgListID
MktgPub.PublicationCode
MrpProc.ProcessName
MrpProcQueue.ProcessName
MrpQueue.Name
MscShpHd.Name
MscShpHd.PackNum
MsgIDCounter.MsgIDCounter
MXPACConfiguration.MXPACCode
MXTaxRegime.TaxRegime
MXWHTaxCertHead.CertificateNum
MYARConsEInvcHead.ConsInvoiceNum
NARelationship.RlsClassCode
NettingHead.NettingID
NLICPReport.ReportID
NLTaxReportDeclaration.DeclarationUID
NonConf.TranID
ObjectSecurity.SecCode
OpMaster.OpCode
OpStd.OpStdID
OpText.OpTextID
OrderDtl.OrderLine
OrderHed.ICPONum
OrderHed.OrderNum
OrderRel.OrderRelNum
PackClss.PkgClass
Packing.PartNum
Packing.PkgCode
PackingMtlType.PkgMtlTypeCode
PackingType.PkgTypeCode
PackOutSearch.POGetRows
PActivity.ActID
PADay.PADayID
PAPlan.PAPlanID
ParsingParam.ParamCode
Part.PartNum
PartAllocRuleClass.RuleClassID
PartAllocRuleMasterDtl.MasterRuleID
PartAllocTemplate.AllocTemplateID
PartBin.BinNum
PartBinSearch.PartBin
PartClass.ClassID
PartDtl.SysRowID
PartFIFOCost.FIFODate
PartLot.LotNum
PartPlant.Plant
PartPlantWhse.WarehouseCode
PartRev.PartNum
PartRev.RevisionNum
PartSched.PartNum
PartSchedSearch.PartNum
PartSubs.SubPart
PartSug.Type
PartTran.TranType
PartWhse.WarehouseCode
PartWipSearch.BinNum
PartWipSearch.JobNum
PartWipSearch.WarehouseCode
PASchedule.SchedID
PAWeek.PAWeekID
PayMethod.PMUID
PayType.PayTypeID
PBGInvcHead.ProjectID
PCashDesk.CashDeskID
PCashEntry.CashDeskID
PCashOprType.OprTypeCode
PcConData.PartNum
PcConType.TypeCode
PcLookupColSetHed.ColSetID
PcLookupTblHed.LookupTblID
PcStatus.ConfigID
PDFFormTemplate.TemplateID
PeLog.GPostingUID
PerBillHead.CustID
PerBillStmtGrp.PerBillStmtGrpID
PerCon.PerConID
Periodicity.Periodicity
Periodicity.Plant
Person.PersonID
PIStatus.PIStatus
PIType.PIType
PkgControl.PkgControlIDCode
PkgControlHeader.PCID
PkgControlID.PCID
PkgControlIDMaint.PCID
PkgControlLabelType.LabelType
PkgControlLabelValue.CustID
PkgControlStation.StationID
PkgControlTranRouting.TranType
PkgControlTranRoutingPrinter.PrinterID
PlanContractHdr.ContractID
Plant.Plant
PlantConfCtrl.Plant
PlantCost.PlantCostID
PlantWhseSearch.WarehouseCode
PlasticPackagingTaxReport.ReportID
PLJPKVATReport.ReportID
POApvMsg.PONum
POHeader.PONum
POSchedule.ContractPONum
PRCheck.CheckNum
PRChkGrp.GroupID
PRClass.ClassID
PRDeduct.DeductionID
PredictiveSearch.QuickSearchID
PrefScheme.PrefSchemeID
PREmpMas.EmpID
PRHoldy.Holiday
PriceGroup.PriceGroupCode
PriceLst.ListCode
ProcessSet.ProcessID
ProdActDay.PADayID
ProdCal.CalendarID
ProdCalWeek.CalendarID
ProdGrup.ProdCode
ProdTeam.ProdTeamID
ProjChkLstType.TypeID
Project.ProjectID
PRTaxMas.TaxTblID
PRW2Dtl.ControlNum
PRWrkCmp.WorkCompCode
PurAgent.BuyerID
PurMisc.MiscCode
PurTerms.TermsCode
QMarkUp.MarkUpID
QuickSearch.QuickSearchID
QuoteAnalysisExp.QuoteNum
QuoteAsm.QuoteNum
QuoteDtl.QuoteLine
QuoteHed.QuoteNum
QuoteOpr.OprSeq
RASchedCd.RACode
RateType.RateTypeID
Rating.RatingCode
RcvDtl.PackLine
RcvHead.PackSlip
Reason.ReasonCode
ReasonDetail.ReasonCode
RebateHdr.RebateID
RebateTrans.RebateID
ReceiptsFromMfgJobAsmbl.JobNum
ReclassCode.ReclassCodeID
RecurBookListSearch.BookID
RecurringCycle.CycleCode
RefCategory.RefCategory
Region.RegionCode
ReminderGroup.GroupCode
RenewalCode.RenewalCode
Report.ReportID
ReportStyle.ReportID
ReqActs.ReqActionID
ReqHead.ReqNum
ReservePri.PriorityCode
Resource.ResourceID
ResourceCollection.CollectionID
ResourceGroup.ResourceGrpID
ResourceType.ResourceTypeID
RestrictFcts.Program
RestrictFcts.RestrictFct
RestrictionType.RestrictionTypeID
ReverseCashReceipt.HeadNum
RFQHead.RFQNum
RFQSugg.SugNum
RFQVend.RFQNum
RlsClass.RlsClassCode
RMADtl.RMALine
RMAHead.RMANum
RoleCd.RoleCode
RoughCutParam.RoughCutCode
RptDataDef.RptDefID
RptStructuredOutputDef.RptStructuredOutputDefID
RptSubmission.RptSubmissionID
RunGLAllocSearch.BatchID
RvJrn.RvJrnUID
SalesCat.SalesCatID
SalesPersonWBCustomer.CustID
SalesRep.SalesRepCode
SalesTax.TaxCode
SalesTer.TerritoryID
SalesTRC.RateCode
SchedPri.SchedCode
Schema.FieldName
Schema.TableName
SecColumn.TableName
SecGroup.SecGroupCode
Security.SecCode
SerialMask.SerialMaskID
SerialNo.SerialNumber
ServiceContract.ContractNum
SetupGrp.SetupGroup
ShipDtl.PackNum
ShipHead.PackNum
ShipTo.ShipToNum
ShipVia.ShipViaCode
SkipLotCtl.SkipCode
SolutionType.SolutionTypeID
SpecHed.SpecID
SRepQHed.SalesRepCode
StageNo.StageNumber
StatUOM.StatUOMCode
StockProvisionFormat.StockProvFmtCode
SubShipH.PackNum
Substance.SubstanceID
SubstanceRestriction.RestrictionTypeID
SubstanceSearch.SubstanceID
SugPOChg.PONum
SugPoDtl.SugNum
SupplierPart.PartNum
SysActivityLog.ActivitySeq
SysActivityTracker.ActivityID
SysAgent.AgentID
SysCubeDef.CubeID
SysPrinter.PrinterID
SysRptLst.RecSeq
SysTag.SysRowID
Tariff.TariffCode
Task.TaskID
TaskMast.TaskID
TaskSet.TaskSetID
TaskStat.StatusCode
TaskType.TypeCode
TaxAlgrm.Algorithm
TaxAuthorityCd.TaxAuthorityCode
TaxBoxDefault.BoxCode
TaxBoxReportConfigHead.ConfigID
TaxCat.TaxCatID
TaxCent.CentCode
TaxJuris.TaxJurisCode
TaxReport.ReportID
TaxRgn.TaxRegionCode
TaxRptCat.RptCatCode
TaxSvcHead.TaxSvcID
TaxText.TextCode
TaxTran.LegalNumber
TaxValidationHead.TaxValidationID
Terms.TermsCode
TFOrdDtlSearch.TFOrdLine
TFOrdHed.TFOrdNum
TFOrdSug.TFOrdNum
TFShipHead.PackNum
TimeTypCd.TimeTypCd
TINValidation.TINValidationCode
TINValidationResult.TINValidationResultCode
TranDocType.TranDocTypeID
TranTypeSearch.TranType
TWTaxPermit.EntryDate
UD01.Key1
UD01.Key2
UD01.Key3
UD01.Key4
UD01.Key5
UD02.Key1
UD02.Key2
UD02.Key3
UD02.Key4
UD02.Key5
UD03.Key1
UD03.Key2
UD03.Key3
UD03.Key4
UD03.Key5
UD04.Key1
UD04.Key2
UD04.Key3
UD04.Key4
UD04.Key5
UD05.Key1
UD05.Key2
UD05.Key3
UD05.Key4
UD05.Key5
UD06.Key1
UD06.Key2
UD06.Key3
UD06.Key4
UD06.Key5
UD07.Key1
UD07.Key2
UD07.Key3
UD07.Key4
UD07.Key5
UD08.Key1
UD08.Key2
UD08.Key3
UD08.Key4
UD08.Key5
UD09.Key1
UD09.Key2
UD09.Key3
UD09.Key4
UD09.Key5
UD10.Key1
UD10.Key2
UD10.Key3
UD10.Key4
UD10.Key5
UD100.Key1
UD100.Key2
UD100.Key3
UD100.Key4
UD100.Key5
UD101.Key1
UD101.Key2
UD101.Key3
UD101.Key4
UD101.Key5
UD102.Key1
UD102.Key2
UD102.Key3
UD102.Key4
UD102.Key5
UD103.Key1
UD103.Key2
UD103.Key3
UD103.Key4
UD103.Key5
UD104.Key1
UD104.Key2
UD104.Key3
UD104.Key4
UD104.Key5
UD105.Key1
UD105.Key2
UD105.Key3
UD105.Key4
UD105.Key5
UD106.Key1
UD106.Key2
UD106.Key3
UD106.Key4
UD106.Key5
UD107.Key1
UD107.Key2
UD107.Key3
UD107.Key4
UD107.Key5
UD108.Key1
UD108.Key2
UD108.Key3
UD108.Key4
UD108.Key5
UD109.Key1
UD109.Key2
UD109.Key3
UD109.Key4
UD109.Key5
UD11.Key1
UD11.Key2
UD11.Key3
UD11.Key4
UD11.Key5
UD110.Key1
UD110.Key2
UD110.Key3
UD110.Key4
UD110.Key5
UD12.Key1
UD12.Key2
UD12.Key3
UD12.Key4
UD12.Key5
UD13.Key1
UD13.Key2
UD13.Key3
UD13.Key4
UD13.Key5
UD14.Key1
UD14.Key2
UD14.Key3
UD14.Key4
UD14.Key5
UD15.Key1
UD15.Key2
UD15.Key3
UD15.Key4
UD15.Key5
UD16.Key1
UD16.Key2
UD16.Key3
UD16.Key4
UD16.Key5
UD17.Key1
UD17.Key2
UD17.Key3
UD17.Key4
UD17.Key5
UD18.Key1
UD18.Key2
UD18.Key3
UD18.Key4
UD18.Key5
UD19.Key1
UD19.Key2
UD19.Key3
UD19.Key4
UD19.Key5
UD20.Key1
UD20.Key2
UD20.Key3
UD20.Key4
UD20.Key5
UD21.Key1
UD21.Key2
UD21.Key3
UD21.Key4
UD21.Key5
UD22.Key1
UD22.Key2
UD22.Key3
UD22.Key4
UD22.Key5
UD23.Key1
UD23.Key2
UD23.Key3
UD23.Key4
UD23.Key5
UD24.Key1
UD24.Key2
UD24.Key3
UD24.Key4
UD24.Key5
UD25.Key1
UD25.Key2
UD25.Key3
UD25.Key4
UD25.Key5
UD26.Key1
UD26.Key2
UD26.Key3
UD26.Key4
UD26.Key5
UD27.Key1
UD27.Key2
UD27.Key3
UD27.Key4
UD27.Key5
UD28.Key1
UD28.Key2
UD28.Key3
UD28.Key4
UD28.Key5
UD29.Key1
UD29.Key2
UD29.Key3
UD29.Key4
UD29.Key5
UD30.Key1
UD30.Key2
UD30.Key3
UD30.Key4
UD30.Key5
UD31.Key1
UD31.Key2
UD31.Key3
UD31.Key4
UD31.Key5
UD32.Key1
UD32.Key2
UD32.Key3
UD32.Key4
UD32.Key5
UD33.Key1
UD33.Key2
UD33.Key3
UD33.Key4
UD33.Key5
UD34.Key1
UD34.Key2
UD34.Key3
UD34.Key4
UD34.Key5
UD35.Key1
UD35.Key2
UD35.Key3
UD35.Key4
UD35.Key5
UD36.Key1
UD36.Key2
UD36.Key3
UD36.Key4
UD36.Key5
UD37.Key1
UD37.Key2
UD37.Key3
UD37.Key4
UD37.Key5
UD38.Key1
UD38.Key2
UD38.Key3
UD38.Key4
UD38.Key5
UD39.Key1
UD39.Key2
UD39.Key3
UD39.Key4
UD39.Key5
UD40.Key1
UD40.Key2
UD40.Key3
UD40.Key4
UD40.Key5
UDCodes.CodeID
UDCodeType.CodeTypeID
UDMap.MapID
UOM.UOMCode
UOMClass.UOMClassID
UserFile.DcdUserID
UserFile.UserID
VendBank.BankID
VendGrup.GroupCode
Vendor.US1099State
Vendor.VendorID
VendorPP.PurPoint
VendPart.PartNum
VNTGLRptMas.ReportID
VoidPayment.HeadNum
Warehse.WarehouseCode
Warning.LabWarnNum
Wave.WaveNum
WFGroup.WFGroupID
WFStage.WFStageID
WhseBin.BinNum
WhseGroup.WhseGroupCode
WhseZone.ZoneID
WHTPaymentHead.ReportID
WHTPaymentSubmit.SubmitReportID
WorkStation.WorkStationID
XAttachMetaData.TableName
XDocTypeCtrl.TableName
XFileRef.XFileRefNum
XXXDef.Key2
ZBODef.ClassName
ZDataSet.DataSetID
ZDataTable.DataTableID
ZSubDataSet.DataTableID
9 Likes

Hi, thanks for this. Im trying to see it for myself in epicor. im on cloud, so i opened up BAQ to examine ice.xxxdef table. Here’s what i got:

I was trying to look for “ABCCode.ABCCode”. Am i missing something?

Thanks

Filter key2 for \shared\search