BPartner AD_Client AD_User

It is here where business functions and pains hits you in the face. Do we extend and weave requirements into Compiere? Or do we just tweak hardly a code with smart thinking and a full grasp of Compierology? You’ll see lots of both in making your business grow.

BPartner AD_Client AD_User

Postby leo » Tue Jun 28, 2005 10:42 pm

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?
leo
 
Posts: 13
Joined: Tue Jun 07, 2005 9:01 pm

Postby leo » Tue Jun 28, 2005 10:50 pm

...sorry the column for the table "worker"...
leo
 
Posts: 13
Joined: Tue Jun 07, 2005 9:01 pm

Postby neilg » Tue Jun 28, 2005 11:14 pm

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
neilg
Regular
 
Posts: 141
Joined: Thu Jun 16, 2005 1:58 pm

Re: BPartner AD_Client AD_User

Postby trifon » Wed Jun 29, 2005 1:03 am

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
Trifon Trifonov
trifon
Senior
 
Posts: 324
Joined: Thu Dec 23, 2004 11:20 pm
Location: Bulgaria, Sofia


Return to Reality Strikes

Who is online

Users browsing this forum: No registered users and 1 guest

cron