View Single Post
  #2 (permalink)  
Old March 21st, 2008, 11:16
bmj_23 bmj_23 is offline
Senior Member and Blogger
 
Join Date: May 2007
Posts: 170
Thanks: 4
Thanked 31 Times in 31 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 2
bmj_23 will become famous soon enough
Re: Where can I find basic OTM info?

Hi - if you are new to OTM implementation, my advice would be NOT to start with understanding the underlying database schema. There are over 1000 tables in there and depending on what you are trying to do, some are very relevant and some have absolutely no relevance at all. If you are really convinced that is the way to go, then I believe that the DB schema is included in the product documentation on the installation or you can purchase a copy of TOAD or something similar to connect direct to the DB to have a browse through the schema.

My advice to start to understand the application is to start to create the key data objects and understand the relationship between them (Order base, order release, shipment, invoice, voucher) using some of the key underlying master data you need (rate offering, rate record, itinerary, service provider, locations etc). The best way to do that, is to take a real life logistics scenario you are familiar with, and attempt to model it in the application. Far more productive than looking at a listing of the database schema.
Reply With Quote
The Following User Says Thank You to bmj_23 For This Useful Post:
eorlandi (March 21st, 2008)