on 10-25-2010 7:41 AM
Hi All,
I would like to SELECT an items B1 assigned 'Internal Number' in a query but can't seem to find the column name it in the OITM table from with query generator.
The only way I can get the result is if I select all ie. 'SELECT * from OITM'. The result returns all columns, including the items Internal Number.
Does anyone know how to select an items 'Internal Number' individually?
Best regards,
John
Hi All,
There is an Internal number. If you do the following..
SELECT * FROM OITM T0
You can see the 'Internal Number' column header between 'Deleted' and 'Expense Account' in the returned results.
I would like to know how to select this 'Internal Number'
Best regards,
John
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Gordon,
T0.DocEntry is what I was after.
Many thanks,
John
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi John,
Check this query:
SELECT T0.ItemCode, T0.DocENtry FROM OITM T0.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi..
There is not internal number field for Items you can select Item Codes for particular item by query
Regards,
Bhavank
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There is no internal number field in the OITM but if you are asking about item code, you can use select itemcode from OITM
JimM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.