[jira] Commented: (OFBIZ-2037) Re-organize RateType, rateAmount and rateCurrency organization in ofbiz.

["Hans Bakker (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OFBIZ-2037?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12647926#action_12647926 ] 

Hans Bakker commented on OFBIZ-2037:
------------------------------------

Some more implications:
1. This change also allows to depreciate the workEffortAssignmentRate in favor of the RateAmount entity.
2. The EmplPositionTypeRate will be depreciated in favour of the EmplPositionTypeRateAndAmount view which will show the same entity now however including the currency.
3. Move the RateType entity definition from the workEffort to the Accounting component and define the RateAmount entity also there. (these entities now used in HM and workEffort)
4. Depreciate the PartyRate entity in favor of the PartyRateType entity not having the currencyUomId in the key and no amount. 
5. Create a partyRateAndAmount view which will enhance the original PartyRate entity now having the currencyUomId and amount moved to the RateAmount entity.
6. Create a conversion service to copy the existing data from EmplPositionTypeRate, PartyRate, and workEffortAssignmentRate to the new RateAmount entity using the system defaultCurrency.



> Re-organize RateType, rateAmount and rateCurrency organization in ofbiz.  
> --------------------------------------------------------------------------
>
>                 Key: OFBIZ-2037
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2037
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: accounting, humanres, specialpurpose/projectmgr, workeffort
>    Affects Versions: SVN trunk
>         Environment: any
>            Reporter: Hans Bakker
>            Assignee: Hans Bakker
>            Priority: Minor
>             Fix For: SVN trunk
>
>
> the rateAmount in ofbiz is defined by the rate type and then by the following criteria when defined:
> from most specific to most general:
> 1. for a partyId (partyRate)
> 2. for a workEffort/timeentry (workEffortAssignmentRate)
> 3. for a employee position (EmplPositionTypeRate)
> 4. for a the default rateTypeId (RateType)
> The currency is defined in level 1,4 but not in the others. It should also be possible to specify the currency at any level.
> What is proposed:
> ===========
> 1. remove currencyUomId and (normal)rate(amount) in the partyRate and rateType (level 1,4) entities
> 2. remove rate(amount) from the workEffortAssignmentRate and employee position (level 2,3) entities
> 3. create a new entity: RateAmount with the following fields:
> 	primary key:
> 		rateTypeId
> 		rateCurrencyUomId
> 		workEffortId
> 		partyId
> 		emplPositionTypeId
> 		periodTypeId (from the PeriodType entity: per hour/day/week/month/quarter)
> 		fromDate
> 	non-key fields:
> 		thruDate
> 		rateAmount
> 4. create a service "getRateAmount" which will retrieve the applicable rate amount for the data provided searching from most specific to most general
> 5. depreciate the getPartyRate service.
> 6. create the createRateAmount and deleteRateAmount(expire) service to update the new entity
> 7. update existing services and forms.
> QUESTION:
> should the accounting organization partyId be in the key of the new RateAmount entity?
> Regards,
> Hans

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.