SVC35602 - SVC_RTV_Serial_Lot_Work_HIST | Prospr

SVC35602 - SVC_RTV_Serial_Lot_Work_HIST

Select * from SVC35602

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
RTV_Number	RTV Number	String	16	View
RTV_Line	RTV Line	Currency	10	View
QTYTYPE	QTY Type 1 = On Hand 2 = Returned 3 = In Use 4 = In Service 5 = Damaged	Integer	2	View
SERLTQTY	Serial/Lot QTY	Currency	10	View
SLTSQNUM	Serial/Lot SEQ Number	Long Integer	4	View
ITEMNMBR	Item Number	String	32	View
SERLNMBR	Serial Number	String	22	View
SVC_Serial_ID	SVC Serial ID	String	22	View
EQUIPID	Equipment ID	Long Integer	4	View
Return_Item_Number	Return Item Number	String	32	View
Return_Serial_Number	Return Serial Number	String	22	View
SVC_Return_Serial_ID	SVC Return Serial ID	String	22	View
Return_Equipment_ID	Return Equipment ID	Long Integer	4	View
BIN	Bin	String	16	View
TOBIN	To Bin	String	16	View
RETCOST	Return Cost	Currency	10	View
SVC_Original_Serial	SVC Original Serial	Boolean	2	View
DATERECD	Date Received	Date	4	View
DTSEQNUM	Date SEQ Number	Currency	10	View
TRXSORCE	TRX Source	String	14	View
Shipped	Shipped	Boolean	2	View
MARKED	Marked	Boolean	2	View
POSTED	Posted	Boolean	2	View
MFGDATE	Manufacture Date	Date	4	View
EXPNDATE	Expiration Date	Date	4	View