SVC5000V - SVC_RMA_MSTR_View_All | Prospr - Dynamics GP Table Reference

SVC5000V - SVC_RMA_MSTR_View_All

Query Builder

Select * from SVC5000V

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
RETSTAT	Return Status	String	4	View
OFFID	Office ID	String	12	View
LOCNCODE	Location Code	String	12	View
CUSTNMBR	Customer Number	String	16	View
CUSTNAME	Customer Name	String	66	View
SOP_Line_Item_Sequence	SOP Line Item Sequence	Long Integer	4	View
SOPNUMBE	SOP Number	String	22	View
RMA_Status	RMA Status	Integer	2	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
ADDRESS3	Address 3	String	62	View
ADRSCODE	Address Code	String	16	View
Bill_To_Customer	Bill To Customer	String	16	View
Bill_of_Lading	Bill of Lading	String	32	View
CITY	City	String	36	View
Commit_Date	Commit Date	Date	4	View
Commit_Time	Commit Time	Time	4	View
COMPDTE	Complete Date	Date	4	View
COMPTME	Complete Time	Time	4	View
CMPNTSEQ	Component Sequence	Long Integer	4	View
CONTACT	Contact	String	62	View
COUNTRY	Country	String	62	View
CURNCYID	Currency ID	String	16	View
CSTPONBR	Customer PO Number	String	22	View
CURRNIDX	Currency Index	Integer	2	View
DECPLACS	Decimal Places	Integer	2	View
RETTYPE	SVC Return Type	String	12	View
RETREF	Return Reference	String	32	View
Return_Time	Return Time	Time	4	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
ETADTE	ETA Date	Date	4	View
ETATME	ETA Time	Time	4	View
ENTDTE	Entry Date	Date	4	View
ENTTME	Entry Time	Time	4	View
EQPLINE	Equipment Line Item Sequence	Long Integer	4	View
EXCHDATE	Exchange Date	Date	4	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
EXGTBLID	Exchange Table ID	String	16	View
EXPNDATE	Expiration Date	Date	4	View
ISMCTRX	IS MC Trx	Integer	2	View
LNITMSEQ	Line Item Sequence	Long Integer	4	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
NOTEINDX	Note Index	Currency	10	View
RATECALC	Rate Calc Method	Integer	2	View
RATETPID	Rate Type ID	String	16	View
Received	Received	Boolean	2	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
RTRNNAME	Return Address Name	String	46	View
RTRNZIP	Return Address Zip Code	String	12	View
Return_Country	Return Country	String	62	View
RETUDATE	Return Date	Date	4	View
RETORIG	Return Origin	Integer	2	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
SVC_Bill_To_Address_Code	SVC Bill To Address Code	String	16	View
SVC_FO_ID	SVC FO ID	String	52	View
SVC_RMA_From_Service	SVC RMA From Service	Boolean	2	View
SVC_Return_State	SVC Return State	String	30	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
CALLNBR	Service Call Number	String	12	View
SRVRECTYPE	Service Record Type	Integer	2	View
SHIPMTHD	Shipping Method	String	16	View
STATE	State	String	30	View
TIME1	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
USERID	User ID	String	16	View
VIEWMODE	View Mode	Integer	2	View
ZIPCODE	Zip Code	String	12	View

SVC5000V - SVC_RMA_MSTR_View_All

Query Builder

Customer Service

Information

My Account

Contact Us