CT00102 - IC COST Item Master | Prospr - Dynamics GP Table Reference

CT00102 - IC COST Item Master

Query Builder

Select * from CT00102

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ITEMNMBR	Item Number	String	32	View
ITEMDESC	Item Description	String	102	View
NOTEINDX	Note Index	Currency	10	View
ITMSHNAM	Item Short Name	String	16	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
ITMGEDSC	Item Generic Description	String	12	View
STNDCOST	Standard Cost	Currency	10	View
CURRCOST	Current Cost	Currency	10	View
LISTPRCE	List Price	Currency	10	View
ITEMSHWT	Item Shipping Weight	Long Integer	4	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
DECPLCUR	Decimal Places Currency	Integer	2	View
ITMTSHID	Item Tax Schedule ID	String	16	View
TAXOPTNS	Tax Options 1. Taxable 2. Nontaxable 3. Base on customers	Integer	2	View
COMMCODE	Commission Code	String	16	View
ICIVMFIXI	IC IV Material Fixed Index	Long Integer	4	View
ICIVMVIXI	IC IV Material Var Index	Long Integer	4	View
ICIVLVIXI	IC IV Labor Var Index	Long Integer	4	View
ICIVLABVAROHIX_I	IC IV Lab Variance OH Index	Long Integer	4	View
ICIVLABVAROHVARIX_I	IC IV Lab Variance OH Var Index	Long Integer	4	View
ICIVMEVIXI	IC IV Machine Efficiency Var Index	Long Integer	4	View
ICIVMACHEFFVAROHIX_I	IC IV Mach Eff Variance OH Index	Long Integer	4	View
ICIVMACHEFFVAROHVARIX_I	IC IV Mach Eff Variance OH Var Index	Long Integer	4	View
ICIVMUIXI	IC IV Material Usage Var Index	Long Integer	4	View
ICIVMATUSAGEVAROHIX_I	IC IV Mat Usage Variance OH Index	Long Integer	4	View
ICIVMATUSAGEVAROHVARIX_I	IC IV Mat Usage Variance OH Var Index	Long Integer	4	View
ICIVOVIXI	IC IV Overhead Var Index	Long Integer	4	View
ICIVPVIXI	IC IV Purchase Price Var Index	Long Integer	4	View
ICIVSCIXI	IC IV Standard Cost Reval Index	Long Integer	4	View
ICIVROIXI	IC IV Returns Offset Index	Long Integer	4	View
ICIVWMIXI	IC IV WIP Material Index	Long Integer	4	View
ICIVUPPV_I	IC IV Unrealized PPV Index	Long Integer	4	View
ICIVWMATOHIXI	IC IV WIP Material OH Index	Long Integer	4	View
ICIVWIPMATOHVARIX_I	IC IV WIP Material OH Var Index	Long Integer	4	View
ICIVWLIXI	IC IV WIP Labor Index	Long Integer	4	View
ICIVWLOHIXI	IC IV WIP Labor OH Index	Long Integer	4	View
ICIVWIPLABOHVARIX_I	IC IV WIP Labor OH Var Index	Long Integer	4	View
ICIVWCIXI	IC IV WIP Machine Index	Long Integer	4	View
ICIVWMACHOHIXI	IC IV WIP Machine OH Index	Long Integer	4	View
ICIVWIPMACHOHVARIX_I	IC IV WIP Machine OH Var Index	Long Integer	4	View
ICIVWOIXI	IC IV WIP Overhead Index	Long Integer	4	View
ICIVCMIXI	IC IV CoGS Material Index	Long Integer	4	View
ICIVCMATOHIXI	IC IV CoGS Material OH Index	Long Integer	4	View
ICIVCOGSMATOHVARIX_I	IC IV CoGS Material OH Var Index	Long Integer	4	View
ICIVCLIXI	IC IV CoGS Labor Index	Long Integer	4	View
ICIVCLABOHIXI	IC IV CoGS Labor OH Index	Long Integer	4	View
ICIVCOGSLABOHVARIX_I	IC IV CoGS Labor OH Var Index	Long Integer	4	View
ICIVCCIXI	IC IV CoGS Machine Index	Long Integer	4	View
ICIVCMACHOHIXI	IC IV CoGS Machine OH Index	Long Integer	4	View
ICIVCOGSMACHOHVARIX_I	IC IV CoGS Machine OH Var Index	Long Integer	4	View
ICIVCOIXI	IC IV CoGS Overhead Index	Long Integer	4	View
ICIVILIXI	IC IV INV Labor Index	Long Integer	4	View
ICIVILABOHIXI	IC IV INV Labor OH Index	Long Integer	4	View
ICIVINVLABOHVARIX_I	IC IV INV Labor OH Var Index	Long Integer	4	View
ICIVIMXI	IC IV INV Machine Index	Long Integer	4	View
ICIVIMACHOHIXI	IC IV INV Machine OH Index	Long Integer	4	View
ICIVINVMACHOHVARIX_I	IC IV INV Machine OH Var Index	Long Integer	4	View
ICIVIMATOHIXI	IC IV INV Material OH Index	Long Integer	4	View
ICIVINVMATOHVARIX_I	IC IV INV Material OH Var Index	Long Integer	4	View
ITMCLSCD	Item Class Code	String	12	View
ITMTRKOP	Item Tracking Option 1. None 2. Serial Numbers 3. Lot Numbers	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
ITMKTFLG	Item Kit Flag	Boolean	2	View
ALWBKORD	Allow Back Orders	Boolean	2	View
FSHGDFLG	Finished Good Flag	Boolean	2	View
CMPTFLAG	Component Flag	Boolean	2	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
UOMSCHDL	U Of M Schedule	String	12	View
ALTITEM1	Alternate Item 1	String	32	View
ALTITEM2	Alternate Item 2	String	32	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
MSTRCDTY	Master Record Type	Integer	2	View
MODIFDT	Modified Date	Date	4	View
MDFUSRID	Modified User ID	String	16	View
CREATDDT	Created Date	Date	4	View
WRNTYDYS	Warranty Days	Integer	2	View
PRCLEVEL	PriceLevel	String	12	View

CT00102 - IC COST Item Master

Query Builder

Customer Service

Information

My Account

Contact Us