Hi Omkar

Column GDTXKY (Object Key) on the Media Objects table, F00165, contains the document number associated with the attachment and coupled with GDOBNM (Object Name) and GDMOSEQN (Seq No) provides a unique key.

GDOBNM identifies the form the attachment is available on, e.g. "GT4311" for purchase orders

GDTXKY is a concatenation of the company, document type, document number and suffix, e.g. "00010|OP|1234|001"

GDMOSEQN is just a numeric value, e.g. 1, 2, 3, etc

You can use SQL to split out the GDTXKY value into it's separate parts. For example the following works over an Oracle 19c database:

select gdobnm as Object_Name
, gdtxky as Object_Key
, substr(gdtxky, 1, 5) as company
, substr(gdtxky, 7, 2) as Doc_Type
, to_number(substr(gdtxky, 10, instr(gdtxky, '|', 10)-10), '99999999') as Doc_No
, substr(gdtxky, instr(gdtxky, '|', 10)+1, 3) as Suffix
, gdmoseqn as Sequence
, case gdgtmotype
when 0 then '0 (Text)'
when 1 then '1 (Image)'
when 2 then '2 (OLE)'
when 3 then '3 (Shortcut)'
when 4 then '4 (Vendor)'
when 5 then '5 (URL)'
else to_char(gdgtmotype)
end as Media_Type
, gdgtitnm as Description
, gdgtfilenm as File_Name_or_Link
, gduser as User_ID
, to_char(to_date(to_char(gdupmj+1900000), 'YYYYDDD'), 'DD/MM/YYYY') as Date_Added
, gdtday as Time_Added
from proddta.f00165
where (gdtxky like '%86456%' or gdtxky like '%107849%' or gdtxky like '%86546%')
and gdgtmotype <> '0';

Hope it helps
Jonathan