Looking for help on finds the material Item field name/ table in maintain router

Question

I am trying to do a crystal report that I need to pull the field that is"material Item"(SEE THE YELLOW HIGHLIGHED that is located in Maintain Router, Detail, then material. The Operation type is 
 Outside Processing. Does anyone know the table or view that contains this field and what the name of this field is called All I see is key fields rather than ID fields. 
 Thank You!!!

LouDavis · Answer

The Material Item Key is stored in tmfRoutDetl_HAI As MatItemKey. You will need to join in timItem and possibly timItemDescription to get the information you want for your report. The Schema Browser can give you more details on these tables.

Sage 500

Looking for help on finds the material Item field name/ table in maintain router

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING