SVC05200 - Returns Line Master | Prospr - Dynamics GP Table Reference

SVC05200 - Returns Line Master

Query Builder

Select * from SVC05200

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
LNSEQNBR	Line SEQ Number	Currency	10	View
SVC_Next_Line_SEQ_Number	SVC Next Line SEQ Number	Currency	10	View
SVC_Prev_Line_SEQ_Number	SVC Prev Line SEQ Number	Currency	10	View
RETTYPE	SVC Return Type	String	12	View
RMA_Status	RMA Status	Integer	2	View
RETSTAT	Return Status	String	4	View
Received	Received	Boolean	2	View
Traveler_Printed	Traveler Printed	Boolean	2	View
SVC_Ready_To_Close	SVC Ready To Close	Boolean	2	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
NOTEINDX	Note Index	Currency	10	View
RETORIG	Return Origin	Integer	2	View
RETREF	Return Reference	String	32	View
SRVRECTYPE	Service Record Type	Integer	2	View
CALLNBR	Service Call Number	String	12	View
EQPLINE	Equipment Line Item Sequence	Long Integer	4	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
SVC_RMA_From_Service	SVC RMA From Service	Boolean	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
SOPNUMBE	SOP Number	String	22	View
CMPNTSEQ	Component Sequence	Long Integer	4	View
SOP_Line_Item_Sequence	SOP Line Item Sequence	Long Integer	4	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
Commit_Date	Commit Date	Date	4	View
Commit_Time	Commit 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
PRMDATE	Promised Date	Date	4	View
REFRENCE	Reference	String	32	View
USERID	User ID	String	16	View
OFFID	Office ID	String	12	View
LOCNCODE	Location Code	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
CUSTNMBR	Customer Number	String	16	View
CUSTNAME	Customer Name	String	66	View
ADRSCODE	Address Code	String	16	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
Bill_To_Customer	Bill To Customer	String	16	View
SVC_Bill_To_Address_Code	SVC Bill To Address Code	String	16	View
CSTPONBR	Customer PO Number	String	22	View
QUANTITY	QTY	Currency	10	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
UOFM	U Of M	String	10	View
ITEMNMBR	Item Number	String	32	View
ITEMDESC	Item Description	String	102	View
UNITCOST	Unit Cost	Currency	10	View
ORUNTCST	Originating Unit Cost	Currency	10	View
EXTDCOST	Extended Cost	Currency	10	View
OREXTCST	Originating Extended Cost	Currency	10	View
UNITPRCE	Unit Price	Currency	10	View
ORUNTPRC	Originating Unit Price	Currency	10	View
XTNDPRCE	Extended Price	Currency	10	View
OXTNDPRC	Originating Extended Price	Currency	10	View
CUSTOWN	Customer Owned	Boolean	2	View
FACTSEAL	Factory Sealed	Boolean	2	View
ORDDOCID	Order Document ID	String	16	View
TRANSLINESEQ	Transfer Line Item Sequence	Long Integer	4	View
STATUS	Transfer Status	Integer	2	View
Flat_Rate_Repair_Price	Flat Rate Repair Price	Currency	10	View
Orig_Flat_RepairPrice	Originating Flat Rate Repair Price	Currency	10	View
Repair_Price	Repair Price	Currency	10	View
Originating_Repair_Price	Originating Repair Price	Currency	10	View
NTE_Price	NTE Price	Currency	10	View
Originating_NTE_Price	Originating NTE Price	Currency	10	View
Repair_Cost	Repair Cost	Currency	10	View
Originating_Repair_Cost	Originating Repair Cost	Currency	10	View
Bill_of_Lading	Bill of Lading	String	32	View
SHIPMTHD	Shipping Method	String	16	View
Credit_SOP_Type	Credit SOP Type	Integer	2	View
Credit_SOP_Number	Credit SOP Number	String	22	View
Credit_SOP_Line_Item_Seq	Credit SOP Line Item Sequence	Long Integer	4	View
Replace_SOP_Type	Replace SOP Type	Integer	2	View
Replace_SOP_Number	Replace SOP Number	String	22	View
Replace_SOP_Line_Item_Se	Replace SOP Line Item Sequence	Long Integer	4	View
Location_Code_Replacemen	Location Code Replacement	String	12	View
Replace_Item_Number	Replace Item Number	String	32	View
Replace_U_Of_M	Replace U Of M	String	10	View
Replace_Price_Level	Replace Price Level	String	12	View
Replace_QTY	Replace QTY	Currency	10	View
Replace_Cost	Replace Cost	Currency	10	View
Originating_Replace_Cost	Originating Replace Cost	Currency	10	View
Replace_Price	Replace Price	Currency	10	View
Originating_Replace_Pric	Originating Replace Price	Currency	10	View
SOP_Number_Invoice	SOP Number Invoice	String	22	View
Item_Number_Invoice	Item Number Invoice	String	32	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
CURRNIDX	Currency Index	Integer	2	View
DECPLCUR	Decimal Places Currency	Integer	2	View
ODECPLCU	Originating Decimal Places Currency	Integer	2	View
Return_Item_Number	Return Item Number	String	32	View
Return_Item_Description	Return Item Description	String	102	View
Return_Location_Code	Return Location Code	String	12	View
Return_QTY	Return QTY	Currency	10	View
Return_U_Of_M	Return U Of M	String	10	View
RETCOST	Return Cost	Currency	10	View
Originating_Return_Cost	Originating Return Cost	Currency	10	View
SVC_Extended_Return_Cost	SVC Extended Return Cost	Currency	10	View
SVC_Orig_Ext_Return_Cost	SVC Originating Extended Return Cost	Currency	10	View
SVC_Return_Price_Level	SVC Return Price Level	String	12	View
SVC_Return_Price	SVC Return Price	Currency	10	View
Originating_Return_Price	Originating Return Price	Currency	10	View
SVC_Extended_Return_Pric	SVC Extended Return Price	Currency	10	View
SVC_Orig_Ext_Return_Pric	SVC Originating Extended Return Price	Currency	10	View
SVC_FO_ID	SVC FO ID	String	52	View
SVC_SCM_Complete	SVC SCM Complete	Integer	2	View
svcRMAKitComponentFrom	svcRMAKitComponentFrom	Integer	2	View
svcRMAComponentSeq	svcRMAComponentSeq	Long Integer	4	View
CMPITQTY	Component Item QTY	Currency	10	View
QTYONHND	QTY On Hand	Currency	10	View
QTYRTRND	QTY Returned	Currency	10	View
QTYINUSE	QTY In Use	Currency	10	View
QTYINSVC	QTY In Service	Currency	10	View
QTYDMGED	QTY Damaged	Currency	10	View
svcReverseFlag	svcReverseFlag	Boolean	2	View
svcRMAallocated	svcRMAallocated	Boolean	2	View

SVC05200 - Returns Line Master

Query Builder

Customer Service

Information

My Account

Contact Us