I would like to know whether every company has its own tables or for all the companies only one set of tables will be there and company number is a part of Tables?

regards,
James

For Baan IVc4 , the tables are separate for each company. And from what little I know about later versions , the position should be same in later versions also.

Baan's query parser allows the compny number to be specified as a field . However it's different when it comes to storage of table.

grajenda,

Usually every company has its own set of tables, but multiple companies may share a table(s). These are called logical tables in Baan. Refer to session ttaad4120m000.

You can use ttmmmXXX._compnr = :company to access the relevant table.

Example: select * from tcmcs015 where tcmcs015._index = {...} and tcmcs015._compnr = 200 selectdo ... endselect