IV10000 - Inventory Transaction Work | Prospr

IV10000 - Inventory Transaction Work

Select * from IV10000

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
BACHNUMB	Batch Number	String	16	View
BCHSOURC	Batch Source	String	16	View
IVDOCNBR	IV Document Number	String	18	View
RCDOCNUM	Recurring Document Number	String	22	View
IVDOCTYP	IV Document Type	Integer	2	View
DOCDATE	Document Date	Date	4	View
MODIFDT	Modified Date	Date	4	View
MDFUSRID	Modified User ID	String	16	View
POSTEDDT	Posted Date	Date	4	View
PTDUSRID	Posted User ID	String	16	View
GLPOSTDT	GL Posting Date	Date	4	View
PSTGSTUS	Posting Status 1 = Work 2 = Open 3 = History 4 = Originating	Integer	2	View
TRXQTYTL	TRX QTY Total	Currency	10	View
IVWHRMSG	IV WORK HDR Messages	Long Integer	4	View
NOTEINDX	Note Index	Currency	10	View
SRCRFRNCNMBR	Source Reference Number	String	32	View
SOURCEINDICATOR	Source Indicator 1 – (none) 2 – Issue 3 – Reverse Issue 4 – Finished Good Post 5 – Reverse Finished Good Post 6 – Stock Count 7 – Field Service – Service Call 8 – Field Service – Return Material Authoization 9 – Field Service – Return to Vendor 10 – Field Service – Work Order 11 – Project Accounting	Integer	2	View