SVC05501 - Return Type Validation Codes | Prospr

SVC05501 - Return Type Validation Codes

Select * from SVC05501

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
RETTYPE	SVC Return Type	String	12	View
DSCRIPTN	Description	String	32	View
RETSTAT	Return Status	String	4	View
Received_Status	Received Status	String	4	View
Shipping_Status	Shipping Status	String	4	View
Close_Status	Close Status	String	4	View
RETPATH	Return Path	Integer	2	View
VNDWARRTYPE	Vendor Warranty Type	String	12	View
RTV_Type	RTV Type	String	12	View
DEPOTTYPE	Depot Type	String	12	View
ORDDOCID	Order Document ID	String	16	View
CRDOCID	Credit Document ID	String	16	View
INVDOCID	Invoice Document ID	String	16	View
LOCNCODE	Location Code	String	12	View
ITLOCN	Intransit Location	String	12	View
ITEMNMBR	Item Number	String	32	View
SVC_Discrepancy_Status	SVC Discrepancy Status	String	4	View
SVC_RMA_Invoice_Batch_ID	SVC RMA Invoice Batch ID	String	16	View
SVC_RMA_Credit_Batch_ID	SVC RMA Credit Batch ID	String	16	View
SVC_RMA_Order_Batch_ID	SVC RMA Order Batch ID	String	16	View
SVC_Sales_Return_Index	SVC Sales Return Index	Long Integer	4	View
SVC_COGS_Index	SVC COGS Index	Long Integer	4	View
SVC_Scrap_Index	SVC Scrap Index	Long Integer	4	View
SVC_Repair_Sales_Index	SVC Repair Sales Index	Long Integer	4	View
SVC_Partial_Received_Sta	SVC Partial Received Status	String	4	View
SVC_Ready_To_Close_Statu	SVC Ready To Close Status	String	4	View
SVCSCRAPCOGREV	SVC Scrap COGS Reversal	Boolean	2	View
QTYTYPE	QTY Type 1 = On Hand 2 = Returned 3 = In Use 4 = In Service 5 = Damaged	Integer	2	View