Job Material Attachment Table .701 Where is it?

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




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

 

Hi,
 
We are on 9.05.607B.  In our system the data for all attachments (document type ID, file name, related to key (e.g., order number, etc) are stored in table called XFileRef.  Is this what you are looking for?  You could sort on Related to file.  I believe it will be JobMtl for your case.
 
Nancy
 
 
---In vantage@yahoogroups.com, <ralmon@...> wrote:

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