The links are stored in the XFileAttch table, Filename is in XFileRef.
Key1 = JobNum
Key2 = Asm
Key3 = MtlSeq
RelatedToFile = JobMtl
From: "ralmon@..." <ralmon@...>
To: vantage@yahoogroups.com
Sent: Friday, November 8, 2013 9:26 AM
Subject: [Vantage] Job Material Attachment Table .701 Where is it??
I am trying to run a query on attachments linked to job material. I couldn't find any fields or tables in BAQ Designer so I ran a trace on the process and it appears that when something is attached to a job material it is stored in a JobMtlAttch Table. But I can't find this table anywhere. Does it exist or does anyone know a good way to query this?
Here is part of what a trace returns:
<JobMtlAttch>
<Company></Company>
<JobNum>130050</JobNum>
<AssemblySeq>0</AssemblySeq>
<MtlSeq>30</MtlSeq>
<DrawingSeq>1</DrawingSeq>
<XFileRefNum>95</XFileRefNum>
<DrawDesc>ENGDWG R6.1</DrawDesc>
<FileName>z:\Desktop\PO_34008FL_from_Innovative_Refrigeration_Systems_Inc._PO_System_5576.pdf</FileName>
<PDMDocID />
<DocTypeID />
<RowIdent>0x003d0e7200010000574845524520282850524f47524553535f5245434944203d200000002b0008fffb0000000000000000000000000000022329292000</RowIdent>
<RowMod />
<DBRowIdent>AD0OcgABAABXSEVSRSAoKFBST0dSRVNTX1JFQ0lEID0gAAAAKwAI//sAAAAAAAAAAAAAAAAAAAIjKSkgAA==</DBRowIdent>
</JobMtlAttch>
Thanks