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.
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.