Go Back > Forum > Baan SIGs > Enhancements

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 54

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 24th October 2006, 11:29
zardoz's Avatar
zardoz zardoz is offline
Join Date: Jan 2003
Location: Torino, Italy
Posts: 445
zardoz is on a distinguished road
Baan: Triton 2, Triton 3, Baan IV, Baan ERP, Baan LN - DB: Oracle, Tbase, MS Sql - OS: Unix, Windows
Thumbs up Logical Tables and Companies
Baan: Baan IVc4

I don't know if it discussed before or if it exists in later versions, but I have is a simple idea for an improvement...

Why Baan doesn't put in any table a field with the company number who generated the row?
There are a lot of tables that you can make logical to implement multi-company, they usually uses a field called "ocmp" (Original Company). Usually doesn't means always...

It's right, a lot of tables doesn't need that field to be 'sharable', but on the other side, if you want other tables to be sharable you have to customize those tables and all scripts and dll's and include functions... a lot of dumb and expensive work.
My company
Reply With Quote
Sponsored Links
Old 15th December 2006, 16:46
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
I think I don't fully understand your problem but if you make a company shareable over multiple companies, you don't need that company column. Further you have to extent all queries (and indexes) with a company column. Last but not least the Baan architecture gives you the possibility to have a different package combination for company A compared to B. So, from many points the approach Baan has is preferable compared to having an additional company column.

kind regards,
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Count Number of Records by Tables and Companies NPRao Enhancements 5 12th June 2004 07:15
Logical EDM Tables naabi0 Manufacturing & Supply Chain 3 13th September 2002 06:29

All times are GMT +2. The time now is 14:03.

©2001-2018 - -