IV10201 - Inventory Purchase Receipts Detail | Prospr

IV10201 - Inventory Purchase Receipts Detail

Select * from IV10201

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ITEMNMBR	Item Number	String	32	View
TRXLOCTN	TRX Location	String	12	View
QTYTYPE	QTY Type 1 = On Hand 2 = Returned 3 = In Use 4 = In Service 5 = Damaged	Integer	2	View
DOCDATE	Document Date	Date	4	View
RCTSEQNM	Receipt SEQ Number	Long Integer	4	View
ORIGINDOCTYPE	Originating Document Type	Integer	2	View
ORIGINDOCID	Originating Document ID	String	32	View
LNSEQNBR	Line SEQ Number	Currency	10	View
CMPNTSEQ	Component Sequence	Long Integer	4	View
QTYSOLD	QTY Sold	Currency	10	View
UNITCOST	Unit Cost	Currency	10	View
IVIVINDX	IV IV Index	Long Integer	4	View
IVIVOFIX	IV IV Offset Index	Long Integer	4	View
SRCRCTSEQNM	Source Receipt SEQ Number	Long Integer	4	View
TRXREFERENCE	Transaction Reference	Integer	2	View
PCHSRCTY	Purchase Receipt Type	Integer	2	View