IV50300 - ABC Analysis Temp | Prospr - Dynamics GP Table Reference

IV50300 - ABC Analysis Temp

Select * from IV50300

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ITEMNMBR	Item Number	String	32	View
ITEMDESC	Item Description	String	102	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
ABCCODE	ABC Code 1 – (None) 2 – A 3 – B 4 – C	Integer	2	View
SGGSTDABCCD	Suggested ABC Code	Integer	2	View
INCLUDEITEM	Include Item	Boolean	2	View
QTYONHND	QTY On Hand	Currency	10	View
PRCNTOFTTL	Percent of Total	Currency	10	View
CMLTVPRCNTOFTTL	Cumulative Percent of Total	Currency	10	View
CMLTVPRCNTOFITMS	Cumulative Percent of Items	Currency	10	View
UNITCOST	Unit Cost	Currency	10	View
RANKINGVALUE	Ranking Value	Currency	10	View
SMMRYDPNDNTUSGQTY	Summary Dependent Usage QTY	Currency	10	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
DECPLCUR	Decimal Places Currency	Integer	2	View
UPDATED	Updated	Boolean	2	View