IV70500 - Inventory Report Options | Prospr - Dynamics GP Table Reference

IV70500 - Inventory Report Options

Query Builder

Select * from IV70500

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PRTBYSIT	Print by Site	Integer	2	View
PRNTOPTN	Print Option	Integer	2	View
STTGNDSC	Start Generic Description	String	12	View
ENGENDSC	End Generic Description	String	12	View
ENUSRCAT_1	End User Category[1]	String	12	View
ENUSRCAT_2	End User Category[2]	String	12	View
ENUSRCAT_3	End User Category[3]	String	12	View
ENUSRCAT_4	End User Category[4]	String	12	View
ENUSRCAT_5	End User Category[5]	String	12	View
ENUSRCAT_6	End User Category[6]	String	12	View
KITSRTBY	Kit Sort By	Integer	2	View
STRTUCAT_1	Start User Category[1]	String	12	View
STRTUCAT_2	Start User Category[2]	String	12	View
STRTUCAT_3	Start User Category[3]	String	12	View
STRTUCAT_4	Start User Category[4]	String	12	View
STRTUCAT_5	Start User Category[5]	String	12	View
STRTUCAT_6	Start User Category[6]	String	12	View
STTITNUM	Start Item Number	String	32	View
ENITMNBR	End Item Number	String	32	View
PRVDRINF	Print Vendor Information	Integer	2	View
PRTDSCNT	Print Discontinued	Boolean	2	View
FINRPTNM	Financial Report Name	String	32	View
PRNTNOTS	Print Notes	Boolean	2	View
PRNTTYPE	Print Type	Integer	2	View
ASKECHTM	Ask Each Time	Boolean	2	View
INCLGNDS	Include Legends	Boolean	2	View
PRNTOFIL	Print to File	Boolean	2	View
PRTOPRTR	Print to Printer	Boolean	2	View
PRTOSCRN	Print to Screen	Boolean	2	View
IFFILXST	If File Existing	Integer	2	View
FILEXPNM	File Export Name	String	256	View
EXPTTYPE	Export Type	Integer	2	View
RPTGRIND	Report Group Index	Integer	2	View
STTCLASS	Start Class	String	12	View
ENDCLASS	End Class	String	12	View
STTSCHED	Start Schedule	String	12	View
ENSCHDUL	End Schedule	String	12	View
STTLOCCD	Start Location Code	String	12	View
ENLOCNCD	End Location Code	String	12	View
STTLOTTY	Start Lot Type	String	12	View
ENLOTTYP	End Lot Type	String	12	View
STRTNGDT	Starting Date	Date	4	View
ENDINGDT	Ending Date	Date	4	View
ENDTKNDT	End Token Date	Integer	2	View
STTOKNDT	Start Token Date	Integer	2	View
STRCTNUM	Start Receipt Number	String	22	View
ENRCTNBR	End Receipt Number	String	22	View
RTPACHIN	Report Palette Choice Index	Integer	2	View
RTGRSBIN	Report Group Sub Index	Currency	10	View
SORTBY	Sort By	Integer	2	View
PRTSRLOT	Print Serial Lot	Boolean	2	View
INZROQTY	Include Zero QTY	Boolean	2	View
PRTITQTY	Print Item Quantities	Boolean	2	View
STTBINUM	Start Bin Number	String	22	View
ENBINNBR	End Bin Number	String	22	View
STDOCNUM	Start Document Number	String	22	View
ENDOCNUM	End Document Number	String	22	View
STDOCTYP	Start Document Type	Integer	2	View
ENDOCTYP	End Document Type	Integer	2	View
STTMODUL	Start Module	String	4	View
ENDMODUL	End Module	String	4	View
STRXSRC	Start TRX Source	String	14	View
ENTRXSRC	End TRX Source	String	14	View
STBCHSRC	Start Batch Source	String	16	View
ENBCHSRC	End Batch Source	String	16	View
STBCHNUM	Start Batch Number	String	16	View
ENDBNMBR	End Batch Number	String	16	View
STVNDRID	Start Vendor ID	String	16	View
ENDVNDID	End Vendor ID	String	16	View
INQTYREQ	Include QTY Requisitioned	Boolean	2	View
INZRORLV	Include Zero Reorder Level	Boolean	2	View
CALSGQTY	Calc Suggested QTYS	Integer	2	View
RCPTOPTS	Receipt Options	Integer	2	View
VENDROPT	Vendor Options	Integer	2	View
SEGSRTBY	Segment Sort By	Integer	2	View
STTACNUM_1	Start Account Number:Account_Segment_Pool1	String	10	View
STTACNUM_2	Start Account Number:Account_Segment_Pool2	String	10	View
STTACNUM_3	Start Account Number:Account_Segment_Pool3	String	10	View
STTACNUM_4	Start Account Number:Account_Segment_Pool4	String	10	View
STTACNUM_5	Start Account Number:Account_Segment_Pool5	String	10	View
EACCNBR_1	End Account Number:Account_Segment_Pool1	String	10	View
EACCNBR_2	End Account Number:Account_Segment_Pool2	String	10	View
EACCNBR_3	End Account Number:Account_Segment_Pool3	String	10	View
EACCNBR_4	End Account Number:Account_Segment_Pool4	String	10	View
EACCNBR_5	End Account Number:Account_Segment_Pool5	String	10	View
SEGMNTRG	Using Segment Range	Integer	2	View
Start_PriceLevel	Start PriceLevel	String	12	View
End_PriceLevel	End PriceLevel	String	12	View
Start_QTY_Type	Start QTY Type	Integer	2	View
End_QTY_Type	End QTY Type	Integer	2	View
Start_Component_Item_Num	Start Component Item Number	String	32	View
End_Component_Item_Numbe	End Component Item Number	String	32	View
BM_Assembly_Journal	BM Assembly Journal	Boolean	2	View
BM_Distribution_Detail	BM Distribution Detail	Boolean	2	View
BM_Bill_Status_Active	BM Bill Status Active	Boolean	2	View
BM_Bill_Status_Pending	BM Bill Status Pending	Boolean	2	View
BM_Bill_Status_Obsolete	BM Bill Status Obsolete	Boolean	2	View
BM_Comp_Status_Active	BM Comp Status Active	Boolean	2	View
BM_Comp_Status_Pending	BM Comp Status Pending	Boolean	2	View
BM_Comp_Status_Obsolete	BM Comp Status Obsolete	Boolean	2	View
BM_Comp_Type_Misc_Charge	BM Comp Type Misc Charges	Boolean	2	View
BM_Comp_Type_Services	BM Comp Type Services	Boolean	2	View
BM_Comp_Type_Flat_Fee	BM Comp Type Flat Fee	Boolean	2	View
BM_Print_Notes_Bill	BM Print Notes Bill	Boolean	2	View
BM_Print_Notes_Comp	BM Print Notes Comp	Boolean	2	View
BM_Print_Cost_Options	BM Print Cost Options	Integer	2	View
Max_Levels	Max Levels	Integer	2	View
DATE1	Date	Date	4	View
BMTRXSTATNOTREL	BM Trx Status Not Released	Boolean	2	View
BMTRXSTATREL	BM Trx Status Released	Boolean	2	View
OPTIONS	Options	Integer	2	View
Start_TRX_ID	Start TRX ID	String	20	View
End_TRX_ID	End TRX ID	String	20	View
Starting_TRX_Date	Starting TRX Date	Date	4	View
Ending_TRX_Date	Ending TRX Date	Date	4	View
STRTSRLT	Start Serial/Lot Number	String	22	View
ENDSERLT	End Serial/Lot Number	String	22	View
StartPriceGroup	Start Price Group	String	12	View
EndPriceGroup	End Price Group	String	12	View
STCURRID	Start Currency ID	String	16	View
ENDCURID	End Currency ID	String	16	View
STRTABCCD	Start ABC Code	Integer	2	View
ENDABCCD	End ABC Code	Integer	2	View
STRTSTCKCNTID	Start Stock Count ID	String	16	View
ENDSTCKCNTID	End Stock Count ID	String	16	View
Start_Landed_Cost_ID	Start Landed Cost ID	String	16	View
End_Landed_Cost_ID	End Landed Cost ID	String	16	View
Start_LandedCostGroupID	Start Landed Cost Group ID	String	16	View
End_LandedCostGroupID	End Landed Cost Group ID	String	16	View
ASOFDATE	As Of Date	Date	4	View
INZRQTYI	Include Zero Qty Items	Boolean	2	View
STARTBIN	Start Bin	String	16	View
ENDBIN	End Bin	String	16	View
LNGSTRTDESC	Long Start Description	String	102	View
LNGENDDESC	Long End Description	String	102	View
USEGLPOSTINGDATE	Use GL Posting Date	Boolean	2	View
INNGVQTY	Include Negative QTY	Boolean	2	View
COSTAVGPERIODIC	Cost For Periodic Average Items	Integer	2	View
PRTINACT	Print Inactive	Boolean	2	View

IV70500 - Inventory Report Options

Query Builder

Customer Service

Information

My Account

Contact Us