Yeah, it's stored in UserComp, field PRIMBUYERID, by DCDUserId. If the authorized user is the default the buyerid will be there. A user can only be the Default Authorized user for one buyer Id. Whenever you set the checkbox the Usercomp table is updated with the new buyer id.
--- In vantage@yahoogroups.com, "Doyle, Jason" wrote:
>
> Epicor 9.05.700B SQL64 Non-Unicode
>
>
>
> Anyone know how to find the Default authorized user through SQL off the
> SalesRep / SaleAuth tables?
>
> It's available in the Business Objects, but I need to access it via SQL,
> and it isn't an actual column....
>
>
>
> Thanks,
>
>
>
> Jason Doyle
>
> Software Architect
>
>
>
> Cranel, Inc.
>
> Cranel Imaging / ISOdx / Versitec
>
> 8999 Gemini Parkway / Columbus, OH 43240
>
> p: 614.318.4256 / f: 614.431.8388
>
> email: jdoyle@...
>
> cranelimaging.com / isodxsolutions.com
> / versitec.com
>
>
>
>
> 1985-2010...Celebrating 25 years of excellence, 25 years of evolution
>
>
>
>
> CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may contain confidential and privileged information for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error; please notify Cranel Incorporated immediately by telephone at 614-431-8000 or 800-288-3475 and destroy all copies of this communication and any attachments.
>
>
>
> [Non-text portions of this message have been removed]
>