SVC00710 - SVC_Inventory_Requirements_Work | Prospr - Dynamics GP Table Reference

SVC00710 - SVC_Inventory_Requirements_Work

Query Builder

Select * from SVC00710

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
SRCDOCNUM	Source Doc Number	String	22	View
SRCDOCTYP	Source Doc Type	Integer	2	View
ITEMNMBR	Item Number	String	32	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
ITEMDESC	Item Description	String	102	View
LOCNCODE	Location Code	String	12	View
QTYORDER	QTY Ordered	Currency	10	View
TRNSFLOC	Transfer From Location	String	12	View
TECHID	Tech ID	String	12	View
QTYBACKO	QTY Backordered	Currency	10	View
UOFM	U Of M	String	10	View
ATYALLOC	QTY Allocated	Currency	10	View
TRNSFQTY	Transfer From QTY	Currency	10	View
STATIONID	Depot Station ID	String	12	View
OFFID	Office ID	String	12	View
TRNFLAG	Transfer Flag	Boolean	2	View
SVC_Disable_XFR_Grouping	SVC_Disable_XFR_Grouping	Boolean	2	View
USERID	User ID	String	16	View
ERMSGNBR	Error Message Number	Integer	2	View
ERMSGTXT	Error Message Text	String	256	View
ERMSGTX2	Error Message Text 2	String	256	View
VENDORID	Vendor ID	String	16	View
SVC_Address_Option	SVC_Address_Option	Integer	2	View
SVC_Misc_Address_Code	SVC_Misc_Address_Code	String	16	View
PRMDATE	Promised Date	Date	4	View
MKDTOPST	Marked To Post	Boolean	2	View
LINITMTYP	Line Item Type	String	4	View
CMPNTSEQ	Component Sequence	Long Integer	4	View