SVC00250 - Service Serial/Lot Work and History | Prospr

SVC00250 - Service Serial/Lot Work and History

Select * from SVC00250

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
SRVRECTYPE	Service Record Type	Integer	2	View
CALLNBR	Service Call Number	String	12	View
EQPLINE	Equipment Line Item Sequence	Long Integer	4	View
LINITMTYP	Line Item Type	String	4	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
QTYTYPE	QTY Type 1 = On Hand 2 = Returned 3 = In Use 4 = In Service 5 = Damaged	Integer	2	View
SERLTNUM	Serial/Lot Number	String	22	View
SERLTQTY	Serial/Lot QTY	Currency	10	View
SLTSQNUM	Serial/Lot SEQ Number	Long Integer	4	View
DATERECD	Date Received	Date	4	View
DTSEQNUM	Date SEQ Number	Currency	10	View
UNITCOST	Unit Cost	Currency	10	View
ITEMNMBR	Item Number	String	32	View
TRXSORCE	TRX Source	String	14	View
POSTED	Posted	Boolean	2	View
OVRSERLT	Override Serial/Lot	Integer	2	View
EQUIPID	Equipment ID	Long Integer	4	View
BIN	Bin	String	16	View
MFGDATE	Manufacture Date	Date	4	View
EXPNDATE	Expiration Date	Date	4	View
CMPNTSEQ	Component Sequence	Long Integer	4	View