Part Attachment Table/Field

Yahoo Archive
1
> In V.6 :
>
> There are four fields you need to use in the drawings table:
> Drawings.Key1, Drawings.RelatedToFile, Drawings.DrawingSeq and
> Drawings.Filename.

Starting with 8.03, the drawings file was replaced with two files, an
attachment table (XFileAttch) and a file reference table (XFileRef). Each
external file gets a reference number as a key in the XFileRef table. This key
is used in the XFileAttch table to link to various documents in Vantage (sales
orders, parts, customers, purchase orders, etc.) and not just drawings
anymore. We have Document Management so I'm not sure what comes with the core
package. I think you can link but the viewers only come with DM.

It's also worth noting that if a file reference changes, all links are updated
since Epicor normalized the table.

Mark W.
2
Does anyone know the table/field where the attachment filename & menu
path are stored? Go to Part Master>Actions>Attachments. The field I
am looking for is the "File Name" field.

Thanks, John
3
> Does anyone know the table/field where the attachment filename & menu
> path are stored? Go to Part Master>Actions>Attachments. The field I
> am looking for is the "File Name" field.

In V8 anyway, you can view all file attachments using System Management |
Company Management | External File Reference.

I went into the customization and looked at the field properties and it says:

XFileRef.XFileName

Mark W.
4
I found the table.field. It is Drawings.Filename. If you link the
part.partnum to the drawings.key1 then you can create a crystal report
that shows the menu path/file name for all attachments per part number.

I will assume that the secretive "key1" that actually is "partnum" is
so that we face an equal challenge each morning.


>
> I went into the customization and looked at the field properties and
it says:
>
> XFileRef.XFileName
>
> Mark W.
>
5
In V.6 :

There are four fields you need to use in the drawings table:
Drawings.Key1, Drawings.RelatedToFile, Drawings.DrawingSeq and
Drawings.Filename.

Drawings.Key1 ---> The contents of this field can be determined by
first referencing the Drawings.RelatedToFile field. If
Drawings.RelatedToFile equals 'PartRev' then key1 will be a part
number.

Drawings.RelatedToFile ---> This is what tells you what area the
drawing is for... for parts it's 'PartRev' for Jobs it's 'JobHead'

Drawings.DrawingSeq ---> This is the sequence of the drawings

Drawings.Filename ---> This is the complete file path.

Here is an example query:

select
drawingseq,
filename
FROM pub.drawings
WHERE
((relatedtofile='PartRev' AND key1='XXPARTNUMHEREXX') or
(relatedtofile='Jobhead' AND key1='XXJOBNUMHEREXX'))




In version 8 it is a little different you need to join two tables to
get what you need. The two tables are XFileRef and XFileAttch.

XFileRef had the key fields in it and the XFileAttch has the file
data in I can give you more info if you need it just let me know.

Michael Gensel, Web Application Developer
Livonia Tool & Laser
936 Anderson Road
Litchfield, MI 49252
ISO 9001:2000 Registered
Email: michaelg@...
Website: www.livoniatool.com
Phone: 888-875-0833
Fax: 517-542-2427

--- In vantage@yahoogroups.com, "JohnBob" <jholden@...> wrote:
>
> I found the table.field. It is Drawings.Filename. If you link the
> part.partnum to the drawings.key1 then you can create a crystal
report
> that shows the menu path/file name for all attachments per part
number.
>
> I will assume that the secretive "key1" that actually is "partnum"
is
> so that we face an equal challenge each morning.
>
>
> >
> > I went into the customization and looked at the field properties
and
> it says:
> >
> > XFileRef.XFileName
> >
> > Mark W.
> >
>