UD Character fields

Reference AnswerBook 12490MPS. This explains the process needed to add more fields to a table.



________________________________
From: Sigfredo Diaz <sdiaz@...>
To: vantage@yahoogroups.com
Sent: Thursday, May 23, 2013 4:30 PM
Subject: RE: [Vantage] UD Character fields


Hi Jose,

I see this in Utilities, "Extended User Defined Table Maintenance -
Table". This supposedly creates a table that is linked to the Epicor
table. Have you used this successfully?

Regards,
Sigfredo.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Thursday, May 23, 2013 3:56 PM
To: Vantage
Subject: Re: [Vantage] UD Character fields

There is a built in function in 9.05 Under System management -> Utils->
Extended User Defined Or something of the sort which basically allows
you to create an unlimited number of fields on any table.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
 <http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
 <http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
 <http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Thu, May 23, 2013 at 3:52 PM, Sigfredo Diaz
<sdiaz@...>wrote:

> **
>
>
> Hi Jose,
>
> What version do you have that is unlimited fields? We have 9.05.605,
> and we have the same 10 Character fields as Paul mentioned below. I am

> aware that from a licensing standpoint, you can buy a version of
> Epicor where you can extend the fields in a database table, but
> supposedly that is at a much higher price point. The only other way,
> we were able to do it was to have our VAR add Extended UD tables and
use those fields.
>
> Regards,
> Sigfredo.
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of Jose Gomez
> Sent: Thursday, May 23, 2013 3:47 PM
> To: Vantage
> Subject: Re: [Vantage] UD Character fields
>
> you have unlimited fields in 9.05
> On May 23, 2013 3:35 PM, "Paul Pachniak"
> <paul.pachniak@...>
> wrote:
>
> > **
>
> >
> >
> > Hi all,
> >
> > We are currently on 8.03.410 and were wondering if they increased
> > the number of UD fields available for use in 9.05, for instance we
> > have 10
>
> > Character fields in the Part table and were wondering if there any
> > more in the new versions as we have pretty much used up the 10 now
> available.
> >
> > Paul E. Pachniak
> > Controller
> > Ace Precision Machining Corporation
> > W146 N5714 Enterprise Avenue
> > Menomonee Falls, WI, 53051-5916
> > Phone: 262-252-4003 Ext. 3114
> > Fax: 262-252-4974
> > Email: paul.pachniak@...
> > WWW: www.aceprecision.com<http://www.aceprecision.com/>
> >
> > [cid:image001.png@01CE57C2.8CD3B640]
> >
> > NOTICE: THIS MESSAGE CONTAINS THE PROPRIETARY AND CONFIDENTIAL
> > INFORMATION OF ACE PRECISION MACHINING CORP. If you are an
> > unintended recipient, immediately (1) delete all copies of this
> > message and any attachments, and
> > (2) contact the sender. If you are an intended recipient, you are
> > prohibited from deleting or obstructing this or any other Ace
> > Precision Machining Corp. proprietary or confidentiality designation

> > that appears on this message or any attachments. All recipients are
> > prohibited from reproducing, publishing or disclosing the contents
> > of this message and any attachments to others, unless you first
> > request and receive written permission from Ace Precision Machining
Corp.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [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
>

>


[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






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

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



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

We are currently on 8.03.410 and were wondering if they increased the number of UD fields available for use in 9.05, for instance we have 10 Character fields in the Part table and were wondering if there any more in the new versions as we have pretty much used up the 10 now available.

Paul E. Pachniak
Controller
Ace Precision Machining Corporation
W146 N5714 Enterprise Avenue
Menomonee Falls, WI, 53051-5916
Phone: 262-252-4003 Ext. 3114
Fax: 262-252-4974
Email: paul.pachniak@...
WWW: www.aceprecision.com<http://www.aceprecision.com/>

[cid:image001.png@01CE57C2.8CD3B640]







NOTICE: THIS MESSAGE CONTAINS THE PROPRIETARY AND CONFIDENTIAL INFORMATION OF ACE PRECISION MACHINING CORP. If you are an unintended recipient, immediately (1) delete all copies of this message and any attachments, and (2) contact the sender. If you are an intended recipient, you are prohibited from deleting or obstructing this or any other Ace Precision Machining Corp. proprietary or confidentiality designation that appears on this message or any attachments. All recipients are prohibited from reproducing, publishing or disclosing the contents of this message and any attachments to others, unless you first request and receive written permission from Ace Precision Machining Corp.


[Non-text portions of this message have been removed]
you have unlimited fields in 9.05
On May 23, 2013 3:35 PM, "Paul Pachniak" <paul.pachniak@...>
wrote:

> **
>
>
> Hi all,
>
> We are currently on 8.03.410 and were wondering if they increased the
> number of UD fields available for use in 9.05, for instance we have 10
> Character fields in the Part table and were wondering if there any more in
> the new versions as we have pretty much used up the 10 now available.
>
> Paul E. Pachniak
> Controller
> Ace Precision Machining Corporation
> W146 N5714 Enterprise Avenue
> Menomonee Falls, WI, 53051-5916
> Phone: 262-252-4003 Ext. 3114
> Fax: 262-252-4974
> Email: paul.pachniak@...
> WWW: www.aceprecision.com<http://www.aceprecision.com/>
>
> [cid:image001.png@01CE57C2.8CD3B640]
>
> NOTICE: THIS MESSAGE CONTAINS THE PROPRIETARY AND CONFIDENTIAL INFORMATION
> OF ACE PRECISION MACHINING CORP. If you are an unintended recipient,
> immediately (1) delete all copies of this message and any attachments, and
> (2) contact the sender. If you are an intended recipient, you are
> prohibited from deleting or obstructing this or any other Ace Precision
> Machining Corp. proprietary or confidentiality designation that appears on
> this message or any attachments. All recipients are prohibited from
> reproducing, publishing or disclosing the contents of this message and any
> attachments to others, unless you first request and receive written
> permission from Ace Precision Machining Corp.
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
Did you also use the 10 ShortChar fields? Or did you not know you could also use those (if under 50 characters)

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Paul Pachniak
Sent: Thursday, May 23, 2013 2:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] UD Character fields



Hi all,

We are currently on 8.03.410 and were wondering if they increased the number of UD fields available for use in 9.05, for instance we have 10 Character fields in the Part table and were wondering if there any more in the new versions as we have pretty much used up the 10 now available.

Paul E. Pachniak
Controller
Ace Precision Machining Corporation
W146 N5714 Enterprise Avenue
Menomonee Falls, WI, 53051-5916
Phone: 262-252-4003 Ext. 3114
Fax: 262-252-4974
Email: paul.pachniak@...<mailto:paul.pachniak%40aceprecision.com>
WWW: www.aceprecision.com<http://www.aceprecision.com/>

[cid:image001.png@01CE57C2.8CD3B640<mailto:image001.png%4001CE57C2.8CD3B640>]

NOTICE: THIS MESSAGE CONTAINS THE PROPRIETARY AND CONFIDENTIAL INFORMATION OF ACE PRECISION MACHINING CORP. If you are an unintended recipient, immediately (1) delete all copies of this message and any attachments, and (2) contact the sender. If you are an intended recipient, you are prohibited from deleting or obstructing this or any other Ace Precision Machining Corp. proprietary or confidentiality designation that appears on this message or any attachments. All recipients are prohibited from reproducing, publishing or disclosing the contents of this message and any attachments to others, unless you first request and receive written permission from Ace Precision Machining Corp.

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



[Non-text portions of this message have been removed]
With Extended UD Tables you mean?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Thursday, May 23, 2013 3:47 PM
To: Vantage
Subject: Re: [Vantage] UD Character fields

you have unlimited fields in 9.05
On May 23, 2013 3:35 PM, "Paul Pachniak" <paul.pachniak@...>
wrote:

> **
>
>
> Hi all,
>
> We are currently on 8.03.410 and were wondering if they increased the
> number of UD fields available for use in 9.05, for instance we have 10
> Character fields in the Part table and were wondering if there any more in
> the new versions as we have pretty much used up the 10 now available.
>
> Paul E. Pachniak
> Controller
> Ace Precision Machining Corporation
> W146 N5714 Enterprise Avenue
> Menomonee Falls, WI, 53051-5916
> Phone: 262-252-4003 Ext. 3114
> Fax: 262-252-4974
> Email: paul.pachniak@...
> WWW: www.aceprecision.com<http://www.aceprecision.com/>
>
> [cid:image001.png@01CE57C2.8CD3B640]
>
> NOTICE: THIS MESSAGE CONTAINS THE PROPRIETARY AND CONFIDENTIAL INFORMATION
> OF ACE PRECISION MACHINING CORP. If you are an unintended recipient,
> immediately (1) delete all copies of this message and any attachments, and
> (2) contact the sender. If you are an intended recipient, you are
> prohibited from deleting or obstructing this or any other Ace Precision
> Machining Corp. proprietary or confidentiality designation that appears on
> this message or any attachments. All recipients are prohibited from
> reproducing, publishing or disclosing the contents of this message and any
> attachments to others, unless you first request and receive written
> permission from Ace Precision Machining Corp.
>
> [Non-text portions of this message have been removed]
>
>
>


[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
Hi Jose,

What version do you have that is unlimited fields? We have 9.05.605,
and we have the same 10 Character fields as Paul mentioned below. I am
aware that from a licensing standpoint, you can buy a version of Epicor
where you can extend the fields in a database table, but supposedly that
is at a much higher price point. The only other way, we were able to do
it was to have our VAR add Extended UD tables and use those fields.

Regards,
Sigfredo.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Thursday, May 23, 2013 3:47 PM
To: Vantage
Subject: Re: [Vantage] UD Character fields

you have unlimited fields in 9.05
On May 23, 2013 3:35 PM, "Paul Pachniak"
<paul.pachniak@...>
wrote:

> **
>
>
> Hi all,
>
> We are currently on 8.03.410 and were wondering if they increased the
> number of UD fields available for use in 9.05, for instance we have 10

> Character fields in the Part table and were wondering if there any
> more in the new versions as we have pretty much used up the 10 now
available.
>
> Paul E. Pachniak
> Controller
> Ace Precision Machining Corporation
> W146 N5714 Enterprise Avenue
> Menomonee Falls, WI, 53051-5916
> Phone: 262-252-4003 Ext. 3114
> Fax: 262-252-4974
> Email: paul.pachniak@...
> WWW: www.aceprecision.com<http://www.aceprecision.com/>
>
> [cid:image001.png@01CE57C2.8CD3B640]
>
> NOTICE: THIS MESSAGE CONTAINS THE PROPRIETARY AND CONFIDENTIAL
> INFORMATION OF ACE PRECISION MACHINING CORP. If you are an unintended
> recipient, immediately (1) delete all copies of this message and any
> attachments, and
> (2) contact the sender. If you are an intended recipient, you are
> prohibited from deleting or obstructing this or any other Ace
> Precision Machining Corp. proprietary or confidentiality designation
> that appears on this message or any attachments. All recipients are
> prohibited from reproducing, publishing or disclosing the contents of
> this message and any attachments to others, unless you first request
> and receive written permission from Ace Precision Machining Corp.
>
> [Non-text portions of this message have been removed]
>
>
>


[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
There is a built in function in 9.05 Under System management -> Utils->
Extended User Defined Or something of the sort which basically allows you
to create an unlimited number of fields on any table.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Thu, May 23, 2013 at 3:52 PM, Sigfredo Diaz <sdiaz@...>wrote:

> **
>
>
> Hi Jose,
>
> What version do you have that is unlimited fields? We have 9.05.605,
> and we have the same 10 Character fields as Paul mentioned below. I am
> aware that from a licensing standpoint, you can buy a version of Epicor
> where you can extend the fields in a database table, but supposedly that
> is at a much higher price point. The only other way, we were able to do
> it was to have our VAR add Extended UD tables and use those fields.
>
> Regards,
> Sigfredo.
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Jose Gomez
> Sent: Thursday, May 23, 2013 3:47 PM
> To: Vantage
> Subject: Re: [Vantage] UD Character fields
>
> you have unlimited fields in 9.05
> On May 23, 2013 3:35 PM, "Paul Pachniak"
> <paul.pachniak@...>
> wrote:
>
> > **
>
> >
> >
> > Hi all,
> >
> > We are currently on 8.03.410 and were wondering if they increased the
> > number of UD fields available for use in 9.05, for instance we have 10
>
> > Character fields in the Part table and were wondering if there any
> > more in the new versions as we have pretty much used up the 10 now
> available.
> >
> > Paul E. Pachniak
> > Controller
> > Ace Precision Machining Corporation
> > W146 N5714 Enterprise Avenue
> > Menomonee Falls, WI, 53051-5916
> > Phone: 262-252-4003 Ext. 3114
> > Fax: 262-252-4974
> > Email: paul.pachniak@...
> > WWW: www.aceprecision.com<http://www.aceprecision.com/>
> >
> > [cid:image001.png@01CE57C2.8CD3B640]
> >
> > NOTICE: THIS MESSAGE CONTAINS THE PROPRIETARY AND CONFIDENTIAL
> > INFORMATION OF ACE PRECISION MACHINING CORP. If you are an unintended
> > recipient, immediately (1) delete all copies of this message and any
> > attachments, and
> > (2) contact the sender. If you are an intended recipient, you are
> > prohibited from deleting or obstructing this or any other Ace
> > Precision Machining Corp. proprietary or confidentiality designation
> > that appears on this message or any attachments. All recipients are
> > prohibited from reproducing, publishing or disclosing the contents of
> > this message and any attachments to others, unless you first request
> > and receive written permission from Ace Precision Machining Corp.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [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
>
>
>


[Non-text portions of this message have been removed]
Sounds like you're talking about Extended UD Tables. It's a great idea and I know there are some with 9.05.XX that use it. We can't because there's some bug with 607A.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Thursday, May 23, 2013 3:56 PM
To: Vantage
Subject: Re: [Vantage] UD Character fields

There is a built in function in 9.05 Under System management -> Utils->
Extended User Defined Or something of the sort which basically allows you
to create an unlimited number of fields on any table.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Thu, May 23, 2013 at 3:52 PM, Sigfredo Diaz <sdiaz@...>wrote:

> **
>
>
> Hi Jose,
>
> What version do you have that is unlimited fields? We have 9.05.605,
> and we have the same 10 Character fields as Paul mentioned below. I am
> aware that from a licensing standpoint, you can buy a version of Epicor
> where you can extend the fields in a database table, but supposedly that
> is at a much higher price point. The only other way, we were able to do
> it was to have our VAR add Extended UD tables and use those fields.
>
> Regards,
> Sigfredo.
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Jose Gomez
> Sent: Thursday, May 23, 2013 3:47 PM
> To: Vantage
> Subject: Re: [Vantage] UD Character fields
>
> you have unlimited fields in 9.05
> On May 23, 2013 3:35 PM, "Paul Pachniak"
> <paul.pachniak@...>
> wrote:
>
> > **
>
> >
> >
> > Hi all,
> >
> > We are currently on 8.03.410 and were wondering if they increased the
> > number of UD fields available for use in 9.05, for instance we have 10
>
> > Character fields in the Part table and were wondering if there any
> > more in the new versions as we have pretty much used up the 10 now
> available.
> >
> > Paul E. Pachniak
> > Controller
> > Ace Precision Machining Corporation
> > W146 N5714 Enterprise Avenue
> > Menomonee Falls, WI, 53051-5916
> > Phone: 262-252-4003 Ext. 3114
> > Fax: 262-252-4974
> > Email: paul.pachniak@...
> > WWW: www.aceprecision.com<http://www.aceprecision.com/>
> >
> > [cid:image001.png@01CE57C2.8CD3B640]
> >
> > NOTICE: THIS MESSAGE CONTAINS THE PROPRIETARY AND CONFIDENTIAL
> > INFORMATION OF ACE PRECISION MACHINING CORP. If you are an unintended
> > recipient, immediately (1) delete all copies of this message and any
> > attachments, and
> > (2) contact the sender. If you are an intended recipient, you are
> > prohibited from deleting or obstructing this or any other Ace
> > Precision Machining Corp. proprietary or confidentiality designation
> > that appears on this message or any attachments. All recipients are
> > prohibited from reproducing, publishing or disclosing the contents of
> > this message and any attachments to others, unless you first request
> > and receive written permission from Ace Precision Machining Corp.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [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
>
>
>


[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
The last I knew, there were still some problems with these fields. I don't
recall all the specifics, but I believe you had problems accessing these in
ABL code if you needed to. Physically, they're not part of the core table,
they're stored in an extended table and linked by primary key. Again,
working from memory here, I believe the problem was the ABL code didn't
recognize the extended tables so you couldn't validate/save code if you
tried to access these. Perhaps this is fixed in the later versions - I
haven't tried it recently.

Kevin Simon

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jose Gomez
Sent: Thursday, May 23, 2013 3:56 PM
To: Vantage
Subject: Re: [Vantage] UD Character fields

There is a built in function in 9.05 Under System management -> Utils->
Extended User Defined Or something of the sort which basically allows you to
create an unlimited number of fields on any table.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Thu, May 23, 2013 at 3:52 PM, Sigfredo Diaz <sdiaz@...>wrote:

> **
>
>
> Hi Jose,
>
> What version do you have that is unlimited fields? We have 9.05.605,
> and we have the same 10 Character fields as Paul mentioned below. I am
> aware that from a licensing standpoint, you can buy a version of
> Epicor where you can extend the fields in a database table, but
> supposedly that is at a much higher price point. The only other way,
> we were able to do it was to have our VAR add Extended UD tables and use
those fields.
>
> Regards,
> Sigfredo.
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of Jose Gomez
> Sent: Thursday, May 23, 2013 3:47 PM
> To: Vantage
> Subject: Re: [Vantage] UD Character fields
>
> you have unlimited fields in 9.05
> On May 23, 2013 3:35 PM, "Paul Pachniak"
> <paul.pachniak@...>
> wrote:
>
> > **
>
> >
> >
> > Hi all,
> >
> > We are currently on 8.03.410 and were wondering if they increased
> > the number of UD fields available for use in 9.05, for instance we
> > have 10
>
> > Character fields in the Part table and were wondering if there any
> > more in the new versions as we have pretty much used up the 10 now
> available.
> >
> > Paul E. Pachniak
> > Controller
> > Ace Precision Machining Corporation
> > W146 N5714 Enterprise Avenue
> > Menomonee Falls, WI, 53051-5916
> > Phone: 262-252-4003 Ext. 3114
> > Fax: 262-252-4974
> > Email: paul.pachniak@...
> > WWW: www.aceprecision.com<http://www.aceprecision.com/>
> >
> > [cid:image001.png@01CE57C2.8CD3B640]
> >
> > NOTICE: THIS MESSAGE CONTAINS THE PROPRIETARY AND CONFIDENTIAL
> > INFORMATION OF ACE PRECISION MACHINING CORP. If you are an
> > unintended recipient, immediately (1) delete all copies of this
> > message and any attachments, and
> > (2) contact the sender. If you are an intended recipient, you are
> > prohibited from deleting or obstructing this or any other Ace
> > Precision Machining Corp. proprietary or confidentiality designation
> > that appears on this message or any attachments. All recipients are
> > prohibited from reproducing, publishing or disclosing the contents
> > of this message and any attachments to others, unless you first
> > request and receive written permission from Ace Precision Machining
Corp.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [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
>
>
>


[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
If you run the Update UD Extended Tables conversion or menu item in Admin
Tools it should be recognized justfine. It actually creates a Table (at
least in SQL) and links them over the rowid.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Thu, May 23, 2013 at 4:07 PM, SimsTrak Consulting <simstrak@...>wrote:

> **
>
>
> The last I knew, there were still some problems with these fields. I don't
> recall all the specifics, but I believe you had problems accessing these in
> ABL code if you needed to. Physically, they're not part of the core table,
> they're stored in an extended table and linked by primary key. Again,
> working from memory here, I believe the problem was the ABL code didn't
> recognize the extended tables so you couldn't validate/save code if you
> tried to access these. Perhaps this is fixed in the later versions - I
> haven't tried it recently.
>
> Kevin Simon
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of
> Jose Gomez
> Sent: Thursday, May 23, 2013 3:56 PM
> To: Vantage
> Subject: Re: [Vantage] UD Character fields
>
> There is a built in function in 9.05 Under System management -> Utils->
> Extended User Defined Or something of the sort which basically allows you
> to
> create an unlimited number of fields on any table.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
>
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez
> >
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
> On Thu, May 23, 2013 at 3:52 PM, Sigfredo Diaz <sdiaz@...
> >wrote:
>
> > **
>
> >
> >
> > Hi Jose,
> >
> > What version do you have that is unlimited fields? We have 9.05.605,
> > and we have the same 10 Character fields as Paul mentioned below. I am
> > aware that from a licensing standpoint, you can buy a version of
> > Epicor where you can extend the fields in a database table, but
> > supposedly that is at a much higher price point. The only other way,
> > we were able to do it was to have our VAR add Extended UD tables and use
> those fields.
> >
> > Regards,
> > Sigfredo.
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of Jose Gomez
> > Sent: Thursday, May 23, 2013 3:47 PM
> > To: Vantage
> > Subject: Re: [Vantage] UD Character fields
> >
> > you have unlimited fields in 9.05
> > On May 23, 2013 3:35 PM, "Paul Pachniak"
> > <paul.pachniak@...>
> > wrote:
> >
> > > **
> >
> > >
> > >
> > > Hi all,
> > >
> > > We are currently on 8.03.410 and were wondering if they increased
> > > the number of UD fields available for use in 9.05, for instance we
> > > have 10
> >
> > > Character fields in the Part table and were wondering if there any
> > > more in the new versions as we have pretty much used up the 10 now
> > available.
> > >
> > > Paul E. Pachniak
> > > Controller
> > > Ace Precision Machining Corporation
> > > W146 N5714 Enterprise Avenue
> > > Menomonee Falls, WI, 53051-5916
> > > Phone: 262-252-4003 Ext. 3114
> > > Fax: 262-252-4974
> > > Email: paul.pachniak@...
> > > WWW: www.aceprecision.com<http://www.aceprecision.com/>
> > >
> > > [cid:image001.png@01CE57C2.8CD3B640]
> > >
> > > NOTICE: THIS MESSAGE CONTAINS THE PROPRIETARY AND CONFIDENTIAL
> > > INFORMATION OF ACE PRECISION MACHINING CORP. If you are an
> > > unintended recipient, immediately (1) delete all copies of this
> > > message and any attachments, and
> > > (2) contact the sender. If you are an intended recipient, you are
> > > prohibited from deleting or obstructing this or any other Ace
> > > Precision Machining Corp. proprietary or confidentiality designation
> > > that appears on this message or any attachments. All recipients are
> > > prohibited from reproducing, publishing or disclosing the contents
> > > of this message and any attachments to others, unless you first
> > > request and receive written permission from Ace Precision Machining
> Corp.
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> > [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
> >
> >
> >
>
> [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
>
>
>


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

I see this in Utilities, "Extended User Defined Table Maintenance -
Table". This supposedly creates a table that is linked to the Epicor
table. Have you used this successfully?

Regards,
Sigfredo.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Thursday, May 23, 2013 3:56 PM
To: Vantage
Subject: Re: [Vantage] UD Character fields

There is a built in function in 9.05 Under System management -> Utils->
Extended User Defined Or something of the sort which basically allows
you to create an unlimited number of fields on any table.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Thu, May 23, 2013 at 3:52 PM, Sigfredo Diaz
<sdiaz@...>wrote:

> **
>
>
> Hi Jose,
>
> What version do you have that is unlimited fields? We have 9.05.605,
> and we have the same 10 Character fields as Paul mentioned below. I am

> aware that from a licensing standpoint, you can buy a version of
> Epicor where you can extend the fields in a database table, but
> supposedly that is at a much higher price point. The only other way,
> we were able to do it was to have our VAR add Extended UD tables and
use those fields.
>
> Regards,
> Sigfredo.
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of Jose Gomez
> Sent: Thursday, May 23, 2013 3:47 PM
> To: Vantage
> Subject: Re: [Vantage] UD Character fields
>
> you have unlimited fields in 9.05
> On May 23, 2013 3:35 PM, "Paul Pachniak"
> <paul.pachniak@...>
> wrote:
>
> > **
>
> >
> >
> > Hi all,
> >
> > We are currently on 8.03.410 and were wondering if they increased
> > the number of UD fields available for use in 9.05, for instance we
> > have 10
>
> > Character fields in the Part table and were wondering if there any
> > more in the new versions as we have pretty much used up the 10 now
> available.
> >
> > Paul E. Pachniak
> > Controller
> > Ace Precision Machining Corporation
> > W146 N5714 Enterprise Avenue
> > Menomonee Falls, WI, 53051-5916
> > Phone: 262-252-4003 Ext. 3114
> > Fax: 262-252-4974
> > Email: paul.pachniak@...
> > WWW: www.aceprecision.com<http://www.aceprecision.com/>
> >
> > [cid:image001.png@01CE57C2.8CD3B640]
> >
> > NOTICE: THIS MESSAGE CONTAINS THE PROPRIETARY AND CONFIDENTIAL
> > INFORMATION OF ACE PRECISION MACHINING CORP. If you are an
> > unintended recipient, immediately (1) delete all copies of this
> > message and any attachments, and
> > (2) contact the sender. If you are an intended recipient, you are
> > prohibited from deleting or obstructing this or any other Ace
> > Precision Machining Corp. proprietary or confidentiality designation

> > that appears on this message or any attachments. All recipients are
> > prohibited from reproducing, publishing or disclosing the contents
> > of this message and any attachments to others, unless you first
> > request and receive written permission from Ace Precision Machining
Corp.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [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
>
>
>


[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
True statement

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Thursday, May 23, 2013 2:47 PM
To: Vantage
Subject: Re: [Vantage] UD Character fields

you have unlimited fields in 9.05
On May 23, 2013 3:35 PM, "Paul Pachniak" <paul.pachniak@...>
wrote:

> **
>
>
> Hi all,
>
> We are currently on 8.03.410 and were wondering if they increased the
> number of UD fields available for use in 9.05, for instance we have 10
> Character fields in the Part table and were wondering if there any
> more in the new versions as we have pretty much used up the 10 now available.
>
> Paul E. Pachniak
> Controller
> Ace Precision Machining Corporation
> W146 N5714 Enterprise Avenue
> Menomonee Falls, WI, 53051-5916
> Phone: 262-252-4003 Ext. 3114
> Fax: 262-252-4974
> Email: paul.pachniak@...
> WWW: www.aceprecision.com<http://www.aceprecision.com/>
>
> [cid:image001.png@01CE57C2.8CD3B640]
>
> NOTICE: THIS MESSAGE CONTAINS THE PROPRIETARY AND CONFIDENTIAL
> INFORMATION OF ACE PRECISION MACHINING CORP. If you are an unintended
> recipient, immediately (1) delete all copies of this message and any
> attachments, and
> (2) contact the sender. If you are an intended recipient, you are
> prohibited from deleting or obstructing this or any other Ace
> Precision Machining Corp. proprietary or confidentiality designation
> that appears on this message or any attachments. All recipients are
> prohibited from reproducing, publishing or disclosing the contents of
> this message and any attachments to others, unless you first request
> and receive written permission from Ace Precision Machining Corp.
>
> [Non-text portions of this message have been removed]
>
>
>


[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
Yes I use it all the time.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Thu, May 23, 2013 at 4:39 PM, Rob Bucek <rbucek@...> wrote:

> **
>
>
> True statement
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Jose Gomez
> Sent: Thursday, May 23, 2013 2:47 PM
> To: Vantage
> Subject: Re: [Vantage] UD Character fields
>
> you have unlimited fields in 9.05
> On May 23, 2013 3:35 PM, "Paul Pachniak" <paul.pachniak@...>
> wrote:
>
> > **
>
> >
> >
> > Hi all,
> >
> > We are currently on 8.03.410 and were wondering if they increased the
> > number of UD fields available for use in 9.05, for instance we have 10
> > Character fields in the Part table and were wondering if there any
> > more in the new versions as we have pretty much used up the 10 now
> available.
> >
> > Paul E. Pachniak
> > Controller
> > Ace Precision Machining Corporation
> > W146 N5714 Enterprise Avenue
> > Menomonee Falls, WI, 53051-5916
> > Phone: 262-252-4003 Ext. 3114
> > Fax: 262-252-4974
> > Email: paul.pachniak@...
> > WWW: www.aceprecision.com<http://www.aceprecision.com/>
> >
> > [cid:image001.png@01CE57C2.8CD3B640]
> >
> > NOTICE: THIS MESSAGE CONTAINS THE PROPRIETARY AND CONFIDENTIAL
> > INFORMATION OF ACE PRECISION MACHINING CORP. If you are an unintended
> > recipient, immediately (1) delete all copies of this message and any
> > attachments, and
> > (2) contact the sender. If you are an intended recipient, you are
> > prohibited from deleting or obstructing this or any other Ace
> > Precision Machining Corp. proprietary or confidentiality designation
> > that appears on this message or any attachments. All recipients are
> > prohibited from reproducing, publishing or disclosing the contents of
> > this message and any attachments to others, unless you first request
> > and receive written permission from Ace Precision Machining Corp.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [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
>
>
>


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