Hi All,
In Ofbiz I want to create separate database for inventory module with
dependency tables like InentoryItem & so on. I don't see any issue foreign key
relations between dependency tables(like product, order related) but i see the
view entities are using many places in application hence some of the inventory
process may breaks.
Appreciate the response/solution for this. Thanks for advance.
Below are the tables list and view entity list.
Inventory Entities
---------------------------
InventoryItem
InventoryItemDetail
InventoryItemAttribute
InventoryItemStatus
InventoryItemTempRes
InventoryItemType
InventoryItemTypeAttr
InventoryItemVariance
InventoryTransfer
OldOrderItemInventoryRes
PhysicalInventory
InventoryItemLabel
InventoryItemLabelAppl
InventoryItemLabelType
OrderItemShipGrpInvRes
View Entity with depenndencies
--------------------------------
OrderHeaderItemAndInv(Not in use)
MemberEntity
-------------
OrderHeader
OrderItem
OrderItemShipGrpInvRes
OrderHeaderItemAndInvRoles(Not in use)
MemberEntity
-------------
OrderHeader
OrderItem
OrderRole
OrderItemShipGrpInvRes
OrderItemAndShipGrpInvResAndItem - Using to calculation time of inventory
MemberEntity
------------
OrderItem
OrderItemShipGrpInvRes
InventoryItem
OrderItemAndShipGrpInvResAndItemSum - Packing time using in ofbiz
MemberEntity
------------
OrderItem
OrderItemShipGrpInvRes
InventoryItem
OrderItemShipGrpInvResAndItem - Reserve time usage in ofbiz
MemberEntity
------------
InventoryItem
OrderItemShipGrpInvRes
ProductInventoryItem - Prouction usage
MemberEntity
------------
Product
InventoryItem
ProductInventoryItemAndItemIssuance
MemberEntity
------------
Product
InventoryItem
ItemIssuance
ItemIssuanceAndInventoryItem
MemberEntity
------------
ItemIssuance
InventoryItem
ItemIssuanceInventoryItemAndProduct
MemberEntity
------------
ItemIssuance
InventoryItem
Product
ProductInventoryItemAndItemIssuance
MemberEntity
------------
Product
InventoryItem
ItemIssuance
InventoryItemAndDetail
MemberEntity
------------
InventoryItem
InventoryItemDetail`
WorkEffortAndInventoryAssign
MemberEntity
------------
InventoryItem
WorkEffortInventoryAssign
WorkEffortAndInventoryProduced`
MemberEntity
------------
WorkEffortInventoryProduced
InventoryItem
Facility Related Entities
-------------------------
Facility
FacilityAttribute
FacilityContactMechPurpose
FacilityContent
FacilityGroup
FacilityGroupMember
FacilityGroupRole
FacilityGroupRollup
FacilityGroupType
FacilityLocation
FacilityLocationGeoPoint
FacilityParty
FacilityType
FacilityTypeAttr
ProdCatalogInvFacility
OldFacilityRole
ProductFacility
ProductFacilityLocation
ProductStoreFacility
View Entity depenndency
---------------------------
ProductStoreFacilityByOrder(Use In ShipmentForms.xml)
MemberEntity
------------
OrderHeader
ProductStoreFacility
ProductStore
Facility
FacilityAndContactMech(Use in OrderView.groovy)
MemberEntity
------------
Facility
FacilityContactMech
ContactMech
FacilityLocationAndGeoPoint(Use in FacilityLocationGeoLocation.groovy and
EditFacilityLocation.ftl)
MemberEntity
------------
FacilityLocation
FacilityLocationGeoPoint
GeoPoint
ProductFacilityAndPostalAddress(Not in Use)
MemberEntity
------------
ProductFacility
FacilityContactMech
ContactMech
PostalAddress
Thanks & Regards
Jayachandra
