SEE30303 - Inventory Transaction History Detail | Prospr

SEE30303 - Inventory Transaction History Detail

Query Builder

Select * from SEE30303

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ITEMNMBR	Item Number	String	32	View
SEQNUMBR	Sequence Number	Long Integer	4	View
DOCDATE	Document Date	Date	4	View
GLPOSTDT	GL Posting Date	Date	4	View
DOCNUMBR	Document Number	String	22	View
DOCTYPE	Document Type	Integer	2	View
LOCNCODE	Location Code	String	12	View
RCPTNMBR	Receipt Number	String	22	View
RCTSEQNM	Receipt SEQ Number	Long Integer	4	View
PCHSRCTY	Purchase Receipt Type	Integer	2	View
QTYTYPE	QTY Type 1 = On Hand 2 = Returned 3 = In Use 4 = In Service 5 = Damaged	Integer	2	View
UOFM	U Of M	String	10	View
TRXQTYInBase	TRX QTY In Base	Currency	10	View
TRXQTY	TRX QTY	Currency	10	View
VARIANCEQTY	Variance Qty	Currency	10	View
UNITCOST	Unit Cost	Currency	10	View
EXTDCOST	Extended Cost	Currency	10	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
DECPLCUR	Decimal Places Currency	Integer	2	View
IsOverrideReceipt	IsOverrideReceipt	Boolean	2	View
IsOverrideRelieved	IsOverrideRelieved	Boolean	2	View
OverrideRelievedDate	OverrideRelievedDate	Date	4	View
RCPTNMBR1	Originating Revalued Receipt Number	String	22	View
HSTMODUL	History Module	String	4	View
ORTRXSRC	Originating TRX Source	String	14	View
LNSEQNBR	Line SEQ Number	Currency	10	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
CMPNTSEQ	Component Sequence	Long Integer	4	View
SRCRFRNCNMBR	Source Reference Number	String	32	View
VENDORID	Vendor ID	String	16	View
PONUMBER	PO Number	String	18	View
TRXREFERENCE	Transaction Reference	Integer	2	View
VCTNMTHD	Valuation Method 1. FIFO Perpetual 2. LIFO Perpetual 3. Average Perpetual 4. FIFO Periodic (This value is not available for SBM.) 5. LIFO Periodic (This value is not available for SBM.)	Integer	2	View
IVIVINDX	IV IV Index	Long Integer	4	View
IVIVOFIX	IV IV Offset Index	Long Integer	4	View
JRNENTRY	Journal Entry	Long Integer	4	View
TRXSORCE	TRX Source	String	14	View
DEBITAMT	Debit Amount	Currency	10	View
CRDTAMNT	Credit Amount	Currency	10	View
DATE1	Date	Date	4	View
TIME1	Time	Time	4	View

SEE30303 - Inventory Transaction History Detail

Query Builder

Customer Service

Information

My Account

Contact Us