Can't find the tax fields in E9

I'm going tru all messages on this group since i temporary sttoped reading
and i found this messgae

Thanks i see the info there in the PatchFld table
Who knows what else is stored in this table for other tables
I have more than 400k records there

Ephraim


On Mon, Oct 15, 2012 at 2:15 PM, b_ordway <cooner_55421@...> wrote:

> **
>
>
> Epicor tech just sent me sent me a tech tip for the same issue - 13864ESC.
>
> Looks like 9.05 uses a table called "PatchFld"
> In a BAQ criteria add tablename = "taxrate"
> The field is datadecimal.
> The foreignkey field is multivalue - delimited with tildes.
>
>
> --- In vantage@yahoogroups.com, Ephraim Feldman <effgroups@...> wrote:
> >
> > Im with Epicor support on the phone 40 min and they have no idea where to
> > find it.......
> >
> >
> >
> >
> > On Thu, Jan 26, 2012 at 7:15 PM, Ephraim Feldman <effgroups@...>wrote:
>
> >
> > > I tried to look all over
> > >
> > > maybe someone can help here
> > >
> > > where is the tax rate by date stored
> > > in the taxrate table there is a field but its 0
> > >
> > >
> > >
> > > On Wed, Aug 11, 2010 at 9:40 PM, leann_37 <lmarruffo@...> wrote:
> > >
> > >> **
>
> > >>
> > >>
> > >> All,
> > >> Where does the Effective tax rate percentage (from tax type
> maintenance)
> > >> reside in the database? I have poked around all over, and can't find
> it. It
> > >> says it's in TaxRate.DspTaxPercent, but that column apparently doesn't
> > >> really exist (per the data dictionary and SQL), and the % tax rate
> column
> > >> that is in the table equal zero, despite displaying 6.25 on the GUI.
> > >> Any assistance would be appreciated.
> > >> Thanks in advance!
> > >> - leAnn
> > >>
> > >>
> > >>
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
All,
Where does the Effective tax rate percentage (from tax type maintenance) reside in the database? I have poked around all over, and can't find it. It says it's in TaxRate.DspTaxPercent, but that column apparently doesn't really exist (per the data dictionary and SQL), and the % tax rate column that is in the table equal zero, despite displaying 6.25 on the GUI.
Any assistance would be appreciated.
Thanks in advance!
- leAnn
I tried to look all over

maybe someone can help here

where is the tax rate by date stored
in the taxrate table there is a field but its 0


On Wed, Aug 11, 2010 at 9:40 PM, leann_37 <lmarruffo@...> wrote:

> **
>
>
> All,
> Where does the Effective tax rate percentage (from tax type maintenance)
> reside in the database? I have poked around all over, and can't find it. It
> says it's in TaxRate.DspTaxPercent, but that column apparently doesn't
> really exist (per the data dictionary and SQL), and the % tax rate column
> that is in the table equal zero, despite displaying 6.25 on the GUI.
> Any assistance would be appreciated.
> Thanks in advance!
> - leAnn
>
>
>


[Non-text portions of this message have been removed]
Im with Epicor support on the phone 40 min and they have no idea where to
find it.......




On Thu, Jan 26, 2012 at 7:15 PM, Ephraim Feldman <effgroups@...>wrote:

> I tried to look all over
>
> maybe someone can help here
>
> where is the tax rate by date stored
> in the taxrate table there is a field but its 0
>
>
>
> On Wed, Aug 11, 2010 at 9:40 PM, leann_37 <lmarruffo@...> wrote:
>
>> **
>>
>>
>> All,
>> Where does the Effective tax rate percentage (from tax type maintenance)
>> reside in the database? I have poked around all over, and can't find it. It
>> says it's in TaxRate.DspTaxPercent, but that column apparently doesn't
>> really exist (per the data dictionary and SQL), and the % tax rate column
>> that is in the table equal zero, despite displaying 6.25 on the GUI.
>> Any assistance would be appreciated.
>> Thanks in advance!
>> - leAnn
>>
>>
>>
>
>


[Non-text portions of this message have been removed]
If you're looking at it in a screen, right click on the label for that
field, choose field help, technical details, and look at DB field. Or
if you're customizing a screen, looking at EpiBinding in the field
properties.

Brian.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ephraim Feldman
Sent: Friday, January 27, 2012 10:07 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] can't find the tax fields in E9

Im with Epicor support on the phone 40 min and they have no idea where
to
find it.......




On Thu, Jan 26, 2012 at 7:15 PM, Ephraim Feldman
<effgroups@...>wrote:

> I tried to look all over
>
> maybe someone can help here
>
> where is the tax rate by date stored
> in the taxrate table there is a field but its 0
>
>
>
> On Wed, Aug 11, 2010 at 9:40 PM, leann_37 <lmarruffo@...>
wrote:
>
>> **
>>
>>
>> All,
>> Where does the Effective tax rate percentage (from tax type
maintenance)
>> reside in the database? I have poked around all over, and can't find
it. It
>> says it's in TaxRate.DspTaxPercent, but that column apparently
doesn't
>> really exist (per the data dictionary and SQL), and the % tax rate
column
>> that is in the table equal zero, despite displaying 6.25 on the GUI.
>> Any assistance would be appreciated.
>> Thanks in advance!
>> - leAnn
>>
>>
>>
>
>


[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
Epicor tech just sent me sent me a tech tip for the same issue - 13864ESC.

Looks like 9.05 uses a table called "PatchFld"
In a BAQ criteria add tablename = "taxrate"
The field is datadecimal.
The foreignkey field is multivalue - delimited with tildes.

--- In vantage@yahoogroups.com, Ephraim Feldman <effgroups@...> wrote:
>
> Im with Epicor support on the phone 40 min and they have no idea where to
> find it.......
>
>
>
>
> On Thu, Jan 26, 2012 at 7:15 PM, Ephraim Feldman <effgroups@...>wrote:
>
> > I tried to look all over
> >
> > maybe someone can help here
> >
> > where is the tax rate by date stored
> > in the taxrate table there is a field but its 0
> >
> >
> >
> > On Wed, Aug 11, 2010 at 9:40 PM, leann_37 <lmarruffo@...> wrote:
> >
> >> **
> >>
> >>
> >> All,
> >> Where does the Effective tax rate percentage (from tax type maintenance)
> >> reside in the database? I have poked around all over, and can't find it. It
> >> says it's in TaxRate.DspTaxPercent, but that column apparently doesn't
> >> really exist (per the data dictionary and SQL), and the % tax rate column
> >> that is in the table equal zero, despite displaying 6.25 on the GUI.
> >> Any assistance would be appreciated.
> >> Thanks in advance!
> >> - leAnn
> >>
> >>
> >>
> >
> >
>
>
> [Non-text portions of this message have been removed]
>