Contents tagged with InventoryItem
today I want to document some information about how images for inventory items are stored in Acumatica.
Database structure (Acumatica)
InventoryItem - A table that contains all InventoryItem data
> ImageURL - A data field where the image file name being saved.
UploadFile - A table that contains attachments data
> Name - A data field where you can use to join with InventoryItem using InventoryItem.ImageURL = UploadFile.Name
NoteDoc - A table that contains all NoteDoc data
> FileID - A data field unique ID where you can use to join with UploadFile using UploadFile.FileID = NoteDoc.FileID
A SQL query that get data necessary to create the imageExternalLink … more