Where Images stored in Epicor

Epicor ERP 10
1

Where the part images stored? I have few existing images in Part but couldn’t find the images in EpicorData or anywhere. I tried Part > Action > Export Images the path is also blank.

image

2

They are in the database, I think it is Erp.Image table.

Brett

3

Perhaps FileStore

    SELECT p.PartNum, p.ImageFileName, p.ImageID, 
    	   i.*,
    	   fs.*       	   

    FROM [dbo].Part AS p

    INNER JOIN [erp].[Image] AS i
    ON (p.Company = i.Company AND 
        p.ImageID = i.ImageID)

    LEFT JOIN [Ice].[FileStore] AS fs
    ON (fs.Company = i.Company AND      
    	 fs.SysRowID = i.ImageSysRowID )
2 Likes