Page 1 of 1

BPartner AD_Client AD_User

PostPosted: Tue Jun 28, 2005 10:42 pm
by leo
I want to connect a Human Resource Management application to the Compiere DB and I'm looking for the basic tables to merge the databases.
As a HRM I need to find all the columns for the specification of a Worker.
Firstly I tried with the Bpartner but I guess I was wrong...then I tried to use the table AD_User but it seems to be logically different from the feature of the worker in myDB.
The table that I need to merge are the follows:
firstName
lastName
birthDate
taxIdCode
gender
title
birthPlace
registrationCode
idContract
idArea

Can anybody help me?

PostPosted: Tue Jun 28, 2005 10:50 pm
by leo
...sorry the column for the table "worker"...

PostPosted: Tue Jun 28, 2005 11:14 pm
by neilg
Leo,

I don't know the answer but I'm not sure if you've got the right forum... surely the technical forum would be a better choice for this topic?

Regards Neil

Re: BPartner AD_Client AD_User

PostPosted: Wed Jun 29, 2005 1:03 am
by trifon
leo wrote:I want to connect a Human Resource Management application to the Compiere DB and I'm looking for the basic tables to merge the databases.
As a HRM I need to find all the columns for the specification of a Worker.
Firstly I tried with the Bpartner but I guess I was wrong...then I tried to use the table AD_User but it seems to be logically different from the feature of the worker in myDB.
The table that I need to merge are the follows:
firstName
lastName
birthDate
taxIdCode
gender
title
birthPlace
registrationCode
idContract
idArea

Can anybody help me?


This is how your mapping could look:

firstName...............--> AD_User.Name and C_BPartner.Name
lastName............... --> New column AD_User.LastName and C_BPartner.Name2
birthDate................--> AD_User.Birthday
taxIdCode..............--> C_BPartner.TaxID
gender...................--> AD_User.C_Greeting_ID; Could be used to code gander, or could be created new column.
title.......................--> AD_User.Title
birthPlace..............--> New Column AD_User.BirthPlace
registrationCode....--> New Column AD_User.RegistrationCode
idContract.............--> New Column AD_User.Contract_ID
idArea...................--> C_BPartner_Location.C_SalesRegion_ID

For each worker you must create this records:
new record in C_BPartner.
new record in AD_User and set AD_User.C_BPartner_ID from previous record.
new record in C_BPartner_Location and set C_BPartner_Location.C_BPartner_ID from first record.

Regards,
Trifon