Difference between Character01, ShortChar01, UserChar01?

The UserChar fields are left over from Vantage 6.1 and prior. They're custom like character01 etc. but appear on some of the screens. In 8.0, they're just another character01-type field.
----- Original Message -----
From: "Robert Brown" <robertb_versa@...>
To: <vantage@yahoogroups.com>
Sent: Friday, June 13, 2008 9:53 AM
Subject: Re: [Vantage] Re: Difference between Character01, ShortChar01, UserChar01 ?


I've yet to see an instance of UserCharXX fields in use natively by the application. When Epicor makes changes and extends the db via some letter or dot patch release, they use the Xref tables as a temporary bridge until a full release incorporates the new table design in full.

As to Views... well they are ALL abstract views to some practical extent. The closest you will get to the 'real' tables is if you work with BPM in its 4GL Progess language.

For all practical purposes, you can treat anything in the data dictionary as a true table. These will have related assemblies and adapters to allow manipulation of the data via customization (or BPM).

You WILL see slight differences in these tables (fields missing or extra fields perviously not seen) depending upon how you are accessign them.

ODBC will often reveal differences between what it publishes and reveals versus the 'canned' tables/views of Crystal Reports or the raw tables/views you can get at via BAQs (or customization). BPM reveals yet another flavor of the tables/views as it exposes the true temporary tables that the applications work with (to prevent transaction/record locking collisions).

Rob Brown

--- On Wed, 6/11/08, Calvin Krusen <ckrusen@...> wrote:

From: Calvin Krusen <ckrusen@...>
Subject: [Vantage] Re: Difference between Character01, ShortChar01, UserChar01 ?
To: vantage@yahoogroups.com
Date: Wednesday, June 11, 2008, 1:19 PM






Thanks Robert,

Someone else had implied that the UserCharxx fields are actually
used by Epicor. Any truth to that?

Using the Data Dictionary Viewer, the QuoteHed table shows the
UserCharxx fields as X(30).

The Characterxx and ShortCharxx don't appear when viewing the
QuoteHed table with the Dictionary Viewer, but they show up as valid
fields I can bind too, while customizing a form.

Are they actually in the QuoteHed table, or are they implemented via
a 'View'(which I don't understand very well, but that's another
topic).

Thanks,

Calvin

--- In vantage@yahoogroups .com, Robert Brown <robertb_versa@ ...>
wrote:
>
> The differences are nothing more than max character lengths.
>
>
> --- On Tue, 6/10/08, Calvin Krusen <ckrusen@... > wrote:
>
> From: Calvin Krusen <ckrusen@... >
> Subject: [Vantage] Difference between Character01, ShortChar01,
UserChar01 ?
> To: vantage@yahoogroups .com
> Date: Tuesday, June 10, 2008, 11:14 AM
>
>
>
>
>
>
> What is the difference between the Character, ShortChar, and
UserChar
> user fields?
>
> Is it just the filed length? Or does UserChar imply that the field
is
> user dependent?
>
> Calvin
>


















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

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]
What is the difference between the Character, ShortChar, and UserChar
user fields?

Is it just the filed length? Or does UserChar imply that the field is
user dependent?

Calvin
The only difference in Character01 and ShortChar01 is the field length.
UserChar01, etc. are used for specific purposes by Vantage. I can't
remember for sure but I think one example if for User defined Check off
Labels. I have avoided using the UserXXXX fields because it was my
understanding they were reserved for Vantage use.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Calvin Krusen
Sent: Tuesday, June 10, 2008 10:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Difference between Character01, ShortChar01,
UserChar01 ?



What is the difference between the Character, ShortChar, and UserChar
user fields?

Is it just the filed length? Or does UserChar imply that the field is
user dependent?

Calvin



Charles Carden
Manager, MIS
Manitex, Inc.
Phone: 512-942-3086
Fax: 512-942-3089


DISCLAIMER:
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.



[Non-text portions of this message have been removed]
The differences are nothing more than max character lengths.


--- On Tue, 6/10/08, Calvin Krusen <ckrusen@...> wrote:

From: Calvin Krusen <ckrusen@...>
Subject: [Vantage] Difference between Character01, ShortChar01, UserChar01 ?
To: vantage@yahoogroups.com
Date: Tuesday, June 10, 2008, 11:14 AM






What is the difference between the Character, ShortChar, and UserChar
user fields?

Is it just the filed length? Or does UserChar imply that the field is
user dependent?

Calvin
Thanks Robert,

Someone else had implied that the UserCharxx fields are actually
used by Epicor. Any truth to that?

Using the Data Dictionary Viewer, the QuoteHed table shows the
UserCharxx fields as X(30).

The Characterxx and ShortCharxx don't appear when viewing the
QuoteHed table with the Dictionary Viewer, but they show up as valid
fields I can bind too, while customizing a form.

Are they actually in the QuoteHed table, or are they implemented via
a 'View'(which I don't understand very well, but that's another
topic).

Thanks,

Calvin


--- In vantage@yahoogroups.com, Robert Brown <robertb_versa@...>
wrote:
>
> The differences are nothing more than max character lengths.
>
>
> --- On Tue, 6/10/08, Calvin Krusen <ckrusen@...> wrote:
>
> From: Calvin Krusen <ckrusen@...>
> Subject: [Vantage] Difference between Character01, ShortChar01,
UserChar01 ?
> To: vantage@yahoogroups.com
> Date: Tuesday, June 10, 2008, 11:14 AM
>
>
>
>
>
>
> What is the difference between the Character, ShortChar, and
UserChar
> user fields?
>
> Is it just the filed length? Or does UserChar imply that the field
is
> user dependent?
>
> Calvin
>
The Data Dictionary Viewer by default doesn't show those other fields.
To view them you have to check the box labeled "Display VB Fields".
According to the data dictionary viewer all three are user defined Fields.

1. UserCharX Format X(30)

2. ShortCharXX Format X(50)

3. CharacterXX Format X(1000)

I have found that Crystal Report Writer cannot use the CharacterXX to
link to other tables and it has a harder time doing any type of data
manipulations on that type of field. I used a Character field to be a
linking key field to another User Defined Table and i got stung later
when trying to write reports. I couldn't use that field to link back
to my user defined table.

Hope that helps.

--- In vantage@yahoogroups.com, "Calvin Krusen" <ckrusen@...> wrote:
>
> Thanks Robert,
>
> Someone else had implied that the UserCharxx fields are actually
> used by Epicor. Any truth to that?
>
> Using the Data Dictionary Viewer, the QuoteHed table shows the
> UserCharxx fields as X(30).
>
> The Characterxx and ShortCharxx don't appear when viewing the
> QuoteHed table with the Dictionary Viewer, but they show up as valid
> fields I can bind too, while customizing a form.
>
> Are they actually in the QuoteHed table, or are they implemented via
> a 'View'(which I don't understand very well, but that's another
> topic).
>
> Thanks,
>
> Calvin
>
>
> --- In vantage@yahoogroups.com, Robert Brown <robertb_versa@>
> wrote:
> >
> > The differences are nothing more than max character lengths.
> >
> >
> > --- On Tue, 6/10/08, Calvin Krusen <ckrusen@> wrote:
> >
> > From: Calvin Krusen <ckrusen@>
> > Subject: [Vantage] Difference between Character01, ShortChar01,
> UserChar01 ?
> > To: vantage@yahoogroups.com
> > Date: Tuesday, June 10, 2008, 11:14 AM
> >
> >
> >
> >
> >
> >
> > What is the difference between the Character, ShortChar, and
> UserChar
> > user fields?
> >
> > Is it just the filed length? Or does UserChar imply that the field
> is
> > user dependent?
> >
> > Calvin
> >
>
I've yet to see an instance of UserCharXX fields in use natively by the application. When Epicor makes changes and extends the db via some letter or dot patch release, they use the Xref tables as a temporary bridge until a full release incorporates the new table design in full.

As to Views... well they are ALL abstract views to some practical extent. The closest you will get to the 'real' tables is if you work with BPM in its 4GL Progess language.

For all practical purposes, you can treat anything in the data dictionary as a true table. These will have related assemblies and adapters to allow manipulation of the data via customization (or BPM).

You WILL see slight differences in these tables (fields missing or extra fields perviously not seen) depending upon how you are accessign them.

ODBC will often reveal differences between what it publishes and reveals versus the 'canned' tables/views of Crystal Reports or the raw tables/views you can get at via BAQs (or customization). BPM reveals yet another flavor of the tables/views as it exposes the true temporary tables that the applications work with (to prevent transaction/record locking collisions).

Rob Brown

--- On Wed, 6/11/08, Calvin Krusen <ckrusen@...> wrote:

From: Calvin Krusen <ckrusen@...>
Subject: [Vantage] Re: Difference between Character01, ShortChar01, UserChar01 ?
To: vantage@yahoogroups.com
Date: Wednesday, June 11, 2008, 1:19 PM






Thanks Robert,

Someone else had implied that the UserCharxx fields are actually
used by Epicor. Any truth to that?

Using the Data Dictionary Viewer, the QuoteHed table shows the
UserCharxx fields as X(30).

The Characterxx and ShortCharxx don't appear when viewing the
QuoteHed table with the Dictionary Viewer, but they show up as valid
fields I can bind too, while customizing a form.

Are they actually in the QuoteHed table, or are they implemented via
a 'View'(which I don't understand very well, but that's another
topic).

Thanks,

Calvin

--- In vantage@yahoogroups .com, Robert Brown <robertb_versa@ ...>
wrote:
>
> The differences are nothing more than max character lengths.
>
>
> --- On Tue, 6/10/08, Calvin Krusen <ckrusen@... > wrote:
>
> From: Calvin Krusen <ckrusen@... >
> Subject: [Vantage] Difference between Character01, ShortChar01,
UserChar01 ?
> To: vantage@yahoogroups .com
> Date: Tuesday, June 10, 2008, 11:14 AM
>
>
>
>
>
>
> What is the difference between the Character, ShortChar, and
UserChar
> user fields?
>
> Is it just the filed length? Or does UserChar imply that the field
is
> user dependent?
>
> Calvin
>