[OFBIZ-12723] Remove fields oldQuantityOnHand and oldAvailableToPromise from InventoryItem entity

• Type: Improvement
• Status: Closed
• Priority: Trivial
• Resolution: Implemented
• Affects Version/s: Upcoming Branch
• Fix Version/s: Upcoming Branch
• Component/s: datamodel, product
• Assignee: Daniel Watford
• Reporter: Daniel Watford
• Created: 12/Dec/22 18:29
• Updated: 27/Feb/24 16:20
• Resolved: 13/Dec/22 16:19

Description

Remove fields oldQuantityOnHand and oldAvailableToPromise from the InventoryItem entity, associated view-entities, forms and services.

OFBiz currently has a maintenance service, updateOldInventoryToDetailAll, which finds any InventoryItems where oldQuantityOnHand or oldAvailableToPromise are populated and creates corresponding InventoryItemDetail entities. The oldQuantityOnHand and oldAvailableToPromise fields are then cleared.

Based on source code repository logs, were already in the data model when OFBiz was imported into subversion 1st July 2006.

Given the column names for the fields are hard-coded in the data model as QUANTITY_ON_HAND and AVAILABLE_TO_PROMISE, I assume these entity fields, along with the updateOldInventoryToDetailAll service, were implemented as a method of upgrading the data model and are no longer used.

Since these fields are no longer used, lets remove them and their related code, (slightly) reducing the size of ofbiz' sources that need to be maintained.

Issue Links

• links to: GitHub Pull Request #569