ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Item Specs
http://www.istechforum.com/YaBB.pl?num=1312386893

Message started by Betty_Musser on 08/03/11 at 08:54:53

Title: Item Specs
Post by Betty_Musser on 08/03/11 at 08:54:53

Where are item specs located in data base for export to XL?

Title: Re: Item Specs
Post by Kelloggs on 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

:P

Title: Re: Item Specs
Post by Lynn_Pantic on 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.