Hi Fabien,

You need those columns for the multi-client, multi-organization concepts [1]

[1]
http://wiki.openbravo.com/wiki/ERP/2.50/Developers_Guide/Concepts/DB/Tables#Client.2FOrganization

Best Regards,

-- 
Iván Perdomo

> Hello,
>
> I am creating a new module for openbravo: funambol module.
>
> I am creating right now the configuration table to save all the
> configuration options.
>
> My table is:
>
> CREATE TABLE funm_configuration
> (
>    funm_configuration_id character varying(32) NOT NULL,
>    ad_user_id character varying(32) NOT NULL,
>    isActive character(1) NOT NULL DEFAULT 'Y'::bpchar,
>    created timestamp without time zone NOT NULL DEFAULT now(),
>    createdby character varying(32) NOT NULL,
>    updated timestamp without time zone NOT NULL DEFAULT now(),
>    updatedby character varying(32) NOT NULL,
>    funm_username character varying(60) NOT NULL,
>    funm_password character varying(60) NOT NULL,
>    funm_serverurl character varying(60) NOT NULL,
>    funm_contacts character(1) NOT NULL DEFAULT 'Y'::bpchar,
>    funm_emails character(1) NOT NULL DEFAULT 'Y'::bpchar,
>    funm_events character(1) NOT NULL DEFAULT 'Y'::bpchar,
>    funm_tasks character(1) NOT NULL DEFAULT 'Y'::bpchar,
>    funm_notes character(1) NOT NULL DEFAULT 'Y'::bpchar,
>     PRIMARY KEY (funm_configuration_id),
> ION ON DELETE NO ACTIONr_id) REFERENCES ad_user (ad_user_id)    ON
> UPDATE NO ACTI
> ) WITH (OIDS=FALSE)
> ;
>
>
> But I am not sure if I need the fields AD_Client_ID and AD_Org_ID
>
> Those fields are asked when I want to display all the funambol
> configurations already registered in the system with a datagrid.
>
> So do I need or not the AD_Client_ID and AD_Org_ID fields ?
>
> Thanks
>
> Fabien Carrion
>
> ------------------------------------------------------------------------------
> Crystal Reports - New Free Runtime and 30 Day Trial
> Check out the new simplified licensing option that enables
> unlimited royalty-free distribution of the report engine
> for externally facing server and web deployment.
> http://p.sf.net/sfu/businessobjects
> _______________________________________________
> Openbravo-development mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/openbravo-development
>






------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables 
unlimited royalty-free distribution of the report engine 
for externally facing server and web deployment. 
http://p.sf.net/sfu/businessobjects
_______________________________________________
Openbravo-development mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-development

Reply via email to