SVC05015 - SVC_RMA_Receiving_WORK | Prospr - Dynamics GP Table Reference

SVC05015 - SVC_RMA_Receiving_WORK

Select * from SVC05015

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID	User ID	String	16	View
RETDOCID	Return Document ID	String	16	View
LNSEQNBR	Line SEQ Number	Currency	10	View
RMA_Status	RMA Status	Integer	2	View
TECHID	Tech ID	String	12	View
RETTYPE	SVC Return Type	String	12	View
OFFID	Office ID	String	12	View
CUSTNMBR	Customer Number	String	16	View
ADRSCODE	Address Code	String	16	View
CUSTNAME	Customer Name	String	66	View
QUANTITY	QTY	Currency	10	View
ITEMNMBR	Item Number	String	32	View
Return_Item_Number	Return Item Number	String	32	View
Return_QTY	Return QTY	Currency	10	View
LOCNCODE	Location Code	String	12	View
BINNMBR	Bin Number	String	22	View
ORDDOCID	Order Document ID	String	16	View
CALLNBR	Service Call Number	String	12	View
RETREF	Return Reference	String	32	View
CB_Packing_Slip	CB Packing Slip	Boolean	2	View
CHDFLAG	Child Flag	Boolean	2	View
MKDTOPST	Marked To Post	Boolean	2	View
POSTED	Posted	Boolean	2	View
ERMSGNBR	Error Message Number	Integer	2	View
ERMSGTXT	Error Message Text	String	256	View
ERMSGTX2	Error Message Text 2	String	256	View
SOPTYPE	SOP Type 1 = Quote 2 = Order 3 = Invoice 4 = Return 5 = Back Order 6 = Fulfillment Order (In SBF, this value is not available.)	Integer	2	View
SOPNUMBE	SOP Number	String	22	View
UOFM	U Of M	String	10	View
Return_U_Of_M	Return U Of M	String	10	View
DECPLQTY	Decimal Places QTYS	Integer	2	View