CT00002 - IC COST Standard Item Class Defaults | Prospr

CT00002 - IC COST Standard Item Class Defaults

Query Builder

Select * from CT00002

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CMPANYID	Company ID	Integer	2	View
ITEMNMBR	Item Number	String	32	View
ITEMDESC	Item Description	String	102	View
ITMCLSCD	Item Class Code	String	12	View
ITMCLSDC	Item Class Description	String	32	View
DEFLTCLS	Default Class	Boolean	2	View
NOTEINDX	Note Index	Currency	10	View
ITEMTYPE	Item Type 1. Sales Inventory (For SBM, this type is Stock Item.) 2. Discontinued 3. Kit 4. Misc Charges 5. Services 6. Flat Fee (For SBM, this type is Labor.)	Integer	2	View
LOTTYPE	Lot Type	String	12	View
KPERHIST	Keep Period History	Boolean	2	View
KPTRXHST	Keep Trx History	Boolean	2	View
KPCALHST	Keep Calendar History	Boolean	2	View
KPDSTHST	Keep Distribution History	Boolean	2	View
ALWBKORD	Allow Back Orders	Boolean	2	View
ITMGEDSC	Item Generic Description	String	12	View
TAXOPTNS	Tax Options 1. Taxable 2. Nontaxable 3. Base on customers	Integer	2	View
ITMTSHID	Item Tax Schedule ID	String	16	View
COMMCODE	Commission Code	String	16	View
UOMSCHDL	U Of M Schedule	String	12	View
VCTNMTHD	Valuation Method 1. FIFO Perpetual 2. LIFO Perpetual 3. Average Perpetual 4. FIFO Periodic (This value is not available for SBM.) 5. LIFO Periodic (This value is not available for SBM.)	Integer	2	View
USCATVLS_1	User Category Values[1]	String	12	View
USCATVLS_2	User Category Values[2]	String	12	View
USCATVLS_3	User Category Values[3]	String	12	View
USCATVLS_4	User Category Values[4]	String	12	View
USCATVLS_5	User Category Values[5]	String	12	View
USCATVLS_6	User Category Values[6]	String	12	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
DECPLCUR	Decimal Places Currency	Integer	2	View
ICIVICOFDI	IC IV Item Class Ohead Fixed Dollars	Currency	10	View
ICIVICOFPI	IC IV Item Class Ohead Fixed Percent	Long Integer	4	View
ICIVICOVDI	IC IV Item Class Ohead Var Dollars	Currency	10	View
ICIVICOVPI	IC IV Item Class Ohead Var Percent	Long Integer	4	View
ICIVICOFDOPI	IC IV Item Class Fixed Dollars or Percent	Integer	2	View
ICIVICVDOPI	IC IV Item Class Var Dollars or Percent	Integer	2	View
ICIVOUSEI_1	IC IV Overhead Use[1]	Boolean	2	View
ICIVOUSEI_2	IC IV Overhead Use[2]	Boolean	2	View
ICIVOUSEI_3	IC IV Overhead Use[3]	Boolean	2	View
ICIVOUSEI_4	IC IV Overhead Use[4]	Boolean	2	View
ICIVOUSEI_5	IC IV Overhead Use[5]	Boolean	2	View
ICIVOUSEI_6	IC IV Overhead Use[6]	Boolean	2	View
ICIVOUSEI_7	IC IV Overhead Use[7]	Boolean	2	View
ICIVOUSEI_8	IC IV Overhead Use[8]	Boolean	2	View
ICIVOUSEI_9	IC IV Overhead Use[9]	Boolean	2	View
ICIVOUSEI_10	IC IV Overhead Use[10]	Boolean	2	View
ICIVOUSEI_11	IC IV Overhead Use[11]	Boolean	2	View
ICIVOUSEI_12	IC IV Overhead Use[12]	Boolean	2	View
ICIVOUSEI_13	IC IV Overhead Use[13]	Boolean	2	View
ICIVOUSEI_14	IC IV Overhead Use[14]	Boolean	2	View
ICIVOUSEI_15	IC IV Overhead Use[15]	Boolean	2	View
ICIVOUSEI_16	IC IV Overhead Use[16]	Boolean	2	View
ICIVOUSEI_17	IC IV Overhead Use[17]	Boolean	2	View
ICIVOUSEI_18	IC IV Overhead Use[18]	Boolean	2	View
ICIVOUSEI_19	IC IV Overhead Use[19]	Boolean	2	View
ICIVOUSEI_20	IC IV Overhead Use[20]	Boolean	2	View
ICIVOUSEI_21	IC IV Overhead Use[21]	Boolean	2	View
ICIVOUSEI_22	IC IV Overhead Use[22]	Boolean	2	View
ICIVOUSEI_23	IC IV Overhead Use[23]	Boolean	2	View
ICIVOUSEI_24	IC IV Overhead Use[24]	Boolean	2	View
ICIVOUSEI_25	IC IV Overhead Use[25]	Boolean	2	View
ICIVOUSEI_26	IC IV Overhead Use[26]	Boolean	2	View
ICIVOUSEI_27	IC IV Overhead Use[27]	Boolean	2	View
ICIVOUSEI_28	IC IV Overhead Use[28]	Boolean	2	View
ICIVOUSEI_29	IC IV Overhead Use[29]	Boolean	2	View
ICIVOUSEI_30	IC IV Overhead Use[30]	Boolean	2	View
ICIVOUSEI_31	IC IV Overhead Use[31]	Boolean	2	View
ICIVOUSEI_32	IC IV Overhead Use[32]	Boolean	2	View
ICIVOUSEI_33	IC IV Overhead Use[33]	Boolean	2	View
ICIVOUSEI_34	IC IV Overhead Use[34]	Boolean	2	View
ICIVOUSEI_35	IC IV Overhead Use[35]	Boolean	2	View
ICIVOGRPI_1	IC IV Overhead Grouping[1]	Integer	2	View
ICIVOGRPI_2	IC IV Overhead Grouping[2]	Integer	2	View
ICIVOGRPI_3	IC IV Overhead Grouping[3]	Integer	2	View
ICIVOGRPI_4	IC IV Overhead Grouping[4]	Integer	2	View
ICIVOGRPI_5	IC IV Overhead Grouping[5]	Integer	2	View
PRCLEVEL	PriceLevel	String	12	View
MODIFDT	Modified Date	Date	4	View
MDFUSRID	Modified User ID	String	16	View

CT00002 - IC COST Standard Item Class Defaults

Query Builder

Customer Service

Information

My Account

Contact Us