User Defined Fields

Yahoo Archive
1
We use the SQL version of Vantage and have added a SQL table to track the
UDF's we are using by table and field.



Regards,

Paddy Quaite

Director of Purchasing

Nicholson Manufacturing Ltd.

quaiteps@...

250-655-7519 (direct line)

www.nicholsonmfg.com <http://www.debarking.com>





[Non-text portions of this message have been removed]
2
Just a quick question:
Â
We are in the process of defining fields that we will be using for internal use.
Â
Using the Part table as an example, there are several fields that start with "User". I understand that these are allocated for use by the Epicor customers and will never be used in an upgrade by Epicor.
Â
There are several other fields such as ShortChar01 - ShortChar05, Number01 - Number05. Are these fields also allocated for use by t he Epicor customer or are they exclusively for Epicor?
Â
Elaina

[Non-text portions of this message have been removed]
3
All the character01,02..., shortchar01,02..., number01..., date01,02... fields are available for you to use

--- On Wed, 6/24/09, Elaine Gallagher <elaina32@...> wrote:


From: Elaine Gallagher <elaina32@...>
Subject: [Vantage] User Defined Fields
To: vantage@yahoogroups.com
Date: Wednesday, June 24, 2009, 9:26 AM








Just a quick question:
Â
We are in the process of defining fields that we will be using for internal use.
Â
Using the Part table as an example, there are several fields that start with "User". I understand that these are allocated for use by the Epicor customers and will never be used in an upgrade by Epicor.
Â
There are several other fields such as ShortChar01 - ShortChar05, Number01 - Number05. Are these fields also allocated for use by t he Epicor customer or are they exclusively for Epicor?
Â
Elaina

[Non-text portions of this message have been removed]



















[Non-text portions of this message have been removed]
4
When using UD fields, is there a way to track which ones have been previously used? In addition, is there any way to rename the fields so when you are creating reports you know which field is which?

Thanks in advance for the help.

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-716-6400 (office)
+1 513-382-3281 (mobile)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@01CA530F.02982260]



[Non-text portions of this message have been removed]
5
I keep a list of fields I've used in Sharepoint. Vantage doesn't give you a way to track this.

I write BAQs against the UD fields and change the labels in the BAQ as needed. Then you can use the ReportLabels in the BAQ Report.

You definitely will want to create your own data dictionary so you know what those fields mean. Otherwise you can create problems for yourself.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Michelle de la Vega
Sent: Thursday, October 22, 2009 11:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] User Defined Fields

When using UD fields, is there a way to track which ones have been previously used? In addition, is there any way to rename the fields so when you are creating reports you know which field is which?

Thanks in advance for the help.

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-716-6400 (office)
+1 513-382-3281 (mobile)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@01CA530F.02982260]



[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
6
Michelle,

The only way I manage/track the UD fields I've used is via an Excel
spreadsheet. I keep a worksheet for each standard table I use any UD
fields in. I'll put the actual field name (JobHead.ShorChar01) and a
description of what I use it for.

And, unfortunately, you cannot and should not change the field names.
It is up to you, when creating reports, to identify which UD fields are
what....



Vic


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michelle de la Vega
Sent: Thursday, October 22, 2009 11:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] User Defined Fields

When using UD fields, is there a way to track which ones have been
previously used? In addition, is there any way to rename the fields so
when you are creating reports you know which field is which?

Thanks in advance for the help.

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-716-6400 (office)
+1 513-382-3281 (mobile)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@01CA530F.02982260]



[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links