Organization table

[Rizwan Sharif]

Hi,
I am trying to create a company structure similar to
Company->Department->Division->Section (there will be more then one company)
in OFBiz. As mentioned in the book "The Data Model Resource Book"
ORGANIZATION table can be used for this purpose but I am unable to find this
table in OFBiz entities. Is it model in OFBiz with some other name? how can
I create hierarchical  Organization structure in OFBiz?

Thanks,
Sharif

[Amine AZZI]

Hi Rizwan,

I have put such a hierarchy through the relationship mechanism put in the
party module.

Amine.

2007/7/15, Rizwan Sharif <[hidden email]>:

>
> Hi,
> I am trying to create a company structure similar to
> Company->Department->Division->Section (there will be more then one
> company)
> in OFBiz. As mentioned in the book "The Data Model Resource Book"
> ORGANIZATION table can be used for this purpose but I am unable to find
> this
> table in OFBiz entities. Is it model in OFBiz with some other name? how
> can
> I create hierarchical  Organization structure in OFBiz?
>
> Thanks,
> Sharif
>

[Rizwan Sharif]

I have seen a table name "GL_ACCOUNT_ORGANIZATION" does it have to do
something with this?

On 7/15/07, Amine AZZI <[hidden email]> wrote:

>
> Hi Rizwan,
>
> I have put such a hierarchy through the relationship mechanism put in the
> party module.
>
> Amine.
>
> 2007/7/15, Rizwan Sharif <[hidden email]>:
> >
> > Hi,
> > I am trying to create a company structure similar to
> > Company->Department->Division->Section (there will be more then one
> > company)
> > in OFBiz. As mentioned in the book "The Data Model Resource Book"
> > ORGANIZATION table can be used for this purpose but I am unable to find
> > this
> > table in OFBiz entities. Is it model in OFBiz with some other name? how
> > can
> > I create hierarchical  Organization structure in OFBiz?
> >
> > Thanks,
> > Sharif
> >
>

[Amine AZZI]

No actually the table name is party_relationship

2007/7/15, Rizwan Sharif <[hidden email]>:

>
> I have seen a table name "GL_ACCOUNT_ORGANIZATION" does it have to do
> something with this?
>
> On 7/15/07, Amine AZZI <[hidden email]> wrote:
> >
> > Hi Rizwan,
> >
> > I have put such a hierarchy through the relationship mechanism put in
> the
> > party module.
> >
> > Amine.
> >
> > 2007/7/15, Rizwan Sharif <[hidden email]>:
> > >
> > > Hi,
> > > I am trying to create a company structure similar to
> > > Company->Department->Division->Section (there will be more then one
> > > company)
> > > in OFBiz. As mentioned in the book "The Data Model Resource Book"
> > > ORGANIZATION table can be used for this purpose but I am unable to
> find
> > > this
> > > table in OFBiz entities. Is it model in OFBiz with some other name?
> how
> > > can
> > > I create hierarchical  Organization structure in OFBiz?
> > >
> > > Thanks,
> > > Sharif
> > >
> >
>

[Rizwan Sharif]

which tables will contain the records of company/department/division/sector?
there is information which associated with these entities which needs to be
stored. From what i have understand from the book, first i have to create
records for these entities in organization table and then create party
records corresponding to them but the absence of organization table is
creating confusion.

On 7/15/07, Amine AZZI <[hidden email]> wrote:

>
> No actually the table name is party_relationship
>
> 2007/7/15, Rizwan Sharif <[hidden email]>:
> >
> > I have seen a table name "GL_ACCOUNT_ORGANIZATION" does it have to do
> > something with this?
> >
> > On 7/15/07, Amine AZZI <[hidden email]> wrote:
> > >
> > > Hi Rizwan,
> > >
> > > I have put such a hierarchy through the relationship mechanism put in
> > the
> > > party module.
> > >
> > > Amine.
> > >
> > > 2007/7/15, Rizwan Sharif <[hidden email]>:
> > > >
> > > > Hi,
> > > > I am trying to create a company structure similar to
> > > > Company->Department->Division->Section (there will be more then one
> > > > company)
> > > > in OFBiz. As mentioned in the book "The Data Model Resource Book"
> > > > ORGANIZATION table can be used for this purpose but I am unable to
> > find
> > > > this
> > > > table in OFBiz entities. Is it model in OFBiz with some other name?
> > how
> > > > can
> > > > I create hierarchical  Organization structure in OFBiz?
> > > >
> > > > Thanks,
> > > > Sharif
> > > >
> > >
> >
>

[Amine AZZI]

I usually store them in Party table with type "PARTY_GROUP" and then in
party_group table.

2007/7/15, Rizwan Sharif <[hidden email]>:

>
> which tables will contain the records of
> company/department/division/sector?
> there is information which associated with these entities which needs to
> be
> stored. From what i have understand from the book, first i have to create
> records for these entities in organization table and then create party
> records corresponding to them but the absence of organization table is
> creating confusion.
>
> On 7/15/07, Amine AZZI <[hidden email]> wrote:
> >
> > No actually the table name is party_relationship
> >
> > 2007/7/15, Rizwan Sharif <[hidden email]>:
> > >
> > > I have seen a table name "GL_ACCOUNT_ORGANIZATION" does it have to do
> > > something with this?
> > >
> > > On 7/15/07, Amine AZZI <[hidden email]> wrote:
> > > >
> > > > Hi Rizwan,
> > > >
> > > > I have put such a hierarchy through the relationship mechanism put
> in
> > > the
> > > > party module.
> > > >
> > > > Amine.
> > > >
> > > > 2007/7/15, Rizwan Sharif <[hidden email]>:
> > > > >
> > > > > Hi,
> > > > > I am trying to create a company structure similar to
> > > > > Company->Department->Division->Section (there will be more then
> one
> > > > > company)
> > > > > in OFBiz. As mentioned in the book "The Data Model Resource Book"
> > > > > ORGANIZATION table can be used for this purpose but I am unable to
> > > find
> > > > > this
> > > > > table in OFBiz entities. Is it model in OFBiz with some other
> name?
> > > how
> > > > > can
> > > > > I create hierarchical  Organization structure in OFBiz?
> > > > >
> > > > > Thanks,
> > > > > Sharif
> > > > >
> > > >
> > >
> >
>

[Rizwan Sharif]

what about the fields related of company,department,division etc should I
add them to party_group table? is it the right practice?

On 7/15/07, Amine AZZI <[hidden email]> wrote:

>
> I usually store them in Party table with type "PARTY_GROUP" and then in
> party_group table.
>
> 2007/7/15, Rizwan Sharif <[hidden email]>:
> >
> > which tables will contain the records of
> > company/department/division/sector?
> > there is information which associated with these entities which needs to
> > be
> > stored. From what i have understand from the book, first i have to
> create
> > records for these entities in organization table and then create party
> > records corresponding to them but the absence of organization table is
> > creating confusion.
> >
> > On 7/15/07, Amine AZZI <[hidden email]> wrote:
> > >
> > > No actually the table name is party_relationship
> > >
> > > 2007/7/15, Rizwan Sharif <[hidden email]>:
> > > >
> > > > I have seen a table name "GL_ACCOUNT_ORGANIZATION" does it have to
> do
> > > > something with this?
> > > >
> > > > On 7/15/07, Amine AZZI <[hidden email]> wrote:
> > > > >
> > > > > Hi Rizwan,
> > > > >
> > > > > I have put such a hierarchy through the relationship mechanism put
> > in
> > > > the
> > > > > party module.
> > > > >
> > > > > Amine.
> > > > >
> > > > > 2007/7/15, Rizwan Sharif <[hidden email]>:
> > > > > >
> > > > > > Hi,
> > > > > > I am trying to create a company structure similar to
> > > > > > Company->Department->Division->Section (there will be more then
> > one
> > > > > > company)
> > > > > > in OFBiz. As mentioned in the book "The Data Model Resource
> Book"
> > > > > > ORGANIZATION table can be used for this purpose but I am unable
> to
> > > > find
> > > > > > this
> > > > > > table in OFBiz entities. Is it model in OFBiz with some other
> > name?
> > > > how
> > > > > > can
> > > > > > I create hierarchical  Organization structure in OFBiz?
> > > > > >
> > > > > > Thanks,
> > > > > > Sharif
> > > > > >
> > > > >
> > > >
> > >
> >
>