QA010532 - QA_HIST_SCAR | Prospr - Dynamics GP Table Reference

QA010532 - QA_HIST_SCAR

Select * from QA010532

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
SCAR_Number	SCAR Number	String	22	View
nsrnum	NSR Number	String	22	View
DATEENTERED_I	Date Entered	Date	4	View
ITEMNMBR	Item Number	String	32	View
VENDORID	Vendor ID	String	16	View
ORIGINATOR	Originator	String	16	View
PORDNMBR	Purchase Order Number	String	22	View
RECEIVINGNUMBER_I	Receiving Number	String	22	View
RECTRANSNUMBER_I	Receiving Transaction Number	Integer	2	View
LOCNCODE	Location Code	String	12	View
VENDNAME	Vendor Name	String	66	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIPCODE	Zip Code	String	12	View
PHNUMBR1	Phone Number 1	String	22	View
PHNUMBR2	Phone Number 2	String	22	View
FAXNUMBR	Fax Number	String	22	View
ITEMDESC	Item Description	String	102	View
VNDITNUM	Vendor Item Number	String	32	View
QTYRECEIVED2_I	QTY Received2	Currency	10	View
BASEUOFM	Base U Of M	String	10	View
DATEDUE_I	Date Due	Date	4	View
DATEIN_I	Date In	Date	4	View
VNDCNTCT	Vendor Contact	String	62	View
PHONNAME	Phone Number	String	22	View
USERID	User ID	String	16	View
CHANGEDATE_I	Change Date	Date	4	View
MFGNOTEINDEX_I	MFG Note Index	Currency	10	View
MFGNOTEINDEX2_I	MFG Note Index2	Currency	10	View
MFGNOTEINDEX3_I	MFG Note Index3	Currency	10	View
MFGNOTEINDEX4I	MFG Note Index4	Currency	10	View
MFGNOTEINDEX5I	MFG Note Index5	Currency	10	View
MFGNOTEINDEX6I	MFG Note Index6	Currency	10	View