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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Tables Affected by Order creation ?

Status
Not open for further replies.

Adikash

Programmer
Mar 14, 2018
1
0
0
CA
Hi,

We are trying to create a web service wrapper around Macola.
We are aware of:
- OEORDHDR_SQL
- OEORDLIN_SQL

Which other tables..?

Adikash
 
How about using Macola's Web Service or Wisys. If not then running SQL trace, but understand that the table can change based on the inputs, there are many features and options in the system that can change the nature of the transaction. Is this progression or Macola ES. There were DRM documents for Progression that listed tables updated, but again the choices of different features and option will lead to different table combinations.
 
I second using Wisys. No need to recreate the wheel. Also, if you did want to recreate the wheel there are upwards of 30 tables that are read, updated or written to when you create an order depending on the options you have in place.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Macola 10, Synergy, and Crystal Reports.
Check out our Macola tools:
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top