Tuesday, October 13, 2015

Relation between HcmPosition , HcmWorker and DirPartyTable in ax 2012

Relation between HcmPosition , HcmWorker and DirPartyTable in ax 2012

 1.DirPartyTable is equivalnt to Dir Person and PersonId is present in HcmWorker Table and for worker Position there is HcmPositionWorkerAssingment table in which u will find the HcmWorker id n HcmPosition id.

2.there is no direct relation b/w HcmPosition and HcmWorker where the relation is made through HcmPositionWorkerAssignment as #Xainu said i.e HcmPositionWorkerAssignment .worker = HcmWorker.RecId, and for HcmWorker and DirPartyTable - RecId of DirPartyTable is nothing but person field in HcmWorker

3.For hcmworker and hxm position: hcmworker has relation with hcmpositionworkerassignment and hcmpositionworkerassignment has relation with hcmposition and hcmposition has with hcmposition detail. For dirpartytable abd hcmworker: dirpartytable has relation with dirperson and dirperson has relation with hcmworker.