ADItemPr - AD Item Properties | Prospr - Dynamics GP Table Reference

ADItemPr - AD Item Properties

Select * from ADItemPr

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
AD_Item_Saved	AD Item Saved	Boolean	2	View
ADBUY	AD Buy	Boolean	2	View
ADDSGNAUTH	AD Design Authority	String	102	View
ADREVNMBR	AD Revision Number	String	52	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
AD_ItemExists	AD ItemExists	Boolean	2	View
ADITEMNMBR	AD Item Number	String	52	View
ITMCLSCD	Item Class Code	String	12	View
UOFM	U Of M	String	10	View
UOMSCHDL	U Of M Schedule	String	12	View
ADITEMDESC	AD Item Description	Text	2	View