Thanks for your interest and persistence on this Deyan.
Please consider that not every business concept has been modeled and
implemented in OFBiz and that as time goes on and more and more
organizations use OFBiz for more and more requirements there is more
and more implemented in the project.
If this is something you're building and you want to collaborate with
the community to get it refined and into the project you've started
out exactly how you should!
It's a great first step to do a sort of "gap analysis" between what
you need and what is already in the project. Based on that it sounds
like you have identified a gap so the next step is to design something
to fill that gap (and it looks like what you've written has already
started that).
As for how to model it, I agree we need some sort of relationship
between ShipmentRouteSegment and FixedAsset, and this could be a one-
to-many relationship between a ShipmentRouteSegment and a vehicle
FixedAsset. However, in order to meet more general needs we may want
to allow for modeling of multiple vehicles for a specific route
segment of a shipment. This may not be an issue in the organization
you are working for, but in some cases a single large shipment that
does all move together will be split across multiple vehicles (could
be a convoy of trucks, or could be rail cars... and for rail cars they
all move together but chances are you'll want to track each car as a
separate vehicle asset).
Anyway, it's great to have you involved with this and I hope to see
more from you in the near future.
-David
On May 12, 2009, at 3:15 AM, Deyan Tsvetanov wrote:
Yes, I agree - what you are writing here is what is written in the
book.
However I am looking at the OFBiz database tables and I can not find
any
relationship between a shipment route segment ( or a package route
segment ) and a fixed asset.
And my question is: what is the reason that such relationship is
missing
in the OFBiz data model ? Is it on purpose ?
Just FYI - some background for my problem :
What I am trying to achieve is exactly what's written in The Book:
The relationship to VEHICLE would usually be tracked in
circumstances
where the enterprise maintains its own fleet. If the enterprise uses
external car-
riers, the enterprise would probably not need this relationship within
its data
model. Could more than one vehicle be used in a particular SHIPMENT
ROUTE
SEGMENT? For instance, could truck #100 be used and then truck #120
take
over the route at midpoint? This data model will define this
circumstance as
two shipment route segments; therefore, each route would have one and
only
one vehicle.
I have an enterprise that maintains its own fleet. Therefore I want to
know which exact vehicle ( fixed asset ) is carrying the shipment.
What the enterprise also does is handling the packages from one
vehicle
to another - the drivers meet somewhere and exchange shipments.
The vehicles also have GPS devices so I do update the GeoPoint
entities
to track their geographical location.
So I'm missing the link between a shipment_route_segment ( or a
package_route_segment - it's even more logical ) and a fixed asset
( vehicle ).
Thanks,
Deyan
On Mon, 2009-05-11 at 15:29 -0700, BJ
Freeman wrote:
you will notice on page 179 that a vehicle is a sub type of Fixed
Assets. so if the enterprise owns the vehicle, the Fixed asset is
assigned to the ship using.
otherwise it is shipvia using a carrier ship method
look on page 217 fixed asset assignments.
Deyan Tsvetanov sent the following on 5/11/2009 1:46 PM:
P.S.
I'm sorry , forgot to include the details ...
"The book" - pages 178 - 181 ( Shipment Routing and Shipment
Vehicle ).
On Mon, 2009-05-11 at 23:32 +0300, Deyan Tsvetanov wrote:
Hi there,
I have a question regarding the ofbiz data model.
There is a relationship "shipped_using" between
shipment_route_segment
and fixed_asset ( vehicle ) in "The Book".
However in the ofbiz data model there isn't any vehicle
relationship
between from either shipment_route_segment or
shipment_package_route_segment.
My question is: what is the rationale ? Is that a miss or a
hit ? :)
A bug or a feature ?
Thanks in advance,
Deyan
