SOP50400 - Extended Pricing Promotion Inquiry Temp | Prospr

SOP50400 - Extended Pricing Promotion Inquiry Temp

Select * from SOP50400

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID	User ID	String	16	View
ITEMNMBR	Item Number	String	32	View
UOFM	U Of M	String	10	View
PRCSHID	PriceSheetID	String	16	View
EPITMTYP	ExtPricingItemType	String	2	View
STRTDATE	Start Date	Date	4	View
ENDDATE	End Date	Date	4	View
QTYFROM	QTYFrom	Currency	10	View
QTYTO	QTYTo	Currency	10	View
PSITMVAL	PriceSheetItemValue	Currency	10	View
EQUOMQTY	Equivalent U Of M QTY	Currency	10	View
BASEUOFM	Base U Of M	String	10	View
PROMOLVL	PromotionLevel	Integer	2	View
PROMOTYP	PromotionType	Integer	2	View
PRCGRPID	PriceGroupID	String	32	View
PRODTCOD	PromotionDetailCode	String	2	View
ACTIVE	Active 0 = False, for inactive records 1 = True, for active records	Boolean	2	View