blanchap
14th September 2011, 16:14
Hi all,
If any of you have the script codes, would it be possible to have a copy of the program script tdsls4101m000 and tdsls4102s000 (pdf or notepad would be ok)?
we're looking at creating a web interface to create sales orders and i want to look at the scripts to make sure we're not forgetting anything.
Regards
PB
mark_h
14th September 2011, 18:08
Sorry, but we do not allow sharing of code on the forum. If you need a copy of the scripts I recommend working with infor.
blanchap
16th September 2011, 16:01
I know but forget about sharing the script. The only thing i want to know is what are the tables that gets updated when running both sessions.
I asked Infor and they told me that they cannot provide me with that information.
PB
~Vamsi
16th September 2011, 23:50
Talk to your DBA about the feasibility of the following.
An inelegant method of solving this is to:
-Log everyone out of the Baan server (should not be difficult on a dev server)
-Make sure the sessions you need are already opened
-Start tracing the transactions on the database server (Oracle per your profile?)
Downsides
Does not account for all code paths
But at a very high level you should be able to see most of the tables involved.
bdittmar
17th September 2011, 15:50
Hi all,
If any of you have the script codes, would it be possible to have a copy of the program script tdsls4101m000 and tdsls4102s000 (pdf or notepad would be ok)?
we're looking at creating a web interface to create sales orders and i want to look at the scripts to make sure we're not forgetting anything.
Regards
PB
Hello,
the following tables are effected by session tdsls4101m000, but at include level, some additional tables are used.
So you have to check all libraries for used tables.
Tables and libraries used by tdsls4101m000 (BaaN IV)
table ttcmcs036
table ttccom000
table ttccom001
table ttccom010
table ttccom012
table ttccom013
table ttcmcs010
table ttcmcs042
table ttcmcs047
table ttdsls039
table ttdsls040
table ttdsls041
table ttdsls042
table ttdsls048
table ttdsmi200
table ttdrpl100
table ttipcs020
table ttrtop200
table ttrtoc600
table ttdsls038
#include "itccom0003" | check.search.argument
#include "itccom0004" | Read customer balances by company
#include "itccom0014" | Read parent customer
#include "itcmcs0005" | read company data
#include "itcmcs0010" | calculate and round amounts
#include "itcmcs0012" | read currency rates
#include "itcmcs0095" | read mcs095 parameter values
#include "itdsls0020" | Check entered customer
#include "itdsls0002" | process stock transactions sales
#include "itdsls0005" | check item reference
#include "itdsls0025" | Read financial company number
#include "itdsls4000" | General SLS functions
#include "itdsls4101" | Shared functions with EDI
#include "itdsls0027" | read costs set code
#include "itdsls4102" | Shared functions with EDI
#include "itdcms0009" | Margin control CMS
| #include "itdcms4101" | Link Order and Relation
| #include "itdcms0002" | Link Order and Relation
#include "itfgld4000" | Define if multicompany is used
#include "itfgld4004" | Define if company is allowed for Finance
#include "itrtcd0007" | transport
#include <bic_tt> | runtime dictionary information
#include "itcedi0020" | EDI functions
in itdsls0002 tdsls0002.write.tdsls050(tdsls040.orno) | include tdsls0002, line 143 is used.
Tables tdsls050, tdsls051
Are you sure, you will do that work ?
Regards
blanchap
19th September 2011, 16:02
Thank you all for the information.
I knew i would get some answers here.
Regards.