Part Usage Information

[Deb]

I have been asked to combine QAD information with our other DB packages into a third party Business Analytical tool. I do not have any experience with the QAD tables but I have gotten to the point where we have an ODBC connection set up and we are able to import tables from Progress into SQL. One of the areas we are looking to analyze is on the part usage. I need to be able to show for the last 90 days how much of a part we used on each day. In our other DB's we are looking at material transactions with a transaction type of Issue, Finish or Ship. Can anyone tell me where I might find similiar information in the Progress tables?

Thank you!

 

[kishorchari]

Look at Transaction History. (tr_hist)

The Help for Type in 3.21.13 will tell you which tr_type you should be looking at.

In this table you will be using tr_eff_date & tr_qty_chg.

You should use QAD DFD for more info.