Note you can use the stored procedure interface for customers and
vendors. See sql/modules/Company.sql
On Jun 26, 2015 6:43 AM, "Chris Travers" <[email protected]> wrote:
>
> On Jun 25, 2015 11:45 PM, "Tod Harter" <[email protected]>
> wrote:
> >
> > I'm looking for a way in the existing 1.4 database schema to provide an
> identifier for a vendor. I have identifiers in an external system. In the
> old 1.2 vintage LSMB database there was 'vendornumber' which suited this
> purpose. In the current scheme where a vendor is simply a classification of
> Entity is doesn't appear that there is really an equivalent column. Is
> there something I'm missing?
> >
>
> To identify an entity use entity.control_code but note an entity can have
> multiple customer or vendor accounts.
>
> To identify a vendor account or customer account, use
> entry_credit_account.meta_number
> > Thanks!
> >
> > --
> > Tod G. Harter
> > Director of Technology Development
> > Whit's End Solutions, LLC
> >
> >
> ------------------------------------------------------------------------------
> > Monitor 25 network devices or servers for free with OpManager!
> > OpManager is web-based network management software that monitors
> > network devices and physical & virtual servers, alerts via email & sms
> > for fault. Monitor 25 devices for free with no restriction. Download now
> > http://ad.doubleclick.net/ddm/clk/292181274;119417398;o
> > _______________________________________________
> > Ledger-smb-devel mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
> >
>
------------------------------------------------------------------------------
Monitor 25 network devices or servers for free with OpManager!
OpManager is web-based network management software that monitors
network devices and physical & virtual servers, alerts via email & sms
for fault. Monitor 25 devices for free with no restriction. Download now
http://ad.doubleclick.net/ddm/clk/292181274;119417398;o
_______________________________________________
Ledger-smb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
