[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Entity identifier



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" <..hidden..> wrote:


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