SVC05000 - Returns Master | Prospr - Dynamics GP Table Reference

SVC05000 - Returns Master

Query Builder

Select * from SVC05000

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
RETDOCID	Return Document ID	String	16	View
Return_Record_Type	Return Record Type	Integer	2	View
RMA_Status	RMA Status	Integer	2	View
Received	Received	Boolean	2	View
RETORIG	Return Origin	Integer	2	View
RETREF	Return Reference	String	32	View
RETSTAT	Return Status	String	4	View
RETTYPE	SVC Return Type	String	12	View
ENTDTE	Entry Date	Date	4	View
ENTTME	Entry Time	Time	4	View
ETADTE	ETA Date	Date	4	View
ETATME	ETA Time	Time	4	View
RETUDATE	Return Date	Date	4	View
Return_Time	Return Time	Time	4	View
COMPDTE	Complete Date	Date	4	View
COMPTME	Complete Time	Time	4	View
USERID	User ID	String	16	View
OFFID	Office ID	String	12	View
RTRNNAME	Return Address Name	String	46	View
RETADDR1	Return Address 1	String	62	View
RETADDR2	Return Address 2	String	62	View
RETADDR3	Return Address 3	String	62	View
RTRNCITY	Return Address City	String	22	View
SVC_Return_State	SVC Return State	String	30	View
RTRNZIP	Return Address Zip Code	String	12	View
Return_Country	Return Country	String	62	View
LOCNCODE	Location Code	String	12	View
CUSTNMBR	Customer Number	String	16	View
ADRSCODE	Address Code	String	16	View
CUSTNAME	Customer Name	String	66	View
CONTACT	Contact	String	62	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
ADDRESS3	Address 3	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIPCODE	Zip Code	String	12	View
COUNTRY	Country	String	62	View
NOTEINDX	Note Index	Currency	10	View
CALLNBR	Service Call Number	String	12	View
SRVRECTYPE	Service Record Type	Integer	2	View
EQPLINE	Equipment Line Item Sequence	Long Integer	4	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
Bill_of_Lading	Bill of Lading	String	32	View
SHIPMTHD	Shipping Method	String	16	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
SOP_Line_Item_Sequence	SOP Line Item Sequence	Long Integer	4	View
CMPNTSEQ	Component Sequence	Long Integer	4	View
Bill_To_Customer	Bill To Customer	String	16	View
SVC_Bill_To_Address_Code	SVC Bill To Address Code	String	16	View
Commit_Date	Commit Date	Date	4	View
Commit_Time	Commit Time	Time	4	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
USRDEF03	User Defined 3	String	22	View
USRDEF04	User Defined 4	String	22	View
USRDEF05	User Defined 5	String	22	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
RATETPID	Rate Type ID	String	16	View
EXGTBLID	Exchange Table ID	String	16	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
EXCHDATE	Exchange Date	Date	4	View
DECPLACS	Decimal Places	Integer	2	View
TIME1	Time	Time	4	View
RATECALC	Rate Calc Method	Integer	2	View
VIEWMODE	View Mode	Integer	2	View
ISMCTRX	IS MC Trx	Integer	2	View
EXPNDATE	Expiration Date	Date	4	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
MCTRXSTT	MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. 1 = Originating is not a denomination; Functional is not a denomination 2 = Originating is not a denomination; Functional is the Euro currency. 3 = Originating is not a denomination; Functional is a denomination. 4 = Originating is a denomination; Functional is not a denomination. 5 = Originating is a denomination; Functional is a denomination. 6 = Originating is a denomination; Functional is the Euro currency. 7 = Originating is the Euro currency; Functional is a denomination. 8 = Originating is the Euro currency; Functional is not a denomination.	Integer	2	View
CSTPONBR	Customer PO Number	String	22	View
SVC_RMA_Reason_Code	SVC_RMA_Reason_Code	String	4	View
SVC_RMA_Reason_Code_Desc	SVC_RMA_Reason_Code_Desc	String	32	View
SVC_RMA_From_Service	SVC RMA From Service	Boolean	2	View
SVC_FO_ID	SVC FO ID	String	52	View

SVC05000 - Returns Master

Query Builder

Customer Service

Information

My Account

Contact Us