By using this website, you agree to our Terms of Use (click here)
We want to start to attach an image of a shipment to our larger shipments. We are concerned that this will end up using data and so I want to create a generic inquiry to find sales orders with attachements and related info about those attachements such as size, date, name etc...
Does anyone have any idea which tables to pull this data from? I have not been able to find it in the DAC browser
Much appreciate any feedback
Try joining SOOrder.NoteID to UploadFile.NoteID. UploadFileInfo has the filesize and datetime.
@roycelithgo Hi Royce. I tried to connect the SOOrder table to the UploadFile but it does not come up as a possible child table for the SOOrder table. Can you expand on how you would do the above reccomendation?
These are the files I am trying to connect, but with no luck. Any furthar thoughts would be appreciated
Unfortunately looks like the only way to join is via text in the UploadFile.Name field.
Returns 1 row per attachment per sales order with attachment.
Online Members
