IV40100 - Inventory Control Setup | Prospr - Dynamics GP Table Reference

IV40100 - Inventory Control Setup

Query Builder

Select * from IV40100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
SETUPKEY	Setup Key	Integer	2	View
USCATDSC_1	User Category Descriptions[1]	String	16	View
USCATDSC_2	User Category Descriptions[2]	String	16	View
USCATDSC_3	User Category Descriptions[3]	String	16	View
USCATDSC_4	User Category Descriptions[4]	String	16	View
USCATDSC_5	User Category Descriptions[5]	String	16	View
USCATDSC_6	User Category Descriptions[6]	String	16	View
DCDCRADJ	Display Cost For Decrease Adjustments	Boolean	2	View
ACSGFLOC	Account Segment For Locations	Integer	2	View
MAINLOCN	Main Location	String	12	View
DECPLCUR	Decimal Places Currency	Integer	2	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
NXADJDOC	Next Adjustment Document Number	String	22	View
TXTRDNUM	Next Transfer Document Number	String	22	View
NXTVDNUM	Next Variance Document Number	String	22	View
NXPRDNUM	Next Production Document Number	String	22	View
ALADJOVR	Allow Adjustment Overrides	Boolean	2	View
AVAROVRD	Allow Variance Overrides	Boolean	2	View
ATRSOVRD	Allow Transfer Overrides	Boolean	2	View
ATPSTVRNC	Auto Post Variance	Boolean	2	View
ENABLEMULTIBIN	Enable Multi Bin	Boolean	2	View
ENPICKSHORTTSK	Enable Picking Shortage Tasks	Boolean	2	View
USERID	User ID	String	16	View
DISABLEAVGPERPADJ	Disable Avg Perpetual Valuation Adjustments	Boolean	2	View
DISABLEPERPADJ	Disable Perpetual Valuation Adjustments	Boolean	2	View
ALLEXPLOTSIV	Allow Expired Lots IV	Boolean	2	View
ALLEXPLOTSIVPASS	Allow Expired Lots IV Password	String	12	View
ALLEXPLOTSOTHER	Allow Expired Lots Other	Boolean	2	View
ALLEXPLOTOTHERPASS	Allow Expired Lots Other Password	String	12	View
USEEXISTINGSNLOTS	Use Only Existing Serials Lots	Boolean	2	View
ASSIGNLOTNUMBY	Assign Lot Numbers By	Integer	2	View
NXTSPNUM	Next Two Step Transfer Number	String	16	View
VIALOCN	Via Location	String	12	View
Next_Bin_XFer_Doc_Number	Next Bin Transfer Document Number	String	22	View

IV40100 - Inventory Control Setup

Query Builder

Customer Service

Information

My Account

Contact Us