QAD10532 - QA_SCAR | Prospr - Dynamics GP Table Reference

QAD10532 - QA_SCAR

Query Builder

Select * from QAD10532

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
POPRCTNM	POP Receipt Number	String	18	View
RCPTLNNM	Receipt Line Number	Long Integer	4	View
PONUMBER	PO Number	String	18	View
POLNENUM	PO Line Number	Long Integer	4	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