ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Class, Category, & User Defined
http://www.istechforum.com/YaBB.pl?num=1211900330

Message started by dashdown on 05/27/08 at 07:58:50

Title: Class, Category, & User Defined
Post by dashdown on 05/27/08 at 07:58:50

Can anyone tell me which files contain Inventory Class, Category, & User Defined and their descriptions. These are the files that are maintained in SM-C, SM-P, & SM-Q.

Thanks

Title: Re: Class, Category, & User Defined
Post by GasGiant on 05/27/08 at 08:23:01

BKICMSTR has Category in BKIC.PROD.CAT (bkic_prod_cat) and has class in BKIC.PROD.CLASS (bkic_prod_class)

MTICMSTR has user defined in MTIC.PROD.SUBST in the first position of the array (mtic_prod_subst_1)

Title: Re: Class, Category, & User Defined
Post by dashdown on 05/27/08 at 08:44:25

Thank you for your reply. However, the files I am looking for are the ones contain each of these items along with their description but do not tie them to an inventory item. These are the files maintained in the SM drop-down

Title: Re: Class, Category, & User Defined
Post by cathyh on 05/27/08 at 08:55:29

Class is "CLASMSTR" for class code and description, and "CLASS" has the GL accounts. The other ones are new and I'm not sure what they are called.

-----
I think what you are looking for is ISCATMSTR for category and ISUDMSTR for user-defined.

Title: Re: Class, Category, & User Defined
Post by dashdown on 05/27/08 at 08:58:06

Thank You ;)