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