SVC00501 - Delta Item Master | Prospr - Dynamics GP Table Reference

SVC00501 - Delta Item Master

Select * from SVC00501

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ITEMNMBR	Item Number	String	32	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
ITEMDESC	Item Description	String	102	View
ITMSHNAM	Item Short Name	String	16	View
ITMTRKOP	Item Tracking Option 1. None 2. Serial Numbers 3. Lot Numbers	Integer	2	View
LISTPRCE	List Price	Currency	10	View
RTRNABLE	Returnable	Boolean	2	View
METERED	Metered	Boolean	2	View
SVC_Delta_Type	SVC Delta Type	Integer	2	View
MODIFDT	Modified Date	Date	4	View