Hello,

I was just going through a script

program variable
ncmp1 = 230

select tfacp004.* from tfacp004
where tfacp004.agan = 'AG2'
and tfacp004._compnr = :ncmp1
order by tfacp004._index1


i am not able to see this tfacp200._compnr field is the table , why is this so ?? what is the significance of this field ???

on what siutation i should use it ????

Regards

Learner

Hi,

Is the company of query

Dear Neeraj,

Please refer to Company numbers (http://www.baanboard.com/programmers_manual_baanerp_help_functions_database_handling_company_numbers)

Rgds,
Paul

Hi,

Thanks Paul for that link.

Regards


Neeraj Vasudeva

Dear Neeraj,
If you are using Centralised servers for Two different Transacrion groups then a compnr. Every table have the Table Name identified with a Company Number.

If you take a sequential dump of the Table, you will get the result. See the last 3 characters of Sequentially dumped file of that table.

- Suhas Mahajan

Originally posted by learner
Hello,

I was just going through a script

program variable
ncmp1 = 230

select tfacp004.* from tfacp004
where tfacp004.agan = 'AG2'
and tfacp004._compnr = :ncmp1
order by tfacp004._index1


i am not able to see this tfacp200._compnr field is the table , why is this so ?? what is the significance of this field ???

on what siutation i should use it ????

Regards

Neeraj Vasudeva