Note you can use the stored procedure interface for customers and vendors. See sql/modules/Company.sql
On Jun 25, 2015 11:45 PM, "Tod Harter" <..hidden..> 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
> ..hidden..
> 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 ..hidden.. https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel