Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macola Database

Status
Not open for further replies.

RemingtonSteel

Programmer
Jul 14, 2006
65
GB
1. I will be doing some VB.net programs (front end) with Macola Database. Is there any problem down the road if I add tables in Macola Database? What challenges I will encounter if there will be updates for Macola if I add tables in Macola DB?

2. Exact Website for Customer Portal now have a list of database being used per module for Macola ES. Just would like to check if the tables listed are reliable and there are no tables that still needed that is not on the list.

Example. For Distribution (Order Entry)

OECTLFIL_SQL
OEORDHRD_SQL
OEORDLIN_SQL
OEPRCFIL_SQL
OECUSITM_SQL
OEHDRHST_SQL
OELINHST_SQL

3. I don't know how to use flexibility. However, Is it a good strategy to make my own front end and just put the fields I need to populate Macola database.
And besides, I know flexibility is not available on every Module.

Thanks!
 
That is a very small list of the tables that are hit. Also hit almost 100% of the time are:

IMINVLOC_SQL
IMINVTRX_SQL
OEHDRAUD_SQL
OELINAUD_SQL
OEINQORD_SQL

Depending upon if you have any of the following turned on, you can double or triple this table list, up to nearly 40 tables:

Bin control
Serial Control
Lot Control
Hard Allocation
Landed Cost
Forced demand=Pull
Kit Item
Configured items
OE to PO items

I am sure there are more that I have missed, this is just off the top of my head.

I am not sure what you are trying to do, but you need to consider Wisys .COM objects for programming. You call for example, the CreateOeOrder Object, pass it a few variables, and it reads your Macola environment and automatically updates the necessary tables.

This way you do not have to "reverse engineer" Macola.

I can show you some good sample code in VB or .Net, or better yet you can get this directly from Wisys.

Wisys has limitations, as it doesn't have every macola function in it, but it certainly has the big ones! Check it out and let me know if you have any questions.


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

"What version of URGENT!!! are you using?
 
I have added several tables to the Macola database to suppliment our own business needs and it's just another database oject so Macola doesn't care.

Don't however modify any of the Macola tables like adding a column. When you try to launch the client it will blow up.

My perspective on adding a front end outside of Macola is do it where it makes sense. I generally try to add screens and flexibility code within Macola because that is the environment the user is in. When they have to go somewhere else confusion starts to enter their minds and you are dealing with that.

If you are a VB.NET programmer then you will pick up flexibility (AKA VBA) with no problem. Download the Flexibility Programmers guide. After reading through this you will be able to add code easily.
 
I have a few programs outside Macola, a lot of the more general Macola tables contain User_def_field_1 to 5, I have been told that it is safe to use these fields as they won’t be used by Macola (this has held true over several updates). However do not use the Filler fields as they are the spare space put in the tables by Macola for future expansion. The exception to the rule is the OEPRCFIL_SQL where Macola uses the filler_0001 field as the key (go figure).

"Don't worry about the world coming to an end today.
It’s already tomorrow in Australia." - Charles Schulz
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top