IV10001 - Inventory Transaction Amounts Work | Prospr

IV10001 - Inventory Transaction Amounts Work

Select * from IV10001

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
IVDOCNBR	IV Document Number	String	18	View
IVDOCTYP	IV Document Type	Integer	2	View
ITEMNMBR	Item Number	String	32	View
LNSEQNBR	Line SEQ Number	Currency	10	View
UOFM	U Of M	String	10	View
QTYBSUOM	QTY In Base U Of M	Currency	10	View
TRXQTY	TRX QTY	Currency	10	View
UNITCOST	Unit Cost	Currency	10	View
EXTDCOST	Extended Cost	Currency	10	View
TRXLOCTN	TRX Location	String	12	View
TRNSTLOC	Transfer To Location	String	12	View
TRFQTYTY	Transfer From QTY Type 1 = On Hand 2 = Returned 3 = In Use 4 = In Service 5 = Damaged	Integer	2	View
TRTQTYTY	Transfer To QTY Type 1 = On Hand 2 = Returned 3 = In Use 4 = In Service 5 = Damaged	Integer	2	View
IVIVINDX	IV IV Index	Long Integer	4	View
IVIVOFIX	IV IV Offset Index	Long Integer	4	View
IVWLNMSG	IV WORK LINE Messages	Long Integer	4	View
DECPLCUR	Decimal Places Currency	Integer	2	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
USAGETYPE	Usage Type	Integer	2	View
Reason_Code	Reason Code	String	16	View