Welcome, Guest. Please Login.
05/13/25 at 11:57:46
News:
Home Help Search Login


ISTech Support Forum › Evo-ERP and DBA Classic › Items ‹ Previous topic | Next topic ›
Pages: 1
Send Topic Print
Item Specs (Read 648 times)
Betty_Musser
Browser
*


I love YaBB 1G -
SP1!

Posts: 11
Gender: female
Item Specs
08/03/11 at 08:54:53  
Where are item specs located in data base for export to XL?
Back to top
 
 
  IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: Item Specs
Reply #1 - 08/03/11 at 09:06:32  
SELECT  
MTIC_PROD_CODE,  
MTIC_PROD_SPECS_1,  
MTIC_PROD_SPECS_2,  
MTIC_PROD_SPECS_3,  
MTIC_PROD_SPECS_4,  
MTIC_PROD_SPECS_5,  
MTIC_PROD_SUBST_1,  
MTIC_PROD_SUBST_2,  
MTIC_PROD_SUBST_3,  
MTIC_PROD_SUBST_4,  
MTIC_PROD_SUBST_5  
FROM MTICMSTR
 
 Tongue
Back to top
 
 
Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Item Specs
Reply #2 - 08/03/11 at 17:09:40  
Not quite.  The Specs are in MTIS.PROD.SPECS #1 through 12.
 
The data in MTIC.PROD.SUBST #2 through #5 is the information for Inventory User Defined fields in Evo.
Back to top
 
 
Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print
ISTech Support Forum › Evo-ERP and DBA Classic › Items ‹ Previous topic | Next topic ›

ISTech Support Forum » Powered by YaBB 2.1!
YaBB © 2000-2005. All Rights Reserved.

Valid XHTML Valid CSS Powered by Perl Source Forge