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]