Item Master Table 1

[TStriker]

All,

I inherited a Macola database recently and I need to dump some basic part or item master information into an Excel spreadsheet.

I've poked around in the back-end a bit and the table names are a bit cryptic. What is/are the name(s) of the main data tables that contain part or item master information?

Thanks!

-Striker

 

[dgillz]

imitmidx_sql holds the item master
iminvloc_sql holds the item location

Are you using Progression or ES? Do you have eSynergy? if do there may be additional considerations.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[TStriker]

dgillz,

Thanks for the info, that helps a lot.

I don't know what version we're running. My task is to get some of the basic information out of the MACOLA system and inserted into our primary ERP system. MACOLA comes to us via the acquisition of another business in our industry.

The decision has been made to ditch MACOLA so all I really need is to get sosme very basic information out and then we will be done with MACOLA.

-Striker

 

[dgillz]

Let us know if you run into any issues.

Just out of curiosity what is your current MRP system?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?