Any one know what reference table name has the various manufacturing transaction types (or order types) that link to the t_koor field.

Examples would be Purchase Orders, Sales Order, Stock etc.

I don't think this table is a customer specific table although the data entries might be. The t_koor field is referenced throught the database in various tables so my guess is that it is a standard table that holds the cross-reference information.

Thanks,

John

p.s. Sorry, spelled t_koor wrong in the subject of this thread.

koor is a domain used throughout the applications tables. You can use Tools/AppDev/DomainsTables to get the domains session and then go from there to look at the enumerated values.

tc koor act.sfc SFC Production Order
tc koor act.pur Purchase Order
tc koor act.sls Sales Order
tc koor cp.sfc Planned Production Order
tc koor cp.pur Planned Purchase Order
tc koor act.pur.sched Purchase Schedule
tc koor act.sls.sched Sales Schedule
tc koor act.pur.adv Purchase Order Advice
tc koor act.asc ASC Production Order
tc koor mrp.sls Forecast
tc koor mrp.atp ATP Reservation
tc koor sls.quot Sales Quotation
tc koor pur.con Purchase Contract
tc koor sls.con Sales Contract
tc koor wrh.order Warehouse Order
tc koor act.srv Service Order
tc koor pss.pur PRP Purchase Order (TP)
tc koor pss.wrh PRP Warehouse Order (TP)
tc koor wrh.ass Warehousing Assembly Order
tc koor act.trf Warehouse Transfer
tc koor act.pmg Production Batch
tc koor cp.ipl Planned Distribution Order
tc koor cf.ap Assembly Part Demand
tc koor act.sfc.man SFC Production Order (Manual)
tc koor act.pur.man Purchase Order (Manual)
tc koor act.sls.man Sales Order (Manual)
tc koor act.srv.man Service Order (Manual)
tc koor act.trf.man Warehouse Transfer (Manual)
tc koor act.srv.sls Maintenance Sales Order
tc koor act.dpt.wrk Maintenance Work Order
tc koor act.srv.sls.man Maintenance Sales Order (Manual)
tc koor pur.rfq Request for Quotation
tc koor act.sls.sched.f Sales Schedule Forecast
tc koor act.dpt.wrk.man Maintenance Work Order (Manual)
tc koor freight Freight
tc koor stock Stock
tc koor safety.stock Safety Stock
tc koor act.asc.man ASC Production Order (Manual)
tc koor mps.prod Production Plan
tc koor mps.pur Purchase Plan
tc koor cycle.count Cycle Counting Order
tc koor adjustment Adjustment Order
tc koor revaluation Revaluation Order
tc koor product.sched Production Schedule
tc koor product.kanban Production Kanban
tc koor project Project
tc koor project.man Project (Manual)
tc koor enterprise.plan Warehouse Transfer (Distribution)
tc koor pcs.project PCS Project
tc koor not.appl Not Applicable

That's helpful.

But, I tried your suggestion of "You can use Tools/AppDev/DomainsTables " but I'm really not sure what you mean. I am using SSA worktop 2.4.5 to view the various sessions. The menu options you specified don't seem to be the same as what I have.

Warning: I'm very much a newbie to Worktop although expereinced with SQLServer.

I just need to know the table name in SQLServer so I can link to it. An example would be like "Labor types". This is session tcppl0130m000 which relates to the table. tcppl030nnn (where nnn is the company number).

This was easy to find. I simply put "type" in the search feature of Worktop and it listed all the sessions with the word 'type' in it. Opened the session for "Labor Types", then pressed <SHF><CTRL><7> to show the XML tree and was able to find the backend table name.

But, for the life of me, I have no idea what they would have named the session I am looking for. If I knew that, I think I would be all set.

Unfortunately, since koor is a domain instead of maintained master data, it is not as straightforward as your tcppl030 example.

You may want to start by looking at tables ttadv400, ttadv401, and ttadv402 for company 000. Please notice that the package VRC is part of the key of all the tables. I recommend that you find a way to deal with that in anything you program.

Vince

In order to use , ttadv40* tables u need right VRCs and in right order . U can use table ttadv112000 for ur package combination and join with related sessions . Maybe this helps .

Any one know what reference table name has the various manufacturing transaction types (or order types) that link to the t_koor field.

Examples would be Purchase Orders, Sales Order, Stock etc.

I don't think this table is a customer specific table although the data entries might be. The t_koor field is referenced throught the database in various tables so my guess is that it is a standard table that holds the cross-reference information.


I believe that t_koor an enumerated data type. so the values would not be in a table, but stored in the baan data dictionary.

I don't have easy access to baan right now, so if someone can verify that it'd be appreciated.

Dave

It is a domain stored in the DD, but the DD information for domains is stored in the ttadv40x tables.

To the OP, in my experience, these domains change rarely enough that it is usually easier to hardcode the values than to write something to try and look up the values every time.

Vince

Here is the enumerated data for the order type domain. You can take the file and create a table of your own with which to link to the various Baan tables that use order type. That is how we've done it with our add-on report writer.

Separate table creation for enum description is not recommended instead hard coding the description in report writer is much practical and recommended.